SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001262s ]
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=56&srecordnum=1120&status=4' [ RunTime:0.006684s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002385s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009950s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002370s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.008582s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003198s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013531s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001568s ]
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 1100,20 [ RunTime:0.045136s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15153 LIMIT 4 [ RunTime:0.005419s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15153 ORDER BY `minOrder` ASC [ RunTime:0.014845s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15153 ORDER BY `unit` DESC [ RunTime:0.006249s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15153 LIMIT 2 [ RunTime:0.009166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15153 ORDER BY `minOrder` ASC [ RunTime:0.009602s ]
select * from pdf where partno='B82793S0513N201' and brandshort='EPCOS' limit 1 [ RunTime:0.020042s ]
select foldpath,foldpath2,filename from pdf_file where id=566440 limit 1 [ RunTime:0.012997s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B82793S0513N201' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.017979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15152 LIMIT 4 [ RunTime:0.008378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15152 ORDER BY `minOrder` ASC [ RunTime:0.032930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15152 ORDER BY `unit` DESC [ RunTime:0.012296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15152 LIMIT 2 [ RunTime:0.013710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15152 ORDER BY `minOrder` ASC [ RunTime:0.014808s ]
select * from pdf where partno='3386F-1-103TLF' and brandshort='BOURNS' limit 1 [ RunTime:0.009042s ]
select foldpath,foldpath2,filename from pdf_file where id=1851072 limit 1 [ RunTime:0.024648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3386F-1-103TLF' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.023289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15151 LIMIT 4 [ RunTime:0.014503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15151 ORDER BY `minOrder` ASC [ RunTime:0.023666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15151 ORDER BY `unit` DESC [ RunTime:0.019861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15151 LIMIT 2 [ RunTime:0.001565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15151 ORDER BY `minOrder` ASC [ RunTime:0.005159s ]
select * from pdf where partno='172330-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.001836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '172330-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003783s ]
SELECT `id` FROM `stock` WHERE `id` <> 15151 AND `partno` = '172330-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.005167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1643 [ RunTime:0.036596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15046 [ RunTime:0.033310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15150 LIMIT 4 [ RunTime:0.015689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15150 ORDER BY `minOrder` ASC [ RunTime:0.046920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15150 ORDER BY `unit` DESC [ RunTime:0.029338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15150 LIMIT 2 [ RunTime:0.039698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15150 ORDER BY `minOrder` ASC [ RunTime:0.030325s ]
select * from pdf where partno='967056-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.031093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '967056-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.004095s ]
SELECT `id` FROM `stock` WHERE `id` <> 15150 AND `partno` = '967056-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.004404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3281 [ RunTime:0.016897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15045 [ RunTime:0.002121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15149 LIMIT 4 [ RunTime:0.007679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15149 ORDER BY `minOrder` ASC [ RunTime:0.001493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15149 ORDER BY `unit` DESC [ RunTime:0.007750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15149 LIMIT 2 [ RunTime:0.002738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15149 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='PCF0805-13-1K-B-T1.' and brandshort='TT ELECTRONICS / WELWYN' limit 1 [ RunTime:0.019997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCF0805-13-1K-B-T1.' OR `brand` LIKE 'TT ELECTRONICS / WELWYN%' ) ) LIMIT 1 [ RunTime:0.008496s ]
SELECT `id` FROM `stock` WHERE `id` <> 15149 AND `partno` = 'PCF0805-13-1K-B-T1.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics / welwyn%' ) [ RunTime:0.019207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 607 [ RunTime:0.004704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15044 [ RunTime:0.006482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15148 LIMIT 4 [ RunTime:0.002960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15148 ORDER BY `minOrder` ASC [ RunTime:0.008207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15148 ORDER BY `unit` DESC [ RunTime:0.002786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15148 LIMIT 2 [ RunTime:0.005805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15148 ORDER BY `minOrder` ASC [ RunTime:0.001189s ]
select * from pdf where partno='897-10-010-00-300002' and brandshort='MILL MAX' limit 1 [ RunTime:0.012159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '897-10-010-00-300002' OR `brand` LIKE 'MILL MAX%' ) ) LIMIT 1 [ RunTime:0.009173s ]
SELECT `id` FROM `stock` WHERE `id` <> 15148 AND `partno` = '897-10-010-00-300002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill max%' ) [ RunTime:0.007001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8596 [ RunTime:0.007449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15043 [ RunTime:0.006128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15147 LIMIT 4 [ RunTime:0.012504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15147 ORDER BY `minOrder` ASC [ RunTime:0.008781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15147 ORDER BY `unit` DESC [ RunTime:0.012290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15147 LIMIT 2 [ RunTime:0.014321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15147 ORDER BY `minOrder` ASC [ RunTime:0.003707s ]
select * from pdf where partno='SMAJ90A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.015906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ90A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.023580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15146 LIMIT 4 [ RunTime:0.022695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15146 ORDER BY `minOrder` ASC [ RunTime:0.024708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15146 ORDER BY `unit` DESC [ RunTime:0.006548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15146 LIMIT 2 [ RunTime:0.013396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15146 ORDER BY `minOrder` ASC [ RunTime:0.018137s ]
select * from pdf where partno='RP73PF1J243KBTDF' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.016797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RP73PF1J243KBTDF' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.046312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15145 LIMIT 4 [ RunTime:0.030013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15145 ORDER BY `minOrder` ASC [ RunTime:0.010522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15145 ORDER BY `unit` DESC [ RunTime:0.004390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15145 LIMIT 2 [ RunTime:0.008380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15145 ORDER BY `minOrder` ASC [ RunTime:0.004992s ]
select * from pdf where partno='2069250-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.030026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2069250-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.049820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15144 LIMIT 4 [ RunTime:0.057372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15144 ORDER BY `minOrder` ASC [ RunTime:0.015340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15144 ORDER BY `unit` DESC [ RunTime:0.045001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15144 LIMIT 2 [ RunTime:0.034352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15144 ORDER BY `minOrder` ASC [ RunTime:0.022885s ]
select * from pdf where partno='207360-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.019523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '207360-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.046686s ]
SELECT `id` FROM `stock` WHERE `id` <> 15144 AND `partno` = '207360-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.018356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3259 [ RunTime:0.023962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15039 [ RunTime:0.057630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15143 LIMIT 4 [ RunTime:0.021370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15143 ORDER BY `minOrder` ASC [ RunTime:0.032355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15143 ORDER BY `unit` DESC [ RunTime:0.017567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15143 LIMIT 2 [ RunTime:0.017736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15143 ORDER BY `minOrder` ASC [ RunTime:0.008578s ]
select * from pdf where partno='501331-0507' and brandshort='MOLEX' limit 1 [ RunTime:0.010916s ]
select foldpath,foldpath2,filename from pdf_file where id=852950 limit 1 [ RunTime:0.022073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '501331-0507' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.041631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15142 LIMIT 4 [ RunTime:0.007061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15142 ORDER BY `minOrder` ASC [ RunTime:0.014134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15142 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15142 LIMIT 2 [ RunTime:0.006781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15142 ORDER BY `minOrder` ASC [ RunTime:0.008911s ]
select * from pdf where partno='BAS20HT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.004153s ]
select foldpath,foldpath2,filename from pdf_file where id=671906 limit 1 [ RunTime:0.000987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAS20HT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.006316s ]
SELECT `id` FROM `stock` WHERE `id` <> 15142 AND `partno` = 'BAS20HT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7484 [ RunTime:0.015460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15037 [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080084 [ RunTime:0.002341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15141 LIMIT 4 [ RunTime:0.000807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15141 ORDER BY `minOrder` ASC [ RunTime:0.018003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15141 ORDER BY `unit` DESC [ RunTime:0.024298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15141 LIMIT 2 [ RunTime:0.003730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15141 ORDER BY `minOrder` ASC [ RunTime:0.021378s ]
select * from pdf where partno='885012007020' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.024722s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '885012007020' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.021153s ]
SELECT `id` FROM `stock` WHERE `id` <> 15141 AND `partno` = '885012007020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.031825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9455 [ RunTime:0.021916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15036 [ RunTime:0.051348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14040906 [ RunTime:0.026765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15140 LIMIT 4 [ RunTime:0.010156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15140 ORDER BY `minOrder` ASC [ RunTime:0.054997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15140 ORDER BY `unit` DESC [ RunTime:0.015962s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15140 LIMIT 2 [ RunTime:0.074777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15140 ORDER BY `minOrder` ASC [ RunTime:0.039813s ]
select * from pdf where partno='C0805C106M8PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.047262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0805C106M8PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.043184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15139 LIMIT 4 [ RunTime:0.029005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15139 ORDER BY `minOrder` ASC [ RunTime:0.053502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15139 ORDER BY `unit` DESC [ RunTime:0.013952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15139 LIMIT 2 [ RunTime:0.002181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15139 ORDER BY `minOrder` ASC [ RunTime:0.007347s ]
select * from pdf where partno='MCWR06X20R0FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.021772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X20R0FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.025948s ]
SELECT `id` FROM `stock` WHERE `id` <> 15139 AND `partno` = 'MCWR06X20R0FTL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.042776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7243 [ RunTime:0.022364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16256 [ RunTime:0.037177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15138 LIMIT 4 [ RunTime:0.024739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15138 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15138 ORDER BY `unit` DESC [ RunTime:0.014959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15138 LIMIT 2 [ RunTime:0.013078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15138 ORDER BY `minOrder` ASC [ RunTime:0.003259s ]
select * from pdf where partno='SUD50P10-43L-E3' and brandshort='VISHAY' limit 1 [ RunTime:0.007595s ]
select foldpath,foldpath2,filename from pdf_file where id=1110570 limit 1 [ RunTime:0.024005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SUD50P10-43L-E3' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.055081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15137 LIMIT 4 [ RunTime:0.006515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15137 ORDER BY `minOrder` ASC [ RunTime:0.028046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15137 ORDER BY `unit` DESC [ RunTime:0.037589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15137 LIMIT 2 [ RunTime:0.061573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15137 ORDER BY `minOrder` ASC [ RunTime:0.068466s ]
select * from pdf where partno='MC0603B102K500CT' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.094641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC0603B102K500CT' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.083216s ]
SELECT `id` FROM `stock` WHERE `id` <> 15137 AND `partno` = 'MC0603B102K500CT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.027479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3909 [ RunTime:0.037831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16255 [ RunTime:0.009487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15136 LIMIT 4 [ RunTime:0.002445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15136 ORDER BY `minOrder` ASC [ RunTime:0.015670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15136 ORDER BY `unit` DESC [ RunTime:0.042355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15136 LIMIT 2 [ RunTime:0.041019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15136 ORDER BY `minOrder` ASC [ RunTime:0.019226s ]
select * from pdf where partno='207241-1.' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.020849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '207241-1.' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.005425s ]
SELECT `id` FROM `stock` WHERE `id` <> 15136 AND `partno` = '207241-1.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.029950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3930 [ RunTime:0.040283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15033 [ RunTime:0.032423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15135 LIMIT 4 [ RunTime:0.019676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15135 ORDER BY `minOrder` ASC [ RunTime:0.022551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15135 ORDER BY `unit` DESC [ RunTime:0.021613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15135 LIMIT 2 [ RunTime:0.077011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15135 ORDER BY `minOrder` ASC [ RunTime:0.054469s ]
select * from pdf where partno='SF-0402S100-2' and brandshort='BOURNS' limit 1 [ RunTime:0.049186s ]
select foldpath,foldpath2,filename from pdf_file where id=1545256 limit 1 [ RunTime:0.027382s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SF-0402S100-2' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.039646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6091 LIMIT 4 [ RunTime:0.007792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6091 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6091 ORDER BY `unit` DESC [ RunTime:0.004047s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6091 LIMIT 2 [ RunTime:0.002653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6091 ORDER BY `minOrder` ASC [ RunTime:0.010739s ]
select * from pdf where partno='09202.' and brandshort='DESCO' limit 1 [ RunTime:0.015021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '09202.' OR `brand` LIKE 'DESCO%' ) ) LIMIT 1 [ RunTime:0.010002s ]
SELECT `id` FROM `stock` WHERE `id` <> 6091 AND `partno` = '09202.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.008695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16243 [ RunTime:0.009309s ]
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 1100,20 [ RunTime:0.014445s ]
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.001166s ]
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.000566s ]
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.003640s ]