SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001334s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001548s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001313s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.121' ) [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000948s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000203s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000187s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.000152s ]
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.000337s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001256s ]
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:3.870537s ]
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 8920,20 [ RunTime:0.038347s ]
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 ('10486078','11415305','11492592','11981353','11149522','7828','11974031','10462407','2870','11333191','11947195','11481684','11418716','11230706','11482896','11414220','11932622','11950282','11237713','11446018') ORDER BY FIELD(s.id, 10486078,11415305,11492592,11981353,11149522,7828,11974031,10462407,2870,11333191,11947195,11481684,11418716,11230706,11482896,11414220,11932622,11950282,11237713,11446018) [ RunTime:0.006587s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10486078 LIMIT 4 [ RunTime:0.005933s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10486078 ORDER BY `minOrder` ASC [ RunTime:0.004635s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10486078 ORDER BY `unit` DESC [ RunTime:0.004543s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10486078 LIMIT 2 [ RunTime:0.007419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10486078 ORDER BY `minOrder` ASC [ RunTime:0.002763s ]
select * from pdf where partno='CGA5L2X7R1E105K160AA' and brandshort='TDK Corporation' limit 1 [ RunTime:0.013371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11415305 LIMIT 4 [ RunTime:0.014538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11415305 ORDER BY `minOrder` ASC [ RunTime:0.027432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11415305 ORDER BY `unit` DESC [ RunTime:0.039058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11415305 LIMIT 2 [ RunTime:0.040731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11415305 ORDER BY `minOrder` ASC [ RunTime:0.036201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11492592 LIMIT 4 [ RunTime:0.087406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492592 ORDER BY `minOrder` ASC [ RunTime:0.040751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11492592 ORDER BY `unit` DESC [ RunTime:0.031520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11492592 LIMIT 2 [ RunTime:0.052174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11492592 ORDER BY `minOrder` ASC [ RunTime:0.010654s ]
select * from pdf where partno='MX34028SF1' and brandshort='JAE Electronics' limit 1 [ RunTime:0.031824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11981353 LIMIT 4 [ RunTime:0.048136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981353 ORDER BY `minOrder` ASC [ RunTime:0.039745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11981353 ORDER BY `unit` DESC [ RunTime:0.035008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11981353 LIMIT 2 [ RunTime:0.009907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11981353 ORDER BY `minOrder` ASC [ RunTime:0.021965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11149522 LIMIT 4 [ RunTime:0.008545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149522 ORDER BY `minOrder` ASC [ RunTime:0.004694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11149522 ORDER BY `unit` DESC [ RunTime:0.007716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11149522 LIMIT 2 [ RunTime:0.011507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11149522 ORDER BY `minOrder` ASC [ RunTime:0.005094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7828 LIMIT 4 [ RunTime:0.010094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7828 ORDER BY `minOrder` ASC [ RunTime:0.009049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7828 ORDER BY `unit` DESC [ RunTime:0.001202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7828 LIMIT 2 [ RunTime:0.004850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7828 ORDER BY `minOrder` ASC [ RunTime:0.006334s ]
select * from pdf where partno='501930-1100' and brandshort='MOLEX' limit 1 [ RunTime:0.022265s ]
select foldpath,foldpath2,filename from pdf_file where id=853060 limit 1 [ RunTime:0.012084s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '501930-1100' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.017499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11974031 LIMIT 4 [ RunTime:0.010797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11974031 ORDER BY `minOrder` ASC [ RunTime:0.029716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11974031 ORDER BY `unit` DESC [ RunTime:0.010392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11974031 LIMIT 2 [ RunTime:0.007983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11974031 ORDER BY `minOrder` ASC [ RunTime:0.035537s ]
select * from pdf where partno='BMD-340-A-R' and brandshort='u-blox' limit 1 [ RunTime:0.020556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10462407 LIMIT 4 [ RunTime:0.020617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10462407 ORDER BY `minOrder` ASC [ RunTime:0.022300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10462407 ORDER BY `unit` DESC [ RunTime:0.011225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10462407 LIMIT 2 [ RunTime:0.009795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10462407 ORDER BY `minOrder` ASC [ RunTime:0.010005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2870 LIMIT 4 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2870 ORDER BY `minOrder` ASC [ RunTime:0.009428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2870 ORDER BY `unit` DESC [ RunTime:0.008568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2870 LIMIT 2 [ RunTime:0.006411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2870 ORDER BY `minOrder` ASC [ RunTime:0.007707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '154719-0' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.008141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11333191 LIMIT 4 [ RunTime:0.025004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11333191 ORDER BY `minOrder` ASC [ RunTime:0.008511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11333191 ORDER BY `unit` DESC [ RunTime:0.024080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11333191 LIMIT 2 [ RunTime:0.019004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11333191 ORDER BY `minOrder` ASC [ RunTime:0.001106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11947195 LIMIT 4 [ RunTime:0.004823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11947195 ORDER BY `minOrder` ASC [ RunTime:0.000921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11947195 ORDER BY `unit` DESC [ RunTime:0.000855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11947195 LIMIT 2 [ RunTime:0.001940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11947195 ORDER BY `minOrder` ASC [ RunTime:0.003274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481684 LIMIT 4 [ RunTime:0.011103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481684 ORDER BY `minOrder` ASC [ RunTime:0.011971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481684 ORDER BY `unit` DESC [ RunTime:0.007418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481684 LIMIT 2 [ RunTime:0.008438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481684 ORDER BY `minOrder` ASC [ RunTime:0.001914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418716 LIMIT 4 [ RunTime:0.005817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418716 ORDER BY `minOrder` ASC [ RunTime:0.010194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418716 ORDER BY `unit` DESC [ RunTime:0.005866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418716 LIMIT 2 [ RunTime:0.012570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418716 ORDER BY `minOrder` ASC [ RunTime:0.019625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11230706 LIMIT 4 [ RunTime:0.004076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230706 ORDER BY `minOrder` ASC [ RunTime:0.004463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11230706 ORDER BY `unit` DESC [ RunTime:0.014026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11230706 LIMIT 2 [ RunTime:0.011587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11230706 ORDER BY `minOrder` ASC [ RunTime:0.012146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482896 LIMIT 4 [ RunTime:0.019063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482896 ORDER BY `minOrder` ASC [ RunTime:0.000805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482896 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482896 LIMIT 2 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482896 ORDER BY `minOrder` ASC [ RunTime:0.015406s ]
select * from pdf where partno='AT60-202-16141-22' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.012204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11414220 LIMIT 4 [ RunTime:0.012736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414220 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11414220 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11414220 LIMIT 2 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414220 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932622 LIMIT 4 [ RunTime:0.007071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932622 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932622 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932622 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932622 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11950282 LIMIT 4 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950282 ORDER BY `minOrder` ASC [ RunTime:0.003137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11950282 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11950282 LIMIT 2 [ RunTime:0.002826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11950282 ORDER BY `minOrder` ASC [ RunTime:0.003112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11237713 LIMIT 4 [ RunTime:0.006353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237713 ORDER BY `minOrder` ASC [ RunTime:0.006599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11237713 ORDER BY `unit` DESC [ RunTime:0.003150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11237713 LIMIT 2 [ RunTime:0.009429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11237713 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446018 LIMIT 4 [ RunTime:0.002079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446018 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446018 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446018 LIMIT 2 [ RunTime:0.012715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446018 ORDER BY `minOrder` ASC [ RunTime:0.009001s ]
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.837516s ]