SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003254s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.185' , `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=17040&search=1' [ RunTime:0.003032s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001879s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002258s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.185' ) [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002012s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002461s ]
SELECT * FROM `stock_search` WHERE `partno` = '17040' LIMIT 1 [ RunTime:0.000930s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 11:42:12' WHERE `partno` = '17040' [ RunTime:0.003057s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002255s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005450s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11435555 LIMIT 5 [ RunTime:0.001047s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435555 ORDER BY `minOrder` ASC [ RunTime:0.002268s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11435555 ORDER BY `unit` DESC [ RunTime:0.001425s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11435555 LIMIT 2 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11435555 ORDER BY `minOrder` ASC [ RunTime:0.001815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442712 LIMIT 5 [ RunTime:0.001729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442712 ORDER BY `minOrder` ASC [ RunTime:0.009131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11442712 ORDER BY `unit` DESC [ RunTime:0.001358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11442712 LIMIT 2 [ RunTime:0.000668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11442712 ORDER BY `minOrder` ASC [ RunTime:0.003203s ]
select * from pdf where partno='1704033' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12557031 LIMIT 5 [ RunTime:0.005412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557031 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12557031 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12557031 LIMIT 2 [ RunTime:0.009016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557031 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652630 LIMIT 5 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652630 ORDER BY `minOrder` ASC [ RunTime:0.002237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652630 ORDER BY `unit` DESC [ RunTime:0.002503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652630 LIMIT 2 [ RunTime:0.003306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652630 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19624524 LIMIT 5 [ RunTime:0.002187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19624524 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19624524 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19624524 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19624524 ORDER BY `minOrder` ASC [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19012894 LIMIT 5 [ RunTime:0.005506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012894 ORDER BY `minOrder` ASC [ RunTime:0.004154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19012894 ORDER BY `unit` DESC [ RunTime:0.000711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19012894 LIMIT 2 [ RunTime:0.000904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012894 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19012890 LIMIT 5 [ RunTime:0.001090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012890 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19012890 ORDER BY `unit` DESC [ RunTime:0.002234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19012890 LIMIT 2 [ RunTime:0.007615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012890 ORDER BY `minOrder` ASC [ RunTime:0.003925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19012889 LIMIT 5 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012889 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19012889 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19012889 LIMIT 2 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012889 ORDER BY `minOrder` ASC [ RunTime:0.002522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19012883 LIMIT 5 [ RunTime:0.002774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012883 ORDER BY `minOrder` ASC [ RunTime:0.001867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19012883 ORDER BY `unit` DESC [ RunTime:0.000728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19012883 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19012883 ORDER BY `minOrder` ASC [ RunTime:0.000299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509131 LIMIT 5 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509131 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509131 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509131 LIMIT 2 [ RunTime:0.001213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509131 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509130 LIMIT 5 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509130 ORDER BY `minOrder` ASC [ RunTime:0.002106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509130 ORDER BY `unit` DESC [ RunTime:0.001105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509130 LIMIT 2 [ RunTime:0.008896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509130 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308593 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308593 ORDER BY `minOrder` ASC [ RunTime:0.001330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17308593 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17308593 LIMIT 2 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308593 ORDER BY `minOrder` ASC [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17055069 LIMIT 5 [ RunTime:0.004492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055069 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17055069 ORDER BY `unit` DESC [ RunTime:0.009842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17055069 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17055069 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305665 LIMIT 5 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305665 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305665 ORDER BY `unit` DESC [ RunTime:0.002599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305665 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305665 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13305649 LIMIT 5 [ RunTime:0.002303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305649 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13305649 ORDER BY `unit` DESC [ RunTime:0.000846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13305649 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13305649 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12557100 LIMIT 5 [ RunTime:0.000772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557100 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12557100 ORDER BY `unit` DESC [ RunTime:0.001139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12557100 LIMIT 2 [ RunTime:0.002553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557100 ORDER BY `minOrder` ASC [ RunTime:0.003031s ]
select * from pdf where partno='1704062' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12556764 LIMIT 5 [ RunTime:0.004964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556764 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12556764 ORDER BY `unit` DESC [ RunTime:0.003397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12556764 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12556764 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12492400 LIMIT 5 [ RunTime:0.001386s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492400 ORDER BY `minOrder` ASC [ RunTime:0.001116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12492400 ORDER BY `unit` DESC [ RunTime:0.000512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12492400 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12492400 ORDER BY `minOrder` ASC [ RunTime:0.004436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046501 LIMIT 5 [ RunTime:0.005117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046501 ORDER BY `minOrder` ASC [ RunTime:0.003198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046501 ORDER BY `unit` DESC [ RunTime:0.003533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046501 LIMIT 2 [ RunTime:0.002157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046501 ORDER BY `minOrder` ASC [ RunTime:0.002801s ]
select * from pdf where partno='17040' and brandshort='3M' limit 1 [ RunTime:0.008077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433790 LIMIT 5 [ RunTime:0.007208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433790 ORDER BY `minOrder` ASC [ RunTime:0.001972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11433790 ORDER BY `unit` DESC [ RunTime:0.003542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11433790 LIMIT 2 [ RunTime:0.003932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433790 ORDER BY `minOrder` ASC [ RunTime:0.007498s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003574s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560218 LIMIT 5 [ RunTime:0.001795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560218 ORDER BY `minOrder` ASC [ RunTime:0.007855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560218 ORDER BY `unit` DESC [ RunTime:0.002181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560218 LIMIT 2 [ RunTime:0.004751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560218 ORDER BY `minOrder` ASC [ RunTime:0.000861s ]
select * from pdf where partno='1704059' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004720s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704059' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60560219 LIMIT 5 [ RunTime:0.003259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560219 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60560219 ORDER BY `unit` DESC [ RunTime:0.004720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60560219 LIMIT 2 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60560219 ORDER BY `minOrder` ASC [ RunTime:0.007020s ]
select * from pdf where partno='1704020' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002529s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704020' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.011639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60566330 LIMIT 5 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566330 ORDER BY `minOrder` ASC [ RunTime:0.001151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60566330 ORDER BY `unit` DESC [ RunTime:0.002049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60566330 LIMIT 2 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566330 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
select * from pdf where partno='1704033' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704033' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009958s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60566331 LIMIT 5 [ RunTime:0.011714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566331 ORDER BY `minOrder` ASC [ RunTime:0.003757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60566331 ORDER BY `unit` DESC [ RunTime:0.000449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60566331 LIMIT 2 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60566331 ORDER BY `minOrder` ASC [ RunTime:0.000816s ]
select * from pdf where partno='1704062' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704062' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60565838 LIMIT 5 [ RunTime:0.001148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565838 ORDER BY `minOrder` ASC [ RunTime:0.001904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60565838 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60565838 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60565838 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
select * from pdf where partno='1704004' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704004' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60553227 LIMIT 5 [ RunTime:0.004346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60553227 ORDER BY `minOrder` ASC [ RunTime:0.004770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60553227 ORDER BY `unit` DESC [ RunTime:0.003039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60553227 LIMIT 2 [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60553227 ORDER BY `minOrder` ASC [ RunTime:0.000728s ]
select * from pdf where partno='1704071' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704071' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60537800 LIMIT 5 [ RunTime:0.004961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60537800 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60537800 ORDER BY `unit` DESC [ RunTime:0.001404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60537800 LIMIT 2 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60537800 ORDER BY `minOrder` ASC [ RunTime:0.004841s ]
select * from pdf where partno='1704039' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704039' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60518011 LIMIT 5 [ RunTime:0.005764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60518011 ORDER BY `minOrder` ASC [ RunTime:0.004988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60518011 ORDER BY `unit` DESC [ RunTime:0.003746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60518011 LIMIT 2 [ RunTime:0.007599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60518011 ORDER BY `minOrder` ASC [ RunTime:0.004372s ]
select * from pdf where partno='1704065' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704065' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59391610 LIMIT 5 [ RunTime:0.005453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59391610 ORDER BY `minOrder` ASC [ RunTime:0.007416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59391610 ORDER BY `unit` DESC [ RunTime:0.000816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59391610 LIMIT 2 [ RunTime:0.002021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59391610 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
select * from pdf where partno='17040.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17040.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.003330s ]
SELECT `id` FROM `stock` WHERE `id` <> 59391610 AND `partno` = '17040.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.002257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57642724 LIMIT 5 [ RunTime:0.008587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57642724 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57642724 ORDER BY `unit` DESC [ RunTime:0.003429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57642724 LIMIT 2 [ RunTime:0.004660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57642724 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
select * from pdf where partno='17040' and brandshort='3M' limit 1 [ RunTime:0.007219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '17040' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.003771s ]
SELECT `id` FROM `stock` WHERE `id` <> 57642724 AND `partno` = '17040' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.003414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046501 [ RunTime:0.002715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56565309 LIMIT 5 [ RunTime:0.003628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56565309 ORDER BY `minOrder` ASC [ RunTime:0.003148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56565309 ORDER BY `unit` DESC [ RunTime:0.004312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56565309 LIMIT 2 [ RunTime:0.009828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56565309 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
select * from pdf where partno='170408' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012904s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170408' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007681s ]
SELECT `id` FROM `stock` WHERE `id` <> 56565309 AND `partno` = '170408' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509131 [ RunTime:0.012992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56565308 LIMIT 5 [ RunTime:0.006085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56565308 ORDER BY `minOrder` ASC [ RunTime:0.005676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56565308 ORDER BY `unit` DESC [ RunTime:0.006153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56565308 LIMIT 2 [ RunTime:0.005628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56565308 ORDER BY `minOrder` ASC [ RunTime:0.011891s ]
select * from pdf where partno='170409' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008164s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '170409' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009061s ]
SELECT `id` FROM `stock` WHERE `id` <> 56565308 AND `partno` = '170409' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509130 [ RunTime:0.007677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54176609 LIMIT 5 [ RunTime:0.006735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54176609 ORDER BY `minOrder` ASC [ RunTime:0.006442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54176609 ORDER BY `unit` DESC [ RunTime:0.003364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54176609 LIMIT 2 [ RunTime:0.006823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54176609 ORDER BY `minOrder` ASC [ RunTime:0.008943s ]
select * from pdf where partno='1704000' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704000' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.010708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54129173 LIMIT 5 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129173 ORDER BY `minOrder` ASC [ RunTime:0.002112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54129173 ORDER BY `unit` DESC [ RunTime:0.005064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54129173 LIMIT 2 [ RunTime:0.011983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54129173 ORDER BY `minOrder` ASC [ RunTime:0.004102s ]
select * from pdf where partno='1704065022' and brandshort='Molex' limit 1 [ RunTime:0.005733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704065022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32324444 LIMIT 5 [ RunTime:0.004950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324444 ORDER BY `minOrder` ASC [ RunTime:0.011463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32324444 ORDER BY `unit` DESC [ RunTime:0.011092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32324444 LIMIT 2 [ RunTime:0.017733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32324444 ORDER BY `minOrder` ASC [ RunTime:0.020327s ]
select * from pdf where partno='1704001' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1704001' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012852s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009379s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036438s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005653s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009925s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003682s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004827s ]
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 '17040%' OR `brand` LIKE '17040%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007164s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '17040%' OR `brand` LIKE '17040%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007715s ]