SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002438s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=0982&search=1' [ RunTime:0.006922s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001951s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002550s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002529s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002077s ]
SELECT * FROM `stock_search` WHERE `partno` = '0982' LIMIT 1 [ RunTime:0.011730s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-16 04:55:44' WHERE `partno` = '0982' [ RunTime:0.003357s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002149s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056094s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14517021 LIMIT 5 [ RunTime:0.004186s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517021 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14517021 ORDER BY `unit` DESC [ RunTime:0.000478s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14517021 LIMIT 2 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517021 ORDER BY `minOrder` ASC [ RunTime:0.006503s ]
select * from pdf where partno='0982670701' and brandshort='Molex' limit 1 [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13643019 LIMIT 5 [ RunTime:0.006910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643019 ORDER BY `minOrder` ASC [ RunTime:0.006027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13643019 ORDER BY `unit` DESC [ RunTime:0.007128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13643019 LIMIT 2 [ RunTime:0.002961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643019 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630566 LIMIT 5 [ RunTime:0.001957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630566 ORDER BY `minOrder` ASC [ RunTime:0.001179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630566 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630566 LIMIT 2 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630566 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495148 LIMIT 5 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495148 ORDER BY `minOrder` ASC [ RunTime:0.002083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495148 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495148 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495148 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13643746 LIMIT 5 [ RunTime:0.008351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643746 ORDER BY `minOrder` ASC [ RunTime:0.000881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13643746 ORDER BY `unit` DESC [ RunTime:0.001525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13643746 LIMIT 2 [ RunTime:0.004686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13643746 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='0982670469' and brandshort='Molex' limit 1 [ RunTime:0.001167s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.002392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13642291 LIMIT 5 [ RunTime:0.002911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642291 ORDER BY `minOrder` ASC [ RunTime:0.009319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13642291 ORDER BY `unit` DESC [ RunTime:0.001567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13642291 LIMIT 2 [ RunTime:0.002102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642291 ORDER BY `minOrder` ASC [ RunTime:0.001876s ]
select * from pdf where partno='0982660161' and brandshort='Molex' limit 1 [ RunTime:0.001232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13642293 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642293 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13642293 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13642293 LIMIT 2 [ RunTime:0.004838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13642293 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='0982670477' and brandshort='Molex' limit 1 [ RunTime:0.003316s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495866 LIMIT 5 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495866 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495866 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495866 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495866 ORDER BY `minOrder` ASC [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14520617 LIMIT 5 [ RunTime:0.001440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14520617 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14520617 ORDER BY `unit` DESC [ RunTime:0.009333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14520617 LIMIT 2 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14520617 ORDER BY `minOrder` ASC [ RunTime:0.001896s ]
select * from pdf where partno='0982670707' and brandshort='Molex' limit 1 [ RunTime:0.015426s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.001135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522385 LIMIT 5 [ RunTime:0.013665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522385 ORDER BY `minOrder` ASC [ RunTime:0.002940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522385 ORDER BY `unit` DESC [ RunTime:0.005578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522385 LIMIT 2 [ RunTime:0.006548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522385 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
select * from pdf where partno='0982670255' and brandshort='Molex' limit 1 [ RunTime:0.007395s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13645864 LIMIT 5 [ RunTime:0.009163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13645864 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13645864 ORDER BY `unit` DESC [ RunTime:0.001463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13645864 LIMIT 2 [ RunTime:0.006852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13645864 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='0982660427' and brandshort='Molex' limit 1 [ RunTime:0.005429s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.006519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14517032 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517032 ORDER BY `minOrder` ASC [ RunTime:0.000990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14517032 ORDER BY `unit` DESC [ RunTime:0.016351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14517032 LIMIT 2 [ RunTime:0.001956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14517032 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='0982670361' and brandshort='Molex' limit 1 [ RunTime:0.001597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13655654 LIMIT 5 [ RunTime:0.001043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13655654 ORDER BY `minOrder` ASC [ RunTime:0.002552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13655654 ORDER BY `unit` DESC [ RunTime:0.003199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13655654 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13655654 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14524113 LIMIT 5 [ RunTime:0.003079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524113 ORDER BY `minOrder` ASC [ RunTime:0.001390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14524113 ORDER BY `unit` DESC [ RunTime:0.000641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14524113 LIMIT 2 [ RunTime:0.000575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524113 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='0982660425' and brandshort='Molex' limit 1 [ RunTime:0.000902s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.002051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14524117 LIMIT 5 [ RunTime:0.007621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524117 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14524117 ORDER BY `unit` DESC [ RunTime:0.002999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14524117 LIMIT 2 [ RunTime:0.006287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14524117 ORDER BY `minOrder` ASC [ RunTime:0.002040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12630895 LIMIT 5 [ RunTime:0.001112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630895 ORDER BY `minOrder` ASC [ RunTime:0.010074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12630895 ORDER BY `unit` DESC [ RunTime:0.005683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12630895 LIMIT 2 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12630895 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11495905 LIMIT 5 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495905 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11495905 ORDER BY `unit` DESC [ RunTime:0.007206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11495905 LIMIT 2 [ RunTime:0.004919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11495905 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13641527 LIMIT 5 [ RunTime:0.004162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641527 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13641527 ORDER BY `unit` DESC [ RunTime:0.010008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13641527 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13641527 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='0982670254' and brandshort='Molex' limit 1 [ RunTime:0.015212s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.015512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522796 LIMIT 5 [ RunTime:0.005560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522796 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522796 ORDER BY `unit` DESC [ RunTime:0.009593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522796 LIMIT 2 [ RunTime:0.008657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522796 ORDER BY `minOrder` ASC [ RunTime:0.005655s ]
select * from pdf where partno='0982670321' and brandshort='Molex' limit 1 [ RunTime:0.021830s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.001275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14522370 LIMIT 5 [ RunTime:0.019025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522370 ORDER BY `minOrder` ASC [ RunTime:0.024321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14522370 ORDER BY `unit` DESC [ RunTime:0.024108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14522370 LIMIT 2 [ RunTime:0.004489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14522370 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
select * from pdf where partno='0982670711' and brandshort='Molex' limit 1 [ RunTime:0.004459s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.016980s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095025 LIMIT 5 [ RunTime:0.006088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095025 ORDER BY `minOrder` ASC [ RunTime:0.019871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095025 ORDER BY `unit` DESC [ RunTime:0.001300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095025 LIMIT 2 [ RunTime:0.015192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095025 ORDER BY `minOrder` ASC [ RunTime:0.004998s ]
select * from pdf where partno='09821' and brandshort='desco' limit 1 [ RunTime:0.008099s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '09821' OR `brand` LIKE 'desco%' ) ) LIMIT 1 [ RunTime:0.009024s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095025 AND `partno` = '09821' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.014347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12386420 [ RunTime:0.011560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095366 LIMIT 5 [ RunTime:0.009976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095366 ORDER BY `minOrder` ASC [ RunTime:0.002516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095366 ORDER BY `unit` DESC [ RunTime:0.000855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095366 LIMIT 2 [ RunTime:0.000598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095366 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='09825' and brandshort='desco' limit 1 [ RunTime:0.000931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '09825' OR `brand` LIKE 'desco%' ) ) LIMIT 1 [ RunTime:0.004194s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095366 AND `partno` = '09825' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.008409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11332579 [ RunTime:0.006242s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929855 LIMIT 5 [ RunTime:0.003707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929855 ORDER BY `minOrder` ASC [ RunTime:0.001402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929855 ORDER BY `unit` DESC [ RunTime:0.005408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929855 LIMIT 2 [ RunTime:0.001809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929855 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='0982660084' and brandshort='Molex' limit 1 [ RunTime:0.001335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660084' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929421 LIMIT 5 [ RunTime:0.002201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929421 ORDER BY `minOrder` ASC [ RunTime:0.000916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929421 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929421 LIMIT 2 [ RunTime:0.001480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929421 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
select * from pdf where partno='0982670701' and brandshort='Molex' limit 1 [ RunTime:0.000575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670701' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941190 LIMIT 5 [ RunTime:0.003834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941190 ORDER BY `minOrder` ASC [ RunTime:0.002894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941190 ORDER BY `unit` DESC [ RunTime:0.000500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941190 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941190 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='0982980003' and brandshort='Molex' limit 1 [ RunTime:0.005035s ]
select foldpath,foldpath2,filename from pdf_file where id=676470 limit 1 [ RunTime:0.003263s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982980003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941217 LIMIT 5 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941217 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941217 ORDER BY `unit` DESC [ RunTime:0.002912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941217 LIMIT 2 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941217 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
select * from pdf where partno='0982980005' and brandshort='Molex' limit 1 [ RunTime:0.001483s ]
select foldpath,foldpath2,filename from pdf_file where id=676471 limit 1 [ RunTime:0.003167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982980005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939144 LIMIT 5 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939144 ORDER BY `minOrder` ASC [ RunTime:0.000814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939144 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939144 LIMIT 2 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939144 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='0982980001' and brandshort='Molex' limit 1 [ RunTime:0.000930s ]
select foldpath,foldpath2,filename from pdf_file where id=676469 limit 1 [ RunTime:0.002602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982980001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930714 LIMIT 5 [ RunTime:0.003095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930714 ORDER BY `minOrder` ASC [ RunTime:0.002507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930714 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930714 LIMIT 2 [ RunTime:0.002358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930714 ORDER BY `minOrder` ASC [ RunTime:0.002807s ]
select * from pdf where partno='0982660161' and brandshort='Molex' limit 1 [ RunTime:0.000624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660161' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.009346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930698 LIMIT 5 [ RunTime:0.011969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930698 ORDER BY `minOrder` ASC [ RunTime:0.007378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930698 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930698 LIMIT 2 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930698 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='0982670477' and brandshort='Molex' limit 1 [ RunTime:0.000576s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670477' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929459 LIMIT 5 [ RunTime:0.003249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929459 ORDER BY `minOrder` ASC [ RunTime:0.006777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929459 ORDER BY `unit` DESC [ RunTime:0.001402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929459 LIMIT 2 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929459 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
select * from pdf where partno='0982670773' and brandshort='Molex' limit 1 [ RunTime:0.001054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670773' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929876 LIMIT 5 [ RunTime:0.005931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929876 ORDER BY `minOrder` ASC [ RunTime:0.006788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929876 ORDER BY `unit` DESC [ RunTime:0.003143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929876 LIMIT 2 [ RunTime:0.004195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929876 ORDER BY `minOrder` ASC [ RunTime:0.003780s ]
select * from pdf where partno='0982660432' and brandshort='Molex' limit 1 [ RunTime:0.001018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660432' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941245 LIMIT 5 [ RunTime:0.003774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941245 ORDER BY `minOrder` ASC [ RunTime:0.010397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941245 ORDER BY `unit` DESC [ RunTime:0.002043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941245 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941245 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='0982980002' and brandshort='Molex' limit 1 [ RunTime:0.000866s ]
select foldpath,foldpath2,filename from pdf_file where id=676470 limit 1 [ RunTime:0.002234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982980002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930489 LIMIT 5 [ RunTime:0.003601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930489 ORDER BY `minOrder` ASC [ RunTime:0.000846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930489 ORDER BY `unit` DESC [ RunTime:0.006348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930489 LIMIT 2 [ RunTime:0.008849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930489 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='0982670469' and brandshort='Molex' limit 1 [ RunTime:0.000497s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.000322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670469' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929740 LIMIT 5 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929740 ORDER BY `minOrder` ASC [ RunTime:0.000931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929740 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929740 LIMIT 2 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929740 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
select * from pdf where partno='0982660835' and brandshort='Molex' limit 1 [ RunTime:0.003616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660835' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59939706 LIMIT 5 [ RunTime:0.001813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939706 ORDER BY `minOrder` ASC [ RunTime:0.004785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59939706 ORDER BY `unit` DESC [ RunTime:0.002061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59939706 LIMIT 2 [ RunTime:0.010082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59939706 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='0982731001' and brandshort='Molex' limit 1 [ RunTime:0.003241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982731001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930383 LIMIT 5 [ RunTime:0.001519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930383 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930383 ORDER BY `unit` DESC [ RunTime:0.004632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930383 LIMIT 2 [ RunTime:0.002797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930383 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='0982670361' and brandshort='Molex' limit 1 [ RunTime:0.000575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670361' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62930107 LIMIT 5 [ RunTime:0.012517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930107 ORDER BY `minOrder` ASC [ RunTime:0.008077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62930107 ORDER BY `unit` DESC [ RunTime:0.000865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62930107 LIMIT 2 [ RunTime:0.006195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62930107 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
select * from pdf where partno='0982680711' and brandshort='Molex' limit 1 [ RunTime:0.001471s ]
select foldpath,foldpath2,filename from pdf_file where id=2014980 limit 1 [ RunTime:0.001090s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982680711' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929866 LIMIT 5 [ RunTime:0.024712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929866 ORDER BY `minOrder` ASC [ RunTime:0.014379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929866 ORDER BY `unit` DESC [ RunTime:0.001819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929866 LIMIT 2 [ RunTime:0.007361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929866 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='0982660427' and brandshort='Molex' limit 1 [ RunTime:0.000618s ]
select foldpath,foldpath2,filename from pdf_file where id=1515845 limit 1 [ RunTime:0.000390s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660427' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929494 LIMIT 5 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929494 ORDER BY `minOrder` ASC [ RunTime:0.001558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929494 ORDER BY `unit` DESC [ RunTime:0.001115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929494 LIMIT 2 [ RunTime:0.002470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929494 ORDER BY `minOrder` ASC [ RunTime:0.007644s ]
select * from pdf where partno='0982670255' and brandshort='Molex' limit 1 [ RunTime:0.005883s ]
select foldpath,foldpath2,filename from pdf_file where id=1486707 limit 1 [ RunTime:0.002678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982670255' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53082568 LIMIT 5 [ RunTime:0.002921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082568 ORDER BY `minOrder` ASC [ RunTime:0.001596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53082568 ORDER BY `unit` DESC [ RunTime:0.008176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53082568 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53082568 ORDER BY `minOrder` ASC [ RunTime:0.001637s ]
select * from pdf where partno='0982761001' and brandshort='Molex' limit 1 [ RunTime:0.000926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982761001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59941916 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941916 ORDER BY `minOrder` ASC [ RunTime:0.003062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59941916 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59941916 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59941916 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='0982731005' and brandshort='Molex' limit 1 [ RunTime:0.000750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982731005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62929276 LIMIT 5 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929276 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62929276 ORDER BY `unit` DESC [ RunTime:0.002015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62929276 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62929276 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='0982660216' and brandshort='Molex' limit 1 [ RunTime:0.000698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0982660216' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005813s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000922s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002675s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000841s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000586s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003002s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000750s ]
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 '0982%' OR `brand` LIKE '0982%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000831s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0982%' OR `brand` LIKE '0982%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009816s ]