SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001353s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001545s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.166' ) [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001270s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000280s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000382s ]
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.000401s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001775s ]
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 '228%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 1780,20 [ RunTime:0.097283s ]
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 ('5189548','5189547','5189546','5187790','5185642','5185641','5185640','5185639','5184555','5183252','5182087','5182004','5178675','5178107','5166013','5153593','4867717','4867149','4867092','4866217') ORDER BY FIELD(s.id, 5189548,5189547,5189546,5187790,5185642,5185641,5185640,5185639,5184555,5183252,5182087,5182004,5178675,5178107,5166013,5153593,4867717,4867149,4867092,4866217) [ RunTime:0.005855s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5189548 LIMIT 4 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189548 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5189548 ORDER BY `unit` DESC [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5189548 LIMIT 2 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189548 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5189547 LIMIT 4 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189547 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5189547 ORDER BY `unit` DESC [ RunTime:0.002198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5189547 LIMIT 2 [ RunTime:0.004394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189547 ORDER BY `minOrder` ASC [ RunTime:0.000161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5189546 LIMIT 4 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189546 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5189546 ORDER BY `unit` DESC [ RunTime:0.000225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5189546 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5189546 ORDER BY `minOrder` ASC [ RunTime:0.000154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5187790 LIMIT 4 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5187790 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5187790 ORDER BY `unit` DESC [ RunTime:0.000476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5187790 LIMIT 2 [ RunTime:0.001247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5187790 ORDER BY `minOrder` ASC [ RunTime:0.000157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5185642 LIMIT 4 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185642 ORDER BY `minOrder` ASC [ RunTime:0.000599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5185642 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5185642 LIMIT 2 [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185642 ORDER BY `minOrder` ASC [ RunTime:0.000152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5185641 LIMIT 4 [ RunTime:0.000221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185641 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5185641 ORDER BY `unit` DESC [ RunTime:0.001139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5185641 LIMIT 2 [ RunTime:0.001124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185641 ORDER BY `minOrder` ASC [ RunTime:0.001215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5185640 LIMIT 4 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185640 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5185640 ORDER BY `unit` DESC [ RunTime:0.000219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5185640 LIMIT 2 [ RunTime:0.000211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185640 ORDER BY `minOrder` ASC [ RunTime:0.000148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5185639 LIMIT 4 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185639 ORDER BY `minOrder` ASC [ RunTime:0.000953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5185639 ORDER BY `unit` DESC [ RunTime:0.000730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5185639 LIMIT 2 [ RunTime:0.000214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5185639 ORDER BY `minOrder` ASC [ RunTime:0.000150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5184555 LIMIT 4 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5184555 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5184555 ORDER BY `unit` DESC [ RunTime:0.001229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5184555 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5184555 ORDER BY `minOrder` ASC [ RunTime:0.000153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5183252 LIMIT 4 [ RunTime:0.000995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5183252 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5183252 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5183252 LIMIT 2 [ RunTime:0.000216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5183252 ORDER BY `minOrder` ASC [ RunTime:0.000153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5182087 LIMIT 4 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5182087 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5182087 ORDER BY `unit` DESC [ RunTime:0.001227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5182087 LIMIT 2 [ RunTime:0.000685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5182087 ORDER BY `minOrder` ASC [ RunTime:0.000154s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5182004 LIMIT 4 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5182004 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5182004 ORDER BY `unit` DESC [ RunTime:0.000219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5182004 LIMIT 2 [ RunTime:0.001181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5182004 ORDER BY `minOrder` ASC [ RunTime:0.000158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5178675 LIMIT 4 [ RunTime:0.004263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5178675 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5178675 ORDER BY `unit` DESC [ RunTime:0.001988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5178675 LIMIT 2 [ RunTime:0.001886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5178675 ORDER BY `minOrder` ASC [ RunTime:0.000165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5178107 LIMIT 4 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5178107 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5178107 ORDER BY `unit` DESC [ RunTime:0.000220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5178107 LIMIT 2 [ RunTime:0.001945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5178107 ORDER BY `minOrder` ASC [ RunTime:0.004299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5166013 LIMIT 4 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5166013 ORDER BY `minOrder` ASC [ RunTime:0.003620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5166013 ORDER BY `unit` DESC [ RunTime:0.000770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5166013 LIMIT 2 [ RunTime:0.001570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5166013 ORDER BY `minOrder` ASC [ RunTime:0.000163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5153593 LIMIT 4 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5153593 ORDER BY `minOrder` ASC [ RunTime:0.001041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5153593 ORDER BY `unit` DESC [ RunTime:0.001058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5153593 LIMIT 2 [ RunTime:0.000925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5153593 ORDER BY `minOrder` ASC [ RunTime:0.000163s ]
select * from pdf where partno='2286B' and brandshort='Boyd Laconia, LLC' limit 1 [ RunTime:0.004945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4867717 LIMIT 4 [ RunTime:0.001591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867717 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4867717 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4867717 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867717 ORDER BY `minOrder` ASC [ RunTime:0.001473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4867149 LIMIT 4 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867149 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4867149 ORDER BY `unit` DESC [ RunTime:0.000276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4867149 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867149 ORDER BY `minOrder` ASC [ RunTime:0.000184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4867092 LIMIT 4 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867092 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4867092 ORDER BY `unit` DESC [ RunTime:0.001229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4867092 LIMIT 2 [ RunTime:0.000267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4867092 ORDER BY `minOrder` ASC [ RunTime:0.000186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4866217 LIMIT 4 [ RunTime:0.000547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4866217 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4866217 ORDER BY `unit` DESC [ RunTime:0.003775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4866217 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4866217 ORDER BY `minOrder` ASC [ RunTime:0.000192s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '228%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.029992s ]