SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001953s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002245s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.166' ) [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002138s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001330s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001156s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000233s ]
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.000439s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002184s ]
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 'SMCJ10A%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.011958s ]
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 ('4798905','4798904','4796706','4794403','4783236','4782976','4782779','4778585','4777379','4337006','4337005','4336836','4335219','4335168','4329765','4324760','4322916','4322534','4322380','4322078') ORDER BY FIELD(s.id, 4798905,4798904,4796706,4794403,4783236,4782976,4782779,4778585,4777379,4337006,4337005,4336836,4335219,4335168,4329765,4324760,4322916,4322534,4322380,4322078) [ RunTime:0.004896s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4798905 LIMIT 4 [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798905 ORDER BY `minOrder` ASC [ RunTime:0.001082s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4798905 ORDER BY `unit` DESC [ RunTime:0.005073s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4798905 LIMIT 2 [ RunTime:0.002498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798905 ORDER BY `minOrder` ASC [ RunTime:0.002572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4798904 LIMIT 4 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798904 ORDER BY `minOrder` ASC [ RunTime:0.003914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4798904 ORDER BY `unit` DESC [ RunTime:0.000561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4798904 LIMIT 2 [ RunTime:0.006078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4798904 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4796706 LIMIT 4 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4796706 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4796706 ORDER BY `unit` DESC [ RunTime:0.005128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4796706 LIMIT 2 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4796706 ORDER BY `minOrder` ASC [ RunTime:0.000160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4794403 LIMIT 4 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4794403 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4794403 ORDER BY `unit` DESC [ RunTime:0.001315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4794403 LIMIT 2 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4794403 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4783236 LIMIT 4 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4783236 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4783236 ORDER BY `unit` DESC [ RunTime:0.001903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4783236 LIMIT 2 [ RunTime:0.004862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4783236 ORDER BY `minOrder` ASC [ RunTime:0.003489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782976 LIMIT 4 [ RunTime:0.000959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782976 ORDER BY `minOrder` ASC [ RunTime:0.002248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782976 ORDER BY `unit` DESC [ RunTime:0.002437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782976 LIMIT 2 [ RunTime:0.004747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782976 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4782779 LIMIT 4 [ RunTime:0.003105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782779 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4782779 ORDER BY `unit` DESC [ RunTime:0.001804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4782779 LIMIT 2 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4782779 ORDER BY `minOrder` ASC [ RunTime:0.000156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4778585 LIMIT 4 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4778585 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4778585 ORDER BY `unit` DESC [ RunTime:0.007301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4778585 LIMIT 2 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4778585 ORDER BY `minOrder` ASC [ RunTime:0.001515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4777379 LIMIT 4 [ RunTime:0.000940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777379 ORDER BY `minOrder` ASC [ RunTime:0.001777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4777379 ORDER BY `unit` DESC [ RunTime:0.002650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4777379 LIMIT 2 [ RunTime:0.002044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4777379 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337006 LIMIT 4 [ RunTime:0.000826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337006 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337006 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337006 LIMIT 2 [ RunTime:0.002692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337006 ORDER BY `minOrder` ASC [ RunTime:0.006908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4337005 LIMIT 4 [ RunTime:0.003321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337005 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4337005 ORDER BY `unit` DESC [ RunTime:0.002570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4337005 LIMIT 2 [ RunTime:0.003859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4337005 ORDER BY `minOrder` ASC [ RunTime:0.001587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4336836 LIMIT 4 [ RunTime:0.003745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4336836 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4336836 ORDER BY `unit` DESC [ RunTime:0.004675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4336836 LIMIT 2 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4336836 ORDER BY `minOrder` ASC [ RunTime:0.002135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4335219 LIMIT 4 [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4335219 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4335219 ORDER BY `unit` DESC [ RunTime:0.001102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4335219 LIMIT 2 [ RunTime:0.003472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4335219 ORDER BY `minOrder` ASC [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4335168 LIMIT 4 [ RunTime:0.002869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4335168 ORDER BY `minOrder` ASC [ RunTime:0.010001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4335168 ORDER BY `unit` DESC [ RunTime:0.002080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4335168 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4335168 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4329765 LIMIT 4 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329765 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4329765 ORDER BY `unit` DESC [ RunTime:0.001806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4329765 LIMIT 2 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4329765 ORDER BY `minOrder` ASC [ RunTime:0.000249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4324760 LIMIT 4 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4324760 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4324760 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4324760 LIMIT 2 [ RunTime:0.003293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4324760 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4322916 LIMIT 4 [ RunTime:0.000602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322916 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4322916 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4322916 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322916 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4322534 LIMIT 4 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322534 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4322534 ORDER BY `unit` DESC [ RunTime:0.000321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4322534 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322534 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4322380 LIMIT 4 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322380 ORDER BY `minOrder` ASC [ RunTime:0.004193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4322380 ORDER BY `unit` DESC [ RunTime:0.000430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4322380 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322380 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4322078 LIMIT 4 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322078 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4322078 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4322078 LIMIT 2 [ RunTime:0.002535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4322078 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'SMCJ10A%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001103s ]