SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001305s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003419s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001355s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.0' ) [ RunTime:0.004754s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001724s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000225s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000255s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.002702s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.000967s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001229s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` = 4 AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.014660s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` = 4 AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 740,20 [ RunTime:0.007434s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('15514','15513','15512','15511','15510','15509','15508','15507','15506','15505','15504','15503','15502','15501','15500','15499','15498','15497','15496','15495') ORDER BY FIELD(s.id, 15514,15513,15512,15511,15510,15509,15508,15507,15506,15505,15504,15503,15502,15501,15500,15499,15498,15497,15496,15495) [ RunTime:0.008240s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15514 LIMIT 4 [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15514 ORDER BY `minOrder` ASC [ RunTime:0.003042s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15514 ORDER BY `unit` DESC [ RunTime:0.006937s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15514 LIMIT 2 [ RunTime:0.003165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15514 ORDER BY `minOrder` ASC [ RunTime:0.001377s ]
select * from pdf where partno='VLS4012ET-100M' and brandshort='TDK' limit 1 [ RunTime:0.002203s ]
select foldpath,foldpath2,filename from pdf_file where id=2028000 limit 1 [ RunTime:0.000808s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLS4012ET-100M' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.006460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15513 LIMIT 4 [ RunTime:0.001726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15513 ORDER BY `minOrder` ASC [ RunTime:0.013816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15513 ORDER BY `unit` DESC [ RunTime:0.004982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15513 LIMIT 2 [ RunTime:0.002049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15513 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='192317-50' and brandshort='NI' limit 1 [ RunTime:0.003111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '192317-50' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.003831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15512 LIMIT 4 [ RunTime:0.009458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15512 ORDER BY `minOrder` ASC [ RunTime:0.000556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15512 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15512 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15512 ORDER BY `minOrder` ASC [ RunTime:0.007552s ]
select * from pdf where partno='ECEA1HKS100' and brandshort='PANASONIC' limit 1 [ RunTime:0.012889s ]
select foldpath,foldpath2,filename from pdf_file where id=715817 limit 1 [ RunTime:0.001534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECEA1HKS100' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.019129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15511 LIMIT 4 [ RunTime:0.007230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15511 ORDER BY `minOrder` ASC [ RunTime:0.003660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15511 ORDER BY `unit` DESC [ RunTime:0.016734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15511 LIMIT 2 [ RunTime:0.003314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15511 ORDER BY `minOrder` ASC [ RunTime:0.009623s ]
select * from pdf where partno='AVR128DB28-I/SO' and brandshort='MICROCHIP' limit 1 [ RunTime:0.001776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AVR128DB28-I/SO' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.016181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15510 LIMIT 4 [ RunTime:0.007289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15510 ORDER BY `minOrder` ASC [ RunTime:0.004008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15510 ORDER BY `unit` DESC [ RunTime:0.007126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15510 LIMIT 2 [ RunTime:0.012887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15510 ORDER BY `minOrder` ASC [ RunTime:0.001086s ]
select * from pdf where partno='C1005X7S0J105K050BC' and brandshort='TDK' limit 1 [ RunTime:0.004497s ]
select foldpath,foldpath2,filename from pdf_file where id=1917795 limit 1 [ RunTime:0.005820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7S0J105K050BC' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.012581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15509 LIMIT 4 [ RunTime:0.003429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509 ORDER BY `minOrder` ASC [ RunTime:0.016336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15509 ORDER BY `unit` DESC [ RunTime:0.007943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15509 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509 ORDER BY `minOrder` ASC [ RunTime:0.006495s ]
select * from pdf where partno='CPF0805B1R1E1' and brandshort='NEOHM - TE CONNECTIVITY' limit 1 [ RunTime:0.003296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CPF0805B1R1E1' OR `brand` LIKE 'NEOHM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.007435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15508 LIMIT 4 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15508 ORDER BY `minOrder` ASC [ RunTime:0.020907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15508 ORDER BY `unit` DESC [ RunTime:0.017641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15508 LIMIT 2 [ RunTime:0.000669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15508 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='C0603C104K3RACTU' and brandshort='KEMET' limit 1 [ RunTime:0.001342s ]
select foldpath,foldpath2,filename from pdf_file where id=2028654 limit 1 [ RunTime:0.005753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C104K3RACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.018778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15507 LIMIT 4 [ RunTime:0.004281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15507 ORDER BY `minOrder` ASC [ RunTime:0.012563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15507 ORDER BY `unit` DESC [ RunTime:0.014881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15507 LIMIT 2 [ RunTime:0.032461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15507 ORDER BY `minOrder` ASC [ RunTime:0.005122s ]
select * from pdf where partno='CY7C65632-48AXC' and brandshort='INFINEON' limit 1 [ RunTime:0.002152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C65632-48AXC' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.009986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15506 LIMIT 4 [ RunTime:0.014259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15506 ORDER BY `minOrder` ASC [ RunTime:0.009826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15506 ORDER BY `unit` DESC [ RunTime:0.015382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15506 LIMIT 2 [ RunTime:0.003708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15506 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='2743019447' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.020424s ]
select foldpath,foldpath2,filename from pdf_file where id=760021 limit 1 [ RunTime:0.006833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2743019447' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.003235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15505 LIMIT 4 [ RunTime:0.014825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15505 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15505 ORDER BY `unit` DESC [ RunTime:0.006140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15505 LIMIT 2 [ RunTime:0.011531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15505 ORDER BY `minOrder` ASC [ RunTime:0.006871s ]
select * from pdf where partno='502578-0400' and brandshort='MOLEX' limit 1 [ RunTime:0.013642s ]
select foldpath,foldpath2,filename from pdf_file where id=766580 limit 1 [ RunTime:0.011370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '502578-0400' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.014011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15504 LIMIT 4 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15504 ORDER BY `minOrder` ASC [ RunTime:0.002727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15504 ORDER BY `unit` DESC [ RunTime:0.006041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15504 LIMIT 2 [ RunTime:0.001123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15504 ORDER BY `minOrder` ASC [ RunTime:0.000204s ]
select * from pdf where partno='ERJ-PB3B1372V' and brandshort='PANASONIC' limit 1 [ RunTime:0.003796s ]
select foldpath,foldpath2,filename from pdf_file where id=1976083 limit 1 [ RunTime:0.001272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ-PB3B1372V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.024397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15503 LIMIT 4 [ RunTime:0.013419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15503 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15503 ORDER BY `unit` DESC [ RunTime:0.002576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15503 LIMIT 2 [ RunTime:0.010782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15503 ORDER BY `minOrder` ASC [ RunTime:0.007522s ]
select * from pdf where partno='MRFE6VP61K25HR6' and brandshort='NXP' limit 1 [ RunTime:0.002253s ]
select foldpath,foldpath2,filename from pdf_file where id=1726403 limit 1 [ RunTime:0.003798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRFE6VP61K25HR6' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.010568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15502 LIMIT 4 [ RunTime:0.004724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15502 ORDER BY `minOrder` ASC [ RunTime:0.006507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15502 ORDER BY `unit` DESC [ RunTime:0.006344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15502 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15502 ORDER BY `minOrder` ASC [ RunTime:0.001523s ]
select * from pdf where partno='AEH45UM31' and brandshort='XP POWER' limit 1 [ RunTime:0.014176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AEH45UM31' OR `brand` LIKE 'XP POWER%' ) ) LIMIT 1 [ RunTime:0.011412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15501 LIMIT 4 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15501 ORDER BY `minOrder` ASC [ RunTime:0.002514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15501 ORDER BY `unit` DESC [ RunTime:0.004234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15501 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15501 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='HIF3FC-14PA-2.54DSA(71)' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.001900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HIF3FC-14PA-2.54DSA(71)' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.002711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15500 LIMIT 4 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15500 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15500 ORDER BY `unit` DESC [ RunTime:0.000501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15500 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15500 ORDER BY `minOrder` ASC [ RunTime:0.002286s ]
select * from pdf where partno='C0603C270J5GACTU' and brandshort='KEMET' limit 1 [ RunTime:0.001187s ]
select foldpath,foldpath2,filename from pdf_file where id=1998305 limit 1 [ RunTime:0.002110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C270J5GACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.014434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15499 LIMIT 4 [ RunTime:0.014975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15499 ORDER BY `minOrder` ASC [ RunTime:0.005546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15499 ORDER BY `unit` DESC [ RunTime:0.003548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15499 LIMIT 2 [ RunTime:0.012103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15499 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
select * from pdf where partno='DF11-6DS-2C' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.003770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF11-6DS-2C' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.029366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15498 LIMIT 4 [ RunTime:0.052136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15498 ORDER BY `minOrder` ASC [ RunTime:0.020447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15498 ORDER BY `unit` DESC [ RunTime:0.036019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15498 LIMIT 2 [ RunTime:0.037571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15498 ORDER BY `minOrder` ASC [ RunTime:0.045318s ]
select * from pdf where partno='L02R3000F1' and brandshort='LED TECHNOLOGY' limit 1 [ RunTime:0.027136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L02R3000F1' OR `brand` LIKE 'LED TECHNOLOGY%' ) ) LIMIT 1 [ RunTime:0.049698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15497 LIMIT 4 [ RunTime:0.043276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15497 ORDER BY `minOrder` ASC [ RunTime:0.054285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15497 ORDER BY `unit` DESC [ RunTime:0.028365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15497 LIMIT 2 [ RunTime:0.046539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15497 ORDER BY `minOrder` ASC [ RunTime:0.034580s ]
select * from pdf where partno='FDMC6679AZ' and brandshort='ONSEMI' limit 1 [ RunTime:0.059775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDMC6679AZ' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.021399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15496 LIMIT 4 [ RunTime:0.025509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15496 ORDER BY `minOrder` ASC [ RunTime:0.000921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15496 ORDER BY `unit` DESC [ RunTime:0.004187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15496 LIMIT 2 [ RunTime:0.037023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15496 ORDER BY `minOrder` ASC [ RunTime:0.035255s ]
select * from pdf where partno='MGRF2WJ0226AA9' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.012639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MGRF2WJ0226AA9' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.015768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15495 LIMIT 4 [ RunTime:0.019110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15495 ORDER BY `minOrder` ASC [ RunTime:0.029386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15495 ORDER BY `unit` DESC [ RunTime:0.030680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15495 LIMIT 2 [ RunTime:0.003159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15495 ORDER BY `minOrder` ASC [ RunTime:0.010714s ]
select * from pdf where partno='TMK212AB7475KG-T' and brandshort='TAIYO YUDEN' limit 1 [ RunTime:0.021511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMK212AB7475KG-T' OR `brand` LIKE 'TAIYO YUDEN%' ) ) LIMIT 1 [ RunTime:0.002781s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` = 4 AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007736s ]