SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001845s ]
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=9&srecordnum=1120&status=4' [ RunTime:0.012237s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001124s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013368s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001535s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.007980s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001308s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010446s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001689s ]
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 160,20 [ RunTime:0.030384s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16093 LIMIT 4 [ RunTime:0.019918s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16093 ORDER BY `minOrder` ASC [ RunTime:0.008375s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16093 ORDER BY `unit` DESC [ RunTime:0.009121s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16093 LIMIT 2 [ RunTime:0.017569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16093 ORDER BY `minOrder` ASC [ RunTime:0.006880s ]
select * from pdf where partno='PCF0805-13-2K-B-T1.' and brandshort='TT ELECTRONICS / WELWYN' limit 1 [ RunTime:0.007301s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PCF0805-13-2K-B-T1.' OR `brand` LIKE 'TT ELECTRONICS / WELWYN%' ) ) LIMIT 1 [ RunTime:0.011321s ]
SELECT `id` FROM `stock` WHERE `id` <> 16093 AND `partno` = 'PCF0805-13-2K-B-T1.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tt electronics / welwyn%' ) [ RunTime:0.023514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 608 [ RunTime:0.018029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17111 [ RunTime:0.022100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16092 LIMIT 4 [ RunTime:0.012396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16092 ORDER BY `minOrder` ASC [ RunTime:0.014717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16092 ORDER BY `unit` DESC [ RunTime:0.017998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16092 LIMIT 2 [ RunTime:0.011957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16092 ORDER BY `minOrder` ASC [ RunTime:0.016656s ]
select * from pdf where partno='1-480702-0' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.016838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-480702-0' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.018857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16091 LIMIT 4 [ RunTime:0.016691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091 ORDER BY `minOrder` ASC [ RunTime:0.011540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16091 ORDER BY `unit` DESC [ RunTime:0.010647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16091 LIMIT 2 [ RunTime:0.011793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16091 ORDER BY `minOrder` ASC [ RunTime:0.006747s ]
select * from pdf where partno='EEUED2G470S' and brandshort='PANASONIC' limit 1 [ RunTime:0.019729s ]
select foldpath,foldpath2,filename from pdf_file where id=1142745 limit 1 [ RunTime:0.004395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEUED2G470S' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.015063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16090 LIMIT 4 [ RunTime:0.007490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16090 ORDER BY `minOrder` ASC [ RunTime:0.048244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16090 ORDER BY `unit` DESC [ RunTime:0.027850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16090 LIMIT 2 [ RunTime:0.077055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16090 ORDER BY `minOrder` ASC [ RunTime:0.031605s ]
select * from pdf where partno='MFR-25FTE52-120R' and brandshort='YAGEO' limit 1 [ RunTime:0.044552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MFR-25FTE52-120R' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.034844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16089 LIMIT 4 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089 ORDER BY `minOrder` ASC [ RunTime:0.002876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16089 ORDER BY `unit` DESC [ RunTime:0.015564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16089 LIMIT 2 [ RunTime:0.000987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16089 ORDER BY `minOrder` ASC [ RunTime:0.000648s ]
select * from pdf where partno='IRF640NPBF' and brandshort='INFINEON' limit 1 [ RunTime:0.002517s ]
select foldpath,foldpath2,filename from pdf_file where id=601823 limit 1 [ RunTime:0.004024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IRF640NPBF' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16088 LIMIT 4 [ RunTime:0.008811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16088 ORDER BY `minOrder` ASC [ RunTime:0.003271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16088 ORDER BY `unit` DESC [ RunTime:0.003674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16088 LIMIT 2 [ RunTime:0.012940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16088 ORDER BY `minOrder` ASC [ RunTime:0.008556s ]
select * from pdf where partno='1217861-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.010682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217861-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.011156s ]
SELECT `id` FROM `stock` WHERE `id` <> 16088 AND `partno` = '1217861-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.010962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4982 [ RunTime:0.006707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17106 [ RunTime:0.003052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16087 LIMIT 4 [ RunTime:0.003632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16087 ORDER BY `minOrder` ASC [ RunTime:0.001347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16087 ORDER BY `unit` DESC [ RunTime:0.003517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16087 LIMIT 2 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16087 ORDER BY `minOrder` ASC [ RunTime:0.000856s ]
select * from pdf where partno='BK-HKP-R' and brandshort='EATON BUSSMANN' limit 1 [ RunTime:0.002987s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BK-HKP-R' OR `brand` LIKE 'EATON BUSSMANN%' ) ) LIMIT 1 [ RunTime:0.003905s ]
SELECT `id` FROM `stock` WHERE `id` <> 16087 AND `partno` = 'BK-HKP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton bussmann%' ) [ RunTime:0.005327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12594 [ RunTime:0.006512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17105 [ RunTime:0.001540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16086 LIMIT 4 [ RunTime:0.002347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16086 ORDER BY `minOrder` ASC [ RunTime:0.004730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16086 ORDER BY `unit` DESC [ RunTime:0.011996s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16086 LIMIT 2 [ RunTime:0.006733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16086 ORDER BY `minOrder` ASC [ RunTime:0.003727s ]
select * from pdf where partno='TAJD476K025RNJ' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.019299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TAJD476K025RNJ' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.013051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16085 LIMIT 4 [ RunTime:0.005311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16085 ORDER BY `minOrder` ASC [ RunTime:0.003013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16085 ORDER BY `unit` DESC [ RunTime:0.016351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16085 LIMIT 2 [ RunTime:0.014458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16085 ORDER BY `minOrder` ASC [ RunTime:0.011066s ]
select * from pdf where partno='SMBJ6.5A' and brandshort='LITTELFUSE' limit 1 [ RunTime:0.028371s ]
select foldpath,foldpath2,filename from pdf_file where id=422167 limit 1 [ RunTime:0.011245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBJ6.5A' OR `brand` LIKE 'LITTELFUSE%' ) ) LIMIT 1 [ RunTime:0.025350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16084 LIMIT 4 [ RunTime:0.056328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16084 ORDER BY `minOrder` ASC [ RunTime:0.033943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16084 ORDER BY `unit` DESC [ RunTime:0.022656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16084 LIMIT 2 [ RunTime:0.008815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16084 ORDER BY `minOrder` ASC [ RunTime:0.004368s ]
select * from pdf where partno='575-4' and brandshort='KEYSTONE' limit 1 [ RunTime:0.021731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '575-4' OR `brand` LIKE 'KEYSTONE%' ) ) LIMIT 1 [ RunTime:0.027876s ]
SELECT `id` FROM `stock` WHERE `id` <> 16084 AND `partno` = '575-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone%' ) [ RunTime:0.016050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11408 [ RunTime:0.019496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17102 [ RunTime:0.003745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12883507 [ RunTime:0.015035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16083 LIMIT 4 [ RunTime:0.022791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16083 ORDER BY `minOrder` ASC [ RunTime:0.026387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16083 ORDER BY `unit` DESC [ RunTime:0.036280s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16083 LIMIT 2 [ RunTime:0.033980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16083 ORDER BY `minOrder` ASC [ RunTime:0.010224s ]
select * from pdf where partno='MF25 390R' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.030421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MF25 390R' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.033059s ]
SELECT `id` FROM `stock` WHERE `id` <> 16083 AND `partno` = 'MF25 390R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.024879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263 [ RunTime:0.023695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17101 [ RunTime:0.020314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16082 LIMIT 4 [ RunTime:0.016855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16082 ORDER BY `minOrder` ASC [ RunTime:0.003569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16082 ORDER BY `unit` DESC [ RunTime:0.037101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16082 LIMIT 2 [ RunTime:0.012155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16082 ORDER BY `minOrder` ASC [ RunTime:0.006696s ]
select * from pdf where partno='LM358ADT.' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.017318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LM358ADT.' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.016595s ]
SELECT `id` FROM `stock` WHERE `id` <> 16082 AND `partno` = 'LM358ADT.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.020596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1403 [ RunTime:0.009948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17100 [ RunTime:0.009980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16081 LIMIT 4 [ RunTime:0.007887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16081 ORDER BY `minOrder` ASC [ RunTime:0.006427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16081 ORDER BY `unit` DESC [ RunTime:0.021616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16081 LIMIT 2 [ RunTime:0.019851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16081 ORDER BY `minOrder` ASC [ RunTime:0.022355s ]
select * from pdf where partno='1N4733A' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.022713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1N4733A' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.019507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16080 LIMIT 4 [ RunTime:0.002183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16080 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16080 ORDER BY `unit` DESC [ RunTime:0.011023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16080 LIMIT 2 [ RunTime:0.007261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16080 ORDER BY `minOrder` ASC [ RunTime:0.008631s ]
select * from pdf where partno='XAL6060-103MEC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.002496s ]
select foldpath,foldpath2,filename from pdf_file where id=1040481 limit 1 [ RunTime:0.000324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XAL6060-103MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.005627s ]
SELECT `id` FROM `stock` WHERE `id` <> 16080 AND `partno` = 'XAL6060-103MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.004336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5977 [ RunTime:0.001763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17098 [ RunTime:0.008172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14313035 [ RunTime:0.006021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16079 LIMIT 4 [ RunTime:0.020897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16079 ORDER BY `minOrder` ASC [ RunTime:0.018425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16079 ORDER BY `unit` DESC [ RunTime:0.023111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16079 LIMIT 2 [ RunTime:0.015245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16079 ORDER BY `minOrder` ASC [ RunTime:0.013547s ]
select * from pdf where partno='2N3906' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.025381s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2N3906' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.016948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16078 LIMIT 4 [ RunTime:0.033689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16078 ORDER BY `minOrder` ASC [ RunTime:0.015186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16078 ORDER BY `unit` DESC [ RunTime:0.011658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16078 LIMIT 2 [ RunTime:0.014785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16078 ORDER BY `minOrder` ASC [ RunTime:0.003922s ]
select * from pdf where partno='77F102J-TR-RC' and brandshort='BOURNS' limit 1 [ RunTime:0.036231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '77F102J-TR-RC' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.063993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16077 LIMIT 4 [ RunTime:0.028112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16077 ORDER BY `minOrder` ASC [ RunTime:0.044294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16077 ORDER BY `unit` DESC [ RunTime:0.054907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16077 LIMIT 2 [ RunTime:0.034801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16077 ORDER BY `minOrder` ASC [ RunTime:0.014399s ]
select * from pdf where partno='SN74HC14D' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.024244s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SN74HC14D' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.015360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16076 LIMIT 4 [ RunTime:0.023660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076 ORDER BY `minOrder` ASC [ RunTime:0.014820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16076 ORDER BY `unit` DESC [ RunTime:0.018441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16076 LIMIT 2 [ RunTime:0.009238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16076 ORDER BY `minOrder` ASC [ RunTime:0.001886s ]
select * from pdf where partno='FGC-5 M3' and brandshort='KE KITAGAWA' limit 1 [ RunTime:0.019046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FGC-5 M3' OR `brand` LIKE 'KE KITAGAWA%' ) ) LIMIT 1 [ RunTime:0.025147s ]
SELECT `id` FROM `stock` WHERE `id` <> 16076 AND `partno` = 'FGC-5 M3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ke kitagawa%' ) [ RunTime:0.034180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12082 [ RunTime:0.014452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17094 [ RunTime:0.020283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16075 LIMIT 4 [ RunTime:0.030326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16075 ORDER BY `minOrder` ASC [ RunTime:0.018248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16075 ORDER BY `unit` DESC [ RunTime:0.012246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16075 LIMIT 2 [ RunTime:0.043886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16075 ORDER BY `minOrder` ASC [ RunTime:0.005027s ]
select * from pdf where partno='1.10.001.001/0507' and brandshort='RAFI' limit 1 [ RunTime:0.004695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1.10.001.001/0507' OR `brand` LIKE 'RAFI%' ) ) LIMIT 1 [ RunTime:0.023470s ]
SELECT `id` FROM `stock` WHERE `id` <> 16075 AND `partno` = '1.10.001.001/0507' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rafi%' ) [ RunTime:0.026389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14839 [ RunTime:0.059838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17093 [ RunTime:0.075583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16074 LIMIT 4 [ RunTime:0.044176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074 ORDER BY `minOrder` ASC [ RunTime:0.064167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16074 ORDER BY `unit` DESC [ RunTime:0.039939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16074 LIMIT 2 [ RunTime:0.048392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16074 ORDER BY `minOrder` ASC [ RunTime:0.040670s ]
select * from pdf where partno='26-01-3115' and brandshort='MOLEX' limit 1 [ RunTime:0.031010s ]
select foldpath,foldpath2,filename from pdf_file where id=1996673 limit 1 [ RunTime:0.057029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26-01-3115' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.043279s ]
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 160,20 [ RunTime:0.049808s ]
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.018271s ]
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.032842s ]
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.008991s ]