SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001933s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.101' , `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=76064&search=1' [ RunTime:0.003124s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001972s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002527s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.101' ) [ RunTime:0.001107s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002302s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000339s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003340s ]
SELECT * FROM `stock_search` WHERE `partno` = '76064' LIMIT 1 [ RunTime:0.000906s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-21 13:56:47' WHERE `partno` = '76064' [ RunTime:0.013866s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002515s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015900s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18824580 LIMIT 5 [ RunTime:0.001090s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18824580 ORDER BY `minOrder` ASC [ RunTime:0.007852s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18824580 ORDER BY `unit` DESC [ RunTime:0.009765s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18824580 LIMIT 2 [ RunTime:0.004773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18824580 ORDER BY `minOrder` ASC [ RunTime:0.004135s ]
select * from pdf where partno='76064-00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.006207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18807346 LIMIT 5 [ RunTime:0.011415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18807346 ORDER BY `minOrder` ASC [ RunTime:0.007131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18807346 ORDER BY `unit` DESC [ RunTime:0.014664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18807346 LIMIT 2 [ RunTime:0.033411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18807346 ORDER BY `minOrder` ASC [ RunTime:0.019111s ]
select * from pdf where partno='76064-B00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.005443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185224 LIMIT 5 [ RunTime:0.008977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185224 ORDER BY `minOrder` ASC [ RunTime:0.017834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11185224 ORDER BY `unit` DESC [ RunTime:0.003422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11185224 LIMIT 2 [ RunTime:0.026475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185224 ORDER BY `minOrder` ASC [ RunTime:0.003860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823154 LIMIT 5 [ RunTime:0.020111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823154 ORDER BY `minOrder` ASC [ RunTime:0.051233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18823154 ORDER BY `unit` DESC [ RunTime:0.004392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18823154 LIMIT 2 [ RunTime:0.043082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823154 ORDER BY `minOrder` ASC [ RunTime:0.023004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823082 LIMIT 5 [ RunTime:0.014095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823082 ORDER BY `minOrder` ASC [ RunTime:0.018472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18823082 ORDER BY `unit` DESC [ RunTime:0.006643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18823082 LIMIT 2 [ RunTime:0.025466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823082 ORDER BY `minOrder` ASC [ RunTime:0.028634s ]
select * from pdf where partno='76064-B00000850-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.008998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823079 LIMIT 5 [ RunTime:0.012120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823079 ORDER BY `minOrder` ASC [ RunTime:0.033448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18823079 ORDER BY `unit` DESC [ RunTime:0.012240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18823079 LIMIT 2 [ RunTime:0.007957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18823079 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
select * from pdf where partno='76064-B00000600-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.020329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420668 LIMIT 5 [ RunTime:0.025333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14420668 ORDER BY `minOrder` ASC [ RunTime:0.051349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14420668 ORDER BY `unit` DESC [ RunTime:0.003352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14420668 LIMIT 2 [ RunTime:0.009516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14420668 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13335500 LIMIT 5 [ RunTime:0.010301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13335500 ORDER BY `minOrder` ASC [ RunTime:0.041568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13335500 ORDER BY `unit` DESC [ RunTime:0.018555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13335500 LIMIT 2 [ RunTime:0.004514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13335500 ORDER BY `minOrder` ASC [ RunTime:0.010224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12055693 LIMIT 5 [ RunTime:0.011831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12055693 ORDER BY `minOrder` ASC [ RunTime:0.005584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12055693 ORDER BY `unit` DESC [ RunTime:0.003242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12055693 LIMIT 2 [ RunTime:0.002237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12055693 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='76064-00000660-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000610s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51080582 LIMIT 5 [ RunTime:0.007943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080582 ORDER BY `minOrder` ASC [ RunTime:0.011883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51080582 ORDER BY `unit` DESC [ RunTime:0.001400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51080582 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51080582 ORDER BY `minOrder` ASC [ RunTime:0.009009s ]
select * from pdf where partno='76064-00000660-05' and brandshort='honeywell' limit 1 [ RunTime:0.003279s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000660-05' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.007676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081382 LIMIT 5 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081382 ORDER BY `minOrder` ASC [ RunTime:0.001602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081382 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081382 LIMIT 2 [ RunTime:0.007124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081382 ORDER BY `minOrder` ASC [ RunTime:0.002918s ]
select * from pdf where partno='76064-b00000600-01' and brandshort='honeywell' limit 1 [ RunTime:0.003830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-b00000600-01' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.009600s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50819335 LIMIT 5 [ RunTime:0.009664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50819335 ORDER BY `minOrder` ASC [ RunTime:0.009194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50819335 ORDER BY `unit` DESC [ RunTime:0.007052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50819335 LIMIT 2 [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50819335 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='76064-B00000650-05' and brandshort='Honeywell' limit 1 [ RunTime:0.006428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000650-05' OR `brand` LIKE 'Honeywell%' ) ) LIMIT 1 [ RunTime:0.010404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38259239 LIMIT 5 [ RunTime:0.007982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38259239 ORDER BY `minOrder` ASC [ RunTime:0.004032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38259239 ORDER BY `unit` DESC [ RunTime:0.023038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38259239 LIMIT 2 [ RunTime:0.002118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38259239 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='76064-B00000650-05' and brandshort='Honeywell' limit 1 [ RunTime:0.000476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000650-05' OR `brand` LIKE 'Honeywell%' ) ) LIMIT 1 [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50819134 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50819134 ORDER BY `minOrder` ASC [ RunTime:0.001161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50819134 ORDER BY `unit` DESC [ RunTime:0.000898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50819134 LIMIT 2 [ RunTime:0.004350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50819134 ORDER BY `minOrder` ASC [ RunTime:0.002576s ]
select * from pdf where partno='76064-00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000600-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.006351s ]
SELECT `id` FROM `stock` WHERE `id` <> 50819134 AND `partno` = '76064-00000600-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18824580 [ RunTime:0.001011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38258937 LIMIT 5 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38258937 ORDER BY `minOrder` ASC [ RunTime:0.004009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38258937 ORDER BY `unit` DESC [ RunTime:0.004985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38258937 LIMIT 2 [ RunTime:0.008280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38258937 ORDER BY `minOrder` ASC [ RunTime:0.002678s ]
select * from pdf where partno='76064-00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000600-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000415s ]
SELECT `id` FROM `stock` WHERE `id` <> 38258937 AND `partno` = '76064-00000600-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.000986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18824580 [ RunTime:0.007554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38266951 LIMIT 5 [ RunTime:0.003913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38266951 ORDER BY `minOrder` ASC [ RunTime:0.007331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38266951 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38266951 LIMIT 2 [ RunTime:0.002288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38266951 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='76064-B00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000530s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000600-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 38266951 AND `partno` = '76064-B00000600-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18807346 [ RunTime:0.000371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50823981 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50823981 ORDER BY `minOrder` ASC [ RunTime:0.001713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50823981 ORDER BY `unit` DESC [ RunTime:0.002330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50823981 LIMIT 2 [ RunTime:0.011784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50823981 ORDER BY `minOrder` ASC [ RunTime:0.010035s ]
select * from pdf where partno='76064-B00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.001148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000600-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000413s ]
SELECT `id` FROM `stock` WHERE `id` <> 50823981 AND `partno` = '76064-B00000600-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.001239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18807346 [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50857722 LIMIT 5 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857722 ORDER BY `minOrder` ASC [ RunTime:0.007908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50857722 ORDER BY `unit` DESC [ RunTime:0.006904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50857722 LIMIT 2 [ RunTime:0.004165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857722 ORDER BY `minOrder` ASC [ RunTime:0.010695s ]
select * from pdf where partno='76064-B00000650-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000650-14' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.003977s ]
SELECT `id` FROM `stock` WHERE `id` <> 50857722 AND `partno` = '76064-B00000650-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.011269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823154 [ RunTime:0.007074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50857661 LIMIT 5 [ RunTime:0.010098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857661 ORDER BY `minOrder` ASC [ RunTime:0.011533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50857661 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50857661 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857661 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='76064-B00000850-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.005490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000850-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000443s ]
SELECT `id` FROM `stock` WHERE `id` <> 50857661 AND `partno` = '76064-B00000850-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.006460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823082 [ RunTime:0.006641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50857659 LIMIT 5 [ RunTime:0.001338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857659 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50857659 ORDER BY `unit` DESC [ RunTime:0.010156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50857659 LIMIT 2 [ RunTime:0.013945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50857659 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
select * from pdf where partno='76064-B00000600-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000600-22' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT `id` FROM `stock` WHERE `id` <> 50857659 AND `partno` = '76064-B00000600-22' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.001069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823079 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50714012 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50714012 ORDER BY `minOrder` ASC [ RunTime:0.014001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50714012 ORDER BY `unit` DESC [ RunTime:0.017622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50714012 LIMIT 2 [ RunTime:0.001103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50714012 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='76064' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000933s ]
SELECT `id` FROM `stock` WHERE `id` <> 50714012 AND `partno` = '76064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420668 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49417868 LIMIT 5 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417868 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49417868 ORDER BY `unit` DESC [ RunTime:0.000432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49417868 LIMIT 2 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417868 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
select * from pdf where partno='76064-B00000750-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000750-14' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000421s ]
SELECT `id` FROM `stock` WHERE `id` <> 49417868 AND `partno` = '76064-B00000750-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36611560 [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49417651 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417651 ORDER BY `minOrder` ASC [ RunTime:0.003418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49417651 ORDER BY `unit` DESC [ RunTime:0.003378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49417651 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417651 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
select * from pdf where partno='76064-00000660-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000545s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000660-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000479s ]
SELECT `id` FROM `stock` WHERE `id` <> 49417651 AND `partno` = '76064-00000660-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12055693 [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49417569 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417569 ORDER BY `minOrder` ASC [ RunTime:0.003911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49417569 ORDER BY `unit` DESC [ RunTime:0.000458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49417569 LIMIT 2 [ RunTime:0.001748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49417569 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
select * from pdf where partno='76064-00000660-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000660-05' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000423s ]
SELECT `id` FROM `stock` WHERE `id` <> 49417569 AND `partno` = '76064-00000660-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.001066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13335500 [ RunTime:0.000420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38322297 LIMIT 5 [ RunTime:0.015221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322297 ORDER BY `minOrder` ASC [ RunTime:0.003711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38322297 ORDER BY `unit` DESC [ RunTime:0.010331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38322297 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322297 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
select * from pdf where partno='76064-B00000650-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000650-14' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000464s ]
SELECT `id` FROM `stock` WHERE `id` <> 38322297 AND `partno` = '76064-B00000650-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.005748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823154 [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38322193 LIMIT 5 [ RunTime:0.005040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322193 ORDER BY `minOrder` ASC [ RunTime:0.009652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38322193 ORDER BY `unit` DESC [ RunTime:0.005501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38322193 LIMIT 2 [ RunTime:0.002078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322193 ORDER BY `minOrder` ASC [ RunTime:0.009384s ]
select * from pdf where partno='76064-B00000850-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000850-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 38322193 AND `partno` = '76064-B00000850-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.002875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823082 [ RunTime:0.006380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38322191 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322191 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38322191 ORDER BY `unit` DESC [ RunTime:0.003355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38322191 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38322191 ORDER BY `minOrder` ASC [ RunTime:0.006690s ]
select * from pdf where partno='76064-B00000600-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.001179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000600-22' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT `id` FROM `stock` WHERE `id` <> 38322191 AND `partno` = '76064-B00000600-22' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.001033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18823079 [ RunTime:0.004498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38103413 LIMIT 5 [ RunTime:0.007797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38103413 ORDER BY `minOrder` ASC [ RunTime:0.023002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38103413 ORDER BY `unit` DESC [ RunTime:0.027138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38103413 LIMIT 2 [ RunTime:0.028883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38103413 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
select * from pdf where partno='76064' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004264s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 38103413 AND `partno` = '76064' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14420668 [ RunTime:0.009219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36611560 LIMIT 5 [ RunTime:0.002764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611560 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36611560 ORDER BY `unit` DESC [ RunTime:0.003499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36611560 LIMIT 2 [ RunTime:0.005395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611560 ORDER BY `minOrder` ASC [ RunTime:0.022004s ]
select * from pdf where partno='76064-B00000750-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-B00000750-14' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.004215s ]
SELECT `id` FROM `stock` WHERE `id` <> 36611560 AND `partno` = '76064-B00000750-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.009424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49417868 [ RunTime:0.016365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36611294 LIMIT 5 [ RunTime:0.009852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611294 ORDER BY `minOrder` ASC [ RunTime:0.005479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36611294 ORDER BY `unit` DESC [ RunTime:0.020961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36611294 LIMIT 2 [ RunTime:0.017626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611294 ORDER BY `minOrder` ASC [ RunTime:0.010920s ]
select * from pdf where partno='76064-00000660-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.012426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000660-01' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.000796s ]
SELECT `id` FROM `stock` WHERE `id` <> 36611294 AND `partno` = '76064-00000660-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.013333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12055693 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36611154 LIMIT 5 [ RunTime:0.001588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611154 ORDER BY `minOrder` ASC [ RunTime:0.013591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36611154 ORDER BY `unit` DESC [ RunTime:0.021378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36611154 LIMIT 2 [ RunTime:0.004759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36611154 ORDER BY `minOrder` ASC [ RunTime:0.002381s ]
select * from pdf where partno='76064-00000660-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.004896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76064-00000660-05' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions%' ) ) LIMIT 1 [ RunTime:0.007457s ]
SELECT `id` FROM `stock` WHERE `id` <> 36611154 AND `partno` = '76064-00000660-05' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions%' ) [ RunTime:0.006051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13335500 [ RunTime:0.008715s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012837s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006506s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018711s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048613s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020687s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011834s ]
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 '76064%' OR `brand` LIKE '76064%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018915s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '76064%' OR `brand` LIKE '76064%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020242s ]