SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001278s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.177' , `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=2&srecordnum=1120&status=4' [ RunTime:0.010818s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002220s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000514s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001402s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.177' ) [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001113s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002551s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002564s ]
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' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.010337s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16233 LIMIT 5 [ RunTime:0.000648s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16233 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16233 ORDER BY `unit` DESC [ RunTime:0.006920s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16233 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16233 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='51164-0605' and brandshort='MOLEX' limit 1 [ RunTime:0.006928s ]
select foldpath,foldpath2,filename from pdf_file where id=853375 limit 1 [ RunTime:0.003071s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001383s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51164-0605' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.011127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16232 LIMIT 5 [ RunTime:0.010428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16232 ORDER BY `minOrder` ASC [ RunTime:0.006348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16232 ORDER BY `unit` DESC [ RunTime:0.000785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16232 LIMIT 2 [ RunTime:0.011934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16232 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
select * from pdf where partno='B3PS-VH(LF)(SN)' and brandshort='JST JAPAN SOLDERLESS TERMINALS' limit 1 [ RunTime:0.004094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B3PS-VH(LF)(SN)' OR `brand` LIKE 'JST (JAPAN SOLDERLESS TERMINALS)%' ) ) LIMIT 1 [ RunTime:0.001846s ]
SELECT `id` FROM `stock` WHERE `id` <> 16232 AND `partno` = 'B3PS-VH(LF)(SN)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jst%' ) [ RunTime:0.002839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14412 [ RunTime:0.000637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16231 LIMIT 5 [ RunTime:0.009875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16231 ORDER BY `minOrder` ASC [ RunTime:0.011073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16231 ORDER BY `unit` DESC [ RunTime:0.004408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16231 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16231 ORDER BY `minOrder` ASC [ RunTime:0.007569s ]
select * from pdf where partno='BAT54WS-E3-08' and brandshort='VISHAY' limit 1 [ RunTime:0.003126s ]
select foldpath,foldpath2,filename from pdf_file where id=1916027 limit 1 [ RunTime:0.009711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BAT54WS-E3-08' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.011850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16230 LIMIT 5 [ RunTime:0.021312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16230 ORDER BY `minOrder` ASC [ RunTime:0.006173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16230 ORDER BY `unit` DESC [ RunTime:0.003831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16230 LIMIT 2 [ RunTime:0.004153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16230 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='1430381' and brandshort='PHOENIX CONTACT' limit 1 [ RunTime:0.002368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1430381' OR `brand` LIKE 'PHOENIX CONTACT%' ) ) LIMIT 1 [ RunTime:0.008769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16229 LIMIT 5 [ RunTime:0.002636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16229 ORDER BY `minOrder` ASC [ RunTime:0.007137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16229 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16229 LIMIT 2 [ RunTime:0.005539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16229 ORDER BY `minOrder` ASC [ RunTime:0.005518s ]
select * from pdf where partno='V7-1B17D8-263.' and brandshort='HONEYWELL' limit 1 [ RunTime:0.008233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'V7-1B17D8-263.' OR `brand` LIKE 'HONEYWELL%' ) ) LIMIT 1 [ RunTime:0.015371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16228 LIMIT 5 [ RunTime:0.008163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16228 ORDER BY `minOrder` ASC [ RunTime:0.000532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16228 ORDER BY `unit` DESC [ RunTime:0.004667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16228 LIMIT 2 [ RunTime:0.001729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16228 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='MCWR06X1000FTL' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.002972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCWR06X1000FTL' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.005714s ]
SELECT `id` FROM `stock` WHERE `id` <> 16228 AND `partno` = 'MCWR06X1000FTL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.003598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7241 [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7270 [ RunTime:0.007031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227 LIMIT 5 [ RunTime:0.001289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227 ORDER BY `unit` DESC [ RunTime:0.000451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227 LIMIT 2 [ RunTime:0.009397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
select * from pdf where partno='MH32768C' and brandshort='EUROQUARTZ' limit 1 [ RunTime:0.001511s ]
select foldpath,foldpath2,filename from pdf_file where id=1008914 limit 1 [ RunTime:0.002810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MH32768C' OR `brand` LIKE 'EUROQUARTZ%' ) ) LIMIT 1 [ RunTime:0.002536s ]
SELECT `id` FROM `stock` WHERE `id` <> 16227 AND `partno` = 'MH32768C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%euroquartz%' ) [ RunTime:0.011771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3062 [ RunTime:0.000465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226 LIMIT 5 [ RunTime:0.007467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226 ORDER BY `minOrder` ASC [ RunTime:0.003652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16226 ORDER BY `unit` DESC [ RunTime:0.002298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16226 LIMIT 2 [ RunTime:0.007211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='TMDSEVM3517.' and brandshort='TEXAS INSTRUMENTS' limit 1 [ RunTime:0.006312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMDSEVM3517.' OR `brand` LIKE 'TEXAS INSTRUMENTS%' ) ) LIMIT 1 [ RunTime:0.011556s ]
SELECT `id` FROM `stock` WHERE `id` <> 16226 AND `partno` = 'TMDSEVM3517.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%texas instruments%' ) [ RunTime:0.010056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4600 [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16225 LIMIT 5 [ RunTime:0.000517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225 ORDER BY `minOrder` ASC [ RunTime:0.002681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16225 ORDER BY `unit` DESC [ RunTime:0.003627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16225 LIMIT 2 [ RunTime:0.002770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16225 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='RK73H1ETTP49R9F' and brandshort='KOA' limit 1 [ RunTime:0.008329s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RK73H1ETTP49R9F' OR `brand` LIKE 'KOA%' ) ) LIMIT 1 [ RunTime:0.012530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16224 LIMIT 5 [ RunTime:0.003358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224 ORDER BY `minOrder` ASC [ RunTime:0.007494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16224 ORDER BY `unit` DESC [ RunTime:0.022843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16224 LIMIT 2 [ RunTime:0.017270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16224 ORDER BY `minOrder` ASC [ RunTime:0.015168s ]
select * from pdf where partno='P600J-E3/54' and brandshort='VISHAY' limit 1 [ RunTime:0.087947s ]
select foldpath,foldpath2,filename from pdf_file where id=1808853 limit 1 [ RunTime:0.026687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P600J-E3/54' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.034785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16223 LIMIT 5 [ RunTime:0.009565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223 ORDER BY `minOrder` ASC [ RunTime:0.012719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16223 ORDER BY `unit` DESC [ RunTime:0.026476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16223 LIMIT 2 [ RunTime:0.030221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16223 ORDER BY `minOrder` ASC [ RunTime:0.005740s ]
select * from pdf where partno='744777001' and brandshort='WURTH ELEKTRONIK' limit 1 [ RunTime:0.006528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '744777001' OR `brand` LIKE 'WURTH ELEKTRONIK%' ) ) LIMIT 1 [ RunTime:0.020120s ]
SELECT `id` FROM `stock` WHERE `id` <> 16223 AND `partno` = '744777001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.040203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9075 [ RunTime:0.029963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14288817 [ RunTime:0.061971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16222 LIMIT 5 [ RunTime:0.016918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16222 ORDER BY `unit` DESC [ RunTime:0.001649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16222 LIMIT 2 [ RunTime:0.004415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16222 ORDER BY `minOrder` ASC [ RunTime:0.002917s ]
select * from pdf where partno='350429-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.013345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '350429-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.006787s ]
SELECT `id` FROM `stock` WHERE `id` <> 16222 AND `partno` = '350429-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.009095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9776 [ RunTime:0.009826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16221 LIMIT 5 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221 ORDER BY `minOrder` ASC [ RunTime:0.000653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16221 ORDER BY `unit` DESC [ RunTime:0.004329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16221 LIMIT 2 [ RunTime:0.001873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221 ORDER BY `minOrder` ASC [ RunTime:0.000868s ]
select * from pdf where partno='RT0603BRC0710KL' and brandshort='YAGEO' limit 1 [ RunTime:0.006829s ]
select foldpath,foldpath2,filename from pdf_file where id=1485547 limit 1 [ RunTime:0.010414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RT0603BRC0710KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220 LIMIT 5 [ RunTime:0.009091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220 ORDER BY `minOrder` ASC [ RunTime:0.024283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220 ORDER BY `unit` DESC [ RunTime:0.007022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220 ORDER BY `minOrder` ASC [ RunTime:0.013533s ]
select * from pdf where partno='SZMMSZ4687T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.015377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZMMSZ4687T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.021288s ]
SELECT `id` FROM `stock` WHERE `id` <> 16220 AND `partno` = 'SZMMSZ4687T1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.019994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8839 [ RunTime:0.003810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51776932 [ RunTime:0.007083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16219 LIMIT 5 [ RunTime:0.005679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16219 ORDER BY `minOrder` ASC [ RunTime:0.008826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16219 ORDER BY `unit` DESC [ RunTime:0.006194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16219 LIMIT 2 [ RunTime:0.008694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16219 ORDER BY `minOrder` ASC [ RunTime:0.008224s ]
select * from pdf where partno='MC65F103A'limit 1 [ RunTime:0.004778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC65F103A' OR `brand` LIKE '%' ) ) LIMIT 1 [ RunTime:0.010383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16218 LIMIT 5 [ RunTime:0.001127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218 ORDER BY `minOrder` ASC [ RunTime:0.002221s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16218 ORDER BY `unit` DESC [ RunTime:0.000958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16218 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16218 ORDER BY `minOrder` ASC [ RunTime:0.002878s ]
select * from pdf where partno='08055C103JAT2A' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.008454s ]
select foldpath,foldpath2,filename from pdf_file where id=300244 limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '08055C103JAT2A' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.008144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16217 LIMIT 5 [ RunTime:0.006102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217 ORDER BY `minOrder` ASC [ RunTime:0.002821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16217 ORDER BY `unit` DESC [ RunTime:0.001431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16217 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217 ORDER BY `minOrder` ASC [ RunTime:0.004452s ]
select * from pdf where partno='RB751V40T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.004218s ]
select foldpath,foldpath2,filename from pdf_file where id=1124630 limit 1 [ RunTime:0.003724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RB751V40T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.009344s ]
SELECT `id` FROM `stock` WHERE `id` <> 16217 AND `partno` = 'RB751V40T1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.008145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2118 [ RunTime:0.004045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079214 [ RunTime:0.000692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16216 LIMIT 5 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216 ORDER BY `minOrder` ASC [ RunTime:0.003201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16216 ORDER BY `unit` DESC [ RunTime:0.003170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16216 LIMIT 2 [ RunTime:0.018928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16216 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='STM32F103VBT7' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.002200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STM32F103VBT7' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.015800s ]
SELECT `id` FROM `stock` WHERE `id` <> 16216 AND `partno` = 'STM32F103VBT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.015866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6504 [ RunTime:0.009497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17121971 [ RunTime:0.011530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16215 LIMIT 5 [ RunTime:0.003453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16215 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16215 ORDER BY `unit` DESC [ RunTime:0.003345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16215 LIMIT 2 [ RunTime:0.001328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16215 ORDER BY `minOrder` ASC [ RunTime:0.003836s ]
select * from pdf where partno='HCPL0501' and brandshort='ONSEMI' limit 1 [ RunTime:0.006138s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL0501' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.009266s ]
SELECT `id` FROM `stock` WHERE `id` <> 16215 AND `partno` = 'HCPL0501' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7395 [ RunTime:0.005611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15202892 [ RunTime:0.003751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16214 LIMIT 5 [ RunTime:0.002183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214 ORDER BY `minOrder` ASC [ RunTime:0.009364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16214 ORDER BY `unit` DESC [ RunTime:0.001929s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16214 LIMIT 2 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16214 ORDER BY `minOrder` ASC [ RunTime:0.006893s ]
select * from pdf where partno='EEHZC1K330P' and brandshort='PANASONIC' limit 1 [ RunTime:0.008155s ]
select foldpath,foldpath2,filename from pdf_file where id=2012613 limit 1 [ RunTime:0.006650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EEHZC1K330P' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.009149s ]
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' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 20,20 [ RunTime:0.014977s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' ) ) tmp GROUP BY `brand` [ RunTime:0.023382s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' ) AND `categoryid` > 0 [ RunTime:0.014294s ]
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.012827s ]