SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002140s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.70' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock/index?page=3&srecordnum=99&status=3' [ RunTime:0.012788s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002072s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002307s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002308s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.70' ) [ RunTime:0.003609s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003410s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003762s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002168s ]
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` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.019686s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17211 LIMIT 5 [ RunTime:0.018143s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17211 ORDER BY `minOrder` ASC [ RunTime:0.011052s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17211 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17211 LIMIT 2 [ RunTime:0.001253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17211 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
select * from pdf where partno='L4981AD013TR' and brandshort='ST' limit 1 [ RunTime:0.005299s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L4981AD013TR' OR `brand` LIKE 'ST%' ) ) LIMIT 1 [ RunTime:0.028228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17208 LIMIT 5 [ RunTime:0.023359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17208 ORDER BY `minOrder` ASC [ RunTime:0.010409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17208 ORDER BY `unit` DESC [ RunTime:0.045032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17208 LIMIT 2 [ RunTime:0.026666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17208 ORDER BY `minOrder` ASC [ RunTime:0.022368s ]
select * from pdf where partno='AP2127N-2.8TRG1' and brandshort='DIODES' limit 1 [ RunTime:0.045952s ]
select foldpath,foldpath2,filename from pdf_file where id=1600905 limit 1 [ RunTime:0.031831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP2127N-2.8TRG1' OR `brand` LIKE 'DIODES%' ) ) LIMIT 1 [ RunTime:0.038587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17180 LIMIT 5 [ RunTime:0.017564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180 ORDER BY `minOrder` ASC [ RunTime:0.077665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17180 ORDER BY `unit` DESC [ RunTime:0.036778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17180 LIMIT 2 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17180 ORDER BY `minOrder` ASC [ RunTime:0.044942s ]
select * from pdf where partno='GC4344' and brandshort='GLOBALCHIP' limit 1 [ RunTime:0.028985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GC4344' OR `brand` LIKE 'GLOBALCHIP%' ) ) LIMIT 1 [ RunTime:0.045264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17179 LIMIT 5 [ RunTime:0.049981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17179 ORDER BY `minOrder` ASC [ RunTime:0.037195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17179 ORDER BY `unit` DESC [ RunTime:0.035559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17179 LIMIT 2 [ RunTime:0.002765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17179 ORDER BY `minOrder` ASC [ RunTime:0.009698s ]
select * from pdf where partno='GC1808' and brandshort='GLOBALCHIP' limit 1 [ RunTime:0.047098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GC1808' OR `brand` LIKE 'GLOBALCHIP%' ) ) LIMIT 1 [ RunTime:0.034820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17187 LIMIT 5 [ RunTime:0.009352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17187 ORDER BY `minOrder` ASC [ RunTime:0.033179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17187 ORDER BY `unit` DESC [ RunTime:0.057258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17187 LIMIT 2 [ RunTime:0.014822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17187 ORDER BY `minOrder` ASC [ RunTime:0.010970s ]
select * from pdf where partno='UCC27517AQDBVRQ1' and brandshort='TI' limit 1 [ RunTime:0.008421s ]
select foldpath,foldpath2,filename from pdf_file where id=1126144 limit 1 [ RunTime:0.026485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCC27517AQDBVRQ1' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.101613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17239 LIMIT 5 [ RunTime:0.009852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17239 ORDER BY `minOrder` ASC [ RunTime:0.051255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17239 ORDER BY `unit` DESC [ RunTime:0.004454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17239 LIMIT 2 [ RunTime:0.006583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17239 ORDER BY `minOrder` ASC [ RunTime:0.004057s ]
select * from pdf where partno='TXS0102DCUR' and brandshort='TI' limit 1 [ RunTime:0.014766s ]
select foldpath,foldpath2,filename from pdf_file where id=651688 limit 1 [ RunTime:0.000711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TXS0102DCUR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.051271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17233 LIMIT 5 [ RunTime:0.018653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17233 ORDER BY `minOrder` ASC [ RunTime:0.006861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17233 ORDER BY `unit` DESC [ RunTime:0.006577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17233 LIMIT 2 [ RunTime:0.028716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17233 ORDER BY `minOrder` ASC [ RunTime:0.017554s ]
select * from pdf where partno='ATA663454-GDQW' and brandshort='MICROCHIP' limit 1 [ RunTime:0.014908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ATA663454-GDQW' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.032750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17221 LIMIT 5 [ RunTime:0.019920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17221 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17221 ORDER BY `unit` DESC [ RunTime:0.011128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17221 LIMIT 2 [ RunTime:0.037926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17221 ORDER BY `minOrder` ASC [ RunTime:0.002079s ]
select * from pdf where partno='T55B476M010C0070' and brandshort='VISHAY' limit 1 [ RunTime:0.001755s ]
select foldpath,foldpath2,filename from pdf_file where id=1921870 limit 1 [ RunTime:0.012970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T55B476M010C0070' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.029795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17188 LIMIT 5 [ RunTime:0.006126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17188 ORDER BY `minOrder` ASC [ RunTime:0.038764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17188 ORDER BY `unit` DESC [ RunTime:0.014192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17188 LIMIT 2 [ RunTime:0.025588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17188 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
select * from pdf where partno='AP6236' and brandshort='AMPAK' limit 1 [ RunTime:0.027472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AP6236' OR `brand` LIKE 'AMPAK%' ) ) LIMIT 1 [ RunTime:0.045505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17220 LIMIT 5 [ RunTime:0.006989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17220 ORDER BY `minOrder` ASC [ RunTime:0.031743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17220 ORDER BY `unit` DESC [ RunTime:0.048019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17220 LIMIT 2 [ RunTime:0.036538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17220 ORDER BY `minOrder` ASC [ RunTime:0.002805s ]
select * from pdf where partno='SI4174DY-T1-GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.015350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SI4174DY-T1-GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.014677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17198 LIMIT 5 [ RunTime:0.019150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17198 ORDER BY `minOrder` ASC [ RunTime:0.010065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17198 ORDER BY `unit` DESC [ RunTime:0.015005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17198 LIMIT 2 [ RunTime:0.013141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17198 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
select * from pdf where partno='SN65HVD1040QDRQ1' and brandshort='TI' limit 1 [ RunTime:0.004016s ]
select foldpath,foldpath2,filename from pdf_file where id=622500 limit 1 [ RunTime:0.012385s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN65HVD1040QDRQ1' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.068848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17197 LIMIT 5 [ RunTime:0.027807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17197 ORDER BY `minOrder` ASC [ RunTime:0.045928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17197 ORDER BY `unit` DESC [ RunTime:0.016283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17197 LIMIT 2 [ RunTime:0.028188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17197 ORDER BY `minOrder` ASC [ RunTime:0.013891s ]
select * from pdf where partno='CC2652P1FRGZR' and brandshort='TI' limit 1 [ RunTime:0.037920s ]
select foldpath,foldpath2,filename from pdf_file where id=2188426 limit 1 [ RunTime:0.047682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CC2652P1FRGZR' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.128331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17195 LIMIT 5 [ RunTime:0.059865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17195 ORDER BY `minOrder` ASC [ RunTime:0.024397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17195 ORDER BY `unit` DESC [ RunTime:0.015318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17195 LIMIT 2 [ RunTime:0.053682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17195 ORDER BY `minOrder` ASC [ RunTime:0.017088s ]
select * from pdf where partno='SN65HVDA1040BQDRQ1' and brandshort='TI' limit 1 [ RunTime:0.032923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN65HVDA1040BQDRQ1' OR `brand` LIKE 'TI%' ) ) LIMIT 1 [ RunTime:0.071564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17183 LIMIT 5 [ RunTime:0.021928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17183 ORDER BY `minOrder` ASC [ RunTime:0.006116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17183 ORDER BY `unit` DESC [ RunTime:0.002364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17183 LIMIT 2 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17183 ORDER BY `minOrder` ASC [ RunTime:0.004196s ]
select * from pdf where partno='HC32F460JETA-LQFP48' and brandshort='XHSC' limit 1 [ RunTime:0.006656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC32F460JETA-LQFP48' OR `brand` LIKE 'XHSC%' ) ) LIMIT 1 [ RunTime:0.022576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17178 LIMIT 5 [ RunTime:0.004302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17178 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17178 ORDER BY `unit` DESC [ RunTime:0.005511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17178 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17178 ORDER BY `minOrder` ASC [ RunTime:0.001566s ]
select * from pdf where partno='HC32L130F8UA-QFN32TR'limit 1 [ RunTime:0.003019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HC32L130F8UA-QFN32TR' OR `brand` LIKE '华大%' ) ) LIMIT 1 [ RunTime:0.003964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17173 LIMIT 5 [ RunTime:0.003703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17173 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17173 ORDER BY `unit` DESC [ RunTime:0.006254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17173 LIMIT 2 [ RunTime:0.005453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17173 ORDER BY `minOrder` ASC [ RunTime:0.056541s ]
select * from pdf where partno='5CEFA2F23C7N' and brandshort='Altera' limit 1 [ RunTime:0.034881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5CEFA2F23C7N' OR `brand` LIKE 'Altera%' ) ) LIMIT 1 [ RunTime:0.009082s ]
SELECT `id` FROM `stock` WHERE `id` <> 17173 AND `partno` = '5CEFA2F23C7N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altera%' ) [ RunTime:0.013743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16126243 [ RunTime:0.046077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17247 LIMIT 5 [ RunTime:0.008956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17247 ORDER BY `minOrder` ASC [ RunTime:0.018819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17247 ORDER BY `unit` DESC [ RunTime:0.030999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17247 LIMIT 2 [ RunTime:0.013995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17247 ORDER BY `minOrder` ASC [ RunTime:0.021241s ]
select * from pdf where partno='LAN9252V/ML' and brandshort='MICROCHIP' limit 1 [ RunTime:0.020410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LAN9252V/ML' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.039563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17243 LIMIT 5 [ RunTime:0.035883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17243 ORDER BY `minOrder` ASC [ RunTime:0.023106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17243 ORDER BY `unit` DESC [ RunTime:0.005468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17243 LIMIT 2 [ RunTime:0.029215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17243 ORDER BY `minOrder` ASC [ RunTime:0.032404s ]
select * from pdf where partno='TSM103WAIDT' and brandshort='STM' limit 1 [ RunTime:0.017810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM103WAIDT' OR `brand` LIKE 'STM%' ) ) LIMIT 1 [ RunTime:0.022616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17224 LIMIT 5 [ RunTime:0.019875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17224 ORDER BY `minOrder` ASC [ RunTime:0.022532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17224 ORDER BY `unit` DESC [ RunTime:0.048039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17224 LIMIT 2 [ RunTime:0.013955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17224 ORDER BY `minOrder` ASC [ RunTime:0.012336s ]
select * from pdf where partno='GM7122' and brandshort='BROADCHIP' limit 1 [ RunTime:0.060283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GM7122' OR `brand` LIKE 'BROADCHIP%' ) ) LIMIT 1 [ RunTime:0.021804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17223 LIMIT 5 [ RunTime:0.015431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17223 ORDER BY `minOrder` ASC [ RunTime:0.017802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17223 ORDER BY `unit` DESC [ RunTime:0.053932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17223 LIMIT 2 [ RunTime:0.031749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17223 ORDER BY `minOrder` ASC [ RunTime:0.015329s ]
select * from pdf where partno='NCS8801S' and brandshort='NewCoSemi' limit 1 [ RunTime:0.022919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NCS8801S' OR `brand` LIKE 'NewCoSemi%' ) ) LIMIT 1 [ RunTime:0.022035s ]
SELECT `id` FROM `stock` WHERE `id` <> 17223 AND `partno` = 'NCS8801S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newcosemi%' ) [ RunTime:0.014049s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 40,20 [ RunTime:0.035723s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) ) tmp GROUP BY `brand` [ RunTime:0.023765s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '3' ) AND `categoryid` > 0 [ RunTime:0.013933s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (181,132,104) [ RunTime:0.071189s ]