SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002881s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&page=4&srecordnum=1120&status=4' [ RunTime:0.021374s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002660s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.059855s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002344s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.083149s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001493s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.084986s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002554s ]
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` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.020587s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.041903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16193 LIMIT 4 [ RunTime:0.027145s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.041083s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.021101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16193 ORDER BY `unit` DESC [ RunTime:0.025735s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16193 LIMIT 2 [ RunTime:0.042160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16193 ORDER BY `minOrder` ASC [ RunTime:0.063142s ]
select * from pdf where partno='926902-3' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.049791s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '926902-3' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.035423s ]
SELECT `id` FROM `stock` WHERE `id` <> 16193 AND `partno` = '926902-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.032723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11632 [ RunTime:0.038018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192 LIMIT 4 [ RunTime:0.018941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.043461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192 ORDER BY `unit` DESC [ RunTime:0.066151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192 LIMIT 2 [ RunTime:0.040971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192 ORDER BY `minOrder` ASC [ RunTime:0.020636s ]
select * from pdf where partno='LDEIF3470KA0N00' and brandshort='KEMET' limit 1 [ RunTime:0.035491s ]
select foldpath,foldpath2,filename from pdf_file where id=1495047 limit 1 [ RunTime:0.030113s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LDEIF3470KA0N00' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.049036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16191 LIMIT 4 [ RunTime:0.041717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.058343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16191 ORDER BY `unit` DESC [ RunTime:0.055296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16191 LIMIT 2 [ RunTime:0.061330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16191 ORDER BY `minOrder` ASC [ RunTime:0.016597s ]
select * from pdf where partno='783631-01' and brandshort='NI' limit 1 [ RunTime:0.027381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '783631-01' OR `brand` LIKE 'NI%' ) ) LIMIT 1 [ RunTime:0.114438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16190 LIMIT 4 [ RunTime:0.119487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.093625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16190 ORDER BY `unit` DESC [ RunTime:0.079585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16190 LIMIT 2 [ RunTime:0.082374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16190 ORDER BY `minOrder` ASC [ RunTime:0.022188s ]
select * from pdf where partno='RK73B1JTTD200J.' and brandshort='KOA' limit 1 [ RunTime:0.102805s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73B1JTTD200J.' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.082596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16189 LIMIT 4 [ RunTime:0.031957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.069910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16189 ORDER BY `unit` DESC [ RunTime:0.143095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16189 LIMIT 2 [ RunTime:0.047720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16189 ORDER BY `minOrder` ASC [ RunTime:0.032068s ]
select * from pdf where partno='591-2601-013F.' and brandshort='DIALIGHT' limit 1 [ RunTime:0.086310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '591-2601-013F.' OR `brand` LIKE 'DIALIGHT%' ) ) LIMIT 1 [ RunTime:0.081096s ]
SELECT `id` FROM `stock` WHERE `id` <> 16189 AND `partno` = '591-2601-013F.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.110336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4786 [ RunTime:0.046036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16188 LIMIT 4 [ RunTime:0.063919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.064499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16188 ORDER BY `unit` DESC [ RunTime:0.094748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16188 LIMIT 2 [ RunTime:0.040885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16188 ORDER BY `minOrder` ASC [ RunTime:0.011480s ]
select * from pdf where partno='RC0603FR-0727RL' and brandshort='YAGEO' limit 1 [ RunTime:0.092852s ]
select foldpath,foldpath2,filename from pdf_file where id=1976034 limit 1 [ RunTime:0.082245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RC0603FR-0727RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.065343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187 LIMIT 4 [ RunTime:0.076878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.038928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187 ORDER BY `unit` DESC [ RunTime:0.055283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187 LIMIT 2 [ RunTime:0.016968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187 ORDER BY `minOrder` ASC [ RunTime:0.017974s ]
select * from pdf where partno='ZE05H-2P-2H' and brandshort='HIROSEHRS' limit 1 [ RunTime:0.017091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZE05H-2P-2H' OR `brand` LIKE 'HIROSE(HRS)%' ) ) LIMIT 1 [ RunTime:0.062664s ]
SELECT `id` FROM `stock` WHERE `id` <> 16187 AND `partno` = 'ZE05H-2P-2H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hirose%' ) [ RunTime:0.060443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19828545 [ RunTime:0.181183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186 LIMIT 4 [ RunTime:0.075054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.036338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186 ORDER BY `unit` DESC [ RunTime:0.094870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186 LIMIT 2 [ RunTime:0.025402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186 ORDER BY `minOrder` ASC [ RunTime:0.018741s ]
select * from pdf where partno='UPW1E471MPD' and brandshort='NICHICON' limit 1 [ RunTime:0.022888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UPW1E471MPD' OR `brand` LIKE 'NICHICON%' ) ) LIMIT 1 [ RunTime:0.052139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185 LIMIT 4 [ RunTime:0.032212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.085093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185 ORDER BY `unit` DESC [ RunTime:0.119964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185 LIMIT 2 [ RunTime:0.041125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185 ORDER BY `minOrder` ASC [ RunTime:0.065621s ]
select * from pdf where partno='VTX-146-080-212' and brandshort='VIGORTRONIX' limit 1 [ RunTime:0.064325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VTX-146-080-212' OR `brand` LIKE 'VIGORTRONIX%' ) ) LIMIT 1 [ RunTime:0.034348s ]
SELECT `id` FROM `stock` WHERE `id` <> 16185 AND `partno` = 'VTX-146-080-212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vigortronix%' ) [ RunTime:0.041194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9479 [ RunTime:0.055346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11378015 [ RunTime:0.054640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16184 LIMIT 4 [ RunTime:0.091162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.106477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16184 ORDER BY `unit` DESC [ RunTime:0.080098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16184 LIMIT 2 [ RunTime:0.081958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16184 ORDER BY `minOrder` ASC [ RunTime:0.019365s ]
select * from pdf where partno='V23333Z0001B046' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.022620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V23333Z0001B046' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.053062s ]
SELECT `id` FROM `stock` WHERE `id` <> 16184 AND `partno` = 'V23333Z0001B046' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.066874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10708 [ RunTime:0.012584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16183 LIMIT 4 [ RunTime:0.105268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.059175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16183 ORDER BY `unit` DESC [ RunTime:0.088860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16183 LIMIT 2 [ RunTime:0.125610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16183 ORDER BY `minOrder` ASC [ RunTime:0.022910s ]
select * from pdf where partno='0402CS-18NXGLU' and brandshort='COILCRAFT' limit 1 [ RunTime:0.064878s ]
select foldpath,foldpath2,filename from pdf_file where id=1133160 limit 1 [ RunTime:0.025505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0402CS-18NXGLU' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.039949s ]
SELECT `id` FROM `stock` WHERE `id` <> 16183 AND `partno` = '0402CS-18NXGLU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.059925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5914 [ RunTime:0.029069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182 LIMIT 4 [ RunTime:0.010524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.024452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182 ORDER BY `unit` DESC [ RunTime:0.003672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182 LIMIT 2 [ RunTime:0.007072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182 ORDER BY `minOrder` ASC [ RunTime:0.007776s ]
select * from pdf where partno='103000A01F1202' and brandshort='MOLEX' limit 1 [ RunTime:0.029851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '103000A01F1202' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.022944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16181 LIMIT 4 [ RunTime:0.019695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.021377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16181 ORDER BY `unit` DESC [ RunTime:0.019234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16181 LIMIT 2 [ RunTime:0.070997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16181 ORDER BY `minOrder` ASC [ RunTime:0.012788s ]
select * from pdf where partno='1N5817-T' and brandshort='DIODES INC.' limit 1 [ RunTime:0.036755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N5817-T' OR `brand` LIKE 'DIODES INC.%' ) ) LIMIT 1 [ RunTime:0.018247s ]
SELECT `id` FROM `stock` WHERE `id` <> 16181 AND `partno` = '1N5817-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes inc.%' ) [ RunTime:0.040342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10792 [ RunTime:0.079314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16180 LIMIT 4 [ RunTime:0.064530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.037561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16180 ORDER BY `unit` DESC [ RunTime:0.061534s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16180 LIMIT 2 [ RunTime:0.053523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16180 ORDER BY `minOrder` ASC [ RunTime:0.021725s ]
select * from pdf where partno='CTB9300/2A' and brandshort='CAMDENBOSS' limit 1 [ RunTime:0.028554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CTB9300/2A' OR `brand` LIKE 'CAMDENBOSS%' ) ) LIMIT 1 [ RunTime:0.050450s ]
SELECT `id` FROM `stock` WHERE `id` <> 16180 AND `partno` = 'CTB9300/2A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%camdenboss%' ) [ RunTime:0.190899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12957 [ RunTime:0.046406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16179 LIMIT 4 [ RunTime:0.051128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.099798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16179 ORDER BY `unit` DESC [ RunTime:0.026803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16179 LIMIT 2 [ RunTime:0.036776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16179 ORDER BY `minOrder` ASC [ RunTime:0.008092s ]
select * from pdf where partno='C0603C475K9PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.034110s ]
select foldpath,foldpath2,filename from pdf_file where id=530939 limit 1 [ RunTime:0.033224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0603C475K9PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.042161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16178 LIMIT 4 [ RunTime:0.010570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.098290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16178 ORDER BY `unit` DESC [ RunTime:0.061917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16178 LIMIT 2 [ RunTime:0.021490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16178 ORDER BY `minOrder` ASC [ RunTime:0.014558s ]
select * from pdf where partno='VLR-02V' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.074888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'VLR-02V' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.077284s ]
SELECT `id` FROM `stock` WHERE `id` <> 16178 AND `partno` = 'VLR-02V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jst%' ) [ RunTime:0.064362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13739 [ RunTime:0.063686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486726 [ RunTime:0.025085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16177 LIMIT 4 [ RunTime:0.068857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.072672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16177 ORDER BY `unit` DESC [ RunTime:0.038918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16177 LIMIT 2 [ RunTime:0.053156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16177 ORDER BY `minOrder` ASC [ RunTime:0.004076s ]
select * from pdf where partno='B32641B0183J000' and brandshort='EPCOS' limit 1 [ RunTime:0.026510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B32641B0183J000' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.036353s ]
SELECT `id` FROM `stock` WHERE `id` <> 16177 AND `partno` = 'B32641B0183J000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%epcos%' ) [ RunTime:0.044823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12015 [ RunTime:0.030774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16176 LIMIT 4 [ RunTime:0.013300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.020619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16176 ORDER BY `unit` DESC [ RunTime:0.009411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16176 LIMIT 2 [ RunTime:0.054546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16176 ORDER BY `minOrder` ASC [ RunTime:0.005395s ]
select * from pdf where partno='RK73H1ETTP40R2F' and brandshort='KOA' limit 1 [ RunTime:0.015405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73H1ETTP40R2F' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.016705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16175 LIMIT 4 [ RunTime:0.001628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.030520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16175 ORDER BY `unit` DESC [ RunTime:0.028462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16175 LIMIT 2 [ RunTime:0.009371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16175 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
select * from pdf where partno='MCF 0.25W 100K' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.016790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCF 0.25W 100K' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.014985s ]
SELECT `id` FROM `stock` WHERE `id` <> 16175 AND `partno` = 'MCF 0.25W 100K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.011946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14219 [ RunTime:0.008348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16174 LIMIT 4 [ RunTime:0.003679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16174 ORDER BY `minOrder` ASC [ RunTime:0.005909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16174 ORDER BY `unit` DESC [ RunTime:0.005928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16174 LIMIT 2 [ RunTime:0.017276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16174 ORDER BY `minOrder` ASC [ RunTime:0.006996s ]
select * from pdf where partno='T821114A1S100CEU' and brandshort='AMPHENOL COMMUNICATIONS SOLUTIONS' limit 1 [ RunTime:0.021998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'T821114A1S100CEU' OR `brand` LIKE 'AMPHENOL COMMUNICATIONS SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.020849s ]
SELECT `id` FROM `stock` WHERE `id` <> 16174 AND `partno` = 'T821114A1S100CEU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol communications solutions%' ) [ RunTime:0.016540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5771 [ RunTime:0.028462s ]
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` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.045599s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.009486s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.009958s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (21,17,252,16,29,132,127,117,40,481,541,282,671,615,23,577,20,86,377,313,156,148,204,636,39,643,410,113,186,544,369,516,277,134,601,347,105,482,623,133,121,106,432,512,592,326,35,279,152,309,403,517,376,676,296,287,420,490,621,293) [ RunTime:0.003487s ]