SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001352s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001445s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.222' ) [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001319s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000221s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000250s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000184s ]
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.000328s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001560s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'SMCJ48A%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.006395s ]
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 'SMCJ48A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.002791s ]
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 ('6644937','6644787','6642863','6642494','6642306','4798927','4797240','4796747','4791095','4783233','4782982','4782367','4782119','4782022','4777376','4777326','4771956','4337724','4329970','4329762') ORDER BY FIELD(s.id, 6644937,6644787,6642863,6642494,6642306,4798927,4797240,4796747,4791095,4783233,4782982,4782367,4782119,4782022,4777376,4777326,4771956,4337724,4329970,4329762) [ RunTime:0.007361s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6644937 LIMIT 4 [ RunTime:0.003434s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6644937 ORDER BY `minOrder` ASC [ RunTime:0.003576s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6644937 ORDER BY `unit` DESC [ RunTime:0.001338s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6644937 LIMIT 2 [ RunTime:0.010542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6644937 ORDER BY `minOrder` ASC [ RunTime:0.017667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6644787 LIMIT 4 [ RunTime:0.007567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6644787 ORDER BY `minOrder` ASC [ RunTime:0.006724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6644787 ORDER BY `unit` DESC [ RunTime:0.003892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6644787 LIMIT 2 [ RunTime:0.014449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6644787 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6642863 LIMIT 4 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642863 ORDER BY `minOrder` ASC [ RunTime:0.002225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6642863 ORDER BY `unit` DESC [ RunTime:0.000605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6642863 LIMIT 2 [ RunTime:0.002427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642863 ORDER BY `minOrder` ASC [ RunTime:0.007346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6642494 LIMIT 4 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642494 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6642494 ORDER BY `unit` DESC [ RunTime:0.005904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6642494 LIMIT 2 [ RunTime:0.001946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642494 ORDER BY `minOrder` ASC [ RunTime:0.002310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6642306 LIMIT 4 [ RunTime:0.001097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642306 ORDER BY `minOrder` ASC [ RunTime:0.004191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6642306 ORDER BY `unit` DESC [ RunTime:0.011928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6642306 LIMIT 2 [ RunTime:0.010674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6642306 ORDER BY `minOrder` ASC [ RunTime:0.002865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4798927 LIMIT 4 [ RunTime:0.002860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798927 ORDER BY `minOrder` ASC [ RunTime:0.004244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4798927 ORDER BY `unit` DESC [ RunTime:0.002555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4798927 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798927 ORDER BY `minOrder` ASC [ RunTime:0.001617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4797240 LIMIT 4 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4797240 ORDER BY `minOrder` ASC [ RunTime:0.006392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4797240 ORDER BY `unit` DESC [ RunTime:0.009342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4797240 LIMIT 2 [ RunTime:0.001747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4797240 ORDER BY `minOrder` ASC [ RunTime:0.002452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4796747 LIMIT 4 [ RunTime:0.001064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4796747 ORDER BY `minOrder` ASC [ RunTime:0.004225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4796747 ORDER BY `unit` DESC [ RunTime:0.001271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4796747 LIMIT 2 [ RunTime:0.003779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4796747 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4791095 LIMIT 4 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4791095 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4791095 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4791095 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4791095 ORDER BY `minOrder` ASC [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4783233 LIMIT 4 [ RunTime:0.003439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4783233 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4783233 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4783233 LIMIT 2 [ RunTime:0.001695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4783233 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782982 LIMIT 4 [ RunTime:0.000895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782982 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782982 ORDER BY `unit` DESC [ RunTime:0.001327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782982 LIMIT 2 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782982 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782367 LIMIT 4 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782367 ORDER BY `minOrder` ASC [ RunTime:0.002526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782367 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782367 LIMIT 2 [ RunTime:0.000528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782367 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782119 LIMIT 4 [ RunTime:0.000742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782119 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782119 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782119 LIMIT 2 [ RunTime:0.006972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782119 ORDER BY `minOrder` ASC [ RunTime:0.003069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782022 LIMIT 4 [ RunTime:0.001039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782022 ORDER BY `minOrder` ASC [ RunTime:0.003043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782022 ORDER BY `unit` DESC [ RunTime:0.000574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782022 LIMIT 2 [ RunTime:0.013486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782022 ORDER BY `minOrder` ASC [ RunTime:0.006291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4777376 LIMIT 4 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777376 ORDER BY `minOrder` ASC [ RunTime:0.006727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4777376 ORDER BY `unit` DESC [ RunTime:0.011585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4777376 LIMIT 2 [ RunTime:0.001862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777376 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4777326 LIMIT 4 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777326 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4777326 ORDER BY `unit` DESC [ RunTime:0.004392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4777326 LIMIT 2 [ RunTime:0.006268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777326 ORDER BY `minOrder` ASC [ RunTime:0.001908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4771956 LIMIT 4 [ RunTime:0.001240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771956 ORDER BY `minOrder` ASC [ RunTime:0.007901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4771956 ORDER BY `unit` DESC [ RunTime:0.002855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4771956 LIMIT 2 [ RunTime:0.007332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4771956 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337724 LIMIT 4 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337724 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337724 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337724 LIMIT 2 [ RunTime:0.000525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337724 ORDER BY `minOrder` ASC [ RunTime:0.001113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4329970 LIMIT 4 [ RunTime:0.014058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329970 ORDER BY `minOrder` ASC [ RunTime:0.002801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4329970 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4329970 LIMIT 2 [ RunTime:0.001941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329970 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4329762 LIMIT 4 [ RunTime:0.000841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329762 ORDER BY `minOrder` ASC [ RunTime:0.004876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4329762 ORDER BY `unit` DESC [ RunTime:0.002108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4329762 LIMIT 2 [ RunTime:0.002287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329762 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMCJ48A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001865s ]