SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002863s ]
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=0175&search=1' [ RunTime:0.034264s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001803s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.019235s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003449s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.028895s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001045s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007801s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003865s ]
SELECT * FROM `stock_search` WHERE `partno` = '0175' LIMIT 1 [ RunTime:0.026893s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-13 17:35:01' WHERE `partno` = '0175' [ RunTime:0.026445s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003323s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013475s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047875 LIMIT 5 [ RunTime:0.008747s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047875 ORDER BY `minOrder` ASC [ RunTime:0.016401s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12047875 ORDER BY `unit` DESC [ RunTime:0.008488s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12047875 LIMIT 2 [ RunTime:0.002631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12047875 ORDER BY `minOrder` ASC [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561756 LIMIT 5 [ RunTime:0.005679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561756 ORDER BY `minOrder` ASC [ RunTime:0.003195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561756 ORDER BY `unit` DESC [ RunTime:0.008544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561756 LIMIT 2 [ RunTime:0.006793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561756 ORDER BY `minOrder` ASC [ RunTime:0.004669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280127 LIMIT 5 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280127 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13280127 ORDER BY `unit` DESC [ RunTime:0.005324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13280127 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13280127 ORDER BY `minOrder` ASC [ RunTime:0.004640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12008112 LIMIT 5 [ RunTime:0.005482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12008112 ORDER BY `minOrder` ASC [ RunTime:0.001009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12008112 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12008112 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12008112 ORDER BY `minOrder` ASC [ RunTime:0.007304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12889355 LIMIT 5 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889355 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12889355 ORDER BY `unit` DESC [ RunTime:0.007904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12889355 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889355 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12889128 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889128 ORDER BY `minOrder` ASC [ RunTime:0.010728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12889128 ORDER BY `unit` DESC [ RunTime:0.001754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12889128 LIMIT 2 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12889128 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186772 LIMIT 5 [ RunTime:0.001010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186772 ORDER BY `minOrder` ASC [ RunTime:0.020884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12186772 ORDER BY `unit` DESC [ RunTime:0.016292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12186772 LIMIT 2 [ RunTime:0.000670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12186772 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183177 LIMIT 5 [ RunTime:0.015489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183177 ORDER BY `minOrder` ASC [ RunTime:0.005241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183177 ORDER BY `unit` DESC [ RunTime:0.018463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183177 LIMIT 2 [ RunTime:0.013111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183177 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12008887 LIMIT 5 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12008887 ORDER BY `minOrder` ASC [ RunTime:0.013933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12008887 ORDER BY `unit` DESC [ RunTime:0.003921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12008887 LIMIT 2 [ RunTime:0.003620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12008887 ORDER BY `minOrder` ASC [ RunTime:0.006320s ]
select * from pdf where partno='017505' and brandshort='HMS Networks' limit 1 [ RunTime:0.002933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11687545 LIMIT 5 [ RunTime:0.003358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687545 ORDER BY `minOrder` ASC [ RunTime:0.008959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11687545 ORDER BY `unit` DESC [ RunTime:0.006872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11687545 LIMIT 2 [ RunTime:0.003471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11687545 ORDER BY `minOrder` ASC [ RunTime:0.012438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195233 LIMIT 5 [ RunTime:0.006919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195233 ORDER BY `minOrder` ASC [ RunTime:0.000604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195233 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195233 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195233 ORDER BY `minOrder` ASC [ RunTime:0.000260s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003684s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63368135 LIMIT 5 [ RunTime:0.000564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63368135 ORDER BY `minOrder` ASC [ RunTime:0.003887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63368135 ORDER BY `unit` DESC [ RunTime:0.002634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63368135 LIMIT 2 [ RunTime:0.007378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63368135 ORDER BY `minOrder` ASC [ RunTime:0.002008s ]
select * from pdf where partno='0175010T025B' and brandshort='Essentra Components' limit 1 [ RunTime:0.006833s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175010T025B' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.005049s ]
SELECT `id` FROM `stock` WHERE `id` <> 63368135 AND `partno` = '0175010T025B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63364515 LIMIT 5 [ RunTime:0.015331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63364515 ORDER BY `minOrder` ASC [ RunTime:0.012164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63364515 ORDER BY `unit` DESC [ RunTime:0.004893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63364515 LIMIT 2 [ RunTime:0.005538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63364515 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='0175010T025' and brandshort='Essentra Components' limit 1 [ RunTime:0.006648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175010T025' OR `brand` LIKE 'Essentra Components%' ) ) LIMIT 1 [ RunTime:0.001598s ]
SELECT `id` FROM `stock` WHERE `id` <> 63364515 AND `partno` = '0175010T025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra components%' ) [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12047875 [ RunTime:0.003139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60468854 LIMIT 5 [ RunTime:0.010812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468854 ORDER BY `minOrder` ASC [ RunTime:0.014373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60468854 ORDER BY `unit` DESC [ RunTime:0.004519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60468854 LIMIT 2 [ RunTime:0.001809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468854 ORDER BY `minOrder` ASC [ RunTime:0.001462s ]
select * from pdf where partno='0175960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.003325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014564s ]
SELECT `id` FROM `stock` WHERE `id` <> 60468854 AND `partno` = '0175960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561756 [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64379224 LIMIT 5 [ RunTime:0.024603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379224 ORDER BY `minOrder` ASC [ RunTime:0.015374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64379224 ORDER BY `unit` DESC [ RunTime:0.018710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64379224 LIMIT 2 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379224 ORDER BY `minOrder` ASC [ RunTime:0.005574s ]
select * from pdf where partno='017504' and brandshort='HMS Networks' limit 1 [ RunTime:0.006758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '017504' OR `brand` LIKE 'HMS Networks%' ) ) LIMIT 1 [ RunTime:0.012267s ]
SELECT `id` FROM `stock` WHERE `id` <> 64379224 AND `partno` = '017504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hms networks%' ) [ RunTime:0.012783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13280127 [ RunTime:0.001272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64379387 LIMIT 5 [ RunTime:0.002824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379387 ORDER BY `minOrder` ASC [ RunTime:0.006283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64379387 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64379387 LIMIT 2 [ RunTime:0.006883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64379387 ORDER BY `minOrder` ASC [ RunTime:0.003990s ]
select * from pdf where partno='017509' and brandshort='HMS Networks' limit 1 [ RunTime:0.002443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '017509' OR `brand` LIKE 'HMS Networks%' ) ) LIMIT 1 [ RunTime:0.000878s ]
SELECT `id` FROM `stock` WHERE `id` <> 64379387 AND `partno` = '017509' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hms networks%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12008112 [ RunTime:0.002596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64381455 LIMIT 5 [ RunTime:0.003208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381455 ORDER BY `minOrder` ASC [ RunTime:0.011008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64381455 ORDER BY `unit` DESC [ RunTime:0.002222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64381455 LIMIT 2 [ RunTime:0.007352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64381455 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='017505' and brandshort='HMS Networks' limit 1 [ RunTime:0.002008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '017505' OR `brand` LIKE 'HMS Networks%' ) ) LIMIT 1 [ RunTime:0.005146s ]
SELECT `id` FROM `stock` WHERE `id` <> 64381455 AND `partno` = '017505' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hms networks%' ) [ RunTime:0.012597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12008887 [ RunTime:0.013502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60324299 LIMIT 5 [ RunTime:0.012246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324299 ORDER BY `minOrder` ASC [ RunTime:0.003521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60324299 ORDER BY `unit` DESC [ RunTime:0.016183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60324299 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324299 ORDER BY `minOrder` ASC [ RunTime:0.004731s ]
select * from pdf where partno='0175305105' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.014077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175305105' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.011144s ]
SELECT `id` FROM `stock` WHERE `id` <> 60324299 AND `partno` = '0175305105' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.010887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12889355 [ RunTime:0.004801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60324281 LIMIT 5 [ RunTime:0.005434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324281 ORDER BY `minOrder` ASC [ RunTime:0.005376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60324281 ORDER BY `unit` DESC [ RunTime:0.004716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60324281 LIMIT 2 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324281 ORDER BY `minOrder` ASC [ RunTime:0.003712s ]
select * from pdf where partno='0175305104' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.001361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175305104' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.015615s ]
SELECT `id` FROM `stock` WHERE `id` <> 60324281 AND `partno` = '0175305104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.009971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11687545 [ RunTime:0.004428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60324272 LIMIT 5 [ RunTime:0.014022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324272 ORDER BY `minOrder` ASC [ RunTime:0.025559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60324272 ORDER BY `unit` DESC [ RunTime:0.001633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60324272 LIMIT 2 [ RunTime:0.002281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60324272 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
select * from pdf where partno='0175305103' and brandshort='ITT Cannon, LLC' limit 1 [ RunTime:0.013499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175305103' OR `brand` LIKE 'ITT Cannon, LLC%' ) ) LIMIT 1 [ RunTime:0.010108s ]
SELECT `id` FROM `stock` WHERE `id` <> 60324272 AND `partno` = '0175305103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%itt cannon, llc%' ) [ RunTime:0.025466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12889128 [ RunTime:0.007640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58555659 LIMIT 5 [ RunTime:0.013696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555659 ORDER BY `minOrder` ASC [ RunTime:0.007058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58555659 ORDER BY `unit` DESC [ RunTime:0.017534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58555659 LIMIT 2 [ RunTime:0.005672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58555659 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='0175' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.015985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.008920s ]
SELECT `id` FROM `stock` WHERE `id` <> 58555659 AND `partno` = '0175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.017259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12186772 [ RunTime:0.003466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58548762 LIMIT 5 [ RunTime:0.000719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548762 ORDER BY `minOrder` ASC [ RunTime:0.012202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58548762 ORDER BY `unit` DESC [ RunTime:0.009644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58548762 LIMIT 2 [ RunTime:0.007407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548762 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='0175-10' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.002764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175-10' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.017506s ]
SELECT `id` FROM `stock` WHERE `id` <> 58548762 AND `partno` = '0175-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.004789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58548469 LIMIT 5 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548469 ORDER BY `minOrder` ASC [ RunTime:0.001899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58548469 ORDER BY `unit` DESC [ RunTime:0.017100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58548469 LIMIT 2 [ RunTime:0.005756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548469 ORDER BY `minOrder` ASC [ RunTime:0.003031s ]
select * from pdf where partno='0175-06' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.009189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175-06' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.001785s ]
SELECT `id` FROM `stock` WHERE `id` <> 58548469 AND `partno` = '0175-06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183177 [ RunTime:0.011766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58548441 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548441 ORDER BY `minOrder` ASC [ RunTime:0.011678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58548441 ORDER BY `unit` DESC [ RunTime:0.005098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58548441 LIMIT 2 [ RunTime:0.001199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548441 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='0175-05' and brandshort='Gedore Tools, Inc.' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0175-05' OR `brand` LIKE 'Gedore Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000785s ]
SELECT `id` FROM `stock` WHERE `id` <> 58548441 AND `partno` = '0175-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%gedore tools, inc.%' ) [ RunTime:0.001694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195233 [ RunTime:0.001877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32340499 LIMIT 5 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32340499 ORDER BY `minOrder` ASC [ RunTime:0.002627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32340499 ORDER BY `unit` DESC [ RunTime:0.016780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32340499 LIMIT 2 [ RunTime:0.002921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32340499 ORDER BY `minOrder` ASC [ RunTime:0.000804s ]
select * from pdf where partno='01751' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.005606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '01751' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.004306s ]
SELECT `id` FROM `stock` WHERE `id` <> 32340499 AND `partno` = '01751' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.009051s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004023s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001998s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001136s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005097s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011704s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003406s ]
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 '0175%' OR `brand` LIKE '0175%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010162s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0175%' OR `brand` LIKE '0175%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015160s ]