SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002363s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=294&search=1' [ RunTime:0.001839s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002121s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003305s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.001075s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002982s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005111s ]
SELECT * FROM `stock_search` WHERE `partno` = '294' LIMIT 1 [ RunTime:0.002090s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 11:09:40' WHERE `partno` = '294' [ RunTime:0.008027s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003319s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026179s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943976 LIMIT 5 [ RunTime:0.001127s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943976 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943976 ORDER BY `unit` DESC [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943976 LIMIT 2 [ RunTime:0.003162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943976 ORDER BY `minOrder` ASC [ RunTime:0.003342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212442 LIMIT 5 [ RunTime:0.003601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212442 ORDER BY `minOrder` ASC [ RunTime:0.002543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13212442 ORDER BY `unit` DESC [ RunTime:0.006728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13212442 LIMIT 2 [ RunTime:0.004914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212442 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944371 LIMIT 5 [ RunTime:0.009496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944371 ORDER BY `minOrder` ASC [ RunTime:0.014426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944371 ORDER BY `unit` DESC [ RunTime:0.000820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944371 LIMIT 2 [ RunTime:0.002428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944371 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944797 LIMIT 5 [ RunTime:0.016366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944797 ORDER BY `minOrder` ASC [ RunTime:0.035624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944797 ORDER BY `unit` DESC [ RunTime:0.001345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944797 LIMIT 2 [ RunTime:0.001647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944797 ORDER BY `minOrder` ASC [ RunTime:0.007882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943998 LIMIT 5 [ RunTime:0.013823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943998 ORDER BY `minOrder` ASC [ RunTime:0.013593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943998 ORDER BY `unit` DESC [ RunTime:0.003078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943998 LIMIT 2 [ RunTime:0.007018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943998 ORDER BY `minOrder` ASC [ RunTime:0.011558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19185187 LIMIT 5 [ RunTime:0.000963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19185187 ORDER BY `minOrder` ASC [ RunTime:0.003548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19185187 ORDER BY `unit` DESC [ RunTime:0.005971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19185187 LIMIT 2 [ RunTime:0.014234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19185187 ORDER BY `minOrder` ASC [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943992 LIMIT 5 [ RunTime:0.001373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943992 ORDER BY `minOrder` ASC [ RunTime:0.009385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943992 ORDER BY `unit` DESC [ RunTime:0.006399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943992 LIMIT 2 [ RunTime:0.011251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943992 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211508 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211508 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211508 ORDER BY `unit` DESC [ RunTime:0.000523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211508 LIMIT 2 [ RunTime:0.000475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211508 ORDER BY `minOrder` ASC [ RunTime:0.000257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459926 LIMIT 5 [ RunTime:0.001144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459926 ORDER BY `minOrder` ASC [ RunTime:0.005895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459926 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459926 LIMIT 2 [ RunTime:0.002128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459926 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211869 LIMIT 5 [ RunTime:0.001475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211869 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211869 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211869 LIMIT 2 [ RunTime:0.003451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211869 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944561 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944561 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944561 ORDER BY `unit` DESC [ RunTime:0.002378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944561 LIMIT 2 [ RunTime:0.004205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944561 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12790017 LIMIT 5 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790017 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12790017 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12790017 LIMIT 2 [ RunTime:0.008752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12790017 ORDER BY `minOrder` ASC [ RunTime:0.003731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13459927 LIMIT 5 [ RunTime:0.000804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459927 ORDER BY `minOrder` ASC [ RunTime:0.001705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13459927 ORDER BY `unit` DESC [ RunTime:0.000557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13459927 LIMIT 2 [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13459927 ORDER BY `minOrder` ASC [ RunTime:0.007811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791509 LIMIT 5 [ RunTime:0.005678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791509 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791509 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791509 LIMIT 2 [ RunTime:0.006591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791509 ORDER BY `minOrder` ASC [ RunTime:0.001085s ]
select * from pdf where partno='294001-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.005330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212272 LIMIT 5 [ RunTime:0.001227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212272 ORDER BY `minOrder` ASC [ RunTime:0.008021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13212272 ORDER BY `unit` DESC [ RunTime:0.004093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13212272 LIMIT 2 [ RunTime:0.002499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13212272 ORDER BY `minOrder` ASC [ RunTime:0.010926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19836334 LIMIT 5 [ RunTime:0.001599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19836334 ORDER BY `minOrder` ASC [ RunTime:0.003104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19836334 ORDER BY `unit` DESC [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19836334 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19836334 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196027 LIMIT 5 [ RunTime:0.003954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196027 ORDER BY `minOrder` ASC [ RunTime:0.006290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196027 ORDER BY `unit` DESC [ RunTime:0.005033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196027 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196027 ORDER BY `minOrder` ASC [ RunTime:0.000572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348921 LIMIT 5 [ RunTime:0.001157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348921 ORDER BY `minOrder` ASC [ RunTime:0.001132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348921 ORDER BY `unit` DESC [ RunTime:0.002220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348921 LIMIT 2 [ RunTime:0.015528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348921 ORDER BY `minOrder` ASC [ RunTime:0.004898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13349069 LIMIT 5 [ RunTime:0.003680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349069 ORDER BY `minOrder` ASC [ RunTime:0.006775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13349069 ORDER BY `unit` DESC [ RunTime:0.004822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13349069 LIMIT 2 [ RunTime:0.011064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13349069 ORDER BY `minOrder` ASC [ RunTime:0.005021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944723 LIMIT 5 [ RunTime:0.002698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944723 ORDER BY `minOrder` ASC [ RunTime:0.016759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11944723 ORDER BY `unit` DESC [ RunTime:0.013259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11944723 LIMIT 2 [ RunTime:0.013862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11944723 ORDER BY `minOrder` ASC [ RunTime:0.008770s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126423 LIMIT 5 [ RunTime:0.008862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126423 ORDER BY `minOrder` ASC [ RunTime:0.016071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126423 ORDER BY `unit` DESC [ RunTime:0.014886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126423 LIMIT 2 [ RunTime:0.006695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126423 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='2944666651' and brandshort='fair-rite' limit 1 [ RunTime:0.003241s ]
select foldpath,foldpath2,filename from pdf_file where id=1185792 limit 1 [ RunTime:0.003687s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666651' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.006295s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126423 AND `partno` = '2944666651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.001292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113699 [ RunTime:0.010811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212272 [ RunTime:0.009921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113699 LIMIT 5 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113699 ORDER BY `minOrder` ASC [ RunTime:0.004939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113699 ORDER BY `unit` DESC [ RunTime:0.020309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113699 LIMIT 2 [ RunTime:0.008447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113699 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='2944666651' and brandshort='fair-rite' limit 1 [ RunTime:0.000721s ]
select foldpath,foldpath2,filename from pdf_file where id=1185792 limit 1 [ RunTime:0.000302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666651' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113699 AND `partno` = '2944666651' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.013209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126423 [ RunTime:0.000617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212272 [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126606 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126606 ORDER BY `minOrder` ASC [ RunTime:0.001287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51126606 ORDER BY `unit` DESC [ RunTime:0.001977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51126606 LIMIT 2 [ RunTime:0.000906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51126606 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='2944666634' and brandshort='fair-rite' limit 1 [ RunTime:0.001209s ]
select foldpath,foldpath2,filename from pdf_file where id=1185791 limit 1 [ RunTime:0.000391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666634' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 51126606 AND `partno` = '2944666634' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114022 [ RunTime:0.003271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944371 [ RunTime:0.001743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51114022 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114022 ORDER BY `minOrder` ASC [ RunTime:0.006384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51114022 ORDER BY `unit` DESC [ RunTime:0.004870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51114022 LIMIT 2 [ RunTime:0.001913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51114022 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='2944666634' and brandshort='fair-rite' limit 1 [ RunTime:0.000715s ]
select foldpath,foldpath2,filename from pdf_file where id=1185791 limit 1 [ RunTime:0.000320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666634' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.000379s ]
SELECT `id` FROM `stock` WHERE `id` <> 51114022 AND `partno` = '2944666634' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.001293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51126606 [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944371 [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127588 LIMIT 5 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127588 ORDER BY `minOrder` ASC [ RunTime:0.000873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127588 ORDER BY `unit` DESC [ RunTime:0.005039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127588 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127588 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
select * from pdf where partno='2944666661' and brandshort='fair-rite' limit 1 [ RunTime:0.001139s ]
select foldpath,foldpath2,filename from pdf_file where id=1187021 limit 1 [ RunTime:0.000440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666661' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.003289s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127588 AND `partno` = '2944666661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.006294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211869 [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127543 LIMIT 5 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127543 ORDER BY `minOrder` ASC [ RunTime:0.001071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127543 ORDER BY `unit` DESC [ RunTime:0.003185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127543 LIMIT 2 [ RunTime:0.003136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127543 ORDER BY `minOrder` ASC [ RunTime:0.004600s ]
select * from pdf where partno='2944666681' and brandshort='fair-rite' limit 1 [ RunTime:0.003722s ]
select foldpath,foldpath2,filename from pdf_file where id=1187023 limit 1 [ RunTime:0.003228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666681' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.011431s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127543 AND `partno` = '2944666681' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.005829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943992 [ RunTime:0.006429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32197468 LIMIT 5 [ RunTime:0.003580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32197468 ORDER BY `minOrder` ASC [ RunTime:0.003450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32197468 ORDER BY `unit` DESC [ RunTime:0.003737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32197468 LIMIT 2 [ RunTime:0.005648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32197468 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='2944777741' and brandshort='fair-rite' limit 1 [ RunTime:0.001043s ]
select foldpath,foldpath2,filename from pdf_file where id=1187027 limit 1 [ RunTime:0.002176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944777741' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.003609s ]
SELECT `id` FROM `stock` WHERE `id` <> 32197468 AND `partno` = '2944777741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.001378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943998 [ RunTime:0.009060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127746 LIMIT 5 [ RunTime:0.006781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127746 ORDER BY `minOrder` ASC [ RunTime:0.004610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127746 ORDER BY `unit` DESC [ RunTime:0.007524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127746 LIMIT 2 [ RunTime:0.012333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127746 ORDER BY `minOrder` ASC [ RunTime:0.014527s ]
select * from pdf where partno='2944778101' and brandshort='fair-rite' limit 1 [ RunTime:0.006816s ]
select foldpath,foldpath2,filename from pdf_file where id=1187028 limit 1 [ RunTime:0.007735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944778101' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.009628s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127746 AND `partno` = '2944778101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.015491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944375 [ RunTime:0.003553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127615 LIMIT 5 [ RunTime:0.003907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127615 ORDER BY `minOrder` ASC [ RunTime:0.014978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127615 ORDER BY `unit` DESC [ RunTime:0.007565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127615 LIMIT 2 [ RunTime:0.001194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127615 ORDER BY `minOrder` ASC [ RunTime:0.011663s ]
select * from pdf where partno='2944776101' and brandshort='fair-rite' limit 1 [ RunTime:0.002917s ]
select foldpath,foldpath2,filename from pdf_file where id=1187025 limit 1 [ RunTime:0.000593s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944776101' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.003229s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127615 AND `partno` = '2944776101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.018113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37540975 [ RunTime:0.012494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50343587 [ RunTime:0.025543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32198000 LIMIT 5 [ RunTime:0.019070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32198000 ORDER BY `minOrder` ASC [ RunTime:0.033890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32198000 ORDER BY `unit` DESC [ RunTime:0.012014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32198000 LIMIT 2 [ RunTime:0.001812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32198000 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='2944778102' and brandshort='fair-rite' limit 1 [ RunTime:0.004683s ]
select foldpath,foldpath2,filename from pdf_file where id=1098889 limit 1 [ RunTime:0.009500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944778102' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.022980s ]
SELECT `id` FROM `stock` WHERE `id` <> 32198000 AND `partno` = '2944778102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.001037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944723 [ RunTime:0.026757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127519 LIMIT 5 [ RunTime:0.012806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127519 ORDER BY `minOrder` ASC [ RunTime:0.010593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127519 ORDER BY `unit` DESC [ RunTime:0.012246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127519 LIMIT 2 [ RunTime:0.011125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127519 ORDER BY `minOrder` ASC [ RunTime:0.019286s ]
select * from pdf where partno='2944778301' and brandshort='fair-rite' limit 1 [ RunTime:0.022242s ]
select foldpath,foldpath2,filename from pdf_file where id=1187029 limit 1 [ RunTime:0.011689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944778301' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.002834s ]
SELECT `id` FROM `stock` WHERE `id` <> 51127519 AND `partno` = '2944778301' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.000950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944376 [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269831 LIMIT 5 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269831 ORDER BY `minOrder` ASC [ RunTime:0.006583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269831 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269831 LIMIT 2 [ RunTime:0.004402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269831 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
select * from pdf where partno='294711-e' and brandshort='te connectivity / erni' limit 1 [ RunTime:0.006414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294711-e' OR `brand` LIKE 'te connectivity / erni%' ) ) LIMIT 1 [ RunTime:0.000738s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269831 AND `partno` = '294711-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / erni%' ) [ RunTime:0.002080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32232618 LIMIT 5 [ RunTime:0.002531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232618 ORDER BY `minOrder` ASC [ RunTime:0.000943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32232618 ORDER BY `unit` DESC [ RunTime:0.000569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32232618 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32232618 ORDER BY `minOrder` ASC [ RunTime:0.001950s ]
select * from pdf where partno='294502' and brandshort='jkl components' limit 1 [ RunTime:0.002849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294502' OR `brand` LIKE 'jkl components%' ) ) LIMIT 1 [ RunTime:0.001093s ]
SELECT `id` FROM `stock` WHERE `id` <> 32232618 AND `partno` = '294502' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%jkl components%' ) [ RunTime:0.001668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32211022 LIMIT 5 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211022 ORDER BY `minOrder` ASC [ RunTime:0.000984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32211022 ORDER BY `unit` DESC [ RunTime:0.003907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32211022 LIMIT 2 [ RunTime:0.001221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32211022 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
select * from pdf where partno='2945' and brandshort='visaton' limit 1 [ RunTime:0.003398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2945' OR `brand` LIKE 'visaton%' ) ) LIMIT 1 [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32209900 LIMIT 5 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32209900 ORDER BY `minOrder` ASC [ RunTime:0.001978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32209900 ORDER BY `unit` DESC [ RunTime:0.002544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32209900 LIMIT 2 [ RunTime:0.001194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32209900 ORDER BY `minOrder` ASC [ RunTime:0.000216s ]
select * from pdf where partno='2941' and brandshort='visaton' limit 1 [ RunTime:0.000840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2941' OR `brand` LIKE 'visaton%' ) ) LIMIT 1 [ RunTime:0.002733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269217 LIMIT 5 [ RunTime:0.006350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269217 ORDER BY `minOrder` ASC [ RunTime:0.005068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269217 ORDER BY `unit` DESC [ RunTime:0.001133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269217 LIMIT 2 [ RunTime:0.002387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269217 ORDER BY `minOrder` ASC [ RunTime:0.004809s ]
select * from pdf where partno='294029-e' and brandshort='te connectivity / erni' limit 1 [ RunTime:0.000739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294029-e' OR `brand` LIKE 'te connectivity / erni%' ) ) LIMIT 1 [ RunTime:0.001497s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269217 AND `partno` = '294029-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / erni%' ) [ RunTime:0.002475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51096816 LIMIT 5 [ RunTime:0.004464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096816 ORDER BY `minOrder` ASC [ RunTime:0.005700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51096816 ORDER BY `unit` DESC [ RunTime:0.001512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51096816 LIMIT 2 [ RunTime:0.003482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51096816 ORDER BY `minOrder` ASC [ RunTime:0.002963s ]
select * from pdf where partno='2940' and brandshort='adafruit' limit 1 [ RunTime:0.009578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2940' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.008246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51072904 LIMIT 5 [ RunTime:0.014913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072904 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51072904 ORDER BY `unit` DESC [ RunTime:0.002633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51072904 LIMIT 2 [ RunTime:0.004184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51072904 ORDER BY `minOrder` ASC [ RunTime:0.007064s ]
select * from pdf where partno='2943712' and brandshort='phoenix contact' limit 1 [ RunTime:0.003631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2943712' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.006695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32210151 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32210151 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32210151 ORDER BY `unit` DESC [ RunTime:0.001682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32210151 LIMIT 2 [ RunTime:0.004650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32210151 ORDER BY `minOrder` ASC [ RunTime:0.007570s ]
select * from pdf where partno='2947' and brandshort='visaton' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2947' OR `brand` LIKE 'visaton%' ) ) LIMIT 1 [ RunTime:0.008859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51090137 LIMIT 5 [ RunTime:0.025595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090137 ORDER BY `minOrder` ASC [ RunTime:0.003073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51090137 ORDER BY `unit` DESC [ RunTime:0.001163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51090137 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51090137 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='294gb-5028' and brandshort='amphenol ltd' limit 1 [ RunTime:0.001302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294gb-5028' OR `brand` LIKE 'amphenol ltd%' ) ) LIMIT 1 [ RunTime:0.010953s ]
SELECT `id` FROM `stock` WHERE `id` <> 51090137 AND `partno` = '294gb-5028' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol ltd%' ) [ RunTime:0.005033s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57344786 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344786 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57344786 ORDER BY `unit` DESC [ RunTime:0.002748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57344786 LIMIT 2 [ RunTime:0.006304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344786 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='2944666631' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.005162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666631' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.013201s ]
SELECT `id` FROM `stock` WHERE `id` <> 57344786 AND `partno` = '2944666631' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.007919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944797 [ RunTime:0.022702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57343857 LIMIT 5 [ RunTime:0.008073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57343857 ORDER BY `minOrder` ASC [ RunTime:0.028141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57343857 ORDER BY `unit` DESC [ RunTime:0.010131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57343857 LIMIT 2 [ RunTime:0.013075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57343857 ORDER BY `minOrder` ASC [ RunTime:0.011166s ]
select * from pdf where partno='2944666671' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.013680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666671' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000984s ]
SELECT `id` FROM `stock` WHERE `id` <> 57343857 AND `partno` = '2944666671' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13212442 [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57344793 LIMIT 5 [ RunTime:0.010074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344793 ORDER BY `minOrder` ASC [ RunTime:0.005837s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57344793 ORDER BY `unit` DESC [ RunTime:0.004767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57344793 LIMIT 2 [ RunTime:0.002157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344793 ORDER BY `minOrder` ASC [ RunTime:0.004274s ]
select * from pdf where partno='2944666661' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.003560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666661' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.014567s ]
SELECT `id` FROM `stock` WHERE `id` <> 57344793 AND `partno` = '2944666661' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211869 [ RunTime:0.003497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50342844 LIMIT 5 [ RunTime:0.010617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50342844 ORDER BY `minOrder` ASC [ RunTime:0.017466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50342844 ORDER BY `unit` DESC [ RunTime:0.009013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50342844 LIMIT 2 [ RunTime:0.011610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50342844 ORDER BY `minOrder` ASC [ RunTime:0.002444s ]
select * from pdf where partno='2944666634' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.012656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666634' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.006927s ]
SELECT `id` FROM `stock` WHERE `id` <> 50342844 AND `partno` = '2944666634' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.011194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944371 [ RunTime:0.011614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52578752 LIMIT 5 [ RunTime:0.019314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578752 ORDER BY `minOrder` ASC [ RunTime:0.027642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52578752 ORDER BY `unit` DESC [ RunTime:0.006629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52578752 LIMIT 2 [ RunTime:0.015566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52578752 ORDER BY `minOrder` ASC [ RunTime:0.004329s ]
select * from pdf where partno='294919-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.014533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294919-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.007169s ]
SELECT `id` FROM `stock` WHERE `id` <> 52578752 AND `partno` = '294919-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.011333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196027 [ RunTime:0.008983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57347119 LIMIT 5 [ RunTime:0.011228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57347119 ORDER BY `minOrder` ASC [ RunTime:0.012139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57347119 ORDER BY `unit` DESC [ RunTime:0.003232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57347119 LIMIT 2 [ RunTime:0.008232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57347119 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='2943666631' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.019827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2943666631' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.021414s ]
SELECT `id` FROM `stock` WHERE `id` <> 57347119 AND `partno` = '2943666631' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.033882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943976 [ RunTime:0.014963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51219046 LIMIT 5 [ RunTime:0.004939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51219046 ORDER BY `minOrder` ASC [ RunTime:0.004934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51219046 ORDER BY `unit` DESC [ RunTime:0.001073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51219046 LIMIT 2 [ RunTime:0.004160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51219046 ORDER BY `minOrder` ASC [ RunTime:0.015078s ]
select * from pdf where partno='294' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.010304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.012172s ]
SELECT `id` FROM `stock` WHERE `id` <> 51219046 AND `partno` = '294' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.048717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388646 [ RunTime:0.011053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57736536 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57736536 ORDER BY `minOrder` ASC [ RunTime:0.020007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57736536 ORDER BY `unit` DESC [ RunTime:0.000720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57736536 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57736536 ORDER BY `minOrder` ASC [ RunTime:0.002945s ]
select * from pdf where partno='2942CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2942CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013834s ]
SELECT `id` FROM `stock` WHERE `id` <> 57736536 AND `partno` = '2942CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346994 [ RunTime:0.004425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56973692 LIMIT 5 [ RunTime:0.003570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56973692 ORDER BY `minOrder` ASC [ RunTime:0.003226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56973692 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56973692 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56973692 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
select * from pdf where partno='2946PC' and brandshort='Rochester Electronics, LLC' limit 1 [ RunTime:0.000802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2946PC' OR `brand` LIKE 'Rochester Electronics, LLC%' ) ) LIMIT 1 [ RunTime:0.001405s ]
SELECT `id` FROM `stock` WHERE `id` <> 56973692 AND `partno` = '2946PC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rochester electronics, llc%' ) [ RunTime:0.006506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19185187 [ RunTime:0.002990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37540239 LIMIT 5 [ RunTime:0.002540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37540239 ORDER BY `minOrder` ASC [ RunTime:0.002692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37540239 ORDER BY `unit` DESC [ RunTime:0.000849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37540239 LIMIT 2 [ RunTime:0.003774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37540239 ORDER BY `minOrder` ASC [ RunTime:0.000646s ]
select * from pdf where partno='2944666634' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944666634' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 37540239 AND `partno` = '2944666634' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.000839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944371 [ RunTime:0.006392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52635692 LIMIT 5 [ RunTime:0.002392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52635692 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52635692 ORDER BY `unit` DESC [ RunTime:0.002171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52635692 LIMIT 2 [ RunTime:0.002666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52635692 ORDER BY `minOrder` ASC [ RunTime:0.002855s ]
select * from pdf where partno='294647-E' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294647-E' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004367s ]
SELECT `id` FROM `stock` WHERE `id` <> 52635692 AND `partno` = '294647-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.006218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16200959 [ RunTime:0.003107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50343588 LIMIT 5 [ RunTime:0.002656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50343588 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50343588 ORDER BY `unit` DESC [ RunTime:0.003266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50343588 LIMIT 2 [ RunTime:0.000983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50343588 ORDER BY `minOrder` ASC [ RunTime:0.000184s ]
select * from pdf where partno='2944778101' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944778101' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002456s ]
SELECT `id` FROM `stock` WHERE `id` <> 50343588 AND `partno` = '2944778101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.003900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944375 [ RunTime:0.000235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37540976 LIMIT 5 [ RunTime:0.000354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37540976 ORDER BY `minOrder` ASC [ RunTime:0.003130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37540976 ORDER BY `unit` DESC [ RunTime:0.001104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37540976 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37540976 ORDER BY `minOrder` ASC [ RunTime:0.002513s ]
select * from pdf where partno='2944778101' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000304s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944778101' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000223s ]
SELECT `id` FROM `stock` WHERE `id` <> 37540976 AND `partno` = '2944778101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.000518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11944375 [ RunTime:0.005052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52573776 LIMIT 5 [ RunTime:0.016245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52573776 ORDER BY `minOrder` ASC [ RunTime:0.011229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52573776 ORDER BY `unit` DESC [ RunTime:0.005870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52573776 LIMIT 2 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52573776 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='294920-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.000666s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294920-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.002580s ]
SELECT `id` FROM `stock` WHERE `id` <> 52573776 AND `partno` = '294920-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.010261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16228694 [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51183688 LIMIT 5 [ RunTime:0.005900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51183688 ORDER BY `minOrder` ASC [ RunTime:0.006820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51183688 ORDER BY `unit` DESC [ RunTime:0.002239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51183688 LIMIT 2 [ RunTime:0.003713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51183688 ORDER BY `minOrder` ASC [ RunTime:0.000237s ]
select * from pdf where partno='294SN-T1013Z' and brandshort='Toko America Inc.' limit 1 [ RunTime:0.002346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294SN-T1013Z' OR `brand` LIKE 'Toko America Inc.%' ) ) LIMIT 1 [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52496451 LIMIT 5 [ RunTime:0.006128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52496451 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52496451 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52496451 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52496451 ORDER BY `minOrder` ASC [ RunTime:0.002167s ]
select * from pdf where partno='294003-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.007043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294003-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.007302s ]
SELECT `id` FROM `stock` WHERE `id` <> 52496451 AND `partno` = '294003-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.011720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12790017 [ RunTime:0.015681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57344823 LIMIT 5 [ RunTime:0.001627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344823 ORDER BY `minOrder` ASC [ RunTime:0.004220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57344823 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57344823 LIMIT 2 [ RunTime:0.002367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57344823 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='2944777741' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.005650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2944777741' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.003841s ]
SELECT `id` FROM `stock` WHERE `id` <> 57344823 AND `partno` = '2944777741' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.016107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943998 [ RunTime:0.007834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52579159 LIMIT 5 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52579159 ORDER BY `minOrder` ASC [ RunTime:0.003800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52579159 ORDER BY `unit` DESC [ RunTime:0.004129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52579159 LIMIT 2 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52579159 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='294648-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.002625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294648-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.002955s ]
SELECT `id` FROM `stock` WHERE `id` <> 52579159 AND `partno` = '294648-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.007223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19837576 [ RunTime:0.004857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52584711 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52584711 ORDER BY `minOrder` ASC [ RunTime:0.003177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52584711 ORDER BY `unit` DESC [ RunTime:0.004192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52584711 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52584711 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
select * from pdf where partno='294646-E' and brandshort='TE Connectivity Erni' limit 1 [ RunTime:0.015977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '294646-E' OR `brand` LIKE 'TE Connectivity Erni%' ) ) LIMIT 1 [ RunTime:0.008710s ]
SELECT `id` FROM `stock` WHERE `id` <> 52584711 AND `partno` = '294646-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity erni%' ) [ RunTime:0.004130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19836334 [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57739692 LIMIT 5 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739692 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57739692 ORDER BY `unit` DESC [ RunTime:0.013664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57739692 LIMIT 2 [ RunTime:0.004453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57739692 ORDER BY `minOrder` ASC [ RunTime:0.003615s ]
select * from pdf where partno='2940CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.002803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2940CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.002974s ]
SELECT `id` FROM `stock` WHERE `id` <> 57739692 AND `partno` = '2940CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066914 [ RunTime:0.001031s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001278s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004173s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008692s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001360s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015836s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001593s ]
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 ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009201s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '294%' OR `brand` LIKE '294%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009255s ]