SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001171s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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=6034&search=1' [ RunTime:0.001706s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001255s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.007130s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.005603s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001532s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014620s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001667s ]
SELECT * FROM `stock_search` WHERE `partno` = '6034' LIMIT 1 [ RunTime:0.033145s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 11:46:11' WHERE `partno` = '6034' [ RunTime:0.007233s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002497s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027142s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343816 LIMIT 5 [ RunTime:0.006306s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343816 ORDER BY `minOrder` ASC [ RunTime:0.008801s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13343816 ORDER BY `unit` DESC [ RunTime:0.004003s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13343816 LIMIT 2 [ RunTime:0.005205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13343816 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666054 LIMIT 5 [ RunTime:0.018895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666054 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14666054 ORDER BY `unit` DESC [ RunTime:0.000311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14666054 LIMIT 2 [ RunTime:0.013192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666054 ORDER BY `minOrder` ASC [ RunTime:0.010544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881292 LIMIT 5 [ RunTime:0.000976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881292 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881292 ORDER BY `unit` DESC [ RunTime:0.000177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881292 LIMIT 2 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881292 ORDER BY `minOrder` ASC [ RunTime:0.002495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13653222 LIMIT 5 [ RunTime:0.013342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13653222 ORDER BY `minOrder` ASC [ RunTime:0.004775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13653222 ORDER BY `unit` DESC [ RunTime:0.015265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13653222 LIMIT 2 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13653222 ORDER BY `minOrder` ASC [ RunTime:0.004027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13253646 LIMIT 5 [ RunTime:0.008649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253646 ORDER BY `minOrder` ASC [ RunTime:0.007600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13253646 ORDER BY `unit` DESC [ RunTime:0.001824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13253646 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13253646 ORDER BY `minOrder` ASC [ RunTime:0.005669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666177 LIMIT 5 [ RunTime:0.013393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666177 ORDER BY `minOrder` ASC [ RunTime:0.012984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14666177 ORDER BY `unit` DESC [ RunTime:0.004296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14666177 LIMIT 2 [ RunTime:0.008378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14666177 ORDER BY `minOrder` ASC [ RunTime:0.002188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882330 LIMIT 5 [ RunTime:0.016025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882330 ORDER BY `minOrder` ASC [ RunTime:0.023109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12882330 ORDER BY `unit` DESC [ RunTime:0.007843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12882330 LIMIT 2 [ RunTime:0.012141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882330 ORDER BY `minOrder` ASC [ RunTime:0.002955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683150 LIMIT 5 [ RunTime:0.020267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683150 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683150 ORDER BY `unit` DESC [ RunTime:0.011271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683150 LIMIT 2 [ RunTime:0.016065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683150 ORDER BY `minOrder` ASC [ RunTime:0.000538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160187 LIMIT 5 [ RunTime:0.002557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160187 ORDER BY `minOrder` ASC [ RunTime:0.002098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12160187 ORDER BY `unit` DESC [ RunTime:0.014165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12160187 LIMIT 2 [ RunTime:0.009794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12160187 ORDER BY `minOrder` ASC [ RunTime:0.010919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683149 LIMIT 5 [ RunTime:0.001250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683149 ORDER BY `minOrder` ASC [ RunTime:0.008511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683149 ORDER BY `unit` DESC [ RunTime:0.005436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683149 LIMIT 2 [ RunTime:0.003155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683149 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793468 LIMIT 5 [ RunTime:0.009254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793468 ORDER BY `minOrder` ASC [ RunTime:0.001136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18793468 ORDER BY `unit` DESC [ RunTime:0.006632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18793468 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18793468 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788436 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788436 ORDER BY `minOrder` ASC [ RunTime:0.002324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788436 ORDER BY `unit` DESC [ RunTime:0.000936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788436 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788436 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18788430 LIMIT 5 [ RunTime:0.003392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788430 ORDER BY `minOrder` ASC [ RunTime:0.001003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18788430 ORDER BY `unit` DESC [ RunTime:0.001089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18788430 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18788430 ORDER BY `minOrder` ASC [ RunTime:0.008534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784229 LIMIT 5 [ RunTime:0.002840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784229 ORDER BY `minOrder` ASC [ RunTime:0.006455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784229 ORDER BY `unit` DESC [ RunTime:0.001457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784229 LIMIT 2 [ RunTime:0.002626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784229 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784173 LIMIT 5 [ RunTime:0.008835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784173 ORDER BY `minOrder` ASC [ RunTime:0.003414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784173 ORDER BY `unit` DESC [ RunTime:0.002477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784173 LIMIT 2 [ RunTime:0.014126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784173 ORDER BY `minOrder` ASC [ RunTime:0.011102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190344 LIMIT 5 [ RunTime:0.018360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190344 ORDER BY `minOrder` ASC [ RunTime:0.008510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190344 ORDER BY `unit` DESC [ RunTime:0.008104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190344 LIMIT 2 [ RunTime:0.007397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190344 ORDER BY `minOrder` ASC [ RunTime:0.008057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190252 LIMIT 5 [ RunTime:0.006650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190252 ORDER BY `minOrder` ASC [ RunTime:0.003168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190252 ORDER BY `unit` DESC [ RunTime:0.001945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190252 LIMIT 2 [ RunTime:0.014812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190252 ORDER BY `minOrder` ASC [ RunTime:0.011658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167115 LIMIT 5 [ RunTime:0.011904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167115 ORDER BY `minOrder` ASC [ RunTime:0.015797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12167115 ORDER BY `unit` DESC [ RunTime:0.011595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12167115 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12167115 ORDER BY `minOrder` ASC [ RunTime:0.008667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200647 LIMIT 5 [ RunTime:0.016141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200647 ORDER BY `minOrder` ASC [ RunTime:0.014273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200647 ORDER BY `unit` DESC [ RunTime:0.020403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200647 LIMIT 2 [ RunTime:0.012610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200647 ORDER BY `minOrder` ASC [ RunTime:0.004987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200611 LIMIT 5 [ RunTime:0.011248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200611 ORDER BY `minOrder` ASC [ RunTime:0.019203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200611 ORDER BY `unit` DESC [ RunTime:0.030949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200611 LIMIT 2 [ RunTime:0.056587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200611 ORDER BY `minOrder` ASC [ RunTime:0.010225s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008711s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64574890 LIMIT 5 [ RunTime:0.007012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574890 ORDER BY `minOrder` ASC [ RunTime:0.033892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64574890 ORDER BY `unit` DESC [ RunTime:0.015276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64574890 LIMIT 2 [ RunTime:0.019783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64574890 ORDER BY `minOrder` ASC [ RunTime:0.001768s ]
select * from pdf where partno='6034CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002218s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017936s ]
SELECT `id` FROM `stock` WHERE `id` <> 64574890 AND `partno` = '6034CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13343816 [ RunTime:0.002134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62933219 LIMIT 5 [ RunTime:0.010392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62933219 ORDER BY `minOrder` ASC [ RunTime:0.021184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62933219 ORDER BY `unit` DESC [ RunTime:0.006619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62933219 LIMIT 2 [ RunTime:0.011781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62933219 ORDER BY `minOrder` ASC [ RunTime:0.005659s ]
select * from pdf where partno='6034' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.017636s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.016814s ]
SELECT `id` FROM `stock` WHERE `id` <> 62933219 AND `partno` = '6034' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.009022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13653222 [ RunTime:0.008932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62955578 LIMIT 5 [ RunTime:0.009918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955578 ORDER BY `minOrder` ASC [ RunTime:0.019599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62955578 ORDER BY `unit` DESC [ RunTime:0.025633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62955578 LIMIT 2 [ RunTime:0.018428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955578 ORDER BY `minOrder` ASC [ RunTime:0.007970s ]
select * from pdf where partno='6034574' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034574' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020483s ]
SELECT `id` FROM `stock` WHERE `id` <> 62955578 AND `partno` = '6034574' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666054 [ RunTime:0.045202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917199 LIMIT 5 [ RunTime:0.010713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917199 ORDER BY `minOrder` ASC [ RunTime:0.010894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917199 ORDER BY `unit` DESC [ RunTime:0.002080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917199 LIMIT 2 [ RunTime:0.003896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917199 ORDER BY `minOrder` ASC [ RunTime:0.018564s ]
select * from pdf where partno='60346021210420' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346021210420' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003424s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917199 AND `partno` = '60346021210420' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881292 [ RunTime:0.001176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586521 LIMIT 5 [ RunTime:0.011735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586521 ORDER BY `minOrder` ASC [ RunTime:0.006233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586521 ORDER BY `unit` DESC [ RunTime:0.008332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586521 LIMIT 2 [ RunTime:0.012853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586521 ORDER BY `minOrder` ASC [ RunTime:0.007968s ]
select * from pdf where partno='60347' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.011388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60347' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.015447s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586521 AND `partno` = '60347' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.019371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64192857 LIMIT 5 [ RunTime:0.033443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192857 ORDER BY `minOrder` ASC [ RunTime:0.014156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64192857 ORDER BY `unit` DESC [ RunTime:0.028645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64192857 LIMIT 2 [ RunTime:0.010186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64192857 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
select * from pdf where partno='60347' and brandshort='Lantronix, Inc.' limit 1 [ RunTime:0.022365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60347' OR `brand` LIKE 'Lantronix, Inc.%' ) ) LIMIT 1 [ RunTime:0.021309s ]
SELECT `id` FROM `stock` WHERE `id` <> 64192857 AND `partno` = '60347' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lantronix, inc.%' ) [ RunTime:0.031629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13253646 [ RunTime:0.013716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62955937 LIMIT 5 [ RunTime:0.033072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955937 ORDER BY `minOrder` ASC [ RunTime:0.013345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62955937 ORDER BY `unit` DESC [ RunTime:0.016234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62955937 LIMIT 2 [ RunTime:0.007868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62955937 ORDER BY `minOrder` ASC [ RunTime:0.000802s ]
select * from pdf where partno='6034575' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034575' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005871s ]
SELECT `id` FROM `stock` WHERE `id` <> 62955937 AND `partno` = '6034575' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14666177 [ RunTime:0.030437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917200 LIMIT 5 [ RunTime:0.011127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917200 ORDER BY `minOrder` ASC [ RunTime:0.018730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917200 ORDER BY `unit` DESC [ RunTime:0.011759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917200 LIMIT 2 [ RunTime:0.025103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917200 ORDER BY `minOrder` ASC [ RunTime:0.004435s ]
select * from pdf where partno='60346020212320' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.012938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346020212320' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.017779s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917200 AND `partno` = '60346020212320' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683149 [ RunTime:0.026404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64784650 LIMIT 5 [ RunTime:0.023959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784650 ORDER BY `minOrder` ASC [ RunTime:0.019658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64784650 ORDER BY `unit` DESC [ RunTime:0.018553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64784650 LIMIT 2 [ RunTime:0.018852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64784650 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
select * from pdf where partno='6034667' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.036975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034667' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013423s ]
SELECT `id` FROM `stock` WHERE `id` <> 64784650 AND `partno` = '6034667' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18793468 [ RunTime:0.023128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61917201 LIMIT 5 [ RunTime:0.026392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917201 ORDER BY `minOrder` ASC [ RunTime:0.011327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61917201 ORDER BY `unit` DESC [ RunTime:0.023788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61917201 LIMIT 2 [ RunTime:0.018092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61917201 ORDER BY `minOrder` ASC [ RunTime:0.024510s ]
select * from pdf where partno='60346020212220' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346020212220' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016970s ]
SELECT `id` FROM `stock` WHERE `id` <> 61917201 AND `partno` = '60346020212220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.025228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882330 [ RunTime:0.021507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333668 LIMIT 5 [ RunTime:0.016707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333668 ORDER BY `minOrder` ASC [ RunTime:0.023809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333668 ORDER BY `unit` DESC [ RunTime:0.024586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333668 LIMIT 2 [ RunTime:0.011685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333668 ORDER BY `minOrder` ASC [ RunTime:0.014441s ]
select * from pdf where partno='6034867' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034867' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007041s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333668 AND `partno` = '6034867' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64109261 LIMIT 5 [ RunTime:0.007276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109261 ORDER BY `minOrder` ASC [ RunTime:0.022043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64109261 ORDER BY `unit` DESC [ RunTime:0.010133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64109261 LIMIT 2 [ RunTime:0.001815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64109261 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
select * from pdf where partno='6034482' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034482' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008965s ]
SELECT `id` FROM `stock` WHERE `id` <> 64109261 AND `partno` = '6034482' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023884 [ RunTime:0.005662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43834207 LIMIT 5 [ RunTime:0.001132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834207 ORDER BY `minOrder` ASC [ RunTime:0.013399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43834207 ORDER BY `unit` DESC [ RunTime:0.002643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43834207 LIMIT 2 [ RunTime:0.016180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43834207 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
select * from pdf where partno='6034585' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034585' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010990s ]
SELECT `id` FROM `stock` WHERE `id` <> 43834207 AND `partno` = '6034585' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.012960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17271627 [ RunTime:0.013378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335233 LIMIT 5 [ RunTime:0.045185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335233 ORDER BY `minOrder` ASC [ RunTime:0.008701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335233 ORDER BY `unit` DESC [ RunTime:0.008169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335233 LIMIT 2 [ RunTime:0.002257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335233 ORDER BY `minOrder` ASC [ RunTime:0.002480s ]
select * from pdf where partno='6034862' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.033397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034862' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004265s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335233 AND `partno` = '6034862' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.017462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784306 [ RunTime:0.006118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335160 LIMIT 5 [ RunTime:0.014285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335160 ORDER BY `minOrder` ASC [ RunTime:0.014505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335160 ORDER BY `unit` DESC [ RunTime:0.035440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335160 LIMIT 2 [ RunTime:0.011904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335160 ORDER BY `minOrder` ASC [ RunTime:0.014804s ]
select * from pdf where partno='6034863' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034863' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003610s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335160 AND `partno` = '6034863' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200647 [ RunTime:0.006817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335103 LIMIT 5 [ RunTime:0.009463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335103 ORDER BY `minOrder` ASC [ RunTime:0.015213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335103 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335103 LIMIT 2 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335103 ORDER BY `minOrder` ASC [ RunTime:0.001155s ]
select * from pdf where partno='6034875' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034875' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027243s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335103 AND `partno` = '6034875' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784229 [ RunTime:0.028635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63334962 LIMIT 5 [ RunTime:0.008870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334962 ORDER BY `minOrder` ASC [ RunTime:0.024975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63334962 ORDER BY `unit` DESC [ RunTime:0.018630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63334962 LIMIT 2 [ RunTime:0.042120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334962 ORDER BY `minOrder` ASC [ RunTime:0.015359s ]
select * from pdf where partno='6034874' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.023116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034874' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020364s ]
SELECT `id` FROM `stock` WHERE `id` <> 63334962 AND `partno` = '6034874' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784173 [ RunTime:0.020843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333623 LIMIT 5 [ RunTime:0.036004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333623 ORDER BY `minOrder` ASC [ RunTime:0.035304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333623 ORDER BY `unit` DESC [ RunTime:0.012491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333623 LIMIT 2 [ RunTime:0.023818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333623 ORDER BY `minOrder` ASC [ RunTime:0.027481s ]
select * from pdf where partno='6034866' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034866' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.044624s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333623 AND `partno` = '6034866' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784184 [ RunTime:0.033222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586399 LIMIT 5 [ RunTime:0.003834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586399 ORDER BY `minOrder` ASC [ RunTime:0.013921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586399 ORDER BY `unit` DESC [ RunTime:0.022880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586399 LIMIT 2 [ RunTime:0.039338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586399 ORDER BY `minOrder` ASC [ RunTime:0.008590s ]
select * from pdf where partno='60346' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.002873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60346' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.006977s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586399 AND `partno` = '60346' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.019451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12160187 [ RunTime:0.015367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64785364 LIMIT 5 [ RunTime:0.020534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785364 ORDER BY `minOrder` ASC [ RunTime:0.027710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64785364 ORDER BY `unit` DESC [ RunTime:0.005495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64785364 LIMIT 2 [ RunTime:0.006656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64785364 ORDER BY `minOrder` ASC [ RunTime:0.005051s ]
select * from pdf where partno='6034875' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034875' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007580s ]
SELECT `id` FROM `stock` WHERE `id` <> 64785364 AND `partno` = '6034875' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784229 [ RunTime:0.001288s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012853s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009685s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038028s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024315s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015126s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014910s ]
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 '6034%' OR `brand` LIKE '6034%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033264s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6034%' OR `brand` LIKE '6034%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016197s ]