SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002105s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002034s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.000302s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001803s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000285s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 48 LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 48 [ RunTime:0.000236s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602) [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002013s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `status` <> 2 AND `categoryid` IN (540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602) ) [ RunTime:0.000517s ]
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 ( `status` <> 2 AND `categoryid` IN (540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 140,20 [ RunTime:0.006319s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1484 LIMIT 4 [ RunTime:0.003873s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1484 ORDER BY `minOrder` ASC [ RunTime:0.003162s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1484 ORDER BY `unit` DESC [ RunTime:0.003030s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1484 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1484 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '562A032-25-0' OR `brand` LIKE 'RAYCHEM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3694 LIMIT 4 [ RunTime:0.000402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3694 ORDER BY `minOrder` ASC [ RunTime:0.007167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3694 ORDER BY `unit` DESC [ RunTime:0.001396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3694 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3694 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VEP08US09' OR `brand` LIKE 'XP POWER%' ) ) LIMIT 1 [ RunTime:0.002195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 912 LIMIT 4 [ RunTime:0.000238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 912 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 912 ORDER BY `unit` DESC [ RunTime:0.000228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 912 LIMIT 2 [ RunTime:0.000222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 912 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LPT45' OR `brand` LIKE 'ARTESYN EMBEDDED TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7644 LIMIT 4 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7644 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7644 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7644 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7644 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '694108301002' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.000772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2630 LIMIT 4 [ RunTime:0.001450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2630 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2630 ORDER BY `unit` DESC [ RunTime:0.002046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2630 LIMIT 2 [ RunTime:0.004403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2630 ORDER BY `minOrder` ASC [ RunTime:0.005057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AEH45UM31' OR `brand` LIKE 'XP POWER%' ) ) LIMIT 1 [ RunTime:0.001915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10852 LIMIT 4 [ RunTime:0.003423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852 ORDER BY `minOrder` ASC [ RunTime:0.004429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10852 ORDER BY `unit` DESC [ RunTime:0.001286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10852 LIMIT 2 [ RunTime:0.006015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10852 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VNQ860TR-E' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.002905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7759 LIMIT 4 [ RunTime:0.003427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7759 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7759 ORDER BY `unit` DESC [ RunTime:0.002530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7759 LIMIT 2 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7759 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NFM21HC105R1C3D' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.003369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1398 LIMIT 4 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1398 ORDER BY `minOrder` ASC [ RunTime:0.001266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1398 ORDER BY `unit` DESC [ RunTime:0.004269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1398 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1398 ORDER BY `minOrder` ASC [ RunTime:0.003275s ]
select * from pdf where partno='HS516-5M' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.004516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HS516-5M' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.002561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1084 LIMIT 4 [ RunTime:0.000459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1084 ORDER BY `minOrder` ASC [ RunTime:0.006195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1084 ORDER BY `unit` DESC [ RunTime:0.004047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1084 LIMIT 2 [ RunTime:0.009704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1084 ORDER BY `minOrder` ASC [ RunTime:0.002217s ]
select * from pdf where partno='STFE4 2.0 CLR' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STFE4 2.0 CLR' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8370 LIMIT 4 [ RunTime:0.001613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8370 ORDER BY `minOrder` ASC [ RunTime:0.000870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8370 ORDER BY `unit` DESC [ RunTime:0.001575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8370 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8370 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GW-151651' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.001148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1079 LIMIT 4 [ RunTime:0.000350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1079 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1079 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1079 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1079 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SP64/1.2BLACK' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.006301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13844 LIMIT 4 [ RunTime:0.000444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13844 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13844 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13844 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13844 ORDER BY `minOrder` ASC [ RunTime:0.001069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '111-01960' OR `brand` LIKE 'HELLERMANNTYTON%' ) ) LIMIT 1 [ RunTime:0.003319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1217 LIMIT 4 [ RunTime:0.001057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1217 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1217 ORDER BY `unit` DESC [ RunTime:0.001883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1217 LIMIT 2 [ RunTime:0.001294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1217 ORDER BY `minOrder` ASC [ RunTime:0.001430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SCL-3/8-0-STK' OR `brand` LIKE 'RAYCHEM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5824 LIMIT 4 [ RunTime:0.000945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5824 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5824 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5824 LIMIT 2 [ RunTime:0.001287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5824 ORDER BY `minOrder` ASC [ RunTime:0.004901s ]
select * from pdf where partno='DCPP1' and brandshort='CLIFF ELECTRONIC COMPONENTS' limit 1 [ RunTime:0.001471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DCPP1' OR `brand` LIKE 'CLIFF ELECTRONIC COMPONENTS%' ) ) LIMIT 1 [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13823 LIMIT 4 [ RunTime:0.000481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823 ORDER BY `minOrder` ASC [ RunTime:0.003108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13823 ORDER BY `unit` DESC [ RunTime:0.006529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13823 LIMIT 2 [ RunTime:0.005083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13823 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '305-04800' OR `brand` LIKE 'HELLERMANNTYTON%' ) ) LIMIT 1 [ RunTime:0.001636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3580 LIMIT 4 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3580 ORDER BY `minOrder` ASC [ RunTime:0.000637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3580 ORDER BY `unit` DESC [ RunTime:0.000371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3580 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3580 ORDER BY `minOrder` ASC [ RunTime:0.000246s ]
select * from pdf where partno='M80-5000000M1-02-331-00-000' and brandshort='HARWIN' limit 1 [ RunTime:0.001242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'M80-5000000M1-02-331-00-000' OR `brand` LIKE 'HARWIN%' ) ) LIMIT 1 [ RunTime:0.001151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 92 LIMIT 4 [ RunTime:0.000382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 92 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 92 ORDER BY `unit` DESC [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 92 LIMIT 2 [ RunTime:0.000798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 92 ORDER BY `minOrder` ASC [ RunTime:0.000763s ]
select * from pdf where partno='13650' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.001224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13650' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1043 LIMIT 4 [ RunTime:0.000579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1043 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1043 ORDER BY `unit` DESC [ RunTime:0.000952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1043 LIMIT 2 [ RunTime:0.002879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1043 ORDER BY `minOrder` ASC [ RunTime:0.000253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VSU2W' OR `brand` LIKE 'ROXBURGH EMC%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8626 LIMIT 4 [ RunTime:0.001828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8626 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8626 ORDER BY `unit` DESC [ RunTime:0.000360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8626 LIMIT 2 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8626 ORDER BY `minOrder` ASC [ RunTime:0.002306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1319G6-BK' OR `brand` LIKE 'ANDERSON POWER PRODUCTS%' ) ) LIMIT 1 [ RunTime:0.001007s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1213 LIMIT 4 [ RunTime:0.005498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1213 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1213 ORDER BY `unit` DESC [ RunTime:0.002482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1213 LIMIT 2 [ RunTime:0.006008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1213 ORDER BY `minOrder` ASC [ RunTime:0.005091s ]
select * from pdf where partno='RNF-100-2-X-STK' and brandshort='RAYCHEM - TE CONNECTIVITY' limit 1 [ RunTime:0.003633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RNF-100-2-X-STK' OR `brand` LIKE 'RAYCHEM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001754s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` IN (540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602) ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002100s ]