SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001537s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001612s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001205s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000255s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000192s ]
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.000339s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001382s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.769482s ]
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` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 9760,20 [ RunTime:0.145933s ]
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 ('13581','2556','13561','4832','10521218','10506896','14481','13576','10657','9657','4285','10491455','13777','4818','3437','14092','9131','7587','4371','2196') ORDER BY FIELD(s.id, 13581,2556,13561,4832,10521218,10506896,14481,13576,10657,9657,4285,10491455,13777,4818,3437,14092,9131,7587,4371,2196) [ RunTime:0.010554s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13581 LIMIT 4 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13581 ORDER BY `minOrder` ASC [ RunTime:0.001036s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13581 ORDER BY `unit` DESC [ RunTime:0.001817s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13581 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13581 ORDER BY `minOrder` ASC [ RunTime:0.001345s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HSMD-C170' OR `brand` LIKE 'BROADCOM%' ) ) LIMIT 1 [ RunTime:0.006001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2556 LIMIT 4 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2556 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2556 ORDER BY `unit` DESC [ RunTime:0.004717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2556 LIMIT 2 [ RunTime:0.008164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2556 ORDER BY `minOrder` ASC [ RunTime:0.000897s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '39-01-2121' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.006398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13561 LIMIT 4 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13561 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13561 LIMIT 2 [ RunTime:0.001407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13561 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMS6PDH1' OR `brand` LIKE 'SOURIAU-SUNBANK / EATON%' ) ) LIMIT 1 [ RunTime:0.003663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4832 LIMIT 4 [ RunTime:0.004378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4832 ORDER BY `minOrder` ASC [ RunTime:0.007525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4832 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4832 LIMIT 2 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4832 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
select * from pdf where partno='MCPWR12FTEA2000' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCPWR12FTEA2000' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.004824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10521218 LIMIT 4 [ RunTime:0.009575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10521218 ORDER BY `minOrder` ASC [ RunTime:0.010722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10521218 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10521218 LIMIT 2 [ RunTime:0.005974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10521218 ORDER BY `minOrder` ASC [ RunTime:0.004812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10506896 LIMIT 4 [ RunTime:0.002162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10506896 ORDER BY `minOrder` ASC [ RunTime:0.008598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10506896 ORDER BY `unit` DESC [ RunTime:0.001800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10506896 LIMIT 2 [ RunTime:0.004261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10506896 ORDER BY `minOrder` ASC [ RunTime:0.005718s ]
select * from pdf where partno='CGA8N3X7R2E334M230KA' and brandshort='TDK Corporation' limit 1 [ RunTime:0.011198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14481 LIMIT 4 [ RunTime:0.002382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14481 ORDER BY `minOrder` ASC [ RunTime:0.000569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14481 ORDER BY `unit` DESC [ RunTime:0.001901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14481 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14481 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
select * from pdf where partno='S1B-E3/61T' and brandshort='VISHAY' limit 1 [ RunTime:0.013161s ]
select foldpath,foldpath2,filename from pdf_file where id=1919635 limit 1 [ RunTime:0.010384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'S1B-E3/61T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.022751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13576 LIMIT 4 [ RunTime:0.003092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13576 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13576 ORDER BY `unit` DESC [ RunTime:0.001165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13576 LIMIT 2 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13576 ORDER BY `minOrder` ASC [ RunTime:0.000290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2-521103-2.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10657 LIMIT 4 [ RunTime:0.005507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10657 ORDER BY `minOrder` ASC [ RunTime:0.004553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10657 ORDER BY `unit` DESC [ RunTime:0.001526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10657 LIMIT 2 [ RunTime:0.007123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10657 ORDER BY `minOrder` ASC [ RunTime:0.000982s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MMA02040C6808FB300' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.009311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9657 LIMIT 4 [ RunTime:0.000580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9657 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9657 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9657 LIMIT 2 [ RunTime:0.006287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9657 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NZL7V5AXV3T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.016147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4285 LIMIT 4 [ RunTime:0.005283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4285 ORDER BY `minOrder` ASC [ RunTime:0.001610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4285 ORDER BY `unit` DESC [ RunTime:0.003413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4285 LIMIT 2 [ RunTime:0.000829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4285 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='C1210C102KGRACTU' and brandshort='KEMET' limit 1 [ RunTime:0.015237s ]
select foldpath,foldpath2,filename from pdf_file where id=1157139 limit 1 [ RunTime:0.009023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1210C102KGRACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.007758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10491455 LIMIT 4 [ RunTime:0.007768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10491455 ORDER BY `minOrder` ASC [ RunTime:0.001650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10491455 ORDER BY `unit` DESC [ RunTime:0.003538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10491455 LIMIT 2 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10491455 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13777 LIMIT 4 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13777 ORDER BY `minOrder` ASC [ RunTime:0.000644s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13777 ORDER BY `unit` DESC [ RunTime:0.001747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13777 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13777 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='35507-0300' and brandshort='MOLEX' limit 1 [ RunTime:0.003715s ]
select foldpath,foldpath2,filename from pdf_file where id=849201 limit 1 [ RunTime:0.007099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '35507-0300' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.013208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4818 LIMIT 4 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4818 ORDER BY `minOrder` ASC [ RunTime:0.004958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4818 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4818 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4818 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
select * from pdf where partno='302R29W102KV4E' and brandshort='JOHANSON DIELECTRICS' limit 1 [ RunTime:0.007088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '302R29W102KV4E' OR `brand` LIKE 'JOHANSON DIELECTRICS%' ) ) LIMIT 1 [ RunTime:0.001923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3437 LIMIT 4 [ RunTime:0.001992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3437 ORDER BY `minOrder` ASC [ RunTime:0.003157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3437 ORDER BY `unit` DESC [ RunTime:0.002105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3437 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3437 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2916' OR `brand` LIKE 'VISATON%' ) ) LIMIT 1 [ RunTime:0.004323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14092 LIMIT 4 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14092 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14092 ORDER BY `unit` DESC [ RunTime:0.000654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14092 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14092 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
select * from pdf where partno='RC0805FR-0715KL' and brandshort='YAGEO' limit 1 [ RunTime:0.003890s ]
select foldpath,foldpath2,filename from pdf_file where id=1064449 limit 1 [ RunTime:0.003408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0805FR-0715KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9131 LIMIT 4 [ RunTime:0.004636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9131 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9131 ORDER BY `unit` DESC [ RunTime:0.000655s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9131 LIMIT 2 [ RunTime:0.001899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9131 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RBR2LAM60BTFTR' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.005668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7587 LIMIT 4 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7587 ORDER BY `minOrder` ASC [ RunTime:0.001012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7587 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7587 LIMIT 2 [ RunTime:0.004036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7587 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='1-480351-0' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.009401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-480351-0' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.014956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4371 LIMIT 4 [ RunTime:0.002721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4371 ORDER BY `minOrder` ASC [ RunTime:0.003224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4371 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4371 LIMIT 2 [ RunTime:0.000985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4371 ORDER BY `minOrder` ASC [ RunTime:0.004125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B16B-PHDSS (LF)(SN)' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.002487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2196 LIMIT 4 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2196 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2196 ORDER BY `unit` DESC [ RunTime:0.002470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2196 LIMIT 2 [ RunTime:0.004297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2196 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
select * from pdf where partno='2643101902' and brandshort='FAIR-RITE' limit 1 [ RunTime:0.006798s ]
select foldpath,foldpath2,filename from pdf_file where id=759855 limit 1 [ RunTime:0.008978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2643101902' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.008141s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.483487s ]