SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001588s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=3400.1&search=1' [ RunTime:0.001630s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000934s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000474s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001748s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001044s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010592s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001023s ]
SELECT * FROM `stock_search` WHERE `partno` = '3400.1' LIMIT 1 [ RunTime:0.005041s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 07:37:42' WHERE `partno` = '3400.1' [ RunTime:0.006138s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001805s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006622s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655856 LIMIT 5 [ RunTime:0.006205s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655856 ORDER BY `minOrder` ASC [ RunTime:0.003774s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16655856 ORDER BY `unit` DESC [ RunTime:0.009590s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16655856 LIMIT 2 [ RunTime:0.005521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655856 ORDER BY `minOrder` ASC [ RunTime:0.005447s ]
select * from pdf where partno='3400.17.0410' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.016138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655841 LIMIT 5 [ RunTime:0.030632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655841 ORDER BY `minOrder` ASC [ RunTime:0.031568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16655841 ORDER BY `unit` DESC [ RunTime:0.006099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16655841 LIMIT 2 [ RunTime:0.007709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655841 ORDER BY `minOrder` ASC [ RunTime:0.007993s ]
select * from pdf where partno='3400.17.0431' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.007683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655830 LIMIT 5 [ RunTime:0.018552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655830 ORDER BY `minOrder` ASC [ RunTime:0.008442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16655830 ORDER BY `unit` DESC [ RunTime:0.022287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16655830 LIMIT 2 [ RunTime:0.012816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16655830 ORDER BY `minOrder` ASC [ RunTime:0.023464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794511 LIMIT 5 [ RunTime:0.031637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794511 ORDER BY `minOrder` ASC [ RunTime:0.009504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14794511 ORDER BY `unit` DESC [ RunTime:0.031082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14794511 LIMIT 2 [ RunTime:0.036395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794511 ORDER BY `minOrder` ASC [ RunTime:0.019336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794506 LIMIT 5 [ RunTime:0.029660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794506 ORDER BY `minOrder` ASC [ RunTime:0.007343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14794506 ORDER BY `unit` DESC [ RunTime:0.015129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14794506 LIMIT 2 [ RunTime:0.066259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794506 ORDER BY `minOrder` ASC [ RunTime:0.004546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794505 LIMIT 5 [ RunTime:0.030201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794505 ORDER BY `minOrder` ASC [ RunTime:0.025419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14794505 ORDER BY `unit` DESC [ RunTime:0.000950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14794505 LIMIT 2 [ RunTime:0.005795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794505 ORDER BY `minOrder` ASC [ RunTime:0.036915s ]
select * from pdf where partno='3400.17.0235' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.035650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794496 LIMIT 5 [ RunTime:0.010719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794496 ORDER BY `minOrder` ASC [ RunTime:0.027086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14794496 ORDER BY `unit` DESC [ RunTime:0.006927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14794496 LIMIT 2 [ RunTime:0.011517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14794496 ORDER BY `minOrder` ASC [ RunTime:0.029287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900092 LIMIT 5 [ RunTime:0.021564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900092 ORDER BY `minOrder` ASC [ RunTime:0.017065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900092 ORDER BY `unit` DESC [ RunTime:0.025049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900092 LIMIT 2 [ RunTime:0.028458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900092 ORDER BY `minOrder` ASC [ RunTime:0.026791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900088 LIMIT 5 [ RunTime:0.016099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900088 ORDER BY `minOrder` ASC [ RunTime:0.006336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900088 ORDER BY `unit` DESC [ RunTime:0.022496s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900088 LIMIT 2 [ RunTime:0.023461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900088 ORDER BY `minOrder` ASC [ RunTime:0.015714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900086 LIMIT 5 [ RunTime:0.027167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900086 ORDER BY `minOrder` ASC [ RunTime:0.022427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900086 ORDER BY `unit` DESC [ RunTime:0.012438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900086 LIMIT 2 [ RunTime:0.014595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900086 ORDER BY `minOrder` ASC [ RunTime:0.020610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900069 LIMIT 5 [ RunTime:0.029418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900069 ORDER BY `minOrder` ASC [ RunTime:0.007219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900069 ORDER BY `unit` DESC [ RunTime:0.005315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900069 LIMIT 2 [ RunTime:0.017523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900069 ORDER BY `minOrder` ASC [ RunTime:0.009357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11982247 LIMIT 5 [ RunTime:0.008557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11982247 ORDER BY `minOrder` ASC [ RunTime:0.013452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11982247 ORDER BY `unit` DESC [ RunTime:0.012114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11982247 LIMIT 2 [ RunTime:0.015263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11982247 ORDER BY `minOrder` ASC [ RunTime:0.005870s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133161 LIMIT 5 [ RunTime:0.012528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133161 ORDER BY `minOrder` ASC [ RunTime:0.009594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133161 ORDER BY `unit` DESC [ RunTime:0.004902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133161 LIMIT 2 [ RunTime:0.029575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133161 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
select * from pdf where partno='3400.125.200.0' and brandshort='igus' limit 1 [ RunTime:0.007769s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.125.200.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.012896s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133161 AND `partno` = '3400.125.200.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.017045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133095 LIMIT 5 [ RunTime:0.017117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133095 ORDER BY `minOrder` ASC [ RunTime:0.030634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133095 ORDER BY `unit` DESC [ RunTime:0.027558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133095 LIMIT 2 [ RunTime:0.033819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133095 ORDER BY `minOrder` ASC [ RunTime:0.014298s ]
select * from pdf where partno='3400.125.100.0' and brandshort='igus' limit 1 [ RunTime:0.008680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.125.100.0' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.004950s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133095 AND `partno` = '3400.125.100.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.009942s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57387337 LIMIT 5 [ RunTime:0.006474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387337 ORDER BY `minOrder` ASC [ RunTime:0.007963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57387337 ORDER BY `unit` DESC [ RunTime:0.005571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57387337 LIMIT 2 [ RunTime:0.003485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387337 ORDER BY `minOrder` ASC [ RunTime:0.011377s ]
select * from pdf where partno='3400.19.0016' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.035845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.19.0016' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.020148s ]
SELECT `id` FROM `stock` WHERE `id` <> 57387337 AND `partno` = '3400.19.0016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.012778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57387228 LIMIT 5 [ RunTime:0.004595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387228 ORDER BY `minOrder` ASC [ RunTime:0.023256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57387228 ORDER BY `unit` DESC [ RunTime:0.007256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57387228 LIMIT 2 [ RunTime:0.021872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387228 ORDER BY `minOrder` ASC [ RunTime:0.017616s ]
select * from pdf where partno='3400.17.0385' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.033228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0385' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.031071s ]
SELECT `id` FROM `stock` WHERE `id` <> 57387228 AND `partno` = '3400.17.0385' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.015832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57387163 LIMIT 5 [ RunTime:0.011367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387163 ORDER BY `minOrder` ASC [ RunTime:0.018331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57387163 ORDER BY `unit` DESC [ RunTime:0.016085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57387163 LIMIT 2 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387163 ORDER BY `minOrder` ASC [ RunTime:0.002632s ]
select * from pdf where partno='3400.17.0230' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.024760s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0230' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.041030s ]
SELECT `id` FROM `stock` WHERE `id` <> 57387163 AND `partno` = '3400.17.0230' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.019666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57387099 LIMIT 5 [ RunTime:0.018968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387099 ORDER BY `minOrder` ASC [ RunTime:0.035655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57387099 ORDER BY `unit` DESC [ RunTime:0.016896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57387099 LIMIT 2 [ RunTime:0.004686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57387099 ORDER BY `minOrder` ASC [ RunTime:0.004898s ]
select * from pdf where partno='3400.17.0387' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.020520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0387' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.027073s ]
SELECT `id` FROM `stock` WHERE `id` <> 57387099 AND `partno` = '3400.17.0387' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.027351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11982247 [ RunTime:0.043808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57386972 LIMIT 5 [ RunTime:0.009002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57386972 ORDER BY `minOrder` ASC [ RunTime:0.034094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57386972 ORDER BY `unit` DESC [ RunTime:0.026727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57386972 LIMIT 2 [ RunTime:0.011286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57386972 ORDER BY `minOrder` ASC [ RunTime:0.014371s ]
select * from pdf where partno='3400.17.0024' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0024' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.012476s ]
SELECT `id` FROM `stock` WHERE `id` <> 57386972 AND `partno` = '3400.17.0024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.025592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52528014 LIMIT 5 [ RunTime:0.041907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52528014 ORDER BY `minOrder` ASC [ RunTime:0.019249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52528014 ORDER BY `unit` DESC [ RunTime:0.016987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52528014 LIMIT 2 [ RunTime:0.023773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52528014 ORDER BY `minOrder` ASC [ RunTime:0.014435s ]
select * from pdf where partno='3400.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.017137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.011324s ]
SELECT `id` FROM `stock` WHERE `id` <> 52528014 AND `partno` = '3400.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.016480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321455 LIMIT 5 [ RunTime:0.000834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321455 ORDER BY `minOrder` ASC [ RunTime:0.008108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321455 ORDER BY `unit` DESC [ RunTime:0.025734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321455 LIMIT 2 [ RunTime:0.029075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321455 ORDER BY `minOrder` ASC [ RunTime:0.003871s ]
select * from pdf where partno='3400.17.0380' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.004768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0380' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.004448s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321455 AND `partno` = '3400.17.0380' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.020175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794511 [ RunTime:0.008790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321442 LIMIT 5 [ RunTime:0.005083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321442 ORDER BY `minOrder` ASC [ RunTime:0.020282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321442 ORDER BY `unit` DESC [ RunTime:0.005233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321442 LIMIT 2 [ RunTime:0.004021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321442 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='3400.17.0388' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.003515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0388' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.005799s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321442 AND `partno` = '3400.17.0388' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.006132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794506 [ RunTime:0.027178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321439 LIMIT 5 [ RunTime:0.007935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321439 ORDER BY `minOrder` ASC [ RunTime:0.014827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321439 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321439 LIMIT 2 [ RunTime:0.025788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321439 ORDER BY `minOrder` ASC [ RunTime:0.010970s ]
select * from pdf where partno='3400.17.0235' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.003993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0235' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.024063s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321439 AND `partno` = '3400.17.0235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.053477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794505 [ RunTime:0.016324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321438 LIMIT 5 [ RunTime:0.024550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321438 ORDER BY `minOrder` ASC [ RunTime:0.017504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321438 ORDER BY `unit` DESC [ RunTime:0.002760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321438 LIMIT 2 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321438 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
select * from pdf where partno='3400.17.0416' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.006441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0416' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.001834s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321438 AND `partno` = '3400.17.0416' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.021179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900092 [ RunTime:0.017721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321428 LIMIT 5 [ RunTime:0.014086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321428 ORDER BY `minOrder` ASC [ RunTime:0.012212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321428 ORDER BY `unit` DESC [ RunTime:0.008565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321428 LIMIT 2 [ RunTime:0.014281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321428 ORDER BY `minOrder` ASC [ RunTime:0.010066s ]
select * from pdf where partno='3400.17.0410' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.008094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0410' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.013538s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321428 AND `partno` = '3400.17.0410' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.008571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655856 [ RunTime:0.020964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321421 LIMIT 5 [ RunTime:0.025624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321421 ORDER BY `minOrder` ASC [ RunTime:0.052750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321421 ORDER BY `unit` DESC [ RunTime:0.021851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321421 LIMIT 2 [ RunTime:0.043321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321421 ORDER BY `minOrder` ASC [ RunTime:0.033127s ]
select * from pdf where partno='3400.17.0377' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.010044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0377' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.035066s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321421 AND `partno` = '3400.17.0377' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.022273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900086 [ RunTime:0.013002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321413 LIMIT 5 [ RunTime:0.005106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321413 ORDER BY `minOrder` ASC [ RunTime:0.014461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321413 ORDER BY `unit` DESC [ RunTime:0.011093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321413 LIMIT 2 [ RunTime:0.015161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321413 ORDER BY `minOrder` ASC [ RunTime:0.002582s ]
select * from pdf where partno='3400.17.0254' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.004639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0254' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.011626s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321413 AND `partno` = '3400.17.0254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.001047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900088 [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321410 LIMIT 5 [ RunTime:0.006508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321410 ORDER BY `minOrder` ASC [ RunTime:0.004156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321410 ORDER BY `unit` DESC [ RunTime:0.016155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321410 LIMIT 2 [ RunTime:0.003455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321410 ORDER BY `minOrder` ASC [ RunTime:0.010992s ]
select * from pdf where partno='3400.17.0247' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.000841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0247' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.006820s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321410 AND `partno` = '3400.17.0247' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.005714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14794496 [ RunTime:0.010834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321384 LIMIT 5 [ RunTime:0.020282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321384 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321384 ORDER BY `unit` DESC [ RunTime:0.005492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321384 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321384 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
select * from pdf where partno='3400.17.0431' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.008556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0431' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.000993s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321384 AND `partno` = '3400.17.0431' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.003618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655841 [ RunTime:0.009163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321365 LIMIT 5 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321365 ORDER BY `minOrder` ASC [ RunTime:0.003143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321365 ORDER BY `unit` DESC [ RunTime:0.012843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321365 LIMIT 2 [ RunTime:0.005116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321365 ORDER BY `minOrder` ASC [ RunTime:0.001843s ]
select * from pdf where partno='3400.17.0428' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.020830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0428' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.014306s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321365 AND `partno` = '3400.17.0428' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.003051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900069 [ RunTime:0.003930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51321364 LIMIT 5 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321364 ORDER BY `minOrder` ASC [ RunTime:0.013733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51321364 ORDER BY `unit` DESC [ RunTime:0.008979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51321364 LIMIT 2 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51321364 ORDER BY `minOrder` ASC [ RunTime:0.001467s ]
select * from pdf where partno='3400.17.0426' and brandshort='Huber+Suhner, Inc.' limit 1 [ RunTime:0.009281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3400.17.0426' OR `brand` LIKE 'Huber+Suhner, Inc.%' ) ) LIMIT 1 [ RunTime:0.001106s ]
SELECT `id` FROM `stock` WHERE `id` <> 51321364 AND `partno` = '3400.17.0426' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%huber+suhner, inc.%' ) [ RunTime:0.011321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16655830 [ RunTime:0.015205s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009372s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002548s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013318s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012743s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015077s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003716s ]
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 '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011272s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3400.1%' OR `brand` LIKE '3400.1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010509s ]