SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002376s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002092s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.37' ) [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002036s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000324s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000223s ]
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.000447s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002294s ]
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 ( `partno` LIKE 'P6KE200A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.002601s ]
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 ('6655135','6641125','6636522','6636378','6636153','6632870','6632778','4800710','4797782','4795407','4785265','4784289','4781093','4775394','4775264','4773752','4771641','4333419','4332948','4319795') ORDER BY FIELD(s.id, 6655135,6641125,6636522,6636378,6636153,6632870,6632778,4800710,4797782,4795407,4785265,4784289,4781093,4775394,4775264,4773752,4771641,4333419,4332948,4319795) [ RunTime:0.009771s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6655135 LIMIT 4 [ RunTime:0.006901s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6655135 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6655135 ORDER BY `unit` DESC [ RunTime:0.000942s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6655135 LIMIT 2 [ RunTime:0.000844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6655135 ORDER BY `minOrder` ASC [ RunTime:0.000198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6641125 LIMIT 4 [ RunTime:0.000810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6641125 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6641125 ORDER BY `unit` DESC [ RunTime:0.000355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6641125 LIMIT 2 [ RunTime:0.000278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6641125 ORDER BY `minOrder` ASC [ RunTime:0.002426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6636522 LIMIT 4 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636522 ORDER BY `minOrder` ASC [ RunTime:0.003582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6636522 ORDER BY `unit` DESC [ RunTime:0.002413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6636522 LIMIT 2 [ RunTime:0.003404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636522 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6636378 LIMIT 4 [ RunTime:0.002835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636378 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6636378 ORDER BY `unit` DESC [ RunTime:0.000541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6636378 LIMIT 2 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636378 ORDER BY `minOrder` ASC [ RunTime:0.002617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6636153 LIMIT 4 [ RunTime:0.000700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636153 ORDER BY `minOrder` ASC [ RunTime:0.010361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6636153 ORDER BY `unit` DESC [ RunTime:0.007682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6636153 LIMIT 2 [ RunTime:0.001326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6636153 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6632870 LIMIT 4 [ RunTime:0.001065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6632870 ORDER BY `minOrder` ASC [ RunTime:0.003364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6632870 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6632870 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6632870 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6632778 LIMIT 4 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6632778 ORDER BY `minOrder` ASC [ RunTime:0.004475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6632778 ORDER BY `unit` DESC [ RunTime:0.006766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6632778 LIMIT 2 [ RunTime:0.002384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6632778 ORDER BY `minOrder` ASC [ RunTime:0.002957s ]
select * from pdf where partno='P6KE200A-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.005301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4800710 LIMIT 4 [ RunTime:0.001113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4800710 ORDER BY `minOrder` ASC [ RunTime:0.006572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4800710 ORDER BY `unit` DESC [ RunTime:0.002061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4800710 LIMIT 2 [ RunTime:0.003226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4800710 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4797782 LIMIT 4 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4797782 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4797782 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4797782 LIMIT 2 [ RunTime:0.003600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4797782 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4795407 LIMIT 4 [ RunTime:0.001942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4795407 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4795407 ORDER BY `unit` DESC [ RunTime:0.000453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4795407 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4795407 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4785265 LIMIT 4 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4785265 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4785265 ORDER BY `unit` DESC [ RunTime:0.000229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4785265 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4785265 ORDER BY `minOrder` ASC [ RunTime:0.001329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4784289 LIMIT 4 [ RunTime:0.000478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4784289 ORDER BY `minOrder` ASC [ RunTime:0.000929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4784289 ORDER BY `unit` DESC [ RunTime:0.004278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4784289 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4784289 ORDER BY `minOrder` ASC [ RunTime:0.000153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4781093 LIMIT 4 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4781093 ORDER BY `minOrder` ASC [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4781093 ORDER BY `unit` DESC [ RunTime:0.001827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4781093 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4781093 ORDER BY `minOrder` ASC [ RunTime:0.003264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4775394 LIMIT 4 [ RunTime:0.002573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4775394 ORDER BY `minOrder` ASC [ RunTime:0.003135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4775394 ORDER BY `unit` DESC [ RunTime:0.002672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4775394 LIMIT 2 [ RunTime:0.004951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4775394 ORDER BY `minOrder` ASC [ RunTime:0.002268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4775264 LIMIT 4 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4775264 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4775264 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4775264 LIMIT 2 [ RunTime:0.000231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4775264 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4773752 LIMIT 4 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4773752 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4773752 ORDER BY `unit` DESC [ RunTime:0.012245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4773752 LIMIT 2 [ RunTime:0.002575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4773752 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4771641 LIMIT 4 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771641 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4771641 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4771641 LIMIT 2 [ RunTime:0.001868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771641 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
select * from pdf where partno='P6KE200A-TB' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.007738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4333419 LIMIT 4 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4333419 ORDER BY `minOrder` ASC [ RunTime:0.000576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4333419 ORDER BY `unit` DESC [ RunTime:0.006950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4333419 LIMIT 2 [ RunTime:0.002845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4333419 ORDER BY `minOrder` ASC [ RunTime:0.001372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4332948 LIMIT 4 [ RunTime:0.004719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4332948 ORDER BY `minOrder` ASC [ RunTime:0.001239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4332948 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4332948 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4332948 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4319795 LIMIT 4 [ RunTime:0.000766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4319795 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4319795 ORDER BY `unit` DESC [ RunTime:0.001929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4319795 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4319795 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'P6KE200A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000462s ]