SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002294s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `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=106338&search=1' [ RunTime:0.030320s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001809s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.023800s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002437s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.034674s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002964s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.040056s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002713s ]
SELECT * FROM `stock_search` WHERE `partno` = '106338' LIMIT 1 [ RunTime:0.067495s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:35:50' WHERE `partno` = '106338' [ RunTime:0.041408s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002546s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054756s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835324 LIMIT 5 [ RunTime:0.133903s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835324 ORDER BY `minOrder` ASC [ RunTime:0.049016s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835324 ORDER BY `unit` DESC [ RunTime:0.068530s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835324 LIMIT 2 [ RunTime:0.076984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835324 ORDER BY `minOrder` ASC [ RunTime:0.091570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836862 LIMIT 5 [ RunTime:0.045598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836862 ORDER BY `minOrder` ASC [ RunTime:0.045968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836862 ORDER BY `unit` DESC [ RunTime:0.090961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836862 LIMIT 2 [ RunTime:0.035570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836862 ORDER BY `minOrder` ASC [ RunTime:0.041356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836815 LIMIT 5 [ RunTime:0.075775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836815 ORDER BY `minOrder` ASC [ RunTime:0.053635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836815 ORDER BY `unit` DESC [ RunTime:0.034333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836815 LIMIT 2 [ RunTime:0.057225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836815 ORDER BY `minOrder` ASC [ RunTime:0.021971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836354 LIMIT 5 [ RunTime:0.062390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836354 ORDER BY `minOrder` ASC [ RunTime:0.078065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836354 ORDER BY `unit` DESC [ RunTime:0.062606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836354 LIMIT 2 [ RunTime:0.013986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836354 ORDER BY `minOrder` ASC [ RunTime:0.034789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206426 LIMIT 5 [ RunTime:0.050613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206426 ORDER BY `minOrder` ASC [ RunTime:0.046784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206426 ORDER BY `unit` DESC [ RunTime:0.009732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206426 LIMIT 2 [ RunTime:0.035802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206426 ORDER BY `minOrder` ASC [ RunTime:0.003248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080609 LIMIT 5 [ RunTime:0.010575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080609 ORDER BY `minOrder` ASC [ RunTime:0.015409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080609 ORDER BY `unit` DESC [ RunTime:0.031647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080609 LIMIT 2 [ RunTime:0.015651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080609 ORDER BY `minOrder` ASC [ RunTime:0.003409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080552 LIMIT 5 [ RunTime:0.010739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080552 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080552 ORDER BY `unit` DESC [ RunTime:0.006591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080552 LIMIT 2 [ RunTime:0.005070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080552 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080502 LIMIT 5 [ RunTime:0.003373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080502 ORDER BY `minOrder` ASC [ RunTime:0.006407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080502 ORDER BY `unit` DESC [ RunTime:0.012368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080502 LIMIT 2 [ RunTime:0.007821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080502 ORDER BY `minOrder` ASC [ RunTime:0.014531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080028 LIMIT 5 [ RunTime:0.011543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080028 ORDER BY `minOrder` ASC [ RunTime:0.006740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20080028 ORDER BY `unit` DESC [ RunTime:0.005490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20080028 LIMIT 2 [ RunTime:0.021409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20080028 ORDER BY `minOrder` ASC [ RunTime:0.002634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980471 LIMIT 5 [ RunTime:0.007251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980471 ORDER BY `minOrder` ASC [ RunTime:0.001119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980471 ORDER BY `unit` DESC [ RunTime:0.002773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980471 LIMIT 2 [ RunTime:0.025692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980471 ORDER BY `minOrder` ASC [ RunTime:0.003884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772917 LIMIT 5 [ RunTime:0.019439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772917 ORDER BY `minOrder` ASC [ RunTime:0.023199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772917 ORDER BY `unit` DESC [ RunTime:0.017346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772917 LIMIT 2 [ RunTime:0.010834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772917 ORDER BY `minOrder` ASC [ RunTime:0.006640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16358748 LIMIT 5 [ RunTime:0.015349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358748 ORDER BY `minOrder` ASC [ RunTime:0.025097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16358748 ORDER BY `unit` DESC [ RunTime:0.004698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16358748 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16358748 ORDER BY `minOrder` ASC [ RunTime:0.006519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13107274 LIMIT 5 [ RunTime:0.007870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107274 ORDER BY `minOrder` ASC [ RunTime:0.032139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13107274 ORDER BY `unit` DESC [ RunTime:0.016702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13107274 LIMIT 2 [ RunTime:0.025316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13107274 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13105414 LIMIT 5 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13105414 ORDER BY `minOrder` ASC [ RunTime:0.007792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13105414 ORDER BY `unit` DESC [ RunTime:0.000636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13105414 LIMIT 2 [ RunTime:0.006978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13105414 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11852915 LIMIT 5 [ RunTime:0.001428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852915 ORDER BY `minOrder` ASC [ RunTime:0.018619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11852915 ORDER BY `unit` DESC [ RunTime:0.013648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11852915 LIMIT 2 [ RunTime:0.016151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11852915 ORDER BY `minOrder` ASC [ RunTime:0.008512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206662 LIMIT 5 [ RunTime:0.009368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206662 ORDER BY `minOrder` ASC [ RunTime:0.004070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206662 ORDER BY `unit` DESC [ RunTime:0.015372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206662 LIMIT 2 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206662 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206327 LIMIT 5 [ RunTime:0.002027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206327 ORDER BY `minOrder` ASC [ RunTime:0.004190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206327 ORDER BY `unit` DESC [ RunTime:0.015477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206327 LIMIT 2 [ RunTime:0.018644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206327 ORDER BY `minOrder` ASC [ RunTime:0.007953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206207 LIMIT 5 [ RunTime:0.003899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206207 ORDER BY `minOrder` ASC [ RunTime:0.008542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206207 ORDER BY `unit` DESC [ RunTime:0.001294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206207 LIMIT 2 [ RunTime:0.017064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206207 ORDER BY `minOrder` ASC [ RunTime:0.008377s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027786s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64460697 LIMIT 5 [ RunTime:0.033421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460697 ORDER BY `minOrder` ASC [ RunTime:0.030967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64460697 ORDER BY `unit` DESC [ RunTime:0.005419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64460697 LIMIT 2 [ RunTime:0.002058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460697 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='1063383' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004019s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063383' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008503s ]
SELECT `id` FROM `stock` WHERE `id` <> 64460697 AND `partno` = '1063383' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206327 [ RunTime:0.015489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453615 LIMIT 5 [ RunTime:0.020125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453615 ORDER BY `minOrder` ASC [ RunTime:0.030885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453615 ORDER BY `unit` DESC [ RunTime:0.023105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453615 LIMIT 2 [ RunTime:0.016941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453615 ORDER BY `minOrder` ASC [ RunTime:0.006300s ]
select * from pdf where partno='1063381' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063381' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005570s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453615 AND `partno` = '1063381' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.037574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836354 [ RunTime:0.013933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453501 LIMIT 5 [ RunTime:0.000927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453501 ORDER BY `minOrder` ASC [ RunTime:0.001818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453501 ORDER BY `unit` DESC [ RunTime:0.006291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453501 LIMIT 2 [ RunTime:0.007552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453501 ORDER BY `minOrder` ASC [ RunTime:0.008520s ]
select * from pdf where partno='1063385' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063385' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012065s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453501 AND `partno` = '1063385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836815 [ RunTime:0.009925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453500 LIMIT 5 [ RunTime:0.010745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453500 ORDER BY `minOrder` ASC [ RunTime:0.018677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453500 ORDER BY `unit` DESC [ RunTime:0.026728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453500 LIMIT 2 [ RunTime:0.030881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453500 ORDER BY `minOrder` ASC [ RunTime:0.001780s ]
select * from pdf where partno='1063386' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063386' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.029369s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453500 AND `partno` = '1063386' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835324 [ RunTime:0.009354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64804264 LIMIT 5 [ RunTime:0.020263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804264 ORDER BY `minOrder` ASC [ RunTime:0.010667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64804264 ORDER BY `unit` DESC [ RunTime:0.035640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64804264 LIMIT 2 [ RunTime:0.010189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64804264 ORDER BY `minOrder` ASC [ RunTime:0.003664s ]
select * from pdf where partno='1063389' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063389' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006892s ]
SELECT `id` FROM `stock` WHERE `id` <> 64804264 AND `partno` = '1063389' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980471 [ RunTime:0.010606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64803696 LIMIT 5 [ RunTime:0.028669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803696 ORDER BY `minOrder` ASC [ RunTime:0.030691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64803696 ORDER BY `unit` DESC [ RunTime:0.006545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64803696 LIMIT 2 [ RunTime:0.000660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64803696 ORDER BY `minOrder` ASC [ RunTime:0.017298s ]
select * from pdf where partno='1063388' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063388' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012394s ]
SELECT `id` FROM `stock` WHERE `id` <> 64803696 AND `partno` = '1063388' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772917 [ RunTime:0.006809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64461542 LIMIT 5 [ RunTime:0.003751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461542 ORDER BY `minOrder` ASC [ RunTime:0.005830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64461542 ORDER BY `unit` DESC [ RunTime:0.004142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64461542 LIMIT 2 [ RunTime:0.003925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461542 ORDER BY `minOrder` ASC [ RunTime:0.005242s ]
select * from pdf where partno='1063387' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063387' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018113s ]
SELECT `id` FROM `stock` WHERE `id` <> 64461542 AND `partno` = '1063387' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206662 [ RunTime:0.003756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64461132 LIMIT 5 [ RunTime:0.003492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461132 ORDER BY `minOrder` ASC [ RunTime:0.005749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64461132 ORDER BY `unit` DESC [ RunTime:0.003801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64461132 LIMIT 2 [ RunTime:0.003044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461132 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='1063384' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063384' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000820s ]
SELECT `id` FROM `stock` WHERE `id` <> 64461132 AND `partno` = '1063384' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206426 [ RunTime:0.006226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64460389 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460389 ORDER BY `minOrder` ASC [ RunTime:0.003539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64460389 ORDER BY `unit` DESC [ RunTime:0.003143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64460389 LIMIT 2 [ RunTime:0.008317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64460389 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='1063382' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063382' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001910s ]
SELECT `id` FROM `stock` WHERE `id` <> 64460389 AND `partno` = '1063382' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206207 [ RunTime:0.009997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453609 LIMIT 5 [ RunTime:0.009179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453609 ORDER BY `minOrder` ASC [ RunTime:0.005587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453609 ORDER BY `unit` DESC [ RunTime:0.001846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453609 LIMIT 2 [ RunTime:0.006092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453609 ORDER BY `minOrder` ASC [ RunTime:0.001460s ]
select * from pdf where partno='1063380' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063380' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002915s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453609 AND `partno` = '1063380' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836862 [ RunTime:0.004168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60613592 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613592 ORDER BY `minOrder` ASC [ RunTime:0.021084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60613592 ORDER BY `unit` DESC [ RunTime:0.015291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60613592 LIMIT 2 [ RunTime:0.011309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613592 ORDER BY `minOrder` ASC [ RunTime:0.002532s ]
select * from pdf where partno='1063388-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063388-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000829s ]
SELECT `id` FROM `stock` WHERE `id` <> 60613592 AND `partno` = '1063388-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080609 [ RunTime:0.003153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60613562 LIMIT 5 [ RunTime:0.032440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613562 ORDER BY `minOrder` ASC [ RunTime:0.027888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60613562 ORDER BY `unit` DESC [ RunTime:0.011057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60613562 LIMIT 2 [ RunTime:0.009223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613562 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='1063383-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000890s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063383-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007487s ]
SELECT `id` FROM `stock` WHERE `id` <> 60613562 AND `partno` = '1063383-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080552 [ RunTime:0.000640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60613352 LIMIT 5 [ RunTime:0.002740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613352 ORDER BY `minOrder` ASC [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60613352 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60613352 LIMIT 2 [ RunTime:0.005974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60613352 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
select * from pdf where partno='1063382-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.032936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063382-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001878s ]
SELECT `id` FROM `stock` WHERE `id` <> 60613352 AND `partno` = '1063382-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080502 [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60612014 LIMIT 5 [ RunTime:0.004065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60612014 ORDER BY `minOrder` ASC [ RunTime:0.001111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60612014 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60612014 LIMIT 2 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60612014 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
select * from pdf where partno='1063380-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1063380-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000729s ]
SELECT `id` FROM `stock` WHERE `id` <> 60612014 AND `partno` = '1063380-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20080028 [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60408805 LIMIT 5 [ RunTime:0.007669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408805 ORDER BY `minOrder` ASC [ RunTime:0.001121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60408805 ORDER BY `unit` DESC [ RunTime:0.001737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60408805 LIMIT 2 [ RunTime:0.003241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408805 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='106338NP' and brandshort='LAPP' limit 1 [ RunTime:0.000846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106338NP' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.003133s ]
SELECT `id` FROM `stock` WHERE `id` <> 60408805 AND `partno` = '106338NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.001607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11852915 [ RunTime:0.001115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60408760 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408760 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60408760 ORDER BY `unit` DESC [ RunTime:0.000588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60408760 LIMIT 2 [ RunTime:0.001890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60408760 ORDER BY `minOrder` ASC [ RunTime:0.004826s ]
select * from pdf where partno='106338' and brandshort='LAPP' limit 1 [ RunTime:0.001145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '106338' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.000752s ]
SELECT `id` FROM `stock` WHERE `id` <> 60408760 AND `partno` = '106338' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.002417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13105414 [ RunTime:0.000652s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001152s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003635s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002246s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001067s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003271s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021810s ]
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 '106338%' OR `brand` LIKE '106338%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008430s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '106338%' OR `brand` LIKE '106338%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003430s ]