SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002219s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002527s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002752s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000357s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.002205s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000254s ]
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.004062s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002352s ]
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.005539s ]
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 300,20 [ RunTime:0.010800s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9162181 LIMIT 4 [ RunTime:0.006234s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9162181 ORDER BY `minOrder` ASC [ RunTime:0.001588s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9162181 ORDER BY `unit` DESC [ RunTime:0.001593s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9162181 LIMIT 2 [ RunTime:0.001554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9162181 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9145325 LIMIT 4 [ RunTime:0.002033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9145325 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9145325 ORDER BY `unit` DESC [ RunTime:0.000408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9145325 LIMIT 2 [ RunTime:0.002915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9145325 ORDER BY `minOrder` ASC [ RunTime:0.005103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8990267 LIMIT 4 [ RunTime:0.005234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8990267 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8990267 ORDER BY `unit` DESC [ RunTime:0.007471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8990267 LIMIT 2 [ RunTime:0.001653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8990267 ORDER BY `minOrder` ASC [ RunTime:0.001912s ]
select * from pdf where partno='76020124200' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8870906 LIMIT 4 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8870906 ORDER BY `minOrder` ASC [ RunTime:0.005898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8870906 ORDER BY `unit` DESC [ RunTime:0.001876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8870906 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8870906 ORDER BY `minOrder` ASC [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8868809 LIMIT 4 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8868809 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8868809 ORDER BY `unit` DESC [ RunTime:0.002759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8868809 LIMIT 2 [ RunTime:0.009305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8868809 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790625 LIMIT 4 [ RunTime:0.002183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790625 ORDER BY `minOrder` ASC [ RunTime:0.001761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790625 ORDER BY `unit` DESC [ RunTime:0.001898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790625 LIMIT 2 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790625 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='76061-00000015-15' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.001031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790624 LIMIT 4 [ RunTime:0.007540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790624 ORDER BY `minOrder` ASC [ RunTime:0.001831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790624 ORDER BY `unit` DESC [ RunTime:0.001828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790624 LIMIT 2 [ RunTime:0.001795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790624 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='76053-00000500-15' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790533 LIMIT 4 [ RunTime:0.003148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790533 ORDER BY `minOrder` ASC [ RunTime:0.007803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790533 ORDER BY `unit` DESC [ RunTime:0.001811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790533 LIMIT 2 [ RunTime:0.001760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790533 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790464 LIMIT 4 [ RunTime:0.002005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790464 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790464 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790464 LIMIT 2 [ RunTime:0.014319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790464 ORDER BY `minOrder` ASC [ RunTime:0.001141s ]
select * from pdf where partno='76073-00000400-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790462 LIMIT 4 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790462 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790462 ORDER BY `unit` DESC [ RunTime:0.007785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790462 LIMIT 2 [ RunTime:0.001835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790462 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='76051-B00000020-14' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790461 LIMIT 4 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790461 ORDER BY `minOrder` ASC [ RunTime:0.000586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790461 ORDER BY `unit` DESC [ RunTime:0.002977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790461 LIMIT 2 [ RunTime:0.007671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790461 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
select * from pdf where partno='76064-B00000850-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790460 LIMIT 4 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790460 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790460 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790460 LIMIT 2 [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790460 ORDER BY `minOrder` ASC [ RunTime:0.004065s ]
select * from pdf where partno='76071-B00000030-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.004931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790458 LIMIT 4 [ RunTime:0.001819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790458 ORDER BY `minOrder` ASC [ RunTime:0.000690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790458 ORDER BY `unit` DESC [ RunTime:0.002866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790458 LIMIT 2 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790458 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='76064-B00000600-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790453 LIMIT 4 [ RunTime:0.000808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790453 ORDER BY `minOrder` ASC [ RunTime:0.000675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790453 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790453 LIMIT 2 [ RunTime:0.002995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790453 ORDER BY `minOrder` ASC [ RunTime:0.004014s ]
select * from pdf where partno='76051-B00000020-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.004877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790451 LIMIT 4 [ RunTime:0.001731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790451 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790451 ORDER BY `unit` DESC [ RunTime:0.000687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790451 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790451 ORDER BY `minOrder` ASC [ RunTime:0.002546s ]
select * from pdf where partno='76071-00000020-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790430 LIMIT 4 [ RunTime:0.006778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790430 ORDER BY `minOrder` ASC [ RunTime:0.001847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790430 ORDER BY `unit` DESC [ RunTime:0.001799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790430 LIMIT 2 [ RunTime:0.001823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790430 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
select * from pdf where partno='76053-00000300-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.000950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790429 LIMIT 4 [ RunTime:0.002534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790429 ORDER BY `minOrder` ASC [ RunTime:0.007664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790429 ORDER BY `unit` DESC [ RunTime:0.001817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790429 LIMIT 2 [ RunTime:0.001798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790429 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
select * from pdf where partno='76062-00000150-22' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790428 LIMIT 4 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790428 ORDER BY `minOrder` ASC [ RunTime:0.002451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790428 ORDER BY `unit` DESC [ RunTime:0.008089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790428 LIMIT 2 [ RunTime:0.001834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790428 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='76070-00001200-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8790425 LIMIT 4 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790425 ORDER BY `minOrder` ASC [ RunTime:0.000624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8790425 ORDER BY `unit` DESC [ RunTime:0.002894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8790425 LIMIT 2 [ RunTime:0.007924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8790425 ORDER BY `minOrder` ASC [ RunTime:0.000429s ]
select * from pdf where partno='76052-00000200-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.002089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8785849 LIMIT 4 [ RunTime:0.001150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8785849 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8785849 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8785849 LIMIT 2 [ RunTime:0.002896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8785849 ORDER BY `minOrder` ASC [ RunTime:0.004265s ]
select * from pdf where partno='76075-00001000-01' and brandshort='Honeywell Sensing and Productivity Solutions' limit 1 [ RunTime:0.005032s ]
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.000546s ]