SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002122s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.174' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' [ RunTime:0.008744s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002050s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008193s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002146s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.174' ) [ RunTime:0.012036s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002736s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005231s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 148 LIMIT 1 [ RunTime:0.013794s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 148 [ RunTime:0.000409s ]
SELECT `id`,`name` FROM `product_type` WHERE `typeid` = 25 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002414s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `status` <> 2 AND `categoryid` = 148 ) AND `u`.`lockUser` = '0' [ RunTime:0.019173s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `status` <> 2 AND `categoryid` = 148 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007705s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('72','66','250','249','248','13951','3941','71','4237','251','68','252','13953','67','17083','16657','16065','15638','65','69') ORDER BY FIELD(s.id, 72,66,250,249,248,13951,3941,71,4237,251,68,252,13953,67,17083,16657,16065,15638,65,69) [ RunTime:0.013197s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 72 LIMIT 4 [ RunTime:0.005539s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 72 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 72 ORDER BY `unit` DESC [ RunTime:0.003548s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 72 LIMIT 2 [ RunTime:0.001645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 72 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
select * from pdf where partno='B72207S0301K101' and brandshort='EPCOS' limit 1 [ RunTime:0.005486s ]
select foldpath,foldpath2,filename from pdf_file where id=566331 limit 1 [ RunTime:0.000495s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72207S0301K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66 LIMIT 4 [ RunTime:0.007757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66 ORDER BY `minOrder` ASC [ RunTime:0.003660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66 ORDER BY `unit` DESC [ RunTime:0.004328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66 LIMIT 2 [ RunTime:0.016041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66 ORDER BY `minOrder` ASC [ RunTime:0.019026s ]
select * from pdf where partno='B72207S0251K101' and brandshort='EPCOS' limit 1 [ RunTime:0.000328s ]
select foldpath,foldpath2,filename from pdf_file where id=566331 limit 1 [ RunTime:0.002018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72207S0251K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.001365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 250 LIMIT 4 [ RunTime:0.010132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 250 ORDER BY `minOrder` ASC [ RunTime:0.002254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 250 ORDER BY `unit` DESC [ RunTime:0.000170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 250 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 250 ORDER BY `minOrder` ASC [ RunTime:0.001051s ]
select * from pdf where partno='V275LA20AP' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.000257s ]
select foldpath,foldpath2,filename from pdf_file where id=299558 limit 1 [ RunTime:0.000950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V275LA20AP' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 249 LIMIT 4 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 249 ORDER BY `minOrder` ASC [ RunTime:0.000180s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 249 ORDER BY `unit` DESC [ RunTime:0.000163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 249 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 249 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
select * from pdf where partno='V100ZA15P' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.000235s ]
select foldpath,foldpath2,filename from pdf_file where id=179201 limit 1 [ RunTime:0.000170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V100ZA15P' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.000165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 248 LIMIT 4 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 248 ORDER BY `minOrder` ASC [ RunTime:0.000172s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 248 ORDER BY `unit` DESC [ RunTime:0.000168s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 248 LIMIT 2 [ RunTime:0.000314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 248 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
select * from pdf where partno='V27ZA1P' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.000264s ]
select foldpath,foldpath2,filename from pdf_file where id=213253 limit 1 [ RunTime:0.000196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V27ZA1P' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.005609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13951 LIMIT 4 [ RunTime:0.004526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13951 ORDER BY `minOrder` ASC [ RunTime:0.004617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13951 ORDER BY `unit` DESC [ RunTime:0.007337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13951 LIMIT 2 [ RunTime:0.011385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13951 ORDER BY `minOrder` ASC [ RunTime:0.000250s ]
select * from pdf where partno='B72520T0040M062' and brandshort='EPCOS' limit 1 [ RunTime:0.000692s ]
select foldpath,foldpath2,filename from pdf_file where id=643217 limit 1 [ RunTime:0.000309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72520T0040M062' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3941 LIMIT 4 [ RunTime:0.003521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3941 ORDER BY `minOrder` ASC [ RunTime:0.003479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3941 ORDER BY `unit` DESC [ RunTime:0.005179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3941 LIMIT 2 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3941 ORDER BY `minOrder` ASC [ RunTime:0.022864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MLV0805E32503T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71 LIMIT 4 [ RunTime:0.006932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71 ORDER BY `unit` DESC [ RunTime:0.000262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71 LIMIT 2 [ RunTime:0.003230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
select * from pdf where partno='B72220S0271K101' and brandshort='EPCOS' limit 1 [ RunTime:0.005968s ]
select foldpath,foldpath2,filename from pdf_file where id=566343 limit 1 [ RunTime:0.012925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72220S0271K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.006978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4237 LIMIT 4 [ RunTime:0.005915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4237 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4237 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4237 LIMIT 2 [ RunTime:0.005074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4237 ORDER BY `minOrder` ASC [ RunTime:0.005886s ]
select * from pdf where partno='V510LA80BP' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.002472s ]
select foldpath,foldpath2,filename from pdf_file where id=178035 limit 1 [ RunTime:0.005594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V510LA80BP' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.011142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 251 LIMIT 4 [ RunTime:0.007151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 251 ORDER BY `minOrder` ASC [ RunTime:0.006874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 251 ORDER BY `unit` DESC [ RunTime:0.000404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 251 LIMIT 2 [ RunTime:0.007807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 251 ORDER BY `minOrder` ASC [ RunTime:0.000732s ]
select * from pdf where partno='V480LA80BP' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.003350s ]
select foldpath,foldpath2,filename from pdf_file where id=178281 limit 1 [ RunTime:0.005557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V480LA80BP' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68 LIMIT 4 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68 ORDER BY `minOrder` ASC [ RunTime:0.003388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68 ORDER BY `unit` DESC [ RunTime:0.002050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68 LIMIT 2 [ RunTime:0.004271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68 ORDER BY `minOrder` ASC [ RunTime:0.009093s ]
select * from pdf where partno='B72220S0350K101' and brandshort='EPCOS' limit 1 [ RunTime:0.000692s ]
select foldpath,foldpath2,filename from pdf_file where id=566343 limit 1 [ RunTime:0.001917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72220S0350K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.001576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 252 LIMIT 4 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 252 ORDER BY `minOrder` ASC [ RunTime:0.004039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 252 ORDER BY `unit` DESC [ RunTime:0.000318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 252 LIMIT 2 [ RunTime:0.000460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 252 ORDER BY `minOrder` ASC [ RunTime:0.003429s ]
select * from pdf where partno='V56MLA1206H' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.005229s ]
select foldpath,foldpath2,filename from pdf_file where id=1042786 limit 1 [ RunTime:0.004916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V56MLA1206H' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.002898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13953 LIMIT 4 [ RunTime:0.001737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13953 ORDER BY `minOrder` ASC [ RunTime:0.002441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13953 ORDER BY `unit` DESC [ RunTime:0.012610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13953 LIMIT 2 [ RunTime:0.020003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13953 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='B72530T0350K062' and brandshort='EPCOS' limit 1 [ RunTime:0.001182s ]
select foldpath,foldpath2,filename from pdf_file where id=550590 limit 1 [ RunTime:0.002844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72530T0350K062' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.002055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67 LIMIT 4 [ RunTime:0.012287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67 ORDER BY `minOrder` ASC [ RunTime:0.001198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67 ORDER BY `unit` DESC [ RunTime:0.007336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67 LIMIT 2 [ RunTime:0.010696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67 ORDER BY `minOrder` ASC [ RunTime:0.006791s ]
select * from pdf where partno='B72210S0500K101' and brandshort='EPCOS' limit 1 [ RunTime:0.011738s ]
select foldpath,foldpath2,filename from pdf_file where id=566336 limit 1 [ RunTime:0.005923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72210S0500K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.003415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17083 LIMIT 4 [ RunTime:0.009578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17083 ORDER BY `minOrder` ASC [ RunTime:0.001819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17083 ORDER BY `unit` DESC [ RunTime:0.004904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17083 LIMIT 2 [ RunTime:0.003811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17083 ORDER BY `minOrder` ASC [ RunTime:0.008014s ]
select * from pdf where partno='V100ZA15P' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.006131s ]
select foldpath,foldpath2,filename from pdf_file where id=179201 limit 1 [ RunTime:0.004905s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V100ZA15P' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.002096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16657 LIMIT 4 [ RunTime:0.006329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657 ORDER BY `minOrder` ASC [ RunTime:0.003101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16657 ORDER BY `unit` DESC [ RunTime:0.003786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16657 LIMIT 2 [ RunTime:0.008079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16657 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='B72207S0251K101' and brandshort='EPCOS' limit 1 [ RunTime:0.002253s ]
select foldpath,foldpath2,filename from pdf_file where id=566331 limit 1 [ RunTime:0.000307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72207S0251K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16065 LIMIT 4 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16065 ORDER BY `minOrder` ASC [ RunTime:0.005878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16065 ORDER BY `unit` DESC [ RunTime:0.001138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16065 LIMIT 2 [ RunTime:0.008825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16065 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='V100ZA15P' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.000335s ]
select foldpath,foldpath2,filename from pdf_file where id=179201 limit 1 [ RunTime:0.000245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V100ZA15P' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.000282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15638 LIMIT 4 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15638 ORDER BY `minOrder` ASC [ RunTime:0.002383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15638 ORDER BY `unit` DESC [ RunTime:0.004742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15638 LIMIT 2 [ RunTime:0.002248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15638 ORDER BY `minOrder` ASC [ RunTime:0.022512s ]
select * from pdf where partno='B72207S0251K101' and brandshort='EPCOS' limit 1 [ RunTime:0.003469s ]
select foldpath,foldpath2,filename from pdf_file where id=566331 limit 1 [ RunTime:0.000302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72207S0251K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65 LIMIT 4 [ RunTime:0.008027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65 ORDER BY `minOrder` ASC [ RunTime:0.005056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65 ORDER BY `unit` DESC [ RunTime:0.001312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65 LIMIT 2 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='B72220S0300K101' and brandshort='EPCOS' limit 1 [ RunTime:0.000371s ]
select foldpath,foldpath2,filename from pdf_file where id=566343 limit 1 [ RunTime:0.000260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72220S0300K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 69 LIMIT 4 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69 ORDER BY `minOrder` ASC [ RunTime:0.004099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 69 ORDER BY `unit` DESC [ RunTime:0.005776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 69 LIMIT 2 [ RunTime:0.002265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 69 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
select * from pdf where partno='B72207S0300K101' and brandshort='EPCOS' limit 1 [ RunTime:0.000396s ]
select foldpath,foldpath2,filename from pdf_file where id=566331 limit 1 [ RunTime:0.000283s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B72207S0300K101' OR `brand` LIKE 'EPCOS%' ) ) LIMIT 1 [ RunTime:0.000304s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `status` <> 2 AND `categoryid` = 148 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.002872s ]