SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001547s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/category_86/1.html' [ RunTime:0.012423s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002797s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001644s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001816s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000672s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001518s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002231s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 86 [ RunTime:0.008465s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 86 LIMIT 1 [ RunTime:0.005520s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001430s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '86' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011290s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9612 LIMIT 5 [ RunTime:0.025940s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9612 ORDER BY `minOrder` ASC [ RunTime:0.008413s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9612 ORDER BY `unit` DESC [ RunTime:0.021538s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9612 LIMIT 2 [ RunTime:0.015511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9612 ORDER BY `minOrder` ASC [ RunTime:0.006665s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LQM18FN100M00D' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.022792s ]
SELECT `id` FROM `stock` WHERE `id` <> 9612 AND `partno` = 'LQM18FN100M00D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.034694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13438576 [ RunTime:0.002908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5956 LIMIT 5 [ RunTime:0.023622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5956 ORDER BY `minOrder` ASC [ RunTime:0.024772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5956 ORDER BY `unit` DESC [ RunTime:0.022606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5956 LIMIT 2 [ RunTime:0.025544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5956 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1210-153MED' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.008569s ]
SELECT `id` FROM `stock` WHERE `id` <> 5956 AND `partno` = 'MSS1210-153MED' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.005526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13425585 [ RunTime:0.017512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5962 LIMIT 5 [ RunTime:0.010150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5962 ORDER BY `minOrder` ASC [ RunTime:0.013285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5962 ORDER BY `unit` DESC [ RunTime:0.002803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5962 LIMIT 2 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5962 ORDER BY `minOrder` ASC [ RunTime:0.006895s ]
select * from pdf where partno='MSS1278T-333MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.020856s ]
select foldpath,foldpath2,filename from pdf_file where id=1051656 limit 1 [ RunTime:0.020628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1278T-333MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.012438s ]
SELECT `id` FROM `stock` WHERE `id` <> 5962 AND `partno` = 'MSS1278T-333MLD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.019947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7069 LIMIT 5 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7069 ORDER BY `minOrder` ASC [ RunTime:0.043467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7069 ORDER BY `unit` DESC [ RunTime:0.034819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7069 LIMIT 2 [ RunTime:0.010395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7069 ORDER BY `minOrder` ASC [ RunTime:0.010165s ]
select * from pdf where partno='SRN2512-1R5M' and brandshort='BOURNS' limit 1 [ RunTime:0.009960s ]
select foldpath,foldpath2,filename from pdf_file where id=1921743 limit 1 [ RunTime:0.039503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRN2512-1R5M' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.007937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 274 LIMIT 5 [ RunTime:0.003085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 274 ORDER BY `minOrder` ASC [ RunTime:0.018160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 274 ORDER BY `unit` DESC [ RunTime:0.027681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 274 LIMIT 2 [ RunTime:0.033524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 274 ORDER BY `minOrder` ASC [ RunTime:0.007933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22R104C' OR `brand` LIKE 'MURATA POWER SOLUTIONS%' ) ) LIMIT 1 [ RunTime:0.007354s ]
SELECT `id` FROM `stock` WHERE `id` <> 274 AND `partno` = '22R104C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata power solutions%' ) [ RunTime:0.015336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13427296 [ RunTime:0.016997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5175 LIMIT 5 [ RunTime:0.004630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5175 ORDER BY `minOrder` ASC [ RunTime:0.024516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5175 ORDER BY `unit` DESC [ RunTime:0.012191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5175 LIMIT 2 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5175 ORDER BY `minOrder` ASC [ RunTime:0.005815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRN6045-101M' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.008939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5950 LIMIT 5 [ RunTime:0.013373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5950 ORDER BY `minOrder` ASC [ RunTime:0.004565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5950 ORDER BY `unit` DESC [ RunTime:0.000790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5950 LIMIT 2 [ RunTime:0.004967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5950 ORDER BY `minOrder` ASC [ RunTime:0.004410s ]
select * from pdf where partno='EPL3015-682MLC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.009420s ]
select foldpath,foldpath2,filename from pdf_file where id=1156524 limit 1 [ RunTime:0.035167s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EPL3015-682MLC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.021688s ]
SELECT `id` FROM `stock` WHERE `id` <> 5950 AND `partno` = 'EPL3015-682MLC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.032301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5982 LIMIT 5 [ RunTime:0.025788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5982 ORDER BY `minOrder` ASC [ RunTime:0.021058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5982 ORDER BY `unit` DESC [ RunTime:0.045612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5982 LIMIT 2 [ RunTime:0.055790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5982 ORDER BY `minOrder` ASC [ RunTime:0.001031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XFL4020-222MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.013549s ]
SELECT `id` FROM `stock` WHERE `id` <> 5982 AND `partno` = 'XFL4020-222MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.034190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14305986 [ RunTime:0.005981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5983 LIMIT 5 [ RunTime:0.005746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5983 ORDER BY `minOrder` ASC [ RunTime:0.033062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5983 ORDER BY `unit` DESC [ RunTime:0.007166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5983 LIMIT 2 [ RunTime:0.022206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5983 ORDER BY `minOrder` ASC [ RunTime:0.013339s ]
select * from pdf where partno='XFL4020-472MEC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.002638s ]
select foldpath,foldpath2,filename from pdf_file where id=1047029 limit 1 [ RunTime:0.004796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XFL4020-472MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.018387s ]
SELECT `id` FROM `stock` WHERE `id` <> 5983 AND `partno` = 'XFL4020-472MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.018003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14312883 [ RunTime:0.034531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5949 LIMIT 5 [ RunTime:0.010051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5949 ORDER BY `minOrder` ASC [ RunTime:0.012411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5949 ORDER BY `unit` DESC [ RunTime:0.039757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5949 LIMIT 2 [ RunTime:0.023071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5949 ORDER BY `minOrder` ASC [ RunTime:0.001193s ]
select * from pdf where partno='EPL2014-472MLB' and brandshort='COILCRAFT' limit 1 [ RunTime:0.003397s ]
select foldpath,foldpath2,filename from pdf_file where id=1134672 limit 1 [ RunTime:0.001947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EPL2014-472MLB' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.007364s ]
SELECT `id` FROM `stock` WHERE `id` <> 5949 AND `partno` = 'EPL2014-472MLB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.009083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5969 LIMIT 5 [ RunTime:0.001034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5969 ORDER BY `minOrder` ASC [ RunTime:0.003635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5969 ORDER BY `unit` DESC [ RunTime:0.014498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5969 LIMIT 2 [ RunTime:0.009872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5969 ORDER BY `minOrder` ASC [ RunTime:0.004647s ]
select * from pdf where partno='XAL4030-332MEC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.006994s ]
select foldpath,foldpath2,filename from pdf_file where id=1047027 limit 1 [ RunTime:0.036106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XAL4030-332MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.001053s ]
SELECT `id` FROM `stock` WHERE `id` <> 5969 AND `partno` = 'XAL4030-332MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.001175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6101 [ RunTime:0.009562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21689 [ RunTime:0.001574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14305996 [ RunTime:0.004554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14968 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14968 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14968 ORDER BY `unit` DESC [ RunTime:0.006841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14968 LIMIT 2 [ RunTime:0.002816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14968 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
select * from pdf where partno='IHLP3232DZER150M11' and brandshort='VISHAY' limit 1 [ RunTime:0.001298s ]
select foldpath,foldpath2,filename from pdf_file where id=1314408 limit 1 [ RunTime:0.001694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IHLP3232DZER150M11' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.014027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13769 LIMIT 5 [ RunTime:0.008178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13769 ORDER BY `minOrder` ASC [ RunTime:0.004103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13769 ORDER BY `unit` DESC [ RunTime:0.000699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13769 LIMIT 2 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13769 ORDER BY `minOrder` ASC [ RunTime:0.003019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRU5018-1R5Y.' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.009090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6737 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6737 ORDER BY `minOrder` ASC [ RunTime:0.003987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6737 ORDER BY `unit` DESC [ RunTime:0.002267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6737 LIMIT 2 [ RunTime:0.002022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6737 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='SDE1006A-821K' and brandshort='BOURNS' limit 1 [ RunTime:0.004134s ]
select foldpath,foldpath2,filename from pdf_file where id=1062609 limit 1 [ RunTime:0.004027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SDE1006A-821K' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.004163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5958 LIMIT 5 [ RunTime:0.000635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5958 ORDER BY `minOrder` ASC [ RunTime:0.003717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5958 ORDER BY `unit` DESC [ RunTime:0.005025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5958 LIMIT 2 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5958 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1210-333MEB' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.004722s ]
SELECT `id` FROM `stock` WHERE `id` <> 5958 AND `partno` = 'MSS1210-333MEB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.009879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6253 LIMIT 5 [ RunTime:0.005225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6253 ORDER BY `minOrder` ASC [ RunTime:0.007489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6253 ORDER BY `unit` DESC [ RunTime:0.000923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6253 LIMIT 2 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6253 ORDER BY `minOrder` ASC [ RunTime:0.002891s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRP6540-100M' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.010721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5946 LIMIT 5 [ RunTime:0.005561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5946 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5946 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5946 LIMIT 2 [ RunTime:0.002347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5946 ORDER BY `minOrder` ASC [ RunTime:0.004519s ]
select * from pdf where partno='DO3316P-103MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.004663s ]
select foldpath,foldpath2,filename from pdf_file where id=1113627 limit 1 [ RunTime:0.002772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'DO3316P-103MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.000955s ]
SELECT `id` FROM `stock` WHERE `id` <> 5946 AND `partno` = 'DO3316P-103MLD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.008229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419123 [ RunTime:0.007377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7070 LIMIT 5 [ RunTime:0.002569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7070 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7070 ORDER BY `unit` DESC [ RunTime:0.014285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7070 LIMIT 2 [ RunTime:0.014239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7070 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
select * from pdf where partno='SRN4026-150M' and brandshort='BOURNS' limit 1 [ RunTime:0.005411s ]
select foldpath,foldpath2,filename from pdf_file where id=1772394 limit 1 [ RunTime:0.003412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SRN4026-150M' OR `brand` LIKE 'BOURNS%' ) ) LIMIT 1 [ RunTime:0.003975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5981 LIMIT 5 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5981 ORDER BY `minOrder` ASC [ RunTime:0.000686s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5981 ORDER BY `unit` DESC [ RunTime:0.002333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5981 LIMIT 2 [ RunTime:0.006606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5981 ORDER BY `minOrder` ASC [ RunTime:0.010394s ]
select * from pdf where partno='XFL4020-102MEC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.001062s ]
select foldpath,foldpath2,filename from pdf_file where id=1047029 limit 1 [ RunTime:0.001168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XFL4020-102MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.000961s ]
SELECT `id` FROM `stock` WHERE `id` <> 5981 AND `partno` = 'XFL4020-102MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.004813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16382742 [ RunTime:0.015018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5961 LIMIT 5 [ RunTime:0.003728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5961 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5961 ORDER BY `unit` DESC [ RunTime:0.007957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5961 LIMIT 2 [ RunTime:0.002956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5961 ORDER BY `minOrder` ASC [ RunTime:0.004434s ]
select * from pdf where partno='MSS1278-473MLD' and brandshort='COILCRAFT' limit 1 [ RunTime:0.001457s ]
select foldpath,foldpath2,filename from pdf_file where id=1051655 limit 1 [ RunTime:0.009946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MSS1278-473MLD' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.003837s ]
SELECT `id` FROM `stock` WHERE `id` <> 5961 AND `partno` = 'MSS1278-473MLD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.010352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15633 [ RunTime:0.005376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16652 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13419918 [ RunTime:0.003856s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '86' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016077s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '86' ) LIMIT 76 ) tmp GROUP BY `brand` [ RunTime:0.033194s ]