SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002325s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=86064&search=1' [ RunTime:0.039556s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002004s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004918s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002753s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.017225s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002302s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.027208s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005032s ]
SELECT * FROM `stock_search` WHERE `partno` = '86064' LIMIT 1 [ RunTime:0.035733s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-29 15:35:19' WHERE `partno` = '86064' [ RunTime:0.009414s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003246s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046369s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846470 LIMIT 5 [ RunTime:0.016170s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846470 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.010666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846470 ORDER BY `unit` DESC [ RunTime:0.029762s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846470 LIMIT 2 [ RunTime:0.015407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846470 ORDER BY `minOrder` ASC [ RunTime:0.002201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846464 LIMIT 5 [ RunTime:0.004372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846464 ORDER BY `minOrder` ASC [ RunTime:0.020819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846464 ORDER BY `unit` DESC [ RunTime:0.021967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846464 LIMIT 2 [ RunTime:0.029918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846464 ORDER BY `minOrder` ASC [ RunTime:0.025283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846458 LIMIT 5 [ RunTime:0.002601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846458 ORDER BY `minOrder` ASC [ RunTime:0.003453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846458 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846458 LIMIT 2 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846458 ORDER BY `minOrder` ASC [ RunTime:0.007039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846440 LIMIT 5 [ RunTime:0.012808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846440 ORDER BY `minOrder` ASC [ RunTime:0.019308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846440 ORDER BY `unit` DESC [ RunTime:0.042555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846440 LIMIT 2 [ RunTime:0.013618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846440 ORDER BY `minOrder` ASC [ RunTime:0.003964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846404 LIMIT 5 [ RunTime:0.016074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846404 ORDER BY `minOrder` ASC [ RunTime:0.001702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846404 ORDER BY `unit` DESC [ RunTime:0.033708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846404 LIMIT 2 [ RunTime:0.032474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846404 ORDER BY `minOrder` ASC [ RunTime:0.014423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846338 LIMIT 5 [ RunTime:0.033774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846338 ORDER BY `minOrder` ASC [ RunTime:0.043934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846338 ORDER BY `unit` DESC [ RunTime:0.020104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846338 LIMIT 2 [ RunTime:0.007235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846338 ORDER BY `minOrder` ASC [ RunTime:0.003307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846139 LIMIT 5 [ RunTime:0.001482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846139 ORDER BY `minOrder` ASC [ RunTime:0.018804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18846139 ORDER BY `unit` DESC [ RunTime:0.010271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18846139 LIMIT 2 [ RunTime:0.021517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18846139 ORDER BY `minOrder` ASC [ RunTime:0.006961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238373 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238373 ORDER BY `minOrder` ASC [ RunTime:0.009737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15238373 ORDER BY `unit` DESC [ RunTime:0.014404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15238373 LIMIT 2 [ RunTime:0.011866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238373 ORDER BY `minOrder` ASC [ RunTime:0.008421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524184 LIMIT 5 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524184 ORDER BY `minOrder` ASC [ RunTime:0.005276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524184 ORDER BY `unit` DESC [ RunTime:0.010835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524184 LIMIT 2 [ RunTime:0.012160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524184 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171855 LIMIT 5 [ RunTime:0.009010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171855 ORDER BY `minOrder` ASC [ RunTime:0.009371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12171855 ORDER BY `unit` DESC [ RunTime:0.001112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12171855 LIMIT 2 [ RunTime:0.002571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12171855 ORDER BY `minOrder` ASC [ RunTime:0.011746s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015640s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021450s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64513526 LIMIT 5 [ RunTime:0.001260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513526 ORDER BY `minOrder` ASC [ RunTime:0.013687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64513526 ORDER BY `unit` DESC [ RunTime:0.009470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64513526 LIMIT 2 [ RunTime:0.003569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64513526 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='86064' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004051s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005037s ]
SELECT `id` FROM `stock` WHERE `id` <> 64513526 AND `partno` = '86064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524184 [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452024 LIMIT 5 [ RunTime:0.007314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452024 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452024 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452024 LIMIT 2 [ RunTime:0.001704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452024 ORDER BY `minOrder` ASC [ RunTime:0.001466s ]
select * from pdf where partno='86064022' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064022' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452024 AND `partno` = '86064022' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846470 [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452015 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452015 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452015 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452015 LIMIT 2 [ RunTime:0.000611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452015 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='86064025' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064025' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000290s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452015 AND `partno` = '86064025' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846464 [ RunTime:0.000277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452007 LIMIT 5 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452007 ORDER BY `minOrder` ASC [ RunTime:0.002216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452007 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452007 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452007 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
select * from pdf where partno='86064012' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064012' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000264s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452007 AND `partno` = '86064012' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846458 [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64452003 LIMIT 5 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452003 ORDER BY `minOrder` ASC [ RunTime:0.004118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64452003 ORDER BY `unit` DESC [ RunTime:0.001905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64452003 LIMIT 2 [ RunTime:0.005746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64452003 ORDER BY `minOrder` ASC [ RunTime:0.001158s ]
select * from pdf where partno='86064015' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064015' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000276s ]
SELECT `id` FROM `stock` WHERE `id` <> 64452003 AND `partno` = '86064015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238373 [ RunTime:0.000264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451958 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451958 ORDER BY `minOrder` ASC [ RunTime:0.001067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451958 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451958 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451958 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
select * from pdf where partno='86064002' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000323s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064002' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000265s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451958 AND `partno` = '86064002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846440 [ RunTime:0.000262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451816 LIMIT 5 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451816 ORDER BY `minOrder` ASC [ RunTime:0.001143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451816 ORDER BY `unit` DESC [ RunTime:0.000279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451816 LIMIT 2 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451816 ORDER BY `minOrder` ASC [ RunTime:0.003615s ]
select * from pdf where partno='86064005' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064005' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000267s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451816 AND `partno` = '86064005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846404 [ RunTime:0.000259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451561 LIMIT 5 [ RunTime:0.000409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451561 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451561 ORDER BY `unit` DESC [ RunTime:0.000258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451561 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451561 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
select * from pdf where partno='86064007' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064007' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000258s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451561 AND `partno` = '86064007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846338 [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450685 LIMIT 5 [ RunTime:0.001835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450685 ORDER BY `minOrder` ASC [ RunTime:0.003614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450685 ORDER BY `unit` DESC [ RunTime:0.000271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450685 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450685 ORDER BY `minOrder` ASC [ RunTime:0.001535s ]
select * from pdf where partno='86064009' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064009' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.004762s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450685 AND `partno` = '86064009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.002691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450525 LIMIT 5 [ RunTime:0.002013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450525 ORDER BY `minOrder` ASC [ RunTime:0.001214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450525 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450525 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450525 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='86064008' and brandshort='WERMA USA Inc.' limit 1 [ RunTime:0.000315s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064008' OR `brand` LIKE 'WERMA USA Inc.%' ) ) LIMIT 1 [ RunTime:0.000266s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450525 AND `partno` = '86064008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%werma usa inc.%' ) [ RunTime:0.000288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18846139 [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58525807 LIMIT 5 [ RunTime:0.008677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525807 ORDER BY `minOrder` ASC [ RunTime:0.009337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58525807 ORDER BY `unit` DESC [ RunTime:0.005878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58525807 LIMIT 2 [ RunTime:0.009241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58525807 ORDER BY `minOrder` ASC [ RunTime:0.005652s ]
select * from pdf where partno='86064' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.018156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '86064' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.009559s ]
SELECT `id` FROM `stock` WHERE `id` <> 58525807 AND `partno` = '86064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.005511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12171855 [ RunTime:0.003520s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031747s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018259s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004117s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003324s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017262s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020947s ]
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 '86064%' OR `brand` LIKE '86064%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012096s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '86064%' OR `brand` LIKE '86064%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002328s ]