SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001926s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001361s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.43' ) [ RunTime:0.003299s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000879s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000185s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 186 LIMIT 1 [ RunTime:0.001335s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 186 [ RunTime:0.000526s ]
SELECT `id`,`name` FROM `product_type` WHERE `typeid` = 26 [ RunTime:0.000149s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001168s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `status` <> 2 AND `categoryid` = 186 ) [ RunTime:0.004118s ]
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` = 186 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.005878s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 899 LIMIT 4 [ RunTime:0.005093s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 899 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 899 ORDER BY `unit` DESC [ RunTime:0.004059s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 899 LIMIT 2 [ RunTime:0.004024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 899 ORDER BY `minOrder` ASC [ RunTime:0.004695s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '34.51.7.012.0010' OR `brand` LIKE 'FINDER%' ) ) LIMIT 1 [ RunTime:0.013728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 898 LIMIT 4 [ RunTime:0.010764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 898 ORDER BY `minOrder` ASC [ RunTime:0.000721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 898 ORDER BY `unit` DESC [ RunTime:0.004647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 898 LIMIT 2 [ RunTime:0.012563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 898 ORDER BY `minOrder` ASC [ RunTime:0.007681s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '41.52.9.024.0010' OR `brand` LIKE 'FINDER%' ) ) LIMIT 1 [ RunTime:0.013633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2979 LIMIT 4 [ RunTime:0.001091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2979 ORDER BY `minOrder` ASC [ RunTime:0.010144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2979 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2979 LIMIT 2 [ RunTime:0.003599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2979 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
select * from pdf where partno='1393240-6' and brandshort='SCHRACK - TE CONNECTIVITY' limit 1 [ RunTime:0.012331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1393240-6' OR `brand` LIKE 'SCHRACK - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347 LIMIT 4 [ RunTime:0.001985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347 ORDER BY `minOrder` ASC [ RunTime:0.008124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347 ORDER BY `unit` DESC [ RunTime:0.007113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347 LIMIT 2 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347 ORDER BY `minOrder` ASC [ RunTime:0.006229s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3-1393774-5' OR `brand` LIKE 'AXICOM - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.007637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4857 LIMIT 4 [ RunTime:0.008299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4857 ORDER BY `minOrder` ASC [ RunTime:0.010406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4857 ORDER BY `unit` DESC [ RunTime:0.013225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4857 LIMIT 2 [ RunTime:0.004817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4857 ORDER BY `minOrder` ASC [ RunTime:0.003401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1721531-2' OR `brand` LIKE 'OEG - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3148 LIMIT 4 [ RunTime:0.005208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3148 ORDER BY `minOrder` ASC [ RunTime:0.003732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3148 ORDER BY `unit` DESC [ RunTime:0.000516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3148 LIMIT 2 [ RunTime:0.004352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3148 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1-1393210-3' and brandshort='POTTER&BRUMFIELD - TE CONNECTIVITY' limit 1 [ RunTime:0.003898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-1393210-3' OR `brand` LIKE 'POTTER&BRUMFIELD - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13980 LIMIT 4 [ RunTime:0.002594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13980 ORDER BY `minOrder` ASC [ RunTime:0.002883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13980 ORDER BY `unit` DESC [ RunTime:0.005840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13980 LIMIT 2 [ RunTime:0.003773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13980 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '94.74SMA' OR `brand` LIKE 'FINDER%' ) ) LIMIT 1 [ RunTime:0.003556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2977 LIMIT 4 [ RunTime:0.000493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2977 ORDER BY `minOrder` ASC [ RunTime:0.005410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2977 ORDER BY `unit` DESC [ RunTime:0.002872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2977 LIMIT 2 [ RunTime:0.002325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2977 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
select * from pdf where partno='1-1956170-2' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.001450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-1956170-2' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9326 LIMIT 4 [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9326 ORDER BY `minOrder` ASC [ RunTime:0.000256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9326 ORDER BY `unit` DESC [ RunTime:0.000242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9326 LIMIT 2 [ RunTime:0.000966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9326 ORDER BY `minOrder` ASC [ RunTime:0.000215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '70-464-1' OR `brand` LIKE 'SCHNEIDER ELECTRIC/LEGACY RELAY%' ) ) LIMIT 1 [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1133 LIMIT 4 [ RunTime:0.001374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1133 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1133 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1133 LIMIT 2 [ RunTime:0.000262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1133 ORDER BY `minOrder` ASC [ RunTime:0.002446s ]
select * from pdf where partno='TX2-12V' and brandshort='PANASONIC' limit 1 [ RunTime:0.000416s ]
select foldpath,foldpath2,filename from pdf_file where id=1152166 limit 1 [ RunTime:0.000269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TX2-12V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5754 LIMIT 4 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5754 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5754 ORDER BY `unit` DESC [ RunTime:0.002387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5754 LIMIT 2 [ RunTime:0.006921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5754 ORDER BY `minOrder` ASC [ RunTime:0.002894s ]
select * from pdf where partno='G5RL-1A-E-HR DC12' and brandshort='OMRON ELECTRONIC COMPONENTS' limit 1 [ RunTime:0.009189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'G5RL-1A-E-HR DC12' OR `brand` LIKE 'OMRON ELECTRONIC COMPONENTS%' ) ) LIMIT 1 [ RunTime:0.001850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 957 LIMIT 4 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 957 ORDER BY `minOrder` ASC [ RunTime:0.006477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 957 ORDER BY `unit` DESC [ RunTime:0.008219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 957 LIMIT 2 [ RunTime:0.009199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 957 ORDER BY `minOrder` ASC [ RunTime:0.002484s ]
select * from pdf where partno='8-1415053-1' and brandshort='SCHRACK - TE CONNECTIVITY' limit 1 [ RunTime:0.001566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8-1415053-1' OR `brand` LIKE 'SCHRACK - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10034 LIMIT 4 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10034 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10034 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10034 LIMIT 2 [ RunTime:0.000312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10034 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1558661-7' OR `brand` LIKE 'POTTER&BRUMFIELD - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9601 LIMIT 4 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9601 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9601 ORDER BY `unit` DESC [ RunTime:0.000716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9601 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9601 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AQY212FG2SX' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 893 LIMIT 4 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 893 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 893 ORDER BY `unit` DESC [ RunTime:0.000251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 893 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 893 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '55.34.9.024.0040' OR `brand` LIKE 'FINDER%' ) ) LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9324 LIMIT 4 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9324 ORDER BY `minOrder` ASC [ RunTime:0.000251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9324 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9324 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9324 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40.52.9.024.0001' OR `brand` LIKE 'FINDER%' ) ) LIMIT 1 [ RunTime:0.000256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 956 LIMIT 4 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 956 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 956 ORDER BY `unit` DESC [ RunTime:0.000255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 956 LIMIT 2 [ RunTime:0.000224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 956 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V23134A1053C643' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 383 LIMIT 4 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 383 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 383 ORDER BY `unit` DESC [ RunTime:0.000243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 383 LIMIT 2 [ RunTime:0.000221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 383 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EB2-5NU' OR `brand` LIKE 'NEC%' ) ) LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348 LIMIT 4 [ RunTime:0.000248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348 ORDER BY `unit` DESC [ RunTime:0.000234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348 LIMIT 2 [ RunTime:0.000224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348 ORDER BY `minOrder` ASC [ RunTime:0.000224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '9-1393239-5' OR `brand` LIKE 'SCHRACK - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 334 LIMIT 4 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 334 ORDER BY `minOrder` ASC [ RunTime:0.000255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 334 ORDER BY `unit` DESC [ RunTime:0.000230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 334 LIMIT 2 [ RunTime:0.000226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 334 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2342-12-000' OR `brand` LIKE 'COTO TECHNOLOGY%' ) ) LIMIT 1 [ RunTime:0.000259s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` = 186 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.006354s ]