SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001228s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001461s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001337s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000233s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000176s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000150s ]
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.000331s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001352s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) [ RunTime:0.000211s ]
SELECT `s`.`id`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 580,20 [ RunTime:0.012600s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460706 LIMIT 4 [ RunTime:0.002621s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460706 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460706 ORDER BY `unit` DESC [ RunTime:0.004118s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460706 LIMIT 2 [ RunTime:0.001300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460706 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460652 LIMIT 4 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460652 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460652 ORDER BY `unit` DESC [ RunTime:0.000396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460652 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460652 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
select * from pdf where partno='76069-00000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460651 LIMIT 4 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460651 ORDER BY `minOrder` ASC [ RunTime:0.003106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460651 ORDER BY `unit` DESC [ RunTime:0.003443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460651 LIMIT 2 [ RunTime:0.002066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460651 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
select * from pdf where partno='76087-01100060-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460649 LIMIT 4 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460649 ORDER BY `minOrder` ASC [ RunTime:0.003914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460649 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460649 LIMIT 2 [ RunTime:0.001939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460649 ORDER BY `minOrder` ASC [ RunTime:0.004345s ]
select * from pdf where partno='76084-06000600-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.006928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460627 LIMIT 4 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460627 ORDER BY `minOrder` ASC [ RunTime:0.003689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460627 ORDER BY `unit` DESC [ RunTime:0.004170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460627 LIMIT 2 [ RunTime:0.003006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460627 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='76077-00000150-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460615 LIMIT 4 [ RunTime:0.006391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460615 ORDER BY `minOrder` ASC [ RunTime:0.001115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460615 ORDER BY `unit` DESC [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460615 LIMIT 2 [ RunTime:0.004240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460615 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='76052-00000150-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460614 LIMIT 4 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460614 ORDER BY `minOrder` ASC [ RunTime:0.005061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460614 ORDER BY `unit` DESC [ RunTime:0.002854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460614 LIMIT 2 [ RunTime:0.001457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460614 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
select * from pdf where partno='76067-00000150-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460613 LIMIT 4 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460613 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460613 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460613 LIMIT 2 [ RunTime:0.002556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460613 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
select * from pdf where partno='76083-05000500-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460612 LIMIT 4 [ RunTime:0.002573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460612 ORDER BY `minOrder` ASC [ RunTime:0.010824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460612 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460612 LIMIT 2 [ RunTime:0.002865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460612 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='76058-00000320-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460611 LIMIT 4 [ RunTime:0.004280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460611 ORDER BY `minOrder` ASC [ RunTime:0.010045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460611 ORDER BY `unit` DESC [ RunTime:0.003564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460611 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460611 ORDER BY `minOrder` ASC [ RunTime:0.005976s ]
select * from pdf where partno='76064-00000660-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.004224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460610 LIMIT 4 [ RunTime:0.008262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460610 ORDER BY `minOrder` ASC [ RunTime:0.004072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460610 ORDER BY `unit` DESC [ RunTime:0.004843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460610 LIMIT 2 [ RunTime:0.005008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460610 ORDER BY `minOrder` ASC [ RunTime:0.004559s ]
select * from pdf where partno='76072-00000230-15' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460609 LIMIT 4 [ RunTime:0.003320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460609 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460609 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460609 LIMIT 2 [ RunTime:0.001344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460609 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='76052-00000220-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460608 LIMIT 4 [ RunTime:0.001032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460608 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460608 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460608 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460608 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='76058-00000250-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.001375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460607 LIMIT 4 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460607 ORDER BY `minOrder` ASC [ RunTime:0.001985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460607 ORDER BY `unit` DESC [ RunTime:0.004681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460607 LIMIT 2 [ RunTime:0.001112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460607 ORDER BY `minOrder` ASC [ RunTime:0.000254s ]
select * from pdf where partno='76053-00000350-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.005442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460605 LIMIT 4 [ RunTime:0.003990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460605 ORDER BY `minOrder` ASC [ RunTime:0.002552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460605 ORDER BY `unit` DESC [ RunTime:0.009724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460605 LIMIT 2 [ RunTime:0.002034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460605 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
select * from pdf where partno='76054-00000770-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460604 LIMIT 4 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460604 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460604 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460604 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460604 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
select * from pdf where partno='76056-00000015-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460603 LIMIT 4 [ RunTime:0.000693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460603 ORDER BY `minOrder` ASC [ RunTime:0.001529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460603 ORDER BY `unit` DESC [ RunTime:0.001081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460603 LIMIT 2 [ RunTime:0.007383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460603 ORDER BY `minOrder` ASC [ RunTime:0.002169s ]
select * from pdf where partno='76057-M00000140-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460602 LIMIT 4 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460602 ORDER BY `minOrder` ASC [ RunTime:0.000234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460602 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460602 LIMIT 2 [ RunTime:0.002120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460602 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
select * from pdf where partno='76057-M00000170-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460600 LIMIT 4 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460600 ORDER BY `minOrder` ASC [ RunTime:0.001510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460600 ORDER BY `unit` DESC [ RunTime:0.001206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460600 LIMIT 2 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460600 ORDER BY `minOrder` ASC [ RunTime:0.000161s ]
select * from pdf where partno='76058-00000350-05' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2460599 LIMIT 4 [ RunTime:0.003559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460599 ORDER BY `minOrder` ASC [ RunTime:0.001442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2460599 ORDER BY `unit` DESC [ RunTime:0.006661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2460599 LIMIT 2 [ RunTime:0.005175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2460599 ORDER BY `minOrder` ASC [ RunTime:0.003887s ]
select * from pdf where partno='76057-00000150-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002629s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE '760%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.000303s ]