SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002497s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002252s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001508s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '18.97.14.88' ) [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000942s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000206s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 22 [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001139s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` IN ('132','133','134','135','136','137','138','139','140','141') ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007328s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7127 LIMIT 5 [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7127 ORDER BY `minOrder` ASC [ RunTime:0.008506s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7127 ORDER BY `unit` DESC [ RunTime:0.002021s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7127 LIMIT 2 [ RunTime:0.001492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7127 ORDER BY `minOrder` ASC [ RunTime:0.000188s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.000869s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS138NH6327XTSA2' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.016298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780 ORDER BY `minOrder` ASC [ RunTime:0.008082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14780 ORDER BY `unit` DESC [ RunTime:0.002336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14780 LIMIT 2 [ RunTime:0.012411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14780 ORDER BY `minOrder` ASC [ RunTime:0.004670s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDV303N' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.013600s ]
SELECT `id` FROM `stock` WHERE `id` <> 14780 AND `partno` = 'FDV303N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6554 [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44043958 [ RunTime:0.000441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7565 LIMIT 5 [ RunTime:0.001352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7565 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7565 ORDER BY `unit` DESC [ RunTime:0.001088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7565 LIMIT 2 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7565 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='IRF7103TRPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.001527s ]
select foldpath,foldpath2,filename from pdf_file where id=1111645 limit 1 [ RunTime:0.002092s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF7103TRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.007915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17204 LIMIT 5 [ RunTime:0.000710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17204 ORDER BY `minOrder` ASC [ RunTime:0.000940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17204 ORDER BY `unit` DESC [ RunTime:0.000614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17204 LIMIT 2 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17204 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='CRSS042N10N' and brandshort='CRMICRO' limit 1 [ RunTime:0.004948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRSS042N10N' OR `brand` LIKE 'CRMICRO%' ) ) LIMIT 1 [ RunTime:0.001557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5058 LIMIT 5 [ RunTime:0.000374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5058 ORDER BY `minOrder` ASC [ RunTime:0.006083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5058 ORDER BY `unit` DESC [ RunTime:0.001185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5058 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5058 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
select * from pdf where partno='BSS138BK,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS138BK,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.006547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2475 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2475 ORDER BY `minOrder` ASC [ RunTime:0.000783s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2475 ORDER BY `unit` DESC [ RunTime:0.011483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2475 LIMIT 2 [ RunTime:0.006041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2475 ORDER BY `minOrder` ASC [ RunTime:0.002839s ]
select * from pdf where partno='2N7002,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.013324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N7002,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.013929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4467 LIMIT 5 [ RunTime:0.001321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4467 ORDER BY `minOrder` ASC [ RunTime:0.010268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4467 ORDER BY `unit` DESC [ RunTime:0.003503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4467 LIMIT 2 [ RunTime:0.003158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4467 ORDER BY `minOrder` ASC [ RunTime:0.000579s ]
select * from pdf where partno='NDS331N' and brandshort='ONSEMI' limit 1 [ RunTime:0.004736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NDS331N' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.018027s ]
SELECT `id` FROM `stock` WHERE `id` <> 4467 AND `partno` = 'NDS331N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.021355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044153 [ RunTime:0.004017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8283 LIMIT 5 [ RunTime:0.001311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8283 ORDER BY `minOrder` ASC [ RunTime:0.002307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8283 ORDER BY `unit` DESC [ RunTime:0.000797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8283 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8283 ORDER BY `minOrder` ASC [ RunTime:0.002521s ]
select * from pdf where partno='DMG2305UX-7' and brandshort='DIODES INC.' limit 1 [ RunTime:0.001630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DMG2305UX-7' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.007852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5013 LIMIT 5 [ RunTime:0.001654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5013 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5013 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5013 LIMIT 2 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5013 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='BSS138PS,115' and brandshort='NEXPERIA' limit 1 [ RunTime:0.001024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS138PS,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17215 LIMIT 5 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17215 ORDER BY `minOrder` ASC [ RunTime:0.000633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17215 ORDER BY `unit` DESC [ RunTime:0.009739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17215 LIMIT 2 [ RunTime:0.004363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17215 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
select * from pdf where partno='SI2371EDS-T1-GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.004061s ]
select foldpath,foldpath2,filename from pdf_file where id=1462111 limit 1 [ RunTime:0.005967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SI2371EDS-T1-GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.012581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 247 LIMIT 5 [ RunTime:0.002633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 247 ORDER BY `minOrder` ASC [ RunTime:0.001607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 247 ORDER BY `unit` DESC [ RunTime:0.001045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 247 LIMIT 2 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 247 ORDER BY `minOrder` ASC [ RunTime:0.000291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS84PH6327XTSA2' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.013180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2004 LIMIT 5 [ RunTime:0.004128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2004 ORDER BY `minOrder` ASC [ RunTime:0.005088s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2004 ORDER BY `unit` DESC [ RunTime:0.002813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2004 LIMIT 2 [ RunTime:0.000613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2004 ORDER BY `minOrder` ASC [ RunTime:0.000279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NTS4101PT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.007761s ]
SELECT `id` FROM `stock` WHERE `id` <> 2004 AND `partno` = 'NTS4101PT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.005043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44045837 [ RunTime:0.002408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6553 LIMIT 5 [ RunTime:0.008781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6553 ORDER BY `minOrder` ASC [ RunTime:0.009287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6553 ORDER BY `unit` DESC [ RunTime:0.002893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6553 LIMIT 2 [ RunTime:0.004465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6553 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='2N7002P,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.011758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N7002P,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4106 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4106 ORDER BY `minOrder` ASC [ RunTime:0.005854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4106 ORDER BY `unit` DESC [ RunTime:0.004978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4106 LIMIT 2 [ RunTime:0.002374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4106 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='IRLML0060TRPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.006901s ]
select foldpath,foldpath2,filename from pdf_file where id=817312 limit 1 [ RunTime:0.000646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRLML0060TRPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.012654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4466 LIMIT 5 [ RunTime:0.006274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4466 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4466 ORDER BY `unit` DESC [ RunTime:0.000549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4466 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4466 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
select * from pdf where partno='SI2308BDS-T1-GE3' and brandshort='VISHAY' limit 1 [ RunTime:0.003122s ]
select foldpath,foldpath2,filename from pdf_file where id=1058600 limit 1 [ RunTime:0.001497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SI2308BDS-T1-GE3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.013967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4665 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4665 ORDER BY `minOrder` ASC [ RunTime:0.003181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4665 ORDER BY `unit` DESC [ RunTime:0.003308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4665 LIMIT 2 [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4665 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='BSS138P,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.001242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS138P,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.006930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8280 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8280 ORDER BY `minOrder` ASC [ RunTime:0.000695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8280 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8280 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8280 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='DMG1012T-7' and brandshort='DIODES INC.' limit 1 [ RunTime:0.003559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DMG1012T-7' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.003860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14785 LIMIT 5 [ RunTime:0.001385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14785 ORDER BY `minOrder` ASC [ RunTime:0.000747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14785 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14785 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14785 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDN337N' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.016478s ]
SELECT `id` FROM `stock` WHERE `id` <> 14785 AND `partno` = 'FDN337N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.003019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044203 [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14791 LIMIT 5 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14791 ORDER BY `minOrder` ASC [ RunTime:0.001799s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14791 ORDER BY `unit` DESC [ RunTime:0.000752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14791 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14791 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='FDN340P' and brandshort='ONSEMI' limit 1 [ RunTime:0.002564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDN340P' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.015631s ]
SELECT `id` FROM `stock` WHERE `id` <> 14791 AND `partno` = 'FDN340P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44044098 [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8282 LIMIT 5 [ RunTime:0.000720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8282 ORDER BY `minOrder` ASC [ RunTime:0.041350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8282 ORDER BY `unit` DESC [ RunTime:0.002369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8282 LIMIT 2 [ RunTime:0.003200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8282 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
select * from pdf where partno='DMG2305UX-13' and brandshort='DIODES INC.' limit 1 [ RunTime:0.003192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DMG2305UX-13' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.004425s ]
SELECT `id` FROM `stock` WHERE `id` <> 8282 AND `partno` = 'DMG2305UX-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes inc.%' ) [ RunTime:0.011187s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` IN ('132','133','134','135','136','137','138','139','140','141') ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006651s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` IN ('132','133','134','135','136','137','138','139','140','141') ) LIMIT 538 ) tmp GROUP BY `brand` [ RunTime:0.014569s ]