SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002368s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.085623s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609030 LIMIT 5 [ RunTime:0.049908s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609030 ORDER BY `minOrder` ASC [ RunTime:0.032389s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609030 ORDER BY `unit` DESC [ RunTime:0.032510s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609030 LIMIT 2 [ RunTime:0.032589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609030 ORDER BY `minOrder` ASC [ RunTime:0.018535s ]
select * from pdf where partno='0334680001' and brandshort='Molex' limit 1 [ RunTime:0.029986s ]
select foldpath,foldpath2,filename from pdf_file where id=835580 limit 1 [ RunTime:0.011360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609191 LIMIT 5 [ RunTime:0.046004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609191 ORDER BY `minOrder` ASC [ RunTime:0.052219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609191 ORDER BY `unit` DESC [ RunTime:0.093322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609191 LIMIT 2 [ RunTime:0.054079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609191 ORDER BY `minOrder` ASC [ RunTime:0.029564s ]
select * from pdf where partno='0334670024' and brandshort='Molex' limit 1 [ RunTime:0.035827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481776 LIMIT 5 [ RunTime:0.072693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481776 ORDER BY `minOrder` ASC [ RunTime:0.067964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481776 ORDER BY `unit` DESC [ RunTime:0.107558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481776 LIMIT 2 [ RunTime:0.010899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481776 ORDER BY `minOrder` ASC [ RunTime:0.022036s ]
select * from pdf where partno='0334670005' and brandshort='Molex' limit 1 [ RunTime:0.104501s ]
select foldpath,foldpath2,filename from pdf_file where id=835577 limit 1 [ RunTime:0.051945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609376 LIMIT 5 [ RunTime:0.049101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609376 ORDER BY `minOrder` ASC [ RunTime:0.104165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609376 ORDER BY `unit` DESC [ RunTime:0.037471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609376 LIMIT 2 [ RunTime:0.061084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609376 ORDER BY `minOrder` ASC [ RunTime:0.004129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609782 LIMIT 5 [ RunTime:0.042002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609782 ORDER BY `minOrder` ASC [ RunTime:0.036011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609782 ORDER BY `unit` DESC [ RunTime:0.004868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609782 LIMIT 2 [ RunTime:0.024449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609782 ORDER BY `minOrder` ASC [ RunTime:0.003884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609154 LIMIT 5 [ RunTime:0.018228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609154 ORDER BY `minOrder` ASC [ RunTime:0.039978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609154 ORDER BY `unit` DESC [ RunTime:0.025663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609154 LIMIT 2 [ RunTime:0.012878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609154 ORDER BY `minOrder` ASC [ RunTime:0.004043s ]
select * from pdf where partno='0334670006' and brandshort='Molex' limit 1 [ RunTime:0.004152s ]
select foldpath,foldpath2,filename from pdf_file where id=835578 limit 1 [ RunTime:0.006853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481849 LIMIT 5 [ RunTime:0.015250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481849 ORDER BY `minOrder` ASC [ RunTime:0.022089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481849 ORDER BY `unit` DESC [ RunTime:0.034139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481849 LIMIT 2 [ RunTime:0.014994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481849 ORDER BY `minOrder` ASC [ RunTime:0.007089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481605 LIMIT 5 [ RunTime:0.001293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481605 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481605 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481605 LIMIT 2 [ RunTime:0.005397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481605 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628469 LIMIT 5 [ RunTime:0.006214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628469 ORDER BY `minOrder` ASC [ RunTime:0.004590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628469 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628469 LIMIT 2 [ RunTime:0.006133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628469 ORDER BY `minOrder` ASC [ RunTime:0.005525s ]
select * from pdf where partno='0334721202' and brandshort='Molex' limit 1 [ RunTime:0.003340s ]
select foldpath,foldpath2,filename from pdf_file where id=1327458 limit 1 [ RunTime:0.001736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609071 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609071 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609071 ORDER BY `unit` DESC [ RunTime:0.008011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609071 LIMIT 2 [ RunTime:0.003788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609071 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628429 LIMIT 5 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628429 ORDER BY `minOrder` ASC [ RunTime:0.011859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628429 ORDER BY `unit` DESC [ RunTime:0.010280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628429 LIMIT 2 [ RunTime:0.014093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628429 ORDER BY `minOrder` ASC [ RunTime:0.000618s ]
select * from pdf where partno='0334721301' and brandshort='Molex' limit 1 [ RunTime:0.001054s ]
select foldpath,foldpath2,filename from pdf_file where id=1997944 limit 1 [ RunTime:0.013522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12629872 LIMIT 5 [ RunTime:0.010532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629872 ORDER BY `minOrder` ASC [ RunTime:0.002550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12629872 ORDER BY `unit` DESC [ RunTime:0.010717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12629872 LIMIT 2 [ RunTime:0.007534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12629872 ORDER BY `minOrder` ASC [ RunTime:0.014745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11493750 LIMIT 5 [ RunTime:0.006422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493750 ORDER BY `minOrder` ASC [ RunTime:0.003188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11493750 ORDER BY `unit` DESC [ RunTime:0.003203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11493750 LIMIT 2 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11493750 ORDER BY `minOrder` ASC [ RunTime:0.010575s ]
select * from pdf where partno='0334824001' and brandshort='Molex' limit 1 [ RunTime:0.020071s ]
select foldpath,foldpath2,filename from pdf_file where id=2042469 limit 1 [ RunTime:0.004103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609198 LIMIT 5 [ RunTime:0.040400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609198 ORDER BY `minOrder` ASC [ RunTime:0.021994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609198 ORDER BY `unit` DESC [ RunTime:0.020730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609198 LIMIT 2 [ RunTime:0.039493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609198 ORDER BY `minOrder` ASC [ RunTime:0.020775s ]
select * from pdf where partno='0334670003' and brandshort='Molex' limit 1 [ RunTime:0.001668s ]
select foldpath,foldpath2,filename from pdf_file where id=835577 limit 1 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628399 LIMIT 5 [ RunTime:0.010202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628399 ORDER BY `minOrder` ASC [ RunTime:0.010702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628399 ORDER BY `unit` DESC [ RunTime:0.002350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628399 LIMIT 2 [ RunTime:0.009806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628399 ORDER BY `minOrder` ASC [ RunTime:0.005621s ]
select * from pdf where partno='0334722062' and brandshort='Molex' limit 1 [ RunTime:0.006616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628732 LIMIT 5 [ RunTime:0.004001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628732 ORDER BY `minOrder` ASC [ RunTime:0.007127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628732 ORDER BY `unit` DESC [ RunTime:0.000905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628732 LIMIT 2 [ RunTime:0.003573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628732 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
select * from pdf where partno='0334823601' and brandshort='Molex' limit 1 [ RunTime:0.003575s ]
select foldpath,foldpath2,filename from pdf_file where id=1376461 limit 1 [ RunTime:0.001750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11494491 LIMIT 5 [ RunTime:0.001186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494491 ORDER BY `minOrder` ASC [ RunTime:0.008538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11494491 ORDER BY `unit` DESC [ RunTime:0.032857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11494491 LIMIT 2 [ RunTime:0.019015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11494491 ORDER BY `minOrder` ASC [ RunTime:0.030611s ]
select * from pdf where partno='0334824002' and brandshort='Molex' limit 1 [ RunTime:0.007820s ]
select foldpath,foldpath2,filename from pdf_file where id=2042469 limit 1 [ RunTime:0.000275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628400 LIMIT 5 [ RunTime:0.005513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628400 ORDER BY `minOrder` ASC [ RunTime:0.004238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628400 ORDER BY `unit` DESC [ RunTime:0.007734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628400 LIMIT 2 [ RunTime:0.001547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628400 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
select * from pdf where partno='0334824853' and brandshort='Molex' limit 1 [ RunTime:0.001064s ]
select foldpath,foldpath2,filename from pdf_file where id=1651596 limit 1 [ RunTime:0.004550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628501 LIMIT 5 [ RunTime:0.004215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628501 ORDER BY `minOrder` ASC [ RunTime:0.002948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628501 ORDER BY `unit` DESC [ RunTime:0.006507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628501 LIMIT 2 [ RunTime:0.005274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628501 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='0334824802' and brandshort='Molex' limit 1 [ RunTime:0.001743s ]
select foldpath,foldpath2,filename from pdf_file where id=1755432 limit 1 [ RunTime:0.002296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486553 LIMIT 5 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486553 ORDER BY `minOrder` ASC [ RunTime:0.002315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486553 ORDER BY `unit` DESC [ RunTime:0.002028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486553 LIMIT 2 [ RunTime:0.003174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486553 ORDER BY `minOrder` ASC [ RunTime:0.001294s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001426s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343751 LIMIT 5 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343751 ORDER BY `minOrder` ASC [ RunTime:0.000946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343751 ORDER BY `unit` DESC [ RunTime:0.002859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343751 LIMIT 2 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343751 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='0334680001' and brandshort='Molex' limit 1 [ RunTime:0.000674s ]
select foldpath,foldpath2,filename from pdf_file where id=835580 limit 1 [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.007301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944836 LIMIT 5 [ RunTime:0.002615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944836 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944836 ORDER BY `unit` DESC [ RunTime:0.001100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944836 LIMIT 2 [ RunTime:0.005291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944836 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='0334826206' and brandshort='Molex' limit 1 [ RunTime:0.003255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334826206' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.006382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343809 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343809 ORDER BY `minOrder` ASC [ RunTime:0.003037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343809 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343809 LIMIT 2 [ RunTime:0.001750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343809 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='0334680002' and brandshort='Molex' limit 1 [ RunTime:0.000939s ]
select foldpath,foldpath2,filename from pdf_file where id=835579 limit 1 [ RunTime:0.001682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343983 LIMIT 5 [ RunTime:0.005070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343983 ORDER BY `minOrder` ASC [ RunTime:0.005449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343983 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343983 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343983 ORDER BY `minOrder` ASC [ RunTime:0.006198s ]
select * from pdf where partno='0334670005' and brandshort='Molex' limit 1 [ RunTime:0.000567s ]
select foldpath,foldpath2,filename from pdf_file where id=835577 limit 1 [ RunTime:0.000375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670005' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.032646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59944811 LIMIT 5 [ RunTime:0.014133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944811 ORDER BY `minOrder` ASC [ RunTime:0.004276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59944811 ORDER BY `unit` DESC [ RunTime:0.003500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59944811 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59944811 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='0334823622' and brandshort='Molex' limit 1 [ RunTime:0.001000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334823622' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937356 LIMIT 5 [ RunTime:0.009222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937356 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937356 ORDER BY `unit` DESC [ RunTime:0.001107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937356 LIMIT 2 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937356 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='0334724001' and brandshort='Molex' limit 1 [ RunTime:0.002663s ]
select foldpath,foldpath2,filename from pdf_file where id=1535326 limit 1 [ RunTime:0.001887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334724001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.015875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343768 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343768 ORDER BY `minOrder` ASC [ RunTime:0.004243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343768 ORDER BY `unit` DESC [ RunTime:0.008113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343768 LIMIT 2 [ RunTime:0.002825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343768 ORDER BY `minOrder` ASC [ RunTime:0.003582s ]
select * from pdf where partno='0334680003' and brandshort='Molex' limit 1 [ RunTime:0.010016s ]
select foldpath,foldpath2,filename from pdf_file where id=835581 limit 1 [ RunTime:0.013200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343987 LIMIT 5 [ RunTime:0.006011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343987 ORDER BY `minOrder` ASC [ RunTime:0.001322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343987 ORDER BY `unit` DESC [ RunTime:0.006708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343987 LIMIT 2 [ RunTime:0.006550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343987 ORDER BY `minOrder` ASC [ RunTime:0.004378s ]
select * from pdf where partno='0334670003' and brandshort='Molex' limit 1 [ RunTime:0.000503s ]
select foldpath,foldpath2,filename from pdf_file where id=835577 limit 1 [ RunTime:0.002125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345112 LIMIT 5 [ RunTime:0.009598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345112 ORDER BY `minOrder` ASC [ RunTime:0.013203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345112 ORDER BY `unit` DESC [ RunTime:0.016570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345112 LIMIT 2 [ RunTime:0.013151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345112 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
select * from pdf where partno='0334670023' and brandshort='Molex' limit 1 [ RunTime:0.004605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670023' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343078 LIMIT 5 [ RunTime:0.007277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343078 ORDER BY `minOrder` ASC [ RunTime:0.005100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343078 ORDER BY `unit` DESC [ RunTime:0.017037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343078 LIMIT 2 [ RunTime:0.012430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343078 ORDER BY `minOrder` ASC [ RunTime:0.013702s ]
select * from pdf where partno='0334680004' and brandshort='Molex' limit 1 [ RunTime:0.002881s ]
select foldpath,foldpath2,filename from pdf_file where id=835584 limit 1 [ RunTime:0.002095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.046831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345056 LIMIT 5 [ RunTime:0.011825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345056 ORDER BY `minOrder` ASC [ RunTime:0.022897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345056 ORDER BY `unit` DESC [ RunTime:0.011234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345056 LIMIT 2 [ RunTime:0.004725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345056 ORDER BY `minOrder` ASC [ RunTime:0.003070s ]
select * from pdf where partno='0334680021' and brandshort='Molex' limit 1 [ RunTime:0.005797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680021' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344035 LIMIT 5 [ RunTime:0.007245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344035 ORDER BY `minOrder` ASC [ RunTime:0.004146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344035 ORDER BY `unit` DESC [ RunTime:0.014065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344035 LIMIT 2 [ RunTime:0.008964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344035 ORDER BY `minOrder` ASC [ RunTime:0.005500s ]
select * from pdf where partno='0334670004' and brandshort='Molex' limit 1 [ RunTime:0.014814s ]
select foldpath,foldpath2,filename from pdf_file where id=835576 limit 1 [ RunTime:0.019806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670004' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344037 LIMIT 5 [ RunTime:0.003461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344037 ORDER BY `minOrder` ASC [ RunTime:0.015294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344037 ORDER BY `unit` DESC [ RunTime:0.010420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344037 LIMIT 2 [ RunTime:0.004328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344037 ORDER BY `minOrder` ASC [ RunTime:0.009066s ]
select * from pdf where partno='0334670006' and brandshort='Molex' limit 1 [ RunTime:0.003689s ]
select foldpath,foldpath2,filename from pdf_file where id=835578 limit 1 [ RunTime:0.001019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670006' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.021730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343912 LIMIT 5 [ RunTime:0.017440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343912 ORDER BY `minOrder` ASC [ RunTime:0.024096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343912 ORDER BY `unit` DESC [ RunTime:0.052832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343912 LIMIT 2 [ RunTime:0.028408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343912 ORDER BY `minOrder` ASC [ RunTime:0.022718s ]
select * from pdf where partno='0334680023' and brandshort='Molex' limit 1 [ RunTime:0.034100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334680023' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.038459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937716 LIMIT 5 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937716 ORDER BY `minOrder` ASC [ RunTime:0.006800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937716 ORDER BY `unit` DESC [ RunTime:0.007829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937716 LIMIT 2 [ RunTime:0.025658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937716 ORDER BY `minOrder` ASC [ RunTime:0.017014s ]
select * from pdf where partno='0334823628' and brandshort='Molex' limit 1 [ RunTime:0.044028s ]
select foldpath,foldpath2,filename from pdf_file where id=1840138 limit 1 [ RunTime:0.023365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334823628' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.038582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344005 LIMIT 5 [ RunTime:0.028056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344005 ORDER BY `minOrder` ASC [ RunTime:0.027266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344005 ORDER BY `unit` DESC [ RunTime:0.038863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344005 LIMIT 2 [ RunTime:0.049202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344005 ORDER BY `minOrder` ASC [ RunTime:0.008922s ]
select * from pdf where partno='0334670022' and brandshort='Molex' limit 1 [ RunTime:0.011154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334670022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.020234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59934542 LIMIT 5 [ RunTime:0.018058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934542 ORDER BY `minOrder` ASC [ RunTime:0.027648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59934542 ORDER BY `unit` DESC [ RunTime:0.040695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59934542 LIMIT 2 [ RunTime:0.054539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59934542 ORDER BY `minOrder` ASC [ RunTime:0.028092s ]
select * from pdf where partno='0334824001' and brandshort='Molex' limit 1 [ RunTime:0.032294s ]
select foldpath,foldpath2,filename from pdf_file where id=2042469 limit 1 [ RunTime:0.029292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334824001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.039809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937545 LIMIT 5 [ RunTime:0.066675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937545 ORDER BY `minOrder` ASC [ RunTime:0.060227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937545 ORDER BY `unit` DESC [ RunTime:0.028083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937545 LIMIT 2 [ RunTime:0.020141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937545 ORDER BY `minOrder` ASC [ RunTime:0.017502s ]
select * from pdf where partno='0334810302' and brandshort='Molex' limit 1 [ RunTime:0.051847s ]
select foldpath,foldpath2,filename from pdf_file where id=2048085 limit 1 [ RunTime:0.045559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334810302' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937882 LIMIT 5 [ RunTime:0.011187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937882 ORDER BY `minOrder` ASC [ RunTime:0.040982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937882 ORDER BY `unit` DESC [ RunTime:0.016412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937882 LIMIT 2 [ RunTime:0.053411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937882 ORDER BY `minOrder` ASC [ RunTime:0.020435s ]
select * from pdf where partno='0334721202' and brandshort='Molex' limit 1 [ RunTime:0.027182s ]
select foldpath,foldpath2,filename from pdf_file where id=1327458 limit 1 [ RunTime:0.018358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334721202' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.028807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59937475 LIMIT 5 [ RunTime:0.025591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937475 ORDER BY `minOrder` ASC [ RunTime:0.035515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59937475 ORDER BY `unit` DESC [ RunTime:0.018560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59937475 LIMIT 2 [ RunTime:0.016375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59937475 ORDER BY `minOrder` ASC [ RunTime:0.002349s ]
select * from pdf where partno='0334824002' and brandshort='Molex' limit 1 [ RunTime:0.007594s ]
select foldpath,foldpath2,filename from pdf_file where id=2042469 limit 1 [ RunTime:0.005762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0334824002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.025688s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037458s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073955s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060837s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043519s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046238s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028595s ]
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 '0334%' OR `brand` LIKE '0334%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015799s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '0334%' OR `brand` LIKE '0334%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031588s ]