SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.005327s ]
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=00145&search=1' [ RunTime:0.007484s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003013s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005820s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002071s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.002735s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002255s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004506s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001779s ]
SELECT * FROM `stock_search` WHERE `partno` = '00145' LIMIT 1 [ RunTime:0.019300s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-17 05:10:27' WHERE `partno` = '00145' [ RunTime:0.016533s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001515s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047062s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11616995 LIMIT 5 [ RunTime:0.027107s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11616995 ORDER BY `minOrder` ASC [ RunTime:0.009220s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11616995 ORDER BY `unit` DESC [ RunTime:0.044972s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11616995 LIMIT 2 [ RunTime:0.041522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11616995 ORDER BY `minOrder` ASC [ RunTime:0.035082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801080 LIMIT 5 [ RunTime:0.039152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801080 ORDER BY `minOrder` ASC [ RunTime:0.056346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801080 ORDER BY `unit` DESC [ RunTime:0.029133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801080 LIMIT 2 [ RunTime:0.014166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801080 ORDER BY `minOrder` ASC [ RunTime:0.008872s ]
select * from pdf where partno='0014567042' and brandshort='Molex' limit 1 [ RunTime:0.012819s ]
select foldpath,foldpath2,filename from pdf_file where id=833500 limit 1 [ RunTime:0.008144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12803229 LIMIT 5 [ RunTime:0.012505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803229 ORDER BY `minOrder` ASC [ RunTime:0.005997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12803229 ORDER BY `unit` DESC [ RunTime:0.021493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12803229 LIMIT 2 [ RunTime:0.026670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12803229 ORDER BY `minOrder` ASC [ RunTime:0.015384s ]
select * from pdf where partno='0014562082' and brandshort='Molex' limit 1 [ RunTime:0.007618s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.000482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799732 LIMIT 5 [ RunTime:0.011217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799732 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799732 ORDER BY `unit` DESC [ RunTime:0.003026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799732 LIMIT 2 [ RunTime:0.002298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799732 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='0014562031' and brandshort='Molex' limit 1 [ RunTime:0.000894s ]
select foldpath,foldpath2,filename from pdf_file where id=833426 limit 1 [ RunTime:0.011295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615755 LIMIT 5 [ RunTime:0.005712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615755 ORDER BY `minOrder` ASC [ RunTime:0.006276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615755 ORDER BY `unit` DESC [ RunTime:0.006242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615755 LIMIT 2 [ RunTime:0.010872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615755 ORDER BY `minOrder` ASC [ RunTime:0.003408s ]
select * from pdf where partno='0014567037' and brandshort='Molex' limit 1 [ RunTime:0.003142s ]
select foldpath,foldpath2,filename from pdf_file where id=833513 limit 1 [ RunTime:0.001403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12801069 LIMIT 5 [ RunTime:0.005506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801069 ORDER BY `minOrder` ASC [ RunTime:0.006254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12801069 ORDER BY `unit` DESC [ RunTime:0.002430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12801069 LIMIT 2 [ RunTime:0.007693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12801069 ORDER BY `minOrder` ASC [ RunTime:0.001624s ]
select * from pdf where partno='0014567032' and brandshort='Molex' limit 1 [ RunTime:0.004245s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.000759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796881 LIMIT 5 [ RunTime:0.016283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796881 ORDER BY `minOrder` ASC [ RunTime:0.019091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796881 ORDER BY `unit` DESC [ RunTime:0.013111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796881 LIMIT 2 [ RunTime:0.012883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796881 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
select * from pdf where partno='0014562046' and brandshort='Molex' limit 1 [ RunTime:0.001030s ]
select foldpath,foldpath2,filename from pdf_file where id=833423 limit 1 [ RunTime:0.000760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796844 LIMIT 5 [ RunTime:0.012372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796844 ORDER BY `minOrder` ASC [ RunTime:0.011915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796844 ORDER BY `unit` DESC [ RunTime:0.002155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796844 LIMIT 2 [ RunTime:0.007225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796844 ORDER BY `minOrder` ASC [ RunTime:0.004531s ]
select * from pdf where partno='0014567022' and brandshort='Molex' limit 1 [ RunTime:0.004424s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.002761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12802202 LIMIT 5 [ RunTime:0.023697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802202 ORDER BY `minOrder` ASC [ RunTime:0.011899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12802202 ORDER BY `unit` DESC [ RunTime:0.000603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12802202 LIMIT 2 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12802202 ORDER BY `minOrder` ASC [ RunTime:0.008692s ]
select * from pdf where partno='0014562021' and brandshort='Molex' limit 1 [ RunTime:0.007002s ]
select foldpath,foldpath2,filename from pdf_file where id=833420 limit 1 [ RunTime:0.004107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615762 LIMIT 5 [ RunTime:0.005688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615762 ORDER BY `minOrder` ASC [ RunTime:0.001420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615762 ORDER BY `unit` DESC [ RunTime:0.015172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615762 LIMIT 2 [ RunTime:0.004404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615762 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
select * from pdf where partno='0014567062' and brandshort='Molex' limit 1 [ RunTime:0.014458s ]
select foldpath,foldpath2,filename from pdf_file where id=833500 limit 1 [ RunTime:0.020235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615572 LIMIT 5 [ RunTime:0.017506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615572 ORDER BY `minOrder` ASC [ RunTime:0.011423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615572 ORDER BY `unit` DESC [ RunTime:0.024554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615572 LIMIT 2 [ RunTime:0.024765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615572 ORDER BY `minOrder` ASC [ RunTime:0.021401s ]
select * from pdf where partno='0014562024' and brandshort='Molex' limit 1 [ RunTime:0.014603s ]
select foldpath,foldpath2,filename from pdf_file where id=833432 limit 1 [ RunTime:0.010357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799753 LIMIT 5 [ RunTime:0.019031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799753 ORDER BY `minOrder` ASC [ RunTime:0.013231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799753 ORDER BY `unit` DESC [ RunTime:0.008517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799753 LIMIT 2 [ RunTime:0.007575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799753 ORDER BY `minOrder` ASC [ RunTime:0.002644s ]
select * from pdf where partno='0014562072' and brandshort='Molex' limit 1 [ RunTime:0.014913s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.005155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617746 LIMIT 5 [ RunTime:0.030571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617746 ORDER BY `minOrder` ASC [ RunTime:0.010714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617746 ORDER BY `unit` DESC [ RunTime:0.013116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617746 LIMIT 2 [ RunTime:0.006855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617746 ORDER BY `minOrder` ASC [ RunTime:0.002378s ]
select * from pdf where partno='0014562042' and brandshort='Molex' limit 1 [ RunTime:0.003691s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.001225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12799760 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799760 ORDER BY `minOrder` ASC [ RunTime:0.010540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12799760 ORDER BY `unit` DESC [ RunTime:0.002478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12799760 LIMIT 2 [ RunTime:0.006548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12799760 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
select * from pdf where partno='0014562092' and brandshort='Molex' limit 1 [ RunTime:0.001274s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11617018 LIMIT 5 [ RunTime:0.001921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617018 ORDER BY `minOrder` ASC [ RunTime:0.001434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11617018 ORDER BY `unit` DESC [ RunTime:0.001242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11617018 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11617018 ORDER BY `minOrder` ASC [ RunTime:0.002234s ]
select * from pdf where partno='0014567052' and brandshort='Molex' limit 1 [ RunTime:0.000910s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.003781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615780 LIMIT 5 [ RunTime:0.007734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615780 ORDER BY `minOrder` ASC [ RunTime:0.004082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615780 ORDER BY `unit` DESC [ RunTime:0.007714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615780 LIMIT 2 [ RunTime:0.002023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615780 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='0014562121' and brandshort='Molex' limit 1 [ RunTime:0.016910s ]
select foldpath,foldpath2,filename from pdf_file where id=833433 limit 1 [ RunTime:0.005123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12800018 LIMIT 5 [ RunTime:0.007565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800018 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12800018 ORDER BY `unit` DESC [ RunTime:0.010700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12800018 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12800018 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='0014562131' and brandshort='Molex' limit 1 [ RunTime:0.003194s ]
select foldpath,foldpath2,filename from pdf_file where id=833433 limit 1 [ RunTime:0.003818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796384 LIMIT 5 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796384 ORDER BY `minOrder` ASC [ RunTime:0.002885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796384 ORDER BY `unit` DESC [ RunTime:0.011218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796384 LIMIT 2 [ RunTime:0.012381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796384 ORDER BY `minOrder` ASC [ RunTime:0.006392s ]
select * from pdf where partno='0014562034' and brandshort='Molex' limit 1 [ RunTime:0.005217s ]
select foldpath,foldpath2,filename from pdf_file where id=833432 limit 1 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615785 LIMIT 5 [ RunTime:0.003272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615785 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615785 ORDER BY `unit` DESC [ RunTime:0.003041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615785 LIMIT 2 [ RunTime:0.012727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615785 ORDER BY `minOrder` ASC [ RunTime:0.012987s ]
select * from pdf where partno='0014562142' and brandshort='Molex' limit 1 [ RunTime:0.014328s ]
select foldpath,foldpath2,filename from pdf_file where id=833443 limit 1 [ RunTime:0.004274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11615590 LIMIT 5 [ RunTime:0.002478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615590 ORDER BY `minOrder` ASC [ RunTime:0.009939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11615590 ORDER BY `unit` DESC [ RunTime:0.009028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11615590 LIMIT 2 [ RunTime:0.005607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11615590 ORDER BY `minOrder` ASC [ RunTime:0.002662s ]
select * from pdf where partno='0014563051' and brandshort='Molex' limit 1 [ RunTime:0.003867s ]
select foldpath,foldpath2,filename from pdf_file where id=833470 limit 1 [ RunTime:0.015035s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020189s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905026 LIMIT 5 [ RunTime:0.044850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905026 ORDER BY `minOrder` ASC [ RunTime:0.012418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905026 ORDER BY `unit` DESC [ RunTime:0.027247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905026 LIMIT 2 [ RunTime:0.028474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905026 ORDER BY `minOrder` ASC [ RunTime:0.002786s ]
select * from pdf where partno='0014562041' and brandshort='Molex' limit 1 [ RunTime:0.054115s ]
select foldpath,foldpath2,filename from pdf_file where id=833426 limit 1 [ RunTime:0.007115s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562041' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.034632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905107 LIMIT 5 [ RunTime:0.020590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905107 ORDER BY `minOrder` ASC [ RunTime:0.018098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905107 ORDER BY `unit` DESC [ RunTime:0.019790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905107 LIMIT 2 [ RunTime:0.030301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905107 ORDER BY `minOrder` ASC [ RunTime:0.015644s ]
select * from pdf where partno='0014562062' and brandshort='Molex' limit 1 [ RunTime:0.086147s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.003431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562062' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.037188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59906372 LIMIT 5 [ RunTime:0.015827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906372 ORDER BY `minOrder` ASC [ RunTime:0.008875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59906372 ORDER BY `unit` DESC [ RunTime:0.008645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59906372 LIMIT 2 [ RunTime:0.005820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906372 ORDER BY `minOrder` ASC [ RunTime:0.009111s ]
select * from pdf where partno='0014562031' and brandshort='Molex' limit 1 [ RunTime:0.007080s ]
select foldpath,foldpath2,filename from pdf_file where id=833426 limit 1 [ RunTime:0.012361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562031' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.023947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59904933 LIMIT 5 [ RunTime:0.025492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904933 ORDER BY `minOrder` ASC [ RunTime:0.014284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59904933 ORDER BY `unit` DESC [ RunTime:0.008234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59904933 LIMIT 2 [ RunTime:0.031433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904933 ORDER BY `minOrder` ASC [ RunTime:0.019575s ]
select * from pdf where partno='0014567042' and brandshort='Molex' limit 1 [ RunTime:0.015869s ]
select foldpath,foldpath2,filename from pdf_file where id=833500 limit 1 [ RunTime:0.004640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567042' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905736 LIMIT 5 [ RunTime:0.035879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905736 ORDER BY `minOrder` ASC [ RunTime:0.018014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905736 ORDER BY `unit` DESC [ RunTime:0.006788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905736 LIMIT 2 [ RunTime:0.017414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905736 ORDER BY `minOrder` ASC [ RunTime:0.007146s ]
select * from pdf where partno='0014567037' and brandshort='Molex' limit 1 [ RunTime:0.004910s ]
select foldpath,foldpath2,filename from pdf_file where id=833513 limit 1 [ RunTime:0.002771s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567037' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.029811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905157 LIMIT 5 [ RunTime:0.018034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905157 ORDER BY `minOrder` ASC [ RunTime:0.013214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905157 ORDER BY `unit` DESC [ RunTime:0.018443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905157 LIMIT 2 [ RunTime:0.046807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905157 ORDER BY `minOrder` ASC [ RunTime:0.018381s ]
select * from pdf where partno='0014562082' and brandshort='Molex' limit 1 [ RunTime:0.006186s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.013713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562082' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905852 LIMIT 5 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905852 ORDER BY `minOrder` ASC [ RunTime:0.019682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905852 ORDER BY `unit` DESC [ RunTime:0.016233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905852 LIMIT 2 [ RunTime:0.024519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905852 ORDER BY `minOrder` ASC [ RunTime:0.010114s ]
select * from pdf where partno='0014562054' and brandshort='Molex' limit 1 [ RunTime:0.012554s ]
select foldpath,foldpath2,filename from pdf_file where id=833428 limit 1 [ RunTime:0.017483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562054' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.036076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59904908 LIMIT 5 [ RunTime:0.012259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904908 ORDER BY `minOrder` ASC [ RunTime:0.036975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59904908 ORDER BY `unit` DESC [ RunTime:0.007348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59904908 LIMIT 2 [ RunTime:0.009841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904908 ORDER BY `minOrder` ASC [ RunTime:0.024360s ]
select * from pdf where partno='0014567032' and brandshort='Molex' limit 1 [ RunTime:0.011705s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.011344s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567032' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.030723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905733 LIMIT 5 [ RunTime:0.006423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905733 ORDER BY `minOrder` ASC [ RunTime:0.014973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905733 ORDER BY `unit` DESC [ RunTime:0.000846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905733 LIMIT 2 [ RunTime:0.005757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905733 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
select * from pdf where partno='0014567022' and brandshort='Molex' limit 1 [ RunTime:0.000959s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.006678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905770 LIMIT 5 [ RunTime:0.018669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905770 ORDER BY `minOrder` ASC [ RunTime:0.001018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905770 ORDER BY `unit` DESC [ RunTime:0.003826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905770 LIMIT 2 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905770 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='0014567062' and brandshort='Molex' limit 1 [ RunTime:0.001006s ]
select foldpath,foldpath2,filename from pdf_file where id=833500 limit 1 [ RunTime:0.005461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567062' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.033611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59906418 LIMIT 5 [ RunTime:0.005590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906418 ORDER BY `minOrder` ASC [ RunTime:0.005137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59906418 ORDER BY `unit` DESC [ RunTime:0.000694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59906418 LIMIT 2 [ RunTime:0.008822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906418 ORDER BY `minOrder` ASC [ RunTime:0.004227s ]
select * from pdf where partno='0014562024' and brandshort='Molex' limit 1 [ RunTime:0.005658s ]
select foldpath,foldpath2,filename from pdf_file where id=833432 limit 1 [ RunTime:0.004069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562024' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905892 LIMIT 5 [ RunTime:0.007761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905892 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905892 ORDER BY `unit` DESC [ RunTime:0.002108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905892 LIMIT 2 [ RunTime:0.004550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905892 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='0014562072' and brandshort='Molex' limit 1 [ RunTime:0.000639s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.000427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562072' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905893 LIMIT 5 [ RunTime:0.001367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905893 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905893 ORDER BY `unit` DESC [ RunTime:0.009385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905893 LIMIT 2 [ RunTime:0.014702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905893 ORDER BY `minOrder` ASC [ RunTime:0.007767s ]
select * from pdf where partno='0014562071' and brandshort='Molex' limit 1 [ RunTime:0.001038s ]
select foldpath,foldpath2,filename from pdf_file where id=833426 limit 1 [ RunTime:0.001170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562071' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905006 LIMIT 5 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905006 ORDER BY `minOrder` ASC [ RunTime:0.001033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905006 ORDER BY `unit` DESC [ RunTime:0.013278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905006 LIMIT 2 [ RunTime:0.016115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905006 ORDER BY `minOrder` ASC [ RunTime:0.002674s ]
select * from pdf where partno='0014562021' and brandshort='Molex' limit 1 [ RunTime:0.000644s ]
select foldpath,foldpath2,filename from pdf_file where id=833420 limit 1 [ RunTime:0.000381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562021' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59906517 LIMIT 5 [ RunTime:0.010159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906517 ORDER BY `minOrder` ASC [ RunTime:0.010168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59906517 ORDER BY `unit` DESC [ RunTime:0.008219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59906517 LIMIT 2 [ RunTime:0.003350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906517 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
select * from pdf where partno='0014562092' and brandshort='Molex' limit 1 [ RunTime:0.000637s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.000375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562092' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59905066 LIMIT 5 [ RunTime:0.002252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905066 ORDER BY `minOrder` ASC [ RunTime:0.001424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59905066 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59905066 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59905066 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
select * from pdf where partno='0014562042' and brandshort='Molex' limit 1 [ RunTime:0.003702s ]
select foldpath,foldpath2,filename from pdf_file where id=833440 limit 1 [ RunTime:0.000418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562042' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59904962 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904962 ORDER BY `minOrder` ASC [ RunTime:0.003348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59904962 ORDER BY `unit` DESC [ RunTime:0.000485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59904962 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59904962 ORDER BY `minOrder` ASC [ RunTime:0.002151s ]
select * from pdf where partno='0014567052' and brandshort='Molex' limit 1 [ RunTime:0.000617s ]
select foldpath,foldpath2,filename from pdf_file where id=833503 limit 1 [ RunTime:0.000396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014567052' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59906529 LIMIT 5 [ RunTime:0.005306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906529 ORDER BY `minOrder` ASC [ RunTime:0.000998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59906529 ORDER BY `unit` DESC [ RunTime:0.003828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59906529 LIMIT 2 [ RunTime:0.000838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906529 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='0014562121' and brandshort='Molex' limit 1 [ RunTime:0.000443s ]
select foldpath,foldpath2,filename from pdf_file where id=833433 limit 1 [ RunTime:0.000247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562121' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59907436 LIMIT 5 [ RunTime:0.006610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907436 ORDER BY `minOrder` ASC [ RunTime:0.003427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59907436 ORDER BY `unit` DESC [ RunTime:0.007600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59907436 LIMIT 2 [ RunTime:0.009050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59907436 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
select * from pdf where partno='0014562131' and brandshort='Molex' limit 1 [ RunTime:0.007125s ]
select foldpath,foldpath2,filename from pdf_file where id=833433 limit 1 [ RunTime:0.004302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562131' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59906083 LIMIT 5 [ RunTime:0.011968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906083 ORDER BY `minOrder` ASC [ RunTime:0.002211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59906083 ORDER BY `unit` DESC [ RunTime:0.003129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59906083 LIMIT 2 [ RunTime:0.004456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59906083 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='0014562142' and brandshort='Molex' limit 1 [ RunTime:0.000575s ]
select foldpath,foldpath2,filename from pdf_file where id=833443 limit 1 [ RunTime:0.000358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0014562142' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.013137s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001330s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012201s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003623s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005666s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005237s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014229s ]
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 '00145%' OR `brand` LIKE '00145%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010442s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '00145%' OR `brand` LIKE '00145%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013194s ]