SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002404s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002080s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001622s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001869s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000366s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000246s ]
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.000430s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003587s ]
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.006274s ]
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.004597s ]
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.000916s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15514 LIMIT 4 [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15514 ORDER BY `minOrder` ASC [ RunTime:0.001184s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15514 ORDER BY `unit` DESC [ RunTime:0.004510s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15514 LIMIT 2 [ RunTime:0.001574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15514 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
select * from pdf where partno='VLS4012ET-100M' and brandshort='TDK' limit 1 [ RunTime:0.008196s ]
select foldpath,foldpath2,filename from pdf_file where id=2028000 limit 1 [ RunTime:0.005362s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLS4012ET-100M' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.018858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15513 LIMIT 4 [ RunTime:0.001131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15513 ORDER BY `minOrder` ASC [ RunTime:0.003805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15513 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15513 LIMIT 2 [ RunTime:0.003797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15513 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='192317-50' and brandshort='NI' limit 1 [ RunTime:0.002116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '192317-50' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.003528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15512 LIMIT 4 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15512 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15512 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15512 LIMIT 2 [ RunTime:0.008580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15512 ORDER BY `minOrder` ASC [ RunTime:0.003767s ]
select * from pdf where partno='ECEA1HKS100' and brandshort='PANASONIC' limit 1 [ RunTime:0.015488s ]
select foldpath,foldpath2,filename from pdf_file where id=715817 limit 1 [ RunTime:0.003202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ECEA1HKS100' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.022272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15511 LIMIT 4 [ RunTime:0.013047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15511 ORDER BY `minOrder` ASC [ RunTime:0.000756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15511 ORDER BY `unit` DESC [ RunTime:0.003640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15511 LIMIT 2 [ RunTime:0.002484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15511 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
select * from pdf where partno='AVR128DB28-I/SO' and brandshort='MICROCHIP' limit 1 [ RunTime:0.003341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AVR128DB28-I/SO' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.023258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15510 LIMIT 4 [ RunTime:0.003581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15510 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15510 ORDER BY `unit` DESC [ RunTime:0.008819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15510 LIMIT 2 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15510 ORDER BY `minOrder` ASC [ RunTime:0.001828s ]
select * from pdf where partno='C1005X7S0J105K050BC' and brandshort='TDK' limit 1 [ RunTime:0.005056s ]
select foldpath,foldpath2,filename from pdf_file where id=1917795 limit 1 [ RunTime:0.006755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1005X7S0J105K050BC' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.007160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15509 LIMIT 4 [ RunTime:0.000479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15509 ORDER BY `unit` DESC [ RunTime:0.004159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15509 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509 ORDER BY `minOrder` ASC [ RunTime:0.006350s ]
select * from pdf where partno='CPF0805B1R1E1' and brandshort='NEOHM - TE CONNECTIVITY' limit 1 [ RunTime:0.002322s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CPF0805B1R1E1' OR `brand` LIKE 'NEOHM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.013189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15508 LIMIT 4 [ RunTime:0.003948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15508 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15508 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15508 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15508 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
select * from pdf where partno='C0603C104K3RACTU' and brandshort='KEMET' limit 1 [ RunTime:0.001668s ]
select foldpath,foldpath2,filename from pdf_file where id=2028654 limit 1 [ RunTime:0.005810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C104K3RACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.004790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15507 LIMIT 4 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15507 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15507 ORDER BY `unit` DESC [ RunTime:0.005844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15507 LIMIT 2 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15507 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
select * from pdf where partno='CY7C65632-48AXC' and brandshort='INFINEON' limit 1 [ RunTime:0.014310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CY7C65632-48AXC' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.013361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15506 LIMIT 4 [ RunTime:0.004788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15506 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15506 ORDER BY `unit` DESC [ RunTime:0.004667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15506 LIMIT 2 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15506 ORDER BY `minOrder` ASC [ RunTime:0.004365s ]
select * from pdf where partno='2743019447' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.001656s ]
select foldpath,foldpath2,filename from pdf_file where id=760021 limit 1 [ RunTime:0.003957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2743019447' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.007372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15505 LIMIT 4 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15505 ORDER BY `minOrder` ASC [ RunTime:0.004141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15505 ORDER BY `unit` DESC [ RunTime:0.006284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15505 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15505 ORDER BY `minOrder` ASC [ RunTime:0.003258s ]
select * from pdf where partno='502578-0400' and brandshort='MOLEX' limit 1 [ RunTime:0.002845s ]
select foldpath,foldpath2,filename from pdf_file where id=766580 limit 1 [ RunTime:0.003115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '502578-0400' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.007579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15504 LIMIT 4 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15504 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15504 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15504 LIMIT 2 [ RunTime:0.001749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15504 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
select * from pdf where partno='ERJ-PB3B1372V' and brandshort='PANASONIC' limit 1 [ RunTime:0.005895s ]
select foldpath,foldpath2,filename from pdf_file where id=1976083 limit 1 [ RunTime:0.000844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ-PB3B1372V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.012013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15503 LIMIT 4 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15503 ORDER BY `minOrder` ASC [ RunTime:0.001265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15503 ORDER BY `unit` DESC [ RunTime:0.001047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15503 LIMIT 2 [ RunTime:0.001627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15503 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
select * from pdf where partno='MRFE6VP61K25HR6' and brandshort='NXP' limit 1 [ RunTime:0.001829s ]
select foldpath,foldpath2,filename from pdf_file where id=1726403 limit 1 [ RunTime:0.003472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MRFE6VP61K25HR6' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.006828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15502 LIMIT 4 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15502 ORDER BY `minOrder` ASC [ RunTime:0.000668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15502 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15502 LIMIT 2 [ RunTime:0.002559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15502 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
select * from pdf where partno='AEH45UM31' and brandshort='XP POWER' limit 1 [ RunTime:0.001550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AEH45UM31' OR `brand` LIKE 'XP POWER%' ) ) LIMIT 1 [ RunTime:0.005803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15501 LIMIT 4 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15501 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15501 ORDER BY `unit` DESC [ RunTime:0.003484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15501 LIMIT 2 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15501 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='HIF3FC-14PA-2.54DSA(71)' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.001471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HIF3FC-14PA-2.54DSA(71)' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.008227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15500 LIMIT 4 [ RunTime:0.000765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15500 ORDER BY `minOrder` ASC [ RunTime:0.002761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15500 ORDER BY `unit` DESC [ RunTime:0.002935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15500 LIMIT 2 [ RunTime:0.001914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15500 ORDER BY `minOrder` ASC [ RunTime:0.000433s ]
select * from pdf where partno='C0603C270J5GACTU' and brandshort='KEMET' limit 1 [ RunTime:0.009350s ]
select foldpath,foldpath2,filename from pdf_file where id=1998305 limit 1 [ RunTime:0.006918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C270J5GACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.004975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15499 LIMIT 4 [ RunTime:0.006162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15499 ORDER BY `minOrder` ASC [ RunTime:0.007005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15499 ORDER BY `unit` DESC [ RunTime:0.002899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15499 LIMIT 2 [ RunTime:0.009388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15499 ORDER BY `minOrder` ASC [ RunTime:0.009456s ]
select * from pdf where partno='DF11-6DS-2C' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.005829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DF11-6DS-2C' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.001601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15498 LIMIT 4 [ RunTime:0.000535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15498 ORDER BY `minOrder` ASC [ RunTime:0.002520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15498 ORDER BY `unit` DESC [ RunTime:0.002240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15498 LIMIT 2 [ RunTime:0.002811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15498 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='L02R3000F1' and brandshort='LED TECHNOLOGY' limit 1 [ RunTime:0.003245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L02R3000F1' OR `brand` LIKE 'LED TECHNOLOGY%' ) ) LIMIT 1 [ RunTime:0.003947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15497 LIMIT 4 [ RunTime:0.002654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15497 ORDER BY `minOrder` ASC [ RunTime:0.003223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15497 ORDER BY `unit` DESC [ RunTime:0.001458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15497 LIMIT 2 [ RunTime:0.001909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15497 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='FDMC6679AZ' and brandshort='ONSEMI' limit 1 [ RunTime:0.001189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDMC6679AZ' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.018824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15496 LIMIT 4 [ RunTime:0.001819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15496 ORDER BY `minOrder` ASC [ RunTime:0.002292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15496 ORDER BY `unit` DESC [ RunTime:0.001924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15496 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15496 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='MGRF2WJ0226AA9' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.004024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MGRF2WJ0226AA9' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15495 LIMIT 4 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15495 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15495 ORDER BY `unit` DESC [ RunTime:0.001512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15495 LIMIT 2 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15495 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
select * from pdf where partno='TMK212AB7475KG-T' and brandshort='TAIYO YUDEN' limit 1 [ RunTime:0.002136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMK212AB7475KG-T' OR `brand` LIKE 'TAIYO YUDEN%' ) ) LIMIT 1 [ RunTime:0.002408s ]
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.004063s ]