SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000963s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001461s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.186' ) [ RunTime:0.000230s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000890s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000217s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 615 LIMIT 1 [ RunTime:0.000276s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 615 [ RunTime:0.000175s ]
SELECT `id`,`name` FROM `product_type` WHERE `typeid` = 49 [ RunTime:0.000187s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001129s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay IS NULL OR s.isDisplay = 1) ) AND ( `status` <> 2 AND `categoryid` = 615 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001433s ]
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 IS NULL OR s.isDisplay = 1) ) AND `s`.`id` IN ('5354','14707','2251','10287','5852','3548','7891','2841','14710','7677','5357','4987','5356','1728','7679','5851','2753','2247','12692','11210') ORDER BY FIELD(s.id, 5354,14707,2251,10287,5852,3548,7891,2841,14710,7677,5357,4987,5356,1728,7679,5851,2753,2247,12692,11210) [ RunTime:0.004980s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5354 LIMIT 4 [ RunTime:0.000995s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5354 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5354 ORDER BY `unit` DESC [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5354 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5354 ORDER BY `minOrder` ASC [ RunTime:0.000170s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431AIDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.004770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14707 LIMIT 4 [ RunTime:0.002851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707 ORDER BY `minOrder` ASC [ RunTime:0.001271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14707 ORDER BY `unit` DESC [ RunTime:0.007907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14707 LIMIT 2 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14707 ORDER BY `minOrder` ASC [ RunTime:0.000181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM317T' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2251 LIMIT 4 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2251 ORDER BY `minOrder` ASC [ RunTime:0.000518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2251 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2251 LIMIT 2 [ RunTime:0.002154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2251 ORDER BY `minOrder` ASC [ RunTime:0.003558s ]
select * from pdf where partno='LD1117S33CTR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.005995s ]
select foldpath,foldpath2,filename from pdf_file where id=533327 limit 1 [ RunTime:0.000278s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LD1117S33CTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10287 LIMIT 4 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10287 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10287 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10287 LIMIT 2 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10287 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCP718ASN330T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.020093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5852 LIMIT 4 [ RunTime:0.005405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5852 ORDER BY `minOrder` ASC [ RunTime:0.005595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5852 ORDER BY `unit` DESC [ RunTime:0.004675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5852 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5852 ORDER BY `minOrder` ASC [ RunTime:0.000242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78M05CDT-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3548 LIMIT 4 [ RunTime:0.002743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3548 ORDER BY `minOrder` ASC [ RunTime:0.003825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3548 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3548 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3548 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A4403GEUTR-T' OR `brand` LIKE 'ALLEGRO MICROSYSTEMS%' ) ) LIMIT 1 [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7891 LIMIT 4 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7891 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7891 ORDER BY `unit` DESC [ RunTime:0.000221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7891 LIMIT 2 [ RunTime:0.000210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7891 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MIC5504-3.3YM5-TR' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2841 LIMIT 4 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2841 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2841 ORDER BY `unit` DESC [ RunTime:0.000397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2841 LIMIT 2 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2841 ORDER BY `minOrder` ASC [ RunTime:0.001916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TC2117-3.3VDBTR' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.019846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14710 LIMIT 4 [ RunTime:0.007839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14710 ORDER BY `minOrder` ASC [ RunTime:0.003912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14710 ORDER BY `unit` DESC [ RunTime:0.010599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14710 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14710 ORDER BY `minOrder` ASC [ RunTime:0.001689s ]
select * from pdf where partno='L7824CV' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.001164s ]
select foldpath,foldpath2,filename from pdf_file where id=375849 limit 1 [ RunTime:0.002188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L7824CV' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.002196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7677 LIMIT 4 [ RunTime:0.002569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7677 ORDER BY `minOrder` ASC [ RunTime:0.001763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7677 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7677 LIMIT 2 [ RunTime:0.005766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7677 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='TLE42744DV50ATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.001330s ]
select foldpath,foldpath2,filename from pdf_file where id=1472930 limit 1 [ RunTime:0.001583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE42744DV50ATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.007442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5357 LIMIT 4 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5357 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5357 ORDER BY `unit` DESC [ RunTime:0.002547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5357 LIMIT 2 [ RunTime:0.003382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5357 ORDER BY `minOrder` ASC [ RunTime:0.000221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BQDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4987 LIMIT 4 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4987 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4987 ORDER BY `unit` DESC [ RunTime:0.000468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4987 LIMIT 2 [ RunTime:0.000912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4987 ORDER BY `minOrder` ASC [ RunTime:0.000188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCV4274ADT50RKG' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.010483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5356 LIMIT 4 [ RunTime:0.002637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5356 ORDER BY `minOrder` ASC [ RunTime:0.004300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5356 ORDER BY `unit` DESC [ RunTime:0.001978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5356 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5356 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL431BIDBZR,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.007819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1728 LIMIT 4 [ RunTime:0.004195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1728 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1728 ORDER BY `unit` DESC [ RunTime:0.001839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1728 LIMIT 2 [ RunTime:0.001462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1728 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78M05ABDT-TR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7679 LIMIT 4 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7679 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7679 ORDER BY `unit` DESC [ RunTime:0.001296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7679 LIMIT 2 [ RunTime:0.007416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7679 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='TLE4284DV50ATMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.003244s ]
select foldpath,foldpath2,filename from pdf_file where id=1472939 limit 1 [ RunTime:0.006175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4284DV50ATMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.005882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5851 LIMIT 4 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5851 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5851 ORDER BY `unit` DESC [ RunTime:0.004289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5851 LIMIT 2 [ RunTime:0.006767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5851 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78L05ABUTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.003173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2753 LIMIT 4 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2753 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2753 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2753 LIMIT 2 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2753 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP1824T-ADJE/OT' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.009534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2247 LIMIT 4 [ RunTime:0.005642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2247 ORDER BY `minOrder` ASC [ RunTime:0.003438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2247 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2247 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2247 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
select * from pdf where partno='L78L05ABUTR' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.001245s ]
select foldpath,foldpath2,filename from pdf_file where id=126063 limit 1 [ RunTime:0.006718s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L78L05ABUTR' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.001743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12692 LIMIT 4 [ RunTime:0.002781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692 ORDER BY `minOrder` ASC [ RunTime:0.002925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12692 ORDER BY `unit` DESC [ RunTime:0.000646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12692 LIMIT 2 [ RunTime:0.002100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692 ORDER BY `minOrder` ASC [ RunTime:0.002814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4269GMXUMA2' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.007860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11210 LIMIT 4 [ RunTime:0.002643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11210 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11210 ORDER BY `unit` DESC [ RunTime:0.000357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11210 LIMIT 2 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11210 ORDER BY `minOrder` ASC [ RunTime:0.002270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TLE4254GSXUMA4' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` = 615 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001529s ]