SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002261s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.12' , `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=476&search=1' [ RunTime:0.005384s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002066s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002066s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001972s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.12' ) [ RunTime:0.000604s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001556s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000541s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002918s ]
SELECT * FROM `stock_search` WHERE `partno` = '476' LIMIT 1 [ RunTime:0.001434s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-10-20 23:59:34' WHERE `partno` = '476' [ RunTime:0.005352s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001856s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046918s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14890843 LIMIT 5 [ RunTime:0.001053s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890843 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14890843 ORDER BY `unit` DESC [ RunTime:0.000310s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14890843 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890843 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14893174 LIMIT 5 [ RunTime:0.002394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14893174 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14893174 ORDER BY `unit` DESC [ RunTime:0.000727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14893174 LIMIT 2 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14893174 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14890828 LIMIT 5 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890828 ORDER BY `minOrder` ASC [ RunTime:0.000825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14890828 ORDER BY `unit` DESC [ RunTime:0.000756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14890828 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14890828 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13978960 LIMIT 5 [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13978960 ORDER BY `minOrder` ASC [ RunTime:0.000626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13978960 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13978960 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13978960 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14898239 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14898239 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14898239 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14898239 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14898239 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976716 LIMIT 5 [ RunTime:0.003623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976716 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976716 ORDER BY `unit` DESC [ RunTime:0.000243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976716 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976716 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976701 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976701 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976701 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976701 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976701 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889784 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14889784 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14889784 ORDER BY `unit` DESC [ RunTime:0.000335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14889784 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14889784 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609153 LIMIT 5 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609153 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609153 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609153 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609153 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14898368 LIMIT 5 [ RunTime:0.002131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14898368 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14898368 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14898368 LIMIT 2 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14898368 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13978240 LIMIT 5 [ RunTime:0.001109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13978240 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13978240 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13978240 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13978240 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14904275 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14904275 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14904275 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14904275 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14904275 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894073 LIMIT 5 [ RunTime:0.002578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894073 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894073 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894073 LIMIT 2 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894073 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976785 LIMIT 5 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976785 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13976785 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13976785 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13976785 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894056 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894056 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894056 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894056 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894056 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14895338 LIMIT 5 [ RunTime:0.004115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14895338 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14895338 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14895338 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14895338 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13977515 LIMIT 5 [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977515 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13977515 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13977515 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13977515 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14897370 LIMIT 5 [ RunTime:0.001002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14897370 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14897370 ORDER BY `unit` DESC [ RunTime:0.000585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14897370 LIMIT 2 [ RunTime:0.000596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14897370 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13979177 LIMIT 5 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13979177 ORDER BY `minOrder` ASC [ RunTime:0.000638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13979177 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13979177 LIMIT 2 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13979177 ORDER BY `minOrder` ASC [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894093 LIMIT 5 [ RunTime:0.001604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894093 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14894093 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14894093 LIMIT 2 [ RunTime:0.000514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14894093 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71724113 LIMIT 5 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71724113 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71724113 ORDER BY `unit` DESC [ RunTime:0.000570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71724113 LIMIT 2 [ RunTime:0.000489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71724113 ORDER BY `minOrder` ASC [ RunTime:0.000617s ]
select * from pdf where partno='47615-0001' and brandshort='molex' limit 1 [ RunTime:0.003621s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47615-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71787525 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787525 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71787525 ORDER BY `unit` DESC [ RunTime:0.000599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71787525 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71787525 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='47642-1001' and brandshort='molex' limit 1 [ RunTime:0.001343s ]
select foldpath,foldpath2,filename from pdf_file where id=1665598 limit 1 [ RunTime:0.000833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47642-1001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71788443 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788443 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71788443 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71788443 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71788443 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
select * from pdf where partno='47642-0001' and brandshort='molex' limit 1 [ RunTime:0.001803s ]
select foldpath,foldpath2,filename from pdf_file where id=766001 limit 1 [ RunTime:0.002674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47642-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.011905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71785831 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71785831 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71785831 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71785831 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71785831 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
select * from pdf where partno='47634-1002' and brandshort='molex' limit 1 [ RunTime:0.000912s ]
select foldpath,foldpath2,filename from pdf_file where id=765997 limit 1 [ RunTime:0.000518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47634-1002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71785229 LIMIT 5 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71785229 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71785229 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71785229 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71785229 ORDER BY `minOrder` ASC [ RunTime:0.000621s ]
select * from pdf where partno='47634-2000' and brandshort='molex' limit 1 [ RunTime:0.000846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47634-2000' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.012669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71653577 LIMIT 5 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71653577 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71653577 ORDER BY `unit` DESC [ RunTime:0.000633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71653577 LIMIT 2 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71653577 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
select * from pdf where partno='476602000' and brandshort='c&k' limit 1 [ RunTime:0.001639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476602000' OR `brand` LIKE 'c&k%' ) ) LIMIT 1 [ RunTime:0.006177s ]
SELECT `id` FROM `stock` WHERE `id` <> 71653577 AND `partno` = '476602000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71815149 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71815149 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71815149 ORDER BY `unit` DESC [ RunTime:0.000494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71815149 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71815149 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='476-3' and brandshort='keystone electronics' limit 1 [ RunTime:0.001120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476-3' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.000940s ]
SELECT `id` FROM `stock` WHERE `id` <> 71815149 AND `partno` = '476-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883595 [ RunTime:0.003061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097068 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097068 ORDER BY `minOrder` ASC [ RunTime:0.000964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097068 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097068 LIMIT 2 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097068 ORDER BY `minOrder` ASC [ RunTime:0.000589s ]
select * from pdf where partno='476' and brandshort='adafruit' limit 1 [ RunTime:0.000938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71820932 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820932 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71820932 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71820932 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71820932 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
select * from pdf where partno='476w' and brandshort='wakefield thermal' limit 1 [ RunTime:0.002939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476w' OR `brand` LIKE 'wakefield thermal%' ) ) LIMIT 1 [ RunTime:0.001042s ]
SELECT `id` FROM `stock` WHERE `id` <> 71820932 AND `partno` = '476w' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.001271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885389 [ RunTime:0.000728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71670826 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71670826 ORDER BY `minOrder` ASC [ RunTime:0.001202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71670826 ORDER BY `unit` DESC [ RunTime:0.000691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71670826 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71670826 ORDER BY `minOrder` ASC [ RunTime:0.000714s ]
select * from pdf where partno='4763' and brandshort='adafruit' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4763' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001678s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228881 LIMIT 5 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228881 ORDER BY `minOrder` ASC [ RunTime:0.000830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228881 ORDER BY `unit` DESC [ RunTime:0.000330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228881 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228881 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='476CKR025M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.001614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKR025M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000625s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228881 AND `partno` = '476CKR025M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14890843 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155236 LIMIT 5 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155236 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155236 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155236 LIMIT 2 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155236 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='47650-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47650-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000516s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155236 AND `partno` = '47650-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39229645 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229645 ORDER BY `minOrder` ASC [ RunTime:0.002413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39229645 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39229645 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229645 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='476CKR063M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKR063M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000520s ]
SELECT `id` FROM `stock` WHERE `id` <> 39229645 AND `partno` = '476CKR063M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14893174 [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39234621 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234621 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39234621 ORDER BY `unit` DESC [ RunTime:0.000370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39234621 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234621 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='476RSS016M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.004204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476RSS016M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000649s ]
SELECT `id` FROM `stock` WHERE `id` <> 39234621 AND `partno` = '476RSS016M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976716 [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39232085 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39232085 ORDER BY `minOrder` ASC [ RunTime:0.001856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39232085 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39232085 LIMIT 2 [ RunTime:0.000364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39232085 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='476TTA050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.001498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476TTA050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000535s ]
SELECT `id` FROM `stock` WHERE `id` <> 39232085 AND `partno` = '476TTA050M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14898239 [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67155327 LIMIT 5 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155327 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67155327 ORDER BY `unit` DESC [ RunTime:0.000379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67155327 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67155327 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='47649-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47649-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.000475s ]
SELECT `id` FROM `stock` WHERE `id` <> 67155327 AND `partno` = '47649-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609153 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39230624 LIMIT 5 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39230624 ORDER BY `minOrder` ASC [ RunTime:0.006601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39230624 ORDER BY `unit` DESC [ RunTime:0.000401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39230624 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39230624 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='476AXZ035MQ5' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.002131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476AXZ035MQ5' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000492s ]
SELECT `id` FROM `stock` WHERE `id` <> 39230624 AND `partno` = '476AXZ035MQ5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13978960 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228887 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228887 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228887 ORDER BY `unit` DESC [ RunTime:0.000388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228887 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228887 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='476KXM025M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476KXM025M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000399s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228887 AND `partno` = '476KXM025M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976701 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39235489 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235489 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39235489 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39235489 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235489 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='476CKH100M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000611s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKH100M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000368s ]
SELECT `id` FROM `stock` WHERE `id` <> 39235489 AND `partno` = '476CKH100M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14904275 [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39241579 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241579 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39241579 ORDER BY `unit` DESC [ RunTime:0.000290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39241579 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241579 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='476SML016M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476SML016M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000368s ]
SELECT `id` FROM `stock` WHERE `id` <> 39241579 AND `partno` = '476SML016M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13976785 [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39241535 LIMIT 5 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241535 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39241535 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39241535 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241535 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='476CKS063M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.001737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKS063M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 39241535 AND `partno` = '476CKS063M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894056 [ RunTime:0.000421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39235295 LIMIT 5 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235295 ORDER BY `minOrder` ASC [ RunTime:0.004631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39235295 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39235295 LIMIT 2 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235295 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='476AXZ050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476AXZ050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 39235295 AND `partno` = '476AXZ050M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13983213 [ RunTime:0.003358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39231975 LIMIT 5 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39231975 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39231975 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39231975 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39231975 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='476SML100M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476SML100M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 39231975 AND `partno` = '476SML100M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14898368 [ RunTime:0.000319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39241547 LIMIT 5 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241547 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39241547 ORDER BY `unit` DESC [ RunTime:0.000301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39241547 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39241547 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='476KBM050MST' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476KBM050MST' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 39241547 AND `partno` = '476KBM050MST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894073 [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39229798 LIMIT 5 [ RunTime:0.000297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229798 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39229798 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39229798 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39229798 ORDER BY `minOrder` ASC [ RunTime:0.000400s ]
select * from pdf where partno='476CKR050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKR050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000417s ]
SELECT `id` FROM `stock` WHERE `id` <> 39229798 AND `partno` = '476CKR050M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13978240 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39234818 LIMIT 5 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234818 ORDER BY `minOrder` ASC [ RunTime:0.000738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39234818 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39234818 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234818 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
select * from pdf where partno='476KBM050M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476KBM050M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000422s ]
SELECT `id` FROM `stock` WHERE `id` <> 39234818 AND `partno` = '476KBM050M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14895338 [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39234972 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234972 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39234972 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39234972 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39234972 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='476SML035M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476SML035M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000487s ]
SELECT `id` FROM `stock` WHERE `id` <> 39234972 AND `partno` = '476SML035M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14903692 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39231536 LIMIT 5 [ RunTime:0.000343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39231536 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39231536 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39231536 LIMIT 2 [ RunTime:0.000332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39231536 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='476TTA016MSD' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476TTA016MSD' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000445s ]
SELECT `id` FROM `stock` WHERE `id` <> 39231536 AND `partno` = '476TTA016MSD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14897370 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39228777 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228777 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39228777 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39228777 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39228777 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='476CKH025M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.001809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476CKH025M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000456s ]
SELECT `id` FROM `stock` WHERE `id` <> 39228777 AND `partno` = '476CKH025M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14889784 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39235087 LIMIT 5 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235087 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39235087 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39235087 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39235087 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='476KXM063M' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '476KXM063M' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT `id` FROM `stock` WHERE `id` <> 39235087 AND `partno` = '476KXM063M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14894093 [ RunTime:0.000373s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000786s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000675s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000637s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000618s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000620s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000613s ]
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 '476%' OR `brand` LIKE '476%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000693s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '476%' OR `brand` LIKE '476%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002855s ]