SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000906s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=6096&search=1' [ RunTime:0.005119s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001023s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004035s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001651s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.001652s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001486s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016229s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001117s ]
SELECT * FROM `stock_search` WHERE `partno` = '6096' LIMIT 1 [ RunTime:0.019304s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 02:44:53' WHERE `partno` = '6096' [ RunTime:0.008990s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001138s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032502s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883522 LIMIT 5 [ RunTime:0.041874s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883522 ORDER BY `minOrder` ASC [ RunTime:0.039590s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12883522 ORDER BY `unit` DESC [ RunTime:0.027534s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12883522 LIMIT 2 [ RunTime:0.027004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12883522 ORDER BY `minOrder` ASC [ RunTime:0.001957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404845 LIMIT 5 [ RunTime:0.019234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404845 ORDER BY `minOrder` ASC [ RunTime:0.019260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14404845 ORDER BY `unit` DESC [ RunTime:0.021679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14404845 LIMIT 2 [ RunTime:0.011805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14404845 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961476 LIMIT 5 [ RunTime:0.010664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961476 ORDER BY `minOrder` ASC [ RunTime:0.014322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961476 ORDER BY `unit` DESC [ RunTime:0.011466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961476 LIMIT 2 [ RunTime:0.009478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961476 ORDER BY `minOrder` ASC [ RunTime:0.003068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14749488 LIMIT 5 [ RunTime:0.003558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14749488 ORDER BY `minOrder` ASC [ RunTime:0.020017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14749488 ORDER BY `unit` DESC [ RunTime:0.010521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14749488 LIMIT 2 [ RunTime:0.002876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14749488 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12456232 LIMIT 5 [ RunTime:0.015890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456232 ORDER BY `minOrder` ASC [ RunTime:0.050469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12456232 ORDER BY `unit` DESC [ RunTime:0.010578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12456232 LIMIT 2 [ RunTime:0.017377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12456232 ORDER BY `minOrder` ASC [ RunTime:0.009980s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062022s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53818504 LIMIT 5 [ RunTime:0.038324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818504 ORDER BY `minOrder` ASC [ RunTime:0.056253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53818504 ORDER BY `unit` DESC [ RunTime:0.024751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53818504 LIMIT 2 [ RunTime:0.057533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53818504 ORDER BY `minOrder` ASC [ RunTime:0.022561s ]
select * from pdf where partno='60960-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.015718s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60960-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.032841s ]
SELECT `id` FROM `stock` WHERE `id` <> 53818504 AND `partno` = '60960-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.058713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866758 LIMIT 5 [ RunTime:0.041866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866758 ORDER BY `minOrder` ASC [ RunTime:0.054683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51866758 ORDER BY `unit` DESC [ RunTime:0.023504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51866758 LIMIT 2 [ RunTime:0.023730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866758 ORDER BY `minOrder` ASC [ RunTime:0.005851s ]
select * from pdf where partno='6096' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.031895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6096' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.028194s ]
SELECT `id` FROM `stock` WHERE `id` <> 51866758 AND `partno` = '6096' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.043455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883522 [ RunTime:0.042761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56293897 LIMIT 5 [ RunTime:0.018427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56293897 ORDER BY `minOrder` ASC [ RunTime:0.026812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56293897 ORDER BY `unit` DESC [ RunTime:0.018615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56293897 LIMIT 2 [ RunTime:0.040620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56293897 ORDER BY `minOrder` ASC [ RunTime:0.004498s ]
select * from pdf where partno='6096530001' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.043582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6096530001' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.033988s ]
SELECT `id` FROM `stock` WHERE `id` <> 56293897 AND `partno` = '6096530001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.072311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14404845 [ RunTime:0.018381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51277454 LIMIT 5 [ RunTime:0.041395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51277454 ORDER BY `minOrder` ASC [ RunTime:0.033578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51277454 ORDER BY `unit` DESC [ RunTime:0.048925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51277454 LIMIT 2 [ RunTime:0.034443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51277454 ORDER BY `minOrder` ASC [ RunTime:0.010898s ]
select * from pdf where partno='6096' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.067097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6096' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.067033s ]
SELECT `id` FROM `stock` WHERE `id` <> 51277454 AND `partno` = '6096' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.053027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961476 [ RunTime:0.042019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51722429 LIMIT 5 [ RunTime:0.053648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722429 ORDER BY `minOrder` ASC [ RunTime:0.038309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51722429 ORDER BY `unit` DESC [ RunTime:0.021870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51722429 LIMIT 2 [ RunTime:0.047142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722429 ORDER BY `minOrder` ASC [ RunTime:0.029061s ]
select * from pdf where partno='60961' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.027877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60961' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.060857s ]
SELECT `id` FROM `stock` WHERE `id` <> 51722429 AND `partno` = '60961' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.014591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51722428 LIMIT 5 [ RunTime:0.063206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722428 ORDER BY `minOrder` ASC [ RunTime:0.049425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51722428 ORDER BY `unit` DESC [ RunTime:0.036871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51722428 LIMIT 2 [ RunTime:0.085913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51722428 ORDER BY `minOrder` ASC [ RunTime:0.036033s ]
select * from pdf where partno='60960' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.051632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60960' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.081205s ]
SELECT `id` FROM `stock` WHERE `id` <> 51722428 AND `partno` = '60960' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.020319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53820218 LIMIT 5 [ RunTime:0.018745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53820218 ORDER BY `minOrder` ASC [ RunTime:0.048264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53820218 ORDER BY `unit` DESC [ RunTime:0.092599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53820218 LIMIT 2 [ RunTime:0.021182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53820218 ORDER BY `minOrder` ASC [ RunTime:0.028212s ]
select * from pdf where partno='60967-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.056867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60967-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.040179s ]
SELECT `id` FROM `stock` WHERE `id` <> 53820218 AND `partno` = '60967-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.080725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42074423 LIMIT 5 [ RunTime:0.089224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42074423 ORDER BY `minOrder` ASC [ RunTime:0.065470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42074423 ORDER BY `unit` DESC [ RunTime:0.066556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42074423 LIMIT 2 [ RunTime:0.069053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42074423 ORDER BY `minOrder` ASC [ RunTime:0.047801s ]
select * from pdf where partno='609655P8' and brandshort='Schneider Electric' limit 1 [ RunTime:0.024691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609655P8' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.042393s ]
SELECT `id` FROM `stock` WHERE `id` <> 42074423 AND `partno` = '609655P8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.036559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42073155 LIMIT 5 [ RunTime:0.028612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42073155 ORDER BY `minOrder` ASC [ RunTime:0.061044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42073155 ORDER BY `unit` DESC [ RunTime:0.076625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42073155 LIMIT 2 [ RunTime:0.047517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42073155 ORDER BY `minOrder` ASC [ RunTime:0.023609s ]
select * from pdf where partno='609652P16' and brandshort='Schneider Electric' limit 1 [ RunTime:0.050808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609652P16' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.032040s ]
SELECT `id` FROM `stock` WHERE `id` <> 42073155 AND `partno` = '609652P16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.070920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42073115 LIMIT 5 [ RunTime:0.072396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42073115 ORDER BY `minOrder` ASC [ RunTime:0.097272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42073115 ORDER BY `unit` DESC [ RunTime:0.174367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42073115 LIMIT 2 [ RunTime:0.225334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42073115 ORDER BY `minOrder` ASC [ RunTime:0.038650s ]
select * from pdf where partno='609682P12' and brandshort='Schneider Electric' limit 1 [ RunTime:0.067637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609682P12' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.017501s ]
SELECT `id` FROM `stock` WHERE `id` <> 42073115 AND `partno` = '609682P12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.109089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14749488 [ RunTime:0.041447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42061350 LIMIT 5 [ RunTime:0.077629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061350 ORDER BY `minOrder` ASC [ RunTime:0.052937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42061350 ORDER BY `unit` DESC [ RunTime:0.030082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42061350 LIMIT 2 [ RunTime:0.037148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061350 ORDER BY `minOrder` ASC [ RunTime:0.010286s ]
select * from pdf where partno='609652P6' and brandshort='Schneider Electric' limit 1 [ RunTime:0.051688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609652P6' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.030553s ]
SELECT `id` FROM `stock` WHERE `id` <> 42061350 AND `partno` = '609652P6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.026373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42061349 LIMIT 5 [ RunTime:0.020187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061349 ORDER BY `minOrder` ASC [ RunTime:0.016213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42061349 ORDER BY `unit` DESC [ RunTime:0.049213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42061349 LIMIT 2 [ RunTime:0.046695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061349 ORDER BY `minOrder` ASC [ RunTime:0.047210s ]
select * from pdf where partno='609652P4' and brandshort='Schneider Electric' limit 1 [ RunTime:0.057916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609652P4' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.054173s ]
SELECT `id` FROM `stock` WHERE `id` <> 42061349 AND `partno` = '609652P4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.147635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42057396 LIMIT 5 [ RunTime:0.060782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42057396 ORDER BY `minOrder` ASC [ RunTime:0.056730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42057396 ORDER BY `unit` DESC [ RunTime:0.044680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42057396 LIMIT 2 [ RunTime:0.071038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42057396 ORDER BY `minOrder` ASC [ RunTime:0.011711s ]
select * from pdf where partno='609640P3' and brandshort='Schneider Electric' limit 1 [ RunTime:0.045529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609640P3' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.044732s ]
SELECT `id` FROM `stock` WHERE `id` <> 42057396 AND `partno` = '609640P3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.119301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42057395 LIMIT 5 [ RunTime:0.160712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42057395 ORDER BY `minOrder` ASC [ RunTime:0.175229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42057395 ORDER BY `unit` DESC [ RunTime:0.068553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42057395 LIMIT 2 [ RunTime:0.018922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42057395 ORDER BY `minOrder` ASC [ RunTime:0.018303s ]
select * from pdf where partno='609640P1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.091239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609640P1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.025921s ]
SELECT `id` FROM `stock` WHERE `id` <> 42057395 AND `partno` = '609640P1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.033135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32314976 LIMIT 5 [ RunTime:0.060800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314976 ORDER BY `minOrder` ASC [ RunTime:0.058046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32314976 ORDER BY `unit` DESC [ RunTime:0.022074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32314976 LIMIT 2 [ RunTime:0.022389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32314976 ORDER BY `minOrder` ASC [ RunTime:0.009535s ]
select * from pdf where partno='6096' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.051064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6096' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.055262s ]
SELECT `id` FROM `stock` WHERE `id` <> 32314976 AND `partno` = '6096' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.075060s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106786s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056070s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016258s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.113009s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117807s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060552s ]
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 '6096%' OR `brand` LIKE '6096%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082507s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6096%' OR `brand` LIKE '6096%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.070813s ]