SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001418s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=28486&search=1' [ RunTime:0.002067s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002011s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001512s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.005897s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001112s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010801s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001111s ]
SELECT * FROM `stock_search` WHERE `partno` = '28486' LIMIT 1 [ RunTime:0.001117s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-15 22:52:41' WHERE `partno` = '28486' [ RunTime:0.007496s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001262s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028193s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613348 LIMIT 5 [ RunTime:0.015741s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613348 ORDER BY `minOrder` ASC [ RunTime:0.013673s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613348 ORDER BY `unit` DESC [ RunTime:0.007480s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613348 LIMIT 2 [ RunTime:0.016588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613348 ORDER BY `minOrder` ASC [ RunTime:0.014230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799847 LIMIT 5 [ RunTime:0.007973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799847 ORDER BY `minOrder` ASC [ RunTime:0.008442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799847 ORDER BY `unit` DESC [ RunTime:0.043595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799847 LIMIT 2 [ RunTime:0.027724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799847 ORDER BY `minOrder` ASC [ RunTime:0.002286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799789 LIMIT 5 [ RunTime:0.006864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799789 ORDER BY `minOrder` ASC [ RunTime:0.005358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799789 ORDER BY `unit` DESC [ RunTime:0.006670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799789 LIMIT 2 [ RunTime:0.007187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799789 ORDER BY `minOrder` ASC [ RunTime:0.001562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631097 LIMIT 5 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631097 ORDER BY `minOrder` ASC [ RunTime:0.011593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12631097 ORDER BY `unit` DESC [ RunTime:0.018063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12631097 LIMIT 2 [ RunTime:0.025016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12631097 ORDER BY `minOrder` ASC [ RunTime:0.017710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628315 LIMIT 5 [ RunTime:0.019668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628315 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628315 ORDER BY `unit` DESC [ RunTime:0.008584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628315 LIMIT 2 [ RunTime:0.030479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628315 ORDER BY `minOrder` ASC [ RunTime:0.009738s ]
select * from pdf where partno='284869-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.016339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168366 LIMIT 5 [ RunTime:0.012558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168366 ORDER BY `minOrder` ASC [ RunTime:0.011120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12168366 ORDER BY `unit` DESC [ RunTime:0.020155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12168366 LIMIT 2 [ RunTime:0.008949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12168366 ORDER BY `minOrder` ASC [ RunTime:0.003739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19656811 LIMIT 5 [ RunTime:0.019774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656811 ORDER BY `minOrder` ASC [ RunTime:0.012443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19656811 ORDER BY `unit` DESC [ RunTime:0.002223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19656811 LIMIT 2 [ RunTime:0.009902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19656811 ORDER BY `minOrder` ASC [ RunTime:0.009850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294341 LIMIT 5 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294341 ORDER BY `minOrder` ASC [ RunTime:0.000688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13294341 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13294341 LIMIT 2 [ RunTime:0.002320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13294341 ORDER BY `minOrder` ASC [ RunTime:0.002820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801678 LIMIT 5 [ RunTime:0.001756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801678 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801678 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801678 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801678 ORDER BY `minOrder` ASC [ RunTime:0.001480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801351 LIMIT 5 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801351 ORDER BY `minOrder` ASC [ RunTime:0.004482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801351 ORDER BY `unit` DESC [ RunTime:0.001623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801351 LIMIT 2 [ RunTime:0.004343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801351 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801171 LIMIT 5 [ RunTime:0.000900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801171 ORDER BY `minOrder` ASC [ RunTime:0.005721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801171 ORDER BY `unit` DESC [ RunTime:0.007640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801171 LIMIT 2 [ RunTime:0.002299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801171 ORDER BY `minOrder` ASC [ RunTime:0.002799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799838 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799838 ORDER BY `minOrder` ASC [ RunTime:0.001954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799838 ORDER BY `unit` DESC [ RunTime:0.005434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799838 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799838 ORDER BY `minOrder` ASC [ RunTime:0.002913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799816 LIMIT 5 [ RunTime:0.011651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799816 ORDER BY `minOrder` ASC [ RunTime:0.001333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799816 ORDER BY `unit` DESC [ RunTime:0.002406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799816 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799816 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='284865-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12025687 LIMIT 5 [ RunTime:0.003851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025687 ORDER BY `minOrder` ASC [ RunTime:0.004036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12025687 ORDER BY `unit` DESC [ RunTime:0.002168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12025687 LIMIT 2 [ RunTime:0.002441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12025687 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617336 LIMIT 5 [ RunTime:0.000961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617336 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617336 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617336 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617336 ORDER BY `minOrder` ASC [ RunTime:0.001590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11616968 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11616968 ORDER BY `minOrder` ASC [ RunTime:0.003861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11616968 ORDER BY `unit` DESC [ RunTime:0.006352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11616968 LIMIT 2 [ RunTime:0.001033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11616968 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001639s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60361338 LIMIT 5 [ RunTime:0.000892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361338 ORDER BY `minOrder` ASC [ RunTime:0.008761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60361338 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60361338 LIMIT 2 [ RunTime:0.001166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60361338 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='284863-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000581s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284863-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000329s ]
SELECT `id` FROM `stock` WHERE `id` <> 60361338 AND `partno` = '284863-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613348 [ RunTime:0.001379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59946848 LIMIT 5 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946848 ORDER BY `minOrder` ASC [ RunTime:0.004971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59946848 ORDER BY `unit` DESC [ RunTime:0.001368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59946848 LIMIT 2 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946848 ORDER BY `minOrder` ASC [ RunTime:0.006062s ]
select * from pdf where partno='284865-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.019486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59907161 LIMIT 5 [ RunTime:0.007980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907161 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59907161 ORDER BY `unit` DESC [ RunTime:0.003826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59907161 LIMIT 2 [ RunTime:0.002351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907161 ORDER BY `minOrder` ASC [ RunTime:0.001737s ]
select * from pdf where partno='284865-9' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-9' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002298s ]
SELECT `id` FROM `stock` WHERE `id` <> 59907161 AND `partno` = '284865-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799847 [ RunTime:0.001207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59947014 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947014 ORDER BY `minOrder` ASC [ RunTime:0.000806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59947014 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59947014 LIMIT 2 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59947014 ORDER BY `minOrder` ASC [ RunTime:0.001444s ]
select * from pdf where partno='284865-6' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-6' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937125 LIMIT 5 [ RunTime:0.006131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937125 ORDER BY `minOrder` ASC [ RunTime:0.013681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937125 ORDER BY `unit` DESC [ RunTime:0.005840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937125 LIMIT 2 [ RunTime:0.008936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937125 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='284869-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284869-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004905s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937125 AND `partno` = '284869-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628315 [ RunTime:0.002953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937798 LIMIT 5 [ RunTime:0.013223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937798 ORDER BY `minOrder` ASC [ RunTime:0.004075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937798 ORDER BY `unit` DESC [ RunTime:0.003262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937798 LIMIT 2 [ RunTime:0.005211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937798 ORDER BY `minOrder` ASC [ RunTime:0.000566s ]
select * from pdf where partno='284869-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284869-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.016283s ]
SELECT `id` FROM `stock` WHERE `id` <> 59937798 AND `partno` = '284869-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12631097 [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58558817 LIMIT 5 [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58558817 ORDER BY `minOrder` ASC [ RunTime:0.023424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58558817 ORDER BY `unit` DESC [ RunTime:0.001524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58558817 LIMIT 2 [ RunTime:0.015753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58558817 ORDER BY `minOrder` ASC [ RunTime:0.009655s ]
select * from pdf where partno='28486' and brandshort='Wiha' limit 1 [ RunTime:0.009642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '28486' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.009633s ]
SELECT `id` FROM `stock` WHERE `id` <> 58558817 AND `partno` = '28486' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.006578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12168366 [ RunTime:0.006201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59960806 LIMIT 5 [ RunTime:0.019271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960806 ORDER BY `minOrder` ASC [ RunTime:0.002699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59960806 ORDER BY `unit` DESC [ RunTime:0.010203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59960806 LIMIT 2 [ RunTime:0.021935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960806 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='284869-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284869-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022655s ]
SELECT `id` FROM `stock` WHERE `id` <> 59960806 AND `partno` = '284869-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.015933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12025687 [ RunTime:0.006017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59960650 LIMIT 5 [ RunTime:0.001267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960650 ORDER BY `minOrder` ASC [ RunTime:0.013641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59960650 ORDER BY `unit` DESC [ RunTime:0.008695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59960650 LIMIT 2 [ RunTime:0.006737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59960650 ORDER BY `minOrder` ASC [ RunTime:0.002923s ]
select * from pdf where partno='284869-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284869-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009332s ]
SELECT `id` FROM `stock` WHERE `id` <> 59960650 AND `partno` = '284869-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.016011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13294341 [ RunTime:0.003687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59912471 LIMIT 5 [ RunTime:0.010492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912471 ORDER BY `minOrder` ASC [ RunTime:0.012898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59912471 ORDER BY `unit` DESC [ RunTime:0.002444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59912471 LIMIT 2 [ RunTime:0.011564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912471 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='284865-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007899s ]
SELECT `id` FROM `stock` WHERE `id` <> 59912471 AND `partno` = '284865-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799838 [ RunTime:0.007402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59912237 LIMIT 5 [ RunTime:0.006071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912237 ORDER BY `minOrder` ASC [ RunTime:0.002617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59912237 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59912237 LIMIT 2 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59912237 ORDER BY `minOrder` ASC [ RunTime:0.001923s ]
select * from pdf where partno='284865-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.013121s ]
SELECT `id` FROM `stock` WHERE `id` <> 59912237 AND `partno` = '284865-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617336 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59911533 LIMIT 5 [ RunTime:0.007740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911533 ORDER BY `minOrder` ASC [ RunTime:0.003540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59911533 ORDER BY `unit` DESC [ RunTime:0.007143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59911533 LIMIT 2 [ RunTime:0.006095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911533 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
select * from pdf where partno='284865-4' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-4' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009893s ]
SELECT `id` FROM `stock` WHERE `id` <> 59911533 AND `partno` = '284865-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59911413 LIMIT 5 [ RunTime:0.002691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911413 ORDER BY `minOrder` ASC [ RunTime:0.008317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59911413 ORDER BY `unit` DESC [ RunTime:0.003832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59911413 LIMIT 2 [ RunTime:0.027973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911413 ORDER BY `minOrder` ASC [ RunTime:0.004325s ]
select * from pdf where partno='284866-8' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284866-8' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002018s ]
SELECT `id` FROM `stock` WHERE `id` <> 59911413 AND `partno` = '284866-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801678 [ RunTime:0.001740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59911238 LIMIT 5 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911238 ORDER BY `minOrder` ASC [ RunTime:0.002778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59911238 ORDER BY `unit` DESC [ RunTime:0.004954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59911238 LIMIT 2 [ RunTime:0.005582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59911238 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
select * from pdf where partno='284866-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284866-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001472s ]
SELECT `id` FROM `stock` WHERE `id` <> 59911238 AND `partno` = '284866-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11616968 [ RunTime:0.010404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59910870 LIMIT 5 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59910870 ORDER BY `minOrder` ASC [ RunTime:0.001047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59910870 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59910870 LIMIT 2 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59910870 ORDER BY `minOrder` ASC [ RunTime:0.003210s ]
select * from pdf where partno='284865-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001987s ]
SELECT `id` FROM `stock` WHERE `id` <> 59910870 AND `partno` = '284865-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801351 [ RunTime:0.001713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59910453 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59910453 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59910453 ORDER BY `unit` DESC [ RunTime:0.002378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59910453 LIMIT 2 [ RunTime:0.005162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59910453 ORDER BY `minOrder` ASC [ RunTime:0.000574s ]
select * from pdf where partno='284866-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284866-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001173s ]
SELECT `id` FROM `stock` WHERE `id` <> 59910453 AND `partno` = '284866-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801171 [ RunTime:0.000387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59907073 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907073 ORDER BY `minOrder` ASC [ RunTime:0.014116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59907073 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59907073 LIMIT 2 [ RunTime:0.000434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907073 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='284865-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '284865-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000496s ]
SELECT `id` FROM `stock` WHERE `id` <> 59907073 AND `partno` = '284865-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799816 [ RunTime:0.003202s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000966s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004425s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004844s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000944s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004186s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011402s ]
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 '28486%' OR `brand` LIKE '28486%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001043s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '28486%' OR `brand` LIKE '28486%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000695s ]