SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002228s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007107s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001493s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.006776s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001487s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002683s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002833s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000748s ]
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.005785s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001839s ]
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.002900s ]
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 9960,20 [ RunTime:0.068627s ]
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 ('10443730','4013','10524334','10443688','10437135','10432739','13846','12791','10045','5459','365','10508005','10492593','6770','4558','4037','7674','10522194','10432738','8067') ORDER BY FIELD(s.id, 10443730,4013,10524334,10443688,10437135,10432739,13846,12791,10045,5459,365,10508005,10492593,6770,4558,4037,7674,10522194,10432738,8067) [ RunTime:0.012708s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10443730 LIMIT 4 [ RunTime:0.015169s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10443730 ORDER BY `minOrder` ASC [ RunTime:0.005886s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10443730 ORDER BY `unit` DESC [ RunTime:0.005065s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10443730 LIMIT 2 [ RunTime:0.002624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10443730 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
select * from pdf where partno='CKG32KX7R2E104K335AJ' and brandshort='TDK Corporation' limit 1 [ RunTime:0.008207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4013 LIMIT 4 [ RunTime:0.004485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4013 ORDER BY `minOrder` ASC [ RunTime:0.000976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4013 ORDER BY `unit` DESC [ RunTime:0.010709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4013 LIMIT 2 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4013 ORDER BY `minOrder` ASC [ RunTime:0.001359s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '182641-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.025002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10524334 LIMIT 4 [ RunTime:0.007725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10524334 ORDER BY `minOrder` ASC [ RunTime:0.003079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10524334 ORDER BY `unit` DESC [ RunTime:0.014046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10524334 LIMIT 2 [ RunTime:0.005684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10524334 ORDER BY `minOrder` ASC [ RunTime:0.002722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10443688 LIMIT 4 [ RunTime:0.002489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10443688 ORDER BY `minOrder` ASC [ RunTime:0.010868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10443688 ORDER BY `unit` DESC [ RunTime:0.008712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10443688 LIMIT 2 [ RunTime:0.007271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10443688 ORDER BY `minOrder` ASC [ RunTime:0.007608s ]
select * from pdf where partno='CKG45NX7S1H106M500JH' and brandshort='TDK Corporation' limit 1 [ RunTime:0.011376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10437135 LIMIT 4 [ RunTime:0.005702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10437135 ORDER BY `minOrder` ASC [ RunTime:0.003008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10437135 ORDER BY `unit` DESC [ RunTime:0.001514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10437135 LIMIT 2 [ RunTime:0.005319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10437135 ORDER BY `minOrder` ASC [ RunTime:0.000921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10432739 LIMIT 4 [ RunTime:0.000697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10432739 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10432739 ORDER BY `unit` DESC [ RunTime:0.000448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10432739 LIMIT 2 [ RunTime:0.001063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10432739 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
select * from pdf where partno='CGA5L3X8R1E155K160AD' and brandshort='TDK Corporation' limit 1 [ RunTime:0.001466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13846 LIMIT 4 [ RunTime:0.002768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13846 ORDER BY `minOrder` ASC [ RunTime:0.001576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13846 ORDER BY `unit` DESC [ RunTime:0.007640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13846 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13846 ORDER BY `minOrder` ASC [ RunTime:0.005891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'KP-1608SECK' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.002200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791 LIMIT 4 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791 ORDER BY `minOrder` ASC [ RunTime:0.001010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791 LIMIT 2 [ RunTime:0.001258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791 ORDER BY `minOrder` ASC [ RunTime:0.007207s ]
select * from pdf where partno='TMK325ABJ476MM-P' and brandshort='TAIYO YUDEN' limit 1 [ RunTime:0.008949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMK325ABJ476MM-P' OR `brand` LIKE 'TAIYO YUDEN%' ) ) LIMIT 1 [ RunTime:0.009881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10045 LIMIT 4 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10045 ORDER BY `minOrder` ASC [ RunTime:0.001871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10045 ORDER BY `unit` DESC [ RunTime:0.002979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10045 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10045 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PPR-1550' OR `brand` LIKE 'GARDNER BENDER%' ) ) LIMIT 1 [ RunTime:0.004680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5459 LIMIT 4 [ RunTime:0.004042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5459 ORDER BY `minOrder` ASC [ RunTime:0.003086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5459 ORDER BY `unit` DESC [ RunTime:0.003918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5459 LIMIT 2 [ RunTime:0.002501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5459 ORDER BY `minOrder` ASC [ RunTime:0.003002s ]
select * from pdf where partno='MCFRFTDU0180' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.005282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCFRFTDU0180' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.002477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 365 LIMIT 4 [ RunTime:0.006060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 365 ORDER BY `minOrder` ASC [ RunTime:0.008670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 365 ORDER BY `unit` DESC [ RunTime:0.008013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 365 LIMIT 2 [ RunTime:0.009961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 365 ORDER BY `minOrder` ASC [ RunTime:0.002812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HCT1G14GW,125' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10508005 LIMIT 4 [ RunTime:0.003924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10508005 ORDER BY `minOrder` ASC [ RunTime:0.004652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10508005 ORDER BY `unit` DESC [ RunTime:0.006086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10508005 LIMIT 2 [ RunTime:0.017337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10508005 ORDER BY `minOrder` ASC [ RunTime:0.005008s ]
select * from pdf where partno='CGA8N3X7R2E474M230KA' and brandshort='TDK Corporation' limit 1 [ RunTime:0.010832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10492593 LIMIT 4 [ RunTime:0.011849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10492593 ORDER BY `minOrder` ASC [ RunTime:0.001893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10492593 ORDER BY `unit` DESC [ RunTime:0.005614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10492593 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10492593 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6770 LIMIT 4 [ RunTime:0.001396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6770 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6770 ORDER BY `unit` DESC [ RunTime:0.010340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6770 LIMIT 2 [ RunTime:0.008394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6770 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM239DT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.007139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4558 LIMIT 4 [ RunTime:0.004071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4558 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4558 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4558 LIMIT 2 [ RunTime:0.000373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4558 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='503471-0200' and brandshort='MOLEX' limit 1 [ RunTime:0.004314s ]
select foldpath,foldpath2,filename from pdf_file where id=1333528 limit 1 [ RunTime:0.002532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '503471-0200' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.012352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4037 LIMIT 4 [ RunTime:0.011201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4037 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4037 ORDER BY `unit` DESC [ RunTime:0.004220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4037 LIMIT 2 [ RunTime:0.012442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4037 ORDER BY `minOrder` ASC [ RunTime:0.002254s ]
select * from pdf where partno='CIME/E/BE3500S' and brandshort='CAMDENBOSS' limit 1 [ RunTime:0.007684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CIME/E/BE3500S' OR `brand` LIKE 'CAMDENBOSS%' ) ) LIMIT 1 [ RunTime:0.016321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7674 LIMIT 4 [ RunTime:0.007186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7674 ORDER BY `minOrder` ASC [ RunTime:0.014408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7674 ORDER BY `unit` DESC [ RunTime:0.018358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7674 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7674 ORDER BY `minOrder` ASC [ RunTime:0.002295s ]
select * from pdf where partno='T520Y337M010ATE015' and brandshort='KEMET' limit 1 [ RunTime:0.004757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T520Y337M010ATE015' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.013345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10522194 LIMIT 4 [ RunTime:0.007850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10522194 ORDER BY `minOrder` ASC [ RunTime:0.004494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10522194 ORDER BY `unit` DESC [ RunTime:0.000392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10522194 LIMIT 2 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10522194 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10432738 LIMIT 4 [ RunTime:0.001690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10432738 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10432738 ORDER BY `unit` DESC [ RunTime:0.003860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10432738 LIMIT 2 [ RunTime:0.001338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10432738 ORDER BY `minOrder` ASC [ RunTime:0.000540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8067 LIMIT 4 [ RunTime:0.003885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8067 ORDER BY `minOrder` ASC [ RunTime:0.003180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8067 ORDER BY `unit` DESC [ RunTime:0.008027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8067 LIMIT 2 [ RunTime:0.006240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8067 ORDER BY `minOrder` ASC [ RunTime:0.000875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAX6103EUR+T' OR `brand` LIKE 'ANALOG DEVICES%' ) ) LIMIT 1 [ RunTime:0.011011s ]
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.003463s ]