SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003897s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/category_31/1.html' [ RunTime:0.010467s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002894s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.016113s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001523s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.021161s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001008s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.024642s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 31 [ RunTime:0.026934s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002229s ]
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 ('306','307','308','309','310','311','312','313','314','315','316','317') ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090216s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3571 LIMIT 5 [ RunTime:0.073543s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3571 ORDER BY `minOrder` ASC [ RunTime:0.055732s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.098030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3571 ORDER BY `unit` DESC [ RunTime:0.166521s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.025664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3571 LIMIT 2 [ RunTime:0.084796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3571 ORDER BY `minOrder` ASC [ RunTime:0.044568s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSR16..' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.204983s ]
SELECT `id` FROM `stock` WHERE `id` <> 3571 AND `partno` = 'BSR16..' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.135909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3878 LIMIT 5 [ RunTime:0.023115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3878 ORDER BY `minOrder` ASC [ RunTime:0.123536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3878 ORDER BY `unit` DESC [ RunTime:0.145411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3878 LIMIT 2 [ RunTime:0.081215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3878 ORDER BY `minOrder` ASC [ RunTime:0.007431s ]
select * from pdf where partno='PMEG4010CEJ,115' and brandshort='NEXPERIA' limit 1 [ RunTime:0.169127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG4010CEJ,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.054525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6554 LIMIT 5 [ RunTime:0.092706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6554 ORDER BY `minOrder` ASC [ RunTime:0.023749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6554 ORDER BY `unit` DESC [ RunTime:0.105872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6554 LIMIT 2 [ RunTime:0.051952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6554 ORDER BY `minOrder` ASC [ RunTime:0.009750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDV303N' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.063043s ]
SELECT `id` FROM `stock` WHERE `id` <> 6554 AND `partno` = 'FDV303N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.043597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14780 [ RunTime:0.056320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44043958 [ RunTime:0.030429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1946 LIMIT 5 [ RunTime:0.015531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1946 ORDER BY `minOrder` ASC [ RunTime:0.057668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1946 ORDER BY `unit` DESC [ RunTime:0.074230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1946 LIMIT 2 [ RunTime:0.022578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1946 ORDER BY `minOrder` ASC [ RunTime:0.043573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BSS84LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.058250s ]
SELECT `id` FROM `stock` WHERE `id` <> 1946 AND `partno` = 'BSS84LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.089805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44043956 [ RunTime:0.075639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13869 LIMIT 5 [ RunTime:0.052473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13869 ORDER BY `minOrder` ASC [ RunTime:0.048901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13869 ORDER BY `unit` DESC [ RunTime:0.029939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13869 LIMIT 2 [ RunTime:0.090558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13869 ORDER BY `minOrder` ASC [ RunTime:0.048072s ]
select * from pdf where partno='IRF540NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.038707s ]
select foldpath,foldpath2,filename from pdf_file where id=99672 limit 1 [ RunTime:0.019984s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF540NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.088653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9185 LIMIT 5 [ RunTime:0.114675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9185 ORDER BY `minOrder` ASC [ RunTime:0.057899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9185 ORDER BY `unit` DESC [ RunTime:0.086319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9185 LIMIT 2 [ RunTime:0.066842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9185 ORDER BY `minOrder` ASC [ RunTime:0.035990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BGU8009,115' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.023191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3225 LIMIT 5 [ RunTime:0.041913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3225 ORDER BY `minOrder` ASC [ RunTime:0.052363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3225 ORDER BY `unit` DESC [ RunTime:0.037626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3225 LIMIT 2 [ RunTime:0.105528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3225 ORDER BY `minOrder` ASC [ RunTime:0.017011s ]
select * from pdf where partno='BC846BLT1G.' and brandshort='ONSEMI' limit 1 [ RunTime:0.069138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC846BLT1G.' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.075554s ]
SELECT `id` FROM `stock` WHERE `id` <> 3225 AND `partno` = 'BC846BLT1G.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.096676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 253 LIMIT 5 [ RunTime:0.052193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 253 ORDER BY `minOrder` ASC [ RunTime:0.119655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 253 ORDER BY `unit` DESC [ RunTime:0.079669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 253 LIMIT 2 [ RunTime:0.038162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 253 ORDER BY `minOrder` ASC [ RunTime:0.002219s ]
select * from pdf where partno='BTA26-600BRG' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.046649s ]
select foldpath,foldpath2,filename from pdf_file where id=668671 limit 1 [ RunTime:0.002618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BTA26-600BRG' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.097664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13870 LIMIT 5 [ RunTime:0.054855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13870 ORDER BY `minOrder` ASC [ RunTime:0.079219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13870 ORDER BY `unit` DESC [ RunTime:0.021186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13870 LIMIT 2 [ RunTime:0.036700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13870 ORDER BY `minOrder` ASC [ RunTime:0.052145s ]
select * from pdf where partno='IRF640NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.074789s ]
select foldpath,foldpath2,filename from pdf_file where id=601823 limit 1 [ RunTime:0.072701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF640NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.074529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5223 LIMIT 5 [ RunTime:0.031651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5223 ORDER BY `minOrder` ASC [ RunTime:0.009240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5223 ORDER BY `unit` DESC [ RunTime:0.029804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5223 LIMIT 2 [ RunTime:0.018810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5223 ORDER BY `minOrder` ASC [ RunTime:0.005382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC202472M090B20C7B' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005152s ]
SELECT `id` FROM `stock` WHERE `id` <> 5223 AND `partno` = 'MC202472M090B20C7B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.016654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15799 [ RunTime:0.015683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16818 [ RunTime:0.005359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13876 LIMIT 5 [ RunTime:0.016924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13876 ORDER BY `minOrder` ASC [ RunTime:0.014183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13876 ORDER BY `unit` DESC [ RunTime:0.023236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13876 LIMIT 2 [ RunTime:0.009459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13876 ORDER BY `minOrder` ASC [ RunTime:0.009588s ]
select * from pdf where partno='IRFU9120PBF' and brandshort='VISHAY' limit 1 [ RunTime:0.010005s ]
select foldpath,foldpath2,filename from pdf_file where id=874151 limit 1 [ RunTime:0.017735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRFU9120PBF' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.051492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3568 LIMIT 5 [ RunTime:0.012135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3568 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3568 ORDER BY `unit` DESC [ RunTime:0.014299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3568 LIMIT 2 [ RunTime:0.008500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3568 ORDER BY `minOrder` ASC [ RunTime:0.033338s ]
select * from pdf where partno='GF1J' and brandshort='ONSEMI' limit 1 [ RunTime:0.033579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GF1J' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.017115s ]
SELECT `id` FROM `stock` WHERE `id` <> 3568 AND `partno` = 'GF1J' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.009510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079529 [ RunTime:0.014557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3678 LIMIT 5 [ RunTime:0.022995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3678 ORDER BY `minOrder` ASC [ RunTime:0.012181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3678 ORDER BY `unit` DESC [ RunTime:0.034284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3678 LIMIT 2 [ RunTime:0.021020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3678 ORDER BY `minOrder` ASC [ RunTime:0.010045s ]
select * from pdf where partno='2N7002-7-F' and brandshort='DIODES INC.' limit 1 [ RunTime:0.022759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N7002-7-F' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.006115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 576 LIMIT 5 [ RunTime:0.025275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 576 ORDER BY `minOrder` ASC [ RunTime:0.005378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 576 ORDER BY `unit` DESC [ RunTime:0.022785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 576 LIMIT 2 [ RunTime:0.022207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 576 ORDER BY `minOrder` ASC [ RunTime:0.009149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19050351' OR `brand` LIKE 'CML INNOVATIVE TECHNOLOGIES%' ) ) LIMIT 1 [ RunTime:0.025505s ]
SELECT `id` FROM `stock` WHERE `id` <> 576 AND `partno` = '19050351' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cml innovative technologies%' ) [ RunTime:0.008293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3880 LIMIT 5 [ RunTime:0.001494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3880 ORDER BY `minOrder` ASC [ RunTime:0.009064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3880 ORDER BY `unit` DESC [ RunTime:0.002215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3880 LIMIT 2 [ RunTime:0.017648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3880 ORDER BY `minOrder` ASC [ RunTime:0.011264s ]
select * from pdf where partno='BZX585-B5V1,115' and brandshort='NEXPERIA' limit 1 [ RunTime:0.007886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZX585-B5V1,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.042175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3877 LIMIT 5 [ RunTime:0.021229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3877 ORDER BY `minOrder` ASC [ RunTime:0.031834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3877 ORDER BY `unit` DESC [ RunTime:0.028243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3877 LIMIT 2 [ RunTime:0.023634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3877 ORDER BY `minOrder` ASC [ RunTime:0.007414s ]
select * from pdf where partno='PMEG3020EJ,115' and brandshort='NEXPERIA' limit 1 [ RunTime:0.025240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PMEG3020EJ,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.033518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7003 LIMIT 5 [ RunTime:0.022516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7003 ORDER BY `minOrder` ASC [ RunTime:0.006866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7003 ORDER BY `unit` DESC [ RunTime:0.018420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7003 LIMIT 2 [ RunTime:0.051864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7003 ORDER BY `minOrder` ASC [ RunTime:0.024562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'F950J107MAAAQ2' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.017334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3553 LIMIT 5 [ RunTime:0.022687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3553 ORDER BY `minOrder` ASC [ RunTime:0.016380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3553 ORDER BY `unit` DESC [ RunTime:0.007425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3553 LIMIT 2 [ RunTime:0.007122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3553 ORDER BY `minOrder` ASC [ RunTime:0.025942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ15CA-E3/52' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.022532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2235 LIMIT 5 [ RunTime:0.008347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2235 ORDER BY `minOrder` ASC [ RunTime:0.005129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2235 ORDER BY `unit` DESC [ RunTime:0.004219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2235 LIMIT 2 [ RunTime:0.028562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2235 ORDER BY `minOrder` ASC [ RunTime:0.011554s ]
select * from pdf where partno='1N457' and brandshort='ONSEMI' limit 1 [ RunTime:0.006787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N457' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.017438s ]
SELECT `id` FROM `stock` WHERE `id` <> 2235 AND `partno` = '1N457' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.008884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080368 [ RunTime:0.011271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3881 LIMIT 5 [ RunTime:0.006588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3881 ORDER BY `minOrder` ASC [ RunTime:0.024740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3881 ORDER BY `unit` DESC [ RunTime:0.024284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3881 LIMIT 2 [ RunTime:0.006862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3881 ORDER BY `minOrder` ASC [ RunTime:0.016567s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PDZ3.3B,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.021022s ]
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 ('306','307','308','309','310','311','312','313','314','315','316','317') ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025622s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` IN ('306','307','308','309','310','311','312','313','314','315','316','317') ) LIMIT 129 ) tmp GROUP BY `brand` [ RunTime:0.002327s ]