SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003555s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.159' , `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=21700&search=1' [ RunTime:0.006639s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001957s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004319s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003324s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.159' ) [ RunTime:0.004271s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002345s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002371s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002535s ]
SELECT * FROM `stock_search` WHERE `partno` = '21700' LIMIT 1 [ RunTime:0.006317s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-09 00:10:24' WHERE `partno` = '21700' [ RunTime:0.018890s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003275s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046373s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504613 LIMIT 5 [ RunTime:0.029607s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504613 ORDER BY `minOrder` ASC [ RunTime:0.034885s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504613 ORDER BY `unit` DESC [ RunTime:0.127254s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.040374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504613 LIMIT 2 [ RunTime:0.069611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504613 ORDER BY `minOrder` ASC [ RunTime:0.006499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409377 LIMIT 5 [ RunTime:0.051651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409377 ORDER BY `minOrder` ASC [ RunTime:0.032903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409377 ORDER BY `unit` DESC [ RunTime:0.045709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409377 LIMIT 2 [ RunTime:0.061067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409377 ORDER BY `minOrder` ASC [ RunTime:0.013131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12868578 LIMIT 5 [ RunTime:0.041573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12868578 ORDER BY `minOrder` ASC [ RunTime:0.023301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12868578 ORDER BY `unit` DESC [ RunTime:0.021758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12868578 LIMIT 2 [ RunTime:0.024394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12868578 ORDER BY `minOrder` ASC [ RunTime:0.023915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12505646 LIMIT 5 [ RunTime:0.042770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12505646 ORDER BY `minOrder` ASC [ RunTime:0.029807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12505646 ORDER BY `unit` DESC [ RunTime:0.052978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12505646 LIMIT 2 [ RunTime:0.003186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12505646 ORDER BY `minOrder` ASC [ RunTime:0.017116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10838514 LIMIT 5 [ RunTime:0.038279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10838514 ORDER BY `minOrder` ASC [ RunTime:0.049353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10838514 ORDER BY `unit` DESC [ RunTime:0.060159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10838514 LIMIT 2 [ RunTime:0.060136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10838514 ORDER BY `minOrder` ASC [ RunTime:0.024331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674341 LIMIT 5 [ RunTime:0.062642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674341 ORDER BY `minOrder` ASC [ RunTime:0.095861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11674341 ORDER BY `unit` DESC [ RunTime:0.055003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11674341 LIMIT 2 [ RunTime:0.065218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674341 ORDER BY `minOrder` ASC [ RunTime:0.017787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674428 LIMIT 5 [ RunTime:0.025530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674428 ORDER BY `minOrder` ASC [ RunTime:0.021232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11674428 ORDER BY `unit` DESC [ RunTime:0.027409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11674428 LIMIT 2 [ RunTime:0.038659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674428 ORDER BY `minOrder` ASC [ RunTime:0.019153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869185 LIMIT 5 [ RunTime:0.024151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869185 ORDER BY `minOrder` ASC [ RunTime:0.006632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12869185 ORDER BY `unit` DESC [ RunTime:0.021090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12869185 LIMIT 2 [ RunTime:0.029475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869185 ORDER BY `minOrder` ASC [ RunTime:0.016577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869068 LIMIT 5 [ RunTime:0.018228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869068 ORDER BY `minOrder` ASC [ RunTime:0.039673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12869068 ORDER BY `unit` DESC [ RunTime:0.029625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12869068 LIMIT 2 [ RunTime:0.027208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12869068 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674348 LIMIT 5 [ RunTime:0.007103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674348 ORDER BY `minOrder` ASC [ RunTime:0.011122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11674348 ORDER BY `unit` DESC [ RunTime:0.017960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11674348 LIMIT 2 [ RunTime:0.014461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674348 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589964 LIMIT 5 [ RunTime:0.007936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589964 ORDER BY `minOrder` ASC [ RunTime:0.016729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589964 ORDER BY `unit` DESC [ RunTime:0.050986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589964 LIMIT 2 [ RunTime:0.032571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589964 ORDER BY `minOrder` ASC [ RunTime:0.009595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422214 LIMIT 5 [ RunTime:0.015275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422214 ORDER BY `minOrder` ASC [ RunTime:0.017163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422214 ORDER BY `unit` DESC [ RunTime:0.011564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422214 LIMIT 2 [ RunTime:0.010151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422214 ORDER BY `minOrder` ASC [ RunTime:0.010658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13302357 LIMIT 5 [ RunTime:0.017672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13302357 ORDER BY `minOrder` ASC [ RunTime:0.014306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13302357 ORDER BY `unit` DESC [ RunTime:0.004185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13302357 LIMIT 2 [ RunTime:0.016320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13302357 ORDER BY `minOrder` ASC [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12506029 LIMIT 5 [ RunTime:0.008268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12506029 ORDER BY `minOrder` ASC [ RunTime:0.009761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12506029 ORDER BY `unit` DESC [ RunTime:0.002672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12506029 LIMIT 2 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12506029 ORDER BY `minOrder` ASC [ RunTime:0.007467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12506002 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12506002 ORDER BY `minOrder` ASC [ RunTime:0.025084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12506002 ORDER BY `unit` DESC [ RunTime:0.027602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12506002 LIMIT 2 [ RunTime:0.013295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12506002 ORDER BY `minOrder` ASC [ RunTime:0.006697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017687 LIMIT 5 [ RunTime:0.017294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017687 ORDER BY `minOrder` ASC [ RunTime:0.038771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12017687 ORDER BY `unit` DESC [ RunTime:0.005163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12017687 LIMIT 2 [ RunTime:0.014028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017687 ORDER BY `minOrder` ASC [ RunTime:0.014734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674340 LIMIT 5 [ RunTime:0.019661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674340 ORDER BY `minOrder` ASC [ RunTime:0.039346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11674340 ORDER BY `unit` DESC [ RunTime:0.031212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11674340 LIMIT 2 [ RunTime:0.003268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11674340 ORDER BY `minOrder` ASC [ RunTime:0.009349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11410263 LIMIT 5 [ RunTime:0.014871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410263 ORDER BY `minOrder` ASC [ RunTime:0.007232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11410263 ORDER BY `unit` DESC [ RunTime:0.013686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11410263 LIMIT 2 [ RunTime:0.010700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11410263 ORDER BY `minOrder` ASC [ RunTime:0.016283s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255192 LIMIT 5 [ RunTime:0.018385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255192 ORDER BY `minOrder` ASC [ RunTime:0.004703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255192 ORDER BY `unit` DESC [ RunTime:0.009682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255192 LIMIT 2 [ RunTime:0.014417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255192 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='2170088-1' and brandshort='te connectivity' limit 1 [ RunTime:0.003819s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170088-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.020573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255524 LIMIT 5 [ RunTime:0.010378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255524 ORDER BY `minOrder` ASC [ RunTime:0.013115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255524 ORDER BY `unit` DESC [ RunTime:0.003029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255524 LIMIT 2 [ RunTime:0.005864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255524 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='2170088-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.003459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170088-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.003650s ]
SELECT `id` FROM `stock` WHERE `id` <> 32255524 AND `partno` = '2170088-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.010411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255334 LIMIT 5 [ RunTime:0.004449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255334 ORDER BY `minOrder` ASC [ RunTime:0.001549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255334 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255334 LIMIT 2 [ RunTime:0.001635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255334 ORDER BY `minOrder` ASC [ RunTime:0.003394s ]
select * from pdf where partno='2170030-1' and brandshort='te connectivity' limit 1 [ RunTime:0.004252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170030-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028130s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62120425 LIMIT 5 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120425 ORDER BY `minOrder` ASC [ RunTime:0.003208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62120425 ORDER BY `unit` DESC [ RunTime:0.006391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62120425 LIMIT 2 [ RunTime:0.002492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120425 ORDER BY `minOrder` ASC [ RunTime:0.003644s ]
select * from pdf where partno='2170088-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.011618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170088-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62120424 LIMIT 5 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120424 ORDER BY `minOrder` ASC [ RunTime:0.011407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62120424 ORDER BY `unit` DESC [ RunTime:0.001195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62120424 LIMIT 2 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62120424 ORDER BY `minOrder` ASC [ RunTime:0.000536s ]
select * from pdf where partno='2170088-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170088-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005868s ]
SELECT `id` FROM `stock` WHERE `id` <> 62120424 AND `partno` = '2170088-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409377 [ RunTime:0.008567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60426819 LIMIT 5 [ RunTime:0.023360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426819 ORDER BY `minOrder` ASC [ RunTime:0.035002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60426819 ORDER BY `unit` DESC [ RunTime:0.031654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60426819 LIMIT 2 [ RunTime:0.062338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426819 ORDER BY `minOrder` ASC [ RunTime:0.024636s ]
select * from pdf where partno='21700601' and brandshort='LAPP' limit 1 [ RunTime:0.017002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700601' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.013377s ]
SELECT `id` FROM `stock` WHERE `id` <> 60426819 AND `partno` = '21700601' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.070192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12868578 [ RunTime:0.034757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60426818 LIMIT 5 [ RunTime:0.022765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426818 ORDER BY `minOrder` ASC [ RunTime:0.025209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60426818 ORDER BY `unit` DESC [ RunTime:0.004020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60426818 LIMIT 2 [ RunTime:0.083108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426818 ORDER BY `minOrder` ASC [ RunTime:0.019304s ]
select * from pdf where partno='21700600' and brandshort='LAPP' limit 1 [ RunTime:0.035851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700600' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.088517s ]
SELECT `id` FROM `stock` WHERE `id` <> 60426818 AND `partno` = '21700600' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.046482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60426817 LIMIT 5 [ RunTime:0.104396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426817 ORDER BY `minOrder` ASC [ RunTime:0.046191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60426817 ORDER BY `unit` DESC [ RunTime:0.067127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60426817 LIMIT 2 [ RunTime:0.051052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426817 ORDER BY `minOrder` ASC [ RunTime:0.086717s ]
select * from pdf where partno='21700605' and brandshort='LAPP' limit 1 [ RunTime:0.043721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700605' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.048938s ]
SELECT `id` FROM `stock` WHERE `id` <> 60426817 AND `partno` = '21700605' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.042469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60426826 LIMIT 5 [ RunTime:0.036800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426826 ORDER BY `minOrder` ASC [ RunTime:0.047999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60426826 ORDER BY `unit` DESC [ RunTime:0.048366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60426826 LIMIT 2 [ RunTime:0.091492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426826 ORDER BY `minOrder` ASC [ RunTime:0.053693s ]
select * from pdf where partno='21700540' and brandshort='LAPP' limit 1 [ RunTime:0.033446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700540' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.013831s ]
SELECT `id` FROM `stock` WHERE `id` <> 60426826 AND `partno` = '21700540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.032710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674341 [ RunTime:0.004627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60427163 LIMIT 5 [ RunTime:0.005134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427163 ORDER BY `minOrder` ASC [ RunTime:0.009054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60427163 ORDER BY `unit` DESC [ RunTime:0.019269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60427163 LIMIT 2 [ RunTime:0.011862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427163 ORDER BY `minOrder` ASC [ RunTime:0.001470s ]
select * from pdf where partno='21700616' and brandshort='LAPP' limit 1 [ RunTime:0.004801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700616' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.003578s ]
SELECT `id` FROM `stock` WHERE `id` <> 60427163 AND `partno` = '21700616' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.027319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12869068 [ RunTime:0.011930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121631 LIMIT 5 [ RunTime:0.020587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121631 ORDER BY `minOrder` ASC [ RunTime:0.011640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121631 ORDER BY `unit` DESC [ RunTime:0.011018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121631 LIMIT 2 [ RunTime:0.023598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121631 ORDER BY `minOrder` ASC [ RunTime:0.008870s ]
select * from pdf where partno='2170030-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.018306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2170030-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.011798s ]
SELECT `id` FROM `stock` WHERE `id` <> 62121631 AND `partno` = '2170030-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.043508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12505646 [ RunTime:0.040679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60427227 LIMIT 5 [ RunTime:0.045384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427227 ORDER BY `minOrder` ASC [ RunTime:0.044263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60427227 ORDER BY `unit` DESC [ RunTime:0.021223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60427227 LIMIT 2 [ RunTime:0.010351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427227 ORDER BY `minOrder` ASC [ RunTime:0.008165s ]
select * from pdf where partno='21700615' and brandshort='LAPP' limit 1 [ RunTime:0.022840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700615' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.023847s ]
SELECT `id` FROM `stock` WHERE `id` <> 60427227 AND `partno` = '21700615' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.019223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674428 [ RunTime:0.016692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60427166 LIMIT 5 [ RunTime:0.025066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427166 ORDER BY `minOrder` ASC [ RunTime:0.009153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60427166 ORDER BY `unit` DESC [ RunTime:0.018658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60427166 LIMIT 2 [ RunTime:0.010639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427166 ORDER BY `minOrder` ASC [ RunTime:0.008008s ]
select * from pdf where partno='21700639' and brandshort='LAPP' limit 1 [ RunTime:0.020701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700639' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.013073s ]
SELECT `id` FROM `stock` WHERE `id` <> 60427166 AND `partno` = '21700639' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.033050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674340 [ RunTime:0.019508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60426942 LIMIT 5 [ RunTime:0.032795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426942 ORDER BY `minOrder` ASC [ RunTime:0.037549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60426942 ORDER BY `unit` DESC [ RunTime:0.016215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60426942 LIMIT 2 [ RunTime:0.009545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60426942 ORDER BY `minOrder` ASC [ RunTime:0.009482s ]
select * from pdf where partno='21700636' and brandshort='LAPP' limit 1 [ RunTime:0.028601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700636' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.040592s ]
SELECT `id` FROM `stock` WHERE `id` <> 60426942 AND `partno` = '21700636' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.018420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11674348 [ RunTime:0.016196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61145093 LIMIT 5 [ RunTime:0.041880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61145093 ORDER BY `minOrder` ASC [ RunTime:0.028207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61145093 ORDER BY `unit` DESC [ RunTime:0.102484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61145093 LIMIT 2 [ RunTime:0.048910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61145093 ORDER BY `minOrder` ASC [ RunTime:0.017101s ]
select * from pdf where partno='21700648' and brandshort='LAPP' limit 1 [ RunTime:0.053562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700648' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.017242s ]
SELECT `id` FROM `stock` WHERE `id` <> 61145093 AND `partno` = '21700648' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.015723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10838514 [ RunTime:0.037444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60427357 LIMIT 5 [ RunTime:0.004007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427357 ORDER BY `minOrder` ASC [ RunTime:0.018157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60427357 ORDER BY `unit` DESC [ RunTime:0.019581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60427357 LIMIT 2 [ RunTime:0.013819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60427357 ORDER BY `minOrder` ASC [ RunTime:0.016246s ]
select * from pdf where partno='21700630' and brandshort='LAPP' limit 1 [ RunTime:0.013629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700630' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.005665s ]
SELECT `id` FROM `stock` WHERE `id` <> 60427357 AND `partno` = '21700630' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.039567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384283 LIMIT 5 [ RunTime:0.011952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384283 ORDER BY `minOrder` ASC [ RunTime:0.037284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384283 ORDER BY `unit` DESC [ RunTime:0.022663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384283 LIMIT 2 [ RunTime:0.068004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384283 ORDER BY `minOrder` ASC [ RunTime:0.027914s ]
select * from pdf where partno='21700120' and brandshort='LAPP' limit 1 [ RunTime:0.022694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700120' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.012684s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384283 AND `partno` = '21700120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.031858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384279 LIMIT 5 [ RunTime:0.076942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384279 ORDER BY `minOrder` ASC [ RunTime:0.030453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384279 ORDER BY `unit` DESC [ RunTime:0.035658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384279 LIMIT 2 [ RunTime:0.055332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384279 ORDER BY `minOrder` ASC [ RunTime:0.007699s ]
select * from pdf where partno='21700146' and brandshort='LAPP' limit 1 [ RunTime:0.010208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700146' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.039799s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384279 AND `partno` = '21700146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.107430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384266 LIMIT 5 [ RunTime:0.057674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384266 ORDER BY `minOrder` ASC [ RunTime:0.044442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384266 ORDER BY `unit` DESC [ RunTime:0.039944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384266 LIMIT 2 [ RunTime:0.048729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384266 ORDER BY `minOrder` ASC [ RunTime:0.008844s ]
select * from pdf where partno='21700129' and brandshort='LAPP' limit 1 [ RunTime:0.026404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700129' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.020894s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384266 AND `partno` = '21700129' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.024137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384237 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384237 ORDER BY `minOrder` ASC [ RunTime:0.025145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384237 ORDER BY `unit` DESC [ RunTime:0.011167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384237 LIMIT 2 [ RunTime:0.038190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384237 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
select * from pdf where partno='21700144' and brandshort='LAPP' limit 1 [ RunTime:0.013492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700144' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.030534s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384237 AND `partno` = '21700144' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.025132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64058763 LIMIT 5 [ RunTime:0.042773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058763 ORDER BY `minOrder` ASC [ RunTime:0.036255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64058763 ORDER BY `unit` DESC [ RunTime:0.045400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64058763 LIMIT 2 [ RunTime:0.015759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058763 ORDER BY `minOrder` ASC [ RunTime:0.043704s ]
select * from pdf where partno='21700150' and brandshort='LAPP' limit 1 [ RunTime:0.010986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700150' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.021681s ]
SELECT `id` FROM `stock` WHERE `id` <> 64058763 AND `partno` = '21700150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.047370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64058762 LIMIT 5 [ RunTime:0.053878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058762 ORDER BY `minOrder` ASC [ RunTime:0.058035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64058762 ORDER BY `unit` DESC [ RunTime:0.027403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64058762 LIMIT 2 [ RunTime:0.013200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64058762 ORDER BY `minOrder` ASC [ RunTime:0.010898s ]
select * from pdf where partno='21700151' and brandshort='LAPP' limit 1 [ RunTime:0.005764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700151' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.015385s ]
SELECT `id` FROM `stock` WHERE `id` <> 64058762 AND `partno` = '21700151' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.036851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64384246 LIMIT 5 [ RunTime:0.013588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384246 ORDER BY `minOrder` ASC [ RunTime:0.028019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64384246 ORDER BY `unit` DESC [ RunTime:0.007814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64384246 LIMIT 2 [ RunTime:0.012597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64384246 ORDER BY `minOrder` ASC [ RunTime:0.013228s ]
select * from pdf where partno='21700145' and brandshort='LAPP' limit 1 [ RunTime:0.022349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '21700145' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.024283s ]
SELECT `id` FROM `stock` WHERE `id` <> 64384246 AND `partno` = '21700145' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.009763s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019532s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037080s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019221s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015771s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053590s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044313s ]
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 '21700%' OR `brand` LIKE '21700%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023725s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '21700%' OR `brand` LIKE '21700%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041108s ]