SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001321s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=RD15S1000S&search=1' [ RunTime:0.001750s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000961s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000465s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002814s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.002672s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002610s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002415s ]
SELECT * FROM `stock_search` WHERE `partno` = 'RD15S1000S' LIMIT 1 [ RunTime:0.002588s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 02:49:31' WHERE `partno` = 'RD15S1000S' [ RunTime:0.018345s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002580s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012135s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13170258 LIMIT 5 [ RunTime:0.020018s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13170258 ORDER BY `minOrder` ASC [ RunTime:0.009297s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13170258 ORDER BY `unit` DESC [ RunTime:0.006156s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13170258 LIMIT 2 [ RunTime:0.020663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13170258 ORDER BY `minOrder` ASC [ RunTime:0.060503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169560 LIMIT 5 [ RunTime:0.021037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169560 ORDER BY `minOrder` ASC [ RunTime:0.032554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13169560 ORDER BY `unit` DESC [ RunTime:0.028937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13169560 LIMIT 2 [ RunTime:0.010655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13169560 ORDER BY `minOrder` ASC [ RunTime:0.030965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11909497 LIMIT 5 [ RunTime:0.030564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11909497 ORDER BY `minOrder` ASC [ RunTime:0.048643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11909497 ORDER BY `unit` DESC [ RunTime:0.049366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11909497 LIMIT 2 [ RunTime:0.036118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11909497 ORDER BY `minOrder` ASC [ RunTime:0.032644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11908507 LIMIT 5 [ RunTime:0.054982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11908507 ORDER BY `minOrder` ASC [ RunTime:0.107760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11908507 ORDER BY `unit` DESC [ RunTime:0.025513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11908507 LIMIT 2 [ RunTime:0.020015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11908507 ORDER BY `minOrder` ASC [ RunTime:0.010312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11908505 LIMIT 5 [ RunTime:0.066315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11908505 ORDER BY `minOrder` ASC [ RunTime:0.053459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11908505 ORDER BY `unit` DESC [ RunTime:0.042337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11908505 LIMIT 2 [ RunTime:0.041453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11908505 ORDER BY `minOrder` ASC [ RunTime:0.020145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11907824 LIMIT 5 [ RunTime:0.030504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11907824 ORDER BY `minOrder` ASC [ RunTime:0.020397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11907824 ORDER BY `unit` DESC [ RunTime:0.019915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11907824 LIMIT 2 [ RunTime:0.016164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11907824 ORDER BY `minOrder` ASC [ RunTime:0.025823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11907823 LIMIT 5 [ RunTime:0.033341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11907823 ORDER BY `minOrder` ASC [ RunTime:0.018962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11907823 ORDER BY `unit` DESC [ RunTime:0.026778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11907823 LIMIT 2 [ RunTime:0.023635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11907823 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11906209 LIMIT 5 [ RunTime:0.027497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11906209 ORDER BY `minOrder` ASC [ RunTime:0.040549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11906209 ORDER BY `unit` DESC [ RunTime:0.096923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11906209 LIMIT 2 [ RunTime:0.060594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11906209 ORDER BY `minOrder` ASC [ RunTime:0.023728s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021129s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55127648 LIMIT 5 [ RunTime:0.040338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55127648 ORDER BY `minOrder` ASC [ RunTime:0.062856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55127648 ORDER BY `unit` DESC [ RunTime:0.094096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55127648 LIMIT 2 [ RunTime:0.055387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55127648 ORDER BY `minOrder` ASC [ RunTime:0.013863s ]
select * from pdf where partno='RD15S1000S/AA' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.035977s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.022386s ]
SELECT `id` FROM `stock` WHERE `id` <> 55127648 AND `partno` = 'RD15S1000S/AA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.030844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55261925 LIMIT 5 [ RunTime:0.058399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55261925 ORDER BY `minOrder` ASC [ RunTime:0.081122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55261925 ORDER BY `unit` DESC [ RunTime:0.103636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55261925 LIMIT 2 [ RunTime:0.218247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55261925 ORDER BY `minOrder` ASC [ RunTime:0.083496s ]
select * from pdf where partno='RD15S1000S/AA-50-759.1' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.047561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA-50-759.1' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.069442s ]
SELECT `id` FROM `stock` WHERE `id` <> 55261925 AND `partno` = 'RD15S1000S/AA-50-759.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.049856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55260524 LIMIT 5 [ RunTime:0.113634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55260524 ORDER BY `minOrder` ASC [ RunTime:0.033368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55260524 ORDER BY `unit` DESC [ RunTime:0.068330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55260524 LIMIT 2 [ RunTime:0.003425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55260524 ORDER BY `minOrder` ASC [ RunTime:0.015318s ]
select * from pdf where partno='RD15S1000S/AA-50-759.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.048447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA-50-759.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.012969s ]
SELECT `id` FROM `stock` WHERE `id` <> 55260524 AND `partno` = 'RD15S1000S/AA-50-759.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.024908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11909497 [ RunTime:0.045685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55257153 LIMIT 5 [ RunTime:0.051390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55257153 ORDER BY `minOrder` ASC [ RunTime:0.038843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55257153 ORDER BY `unit` DESC [ RunTime:0.025916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55257153 LIMIT 2 [ RunTime:0.036367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55257153 ORDER BY `minOrder` ASC [ RunTime:0.005873s ]
select * from pdf where partno='RD15S1000S-50-759.0' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.022024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S-50-759.0' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.016779s ]
SELECT `id` FROM `stock` WHERE `id` <> 55257153 AND `partno` = 'RD15S1000S-50-759.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.021264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13170258 [ RunTime:0.012974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55256810 LIMIT 5 [ RunTime:0.013441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55256810 ORDER BY `minOrder` ASC [ RunTime:0.021856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55256810 ORDER BY `unit` DESC [ RunTime:0.054686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55256810 LIMIT 2 [ RunTime:0.026408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55256810 ORDER BY `minOrder` ASC [ RunTime:0.010611s ]
select * from pdf where partno='RD15S1000S-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.034398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.032695s ]
SELECT `id` FROM `stock` WHERE `id` <> 55256810 AND `partno` = 'RD15S1000S-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.020031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13169560 [ RunTime:0.037909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55255270 LIMIT 5 [ RunTime:0.024268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55255270 ORDER BY `minOrder` ASC [ RunTime:0.052680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55255270 ORDER BY `unit` DESC [ RunTime:0.056562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55255270 LIMIT 2 [ RunTime:0.038781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55255270 ORDER BY `minOrder` ASC [ RunTime:0.017618s ]
select * from pdf where partno='RD15S1000S-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.026648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.006492s ]
SELECT `id` FROM `stock` WHERE `id` <> 55255270 AND `partno` = 'RD15S1000S-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.060624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11908507 [ RunTime:0.069314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55253747 LIMIT 5 [ RunTime:0.023763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55253747 ORDER BY `minOrder` ASC [ RunTime:0.050254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55253747 ORDER BY `unit` DESC [ RunTime:0.099217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55253747 LIMIT 2 [ RunTime:0.024679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55253747 ORDER BY `minOrder` ASC [ RunTime:0.028835s ]
select * from pdf where partno='RD15S1000S/AA-50' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.056329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA-50' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.040014s ]
SELECT `id` FROM `stock` WHERE `id` <> 55253747 AND `partno` = 'RD15S1000S/AA-50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.132017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55252059 LIMIT 5 [ RunTime:0.028203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55252059 ORDER BY `minOrder` ASC [ RunTime:0.079079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55252059 ORDER BY `unit` DESC [ RunTime:0.022358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55252059 LIMIT 2 [ RunTime:0.074227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55252059 ORDER BY `minOrder` ASC [ RunTime:0.006045s ]
select * from pdf where partno='RD15S1000S/AA-15' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.044460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA-15' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.064991s ]
SELECT `id` FROM `stock` WHERE `id` <> 55252059 AND `partno` = 'RD15S1000S/AA-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.076321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11908505 [ RunTime:0.063270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55242998 LIMIT 5 [ RunTime:0.039254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55242998 ORDER BY `minOrder` ASC [ RunTime:0.048925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55242998 ORDER BY `unit` DESC [ RunTime:0.027833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55242998 LIMIT 2 [ RunTime:0.027880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55242998 ORDER BY `minOrder` ASC [ RunTime:0.017994s ]
select * from pdf where partno='RD15S1000S/AA-759.1' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.080781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S/AA-759.1' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.011659s ]
SELECT `id` FROM `stock` WHERE `id` <> 55242998 AND `partno` = 'RD15S1000S/AA-759.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.023353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11907824 [ RunTime:0.040823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55240070 LIMIT 5 [ RunTime:0.059133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55240070 ORDER BY `minOrder` ASC [ RunTime:0.052217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55240070 ORDER BY `unit` DESC [ RunTime:0.026525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55240070 LIMIT 2 [ RunTime:0.042533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55240070 ORDER BY `minOrder` ASC [ RunTime:0.002618s ]
select * from pdf where partno='RD15S1000S-759.1' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.035492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S-759.1' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.020786s ]
SELECT `id` FROM `stock` WHERE `id` <> 55240070 AND `partno` = 'RD15S1000S-759.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.075447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11907823 [ RunTime:0.023462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55231204 LIMIT 5 [ RunTime:0.052530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55231204 ORDER BY `minOrder` ASC [ RunTime:0.027545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55231204 ORDER BY `unit` DESC [ RunTime:0.039449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55231204 LIMIT 2 [ RunTime:0.024631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55231204 ORDER BY `minOrder` ASC [ RunTime:0.013243s ]
select * from pdf where partno='RD15S1000S' and brandshort='Amphenol Positronic' limit 1 [ RunTime:0.019846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RD15S1000S' OR `brand` LIKE 'Amphenol Positronic%' ) ) LIMIT 1 [ RunTime:0.029098s ]
SELECT `id` FROM `stock` WHERE `id` <> 55231204 AND `partno` = 'RD15S1000S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol positronic%' ) [ RunTime:0.038326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11906209 [ RunTime:0.046484s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015364s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048614s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046100s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017294s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030556s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063754s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012329s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RD15S1000S%' OR `brand` LIKE 'RD15S1000S%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029364s ]