SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002331s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001708s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002660s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000395s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002170s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000353s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000272s ]
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.000460s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002732s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:8.123644s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 8680,20 [ RunTime:0.042567s ]
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 = 1) ) AND `s`.`id` IN ('11978440','11331161','11237897','3838','11481896','7873','8636','11943464','11482261','6859','11160639','9996','11149158','11492577','11489886','11231747','11160992','11954449','11944533','11944741') ORDER BY FIELD(s.id, 11978440,11331161,11237897,3838,11481896,7873,8636,11943464,11482261,6859,11160639,9996,11149158,11492577,11489886,11231747,11160992,11954449,11944533,11944741) [ RunTime:0.004963s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11978440 LIMIT 4 [ RunTime:0.000770s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978440 ORDER BY `minOrder` ASC [ RunTime:0.004033s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11978440 ORDER BY `unit` DESC [ RunTime:0.003995s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11978440 LIMIT 2 [ RunTime:0.000958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11978440 ORDER BY `minOrder` ASC [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11331161 LIMIT 4 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11331161 ORDER BY `minOrder` ASC [ RunTime:0.001885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11331161 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11331161 LIMIT 2 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11331161 ORDER BY `minOrder` ASC [ RunTime:0.001447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11237897 LIMIT 4 [ RunTime:0.004285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237897 ORDER BY `minOrder` ASC [ RunTime:0.001514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11237897 ORDER BY `unit` DESC [ RunTime:0.006056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11237897 LIMIT 2 [ RunTime:0.015281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237897 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3838 LIMIT 4 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3838 ORDER BY `minOrder` ASC [ RunTime:0.001204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3838 ORDER BY `unit` DESC [ RunTime:0.000794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3838 LIMIT 2 [ RunTime:0.004824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3838 ORDER BY `minOrder` ASC [ RunTime:0.003647s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '02-09-1119' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.006634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481896 LIMIT 4 [ RunTime:0.005492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481896 ORDER BY `minOrder` ASC [ RunTime:0.001035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481896 ORDER BY `unit` DESC [ RunTime:0.002249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481896 LIMIT 2 [ RunTime:0.004247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481896 ORDER BY `minOrder` ASC [ RunTime:0.001415s ]
select * from pdf where partno='1411560-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7873 LIMIT 4 [ RunTime:0.004406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7873 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7873 ORDER BY `unit` DESC [ RunTime:0.001422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7873 LIMIT 2 [ RunTime:0.001444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7873 ORDER BY `minOrder` ASC [ RunTime:0.003279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SML-P11VTT86R' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.004572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8636 LIMIT 4 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8636 ORDER BY `minOrder` ASC [ RunTime:0.003555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8636 ORDER BY `unit` DESC [ RunTime:0.000749s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8636 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8636 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='89116-0101' and brandshort='3M' limit 1 [ RunTime:0.002727s ]
select foldpath,foldpath2,filename from pdf_file where id=1497044 limit 1 [ RunTime:0.003321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '89116-0101' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.005238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943464 LIMIT 4 [ RunTime:0.002277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943464 ORDER BY `minOrder` ASC [ RunTime:0.000440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943464 ORDER BY `unit` DESC [ RunTime:0.000612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943464 LIMIT 2 [ RunTime:0.001474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943464 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482261 LIMIT 4 [ RunTime:0.002383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482261 ORDER BY `minOrder` ASC [ RunTime:0.002081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482261 ORDER BY `unit` DESC [ RunTime:0.002341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482261 LIMIT 2 [ RunTime:0.000415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482261 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6859 LIMIT 4 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6859 ORDER BY `minOrder` ASC [ RunTime:0.001047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6859 ORDER BY `unit` DESC [ RunTime:0.000475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6859 LIMIT 2 [ RunTime:0.002461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6859 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='66601-2' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.006256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '66601-2' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11160639 LIMIT 4 [ RunTime:0.001424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11160639 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11160639 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11160639 LIMIT 2 [ RunTime:0.000926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11160639 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9996 LIMIT 4 [ RunTime:0.001550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9996 ORDER BY `minOrder` ASC [ RunTime:0.004033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9996 ORDER BY `unit` DESC [ RunTime:0.010888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9996 LIMIT 2 [ RunTime:0.005819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9996 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='742792662' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.007039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '742792662' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.001318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11149158 LIMIT 4 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149158 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11149158 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11149158 LIMIT 2 [ RunTime:0.001670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149158 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11492577 LIMIT 4 [ RunTime:0.004750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492577 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11492577 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11492577 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492577 ORDER BY `minOrder` ASC [ RunTime:0.001608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11489886 LIMIT 4 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489886 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11489886 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11489886 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11489886 ORDER BY `minOrder` ASC [ RunTime:0.001261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11231747 LIMIT 4 [ RunTime:0.001285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11231747 ORDER BY `minOrder` ASC [ RunTime:0.001581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11231747 ORDER BY `unit` DESC [ RunTime:0.001269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11231747 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11231747 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
select * from pdf where partno='CMDA5DR7D1S' and brandshort='Visual Communications Company - VCC' limit 1 [ RunTime:0.002146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11160992 LIMIT 4 [ RunTime:0.005293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11160992 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11160992 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11160992 LIMIT 2 [ RunTime:0.004498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11160992 ORDER BY `minOrder` ASC [ RunTime:0.000988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11954449 LIMIT 4 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11954449 ORDER BY `minOrder` ASC [ RunTime:0.000811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11954449 ORDER BY `unit` DESC [ RunTime:0.000405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11954449 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11954449 ORDER BY `minOrder` ASC [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944533 LIMIT 4 [ RunTime:0.000605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944533 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944533 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944533 LIMIT 2 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944533 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944741 LIMIT 4 [ RunTime:0.002702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944741 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944741 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944741 LIMIT 2 [ RunTime:0.000971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944741 ORDER BY `minOrder` ASC [ RunTime:0.001516s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.007943s ]