SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001985s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.25' , `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=510&search=1' [ RunTime:0.003704s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002318s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001907s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003156s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.25' ) [ RunTime:0.000561s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002202s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002180s ]
SELECT * FROM `stock_search` WHERE `partno` = '510' LIMIT 1 [ RunTime:0.000973s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-10-23 13:13:39' WHERE `partno` = '510' [ RunTime:0.001754s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003173s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.208413s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20123515 LIMIT 5 [ RunTime:0.001446s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123515 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20123515 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20123515 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20123515 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666788 LIMIT 5 [ RunTime:0.000913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666788 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666788 ORDER BY `unit` DESC [ RunTime:0.000459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666788 LIMIT 2 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666788 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8381 LIMIT 5 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8381 ORDER BY `minOrder` ASC [ RunTime:0.000879s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8381 ORDER BY `unit` DESC [ RunTime:0.000611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8381 LIMIT 2 [ RunTime:0.001060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8381 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51065-0600' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.012333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747062 LIMIT 5 [ RunTime:0.001370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747062 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19747062 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19747062 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747062 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486215 LIMIT 5 [ RunTime:0.000847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486215 ORDER BY `minOrder` ASC [ RunTime:0.000396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486215 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486215 LIMIT 2 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486215 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667118 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667118 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667118 ORDER BY `unit` DESC [ RunTime:0.000447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667118 LIMIT 2 [ RunTime:0.000416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667118 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666789 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666789 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666789 ORDER BY `unit` DESC [ RunTime:0.000384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666789 LIMIT 2 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666789 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14673 LIMIT 5 [ RunTime:0.000432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673 ORDER BY `minOrder` ASC [ RunTime:0.003534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14673 ORDER BY `unit` DESC [ RunTime:0.000748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14673 LIMIT 2 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14673 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
select * from pdf where partno='51021-0400' and brandshort='MOLEX' limit 1 [ RunTime:0.001111s ]
select foldpath,foldpath2,filename from pdf_file where id=824931 limit 1 [ RunTime:0.000466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51021-0400' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.008558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18216517 LIMIT 5 [ RunTime:0.001423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18216517 ORDER BY `minOrder` ASC [ RunTime:0.000391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18216517 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18216517 LIMIT 2 [ RunTime:0.000338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18216517 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13956 LIMIT 5 [ RunTime:0.000715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13956 ORDER BY `minOrder` ASC [ RunTime:0.001261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13956 ORDER BY `unit` DESC [ RunTime:0.000576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13956 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13956 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='51021-0200' and brandshort='MOLEX' limit 1 [ RunTime:0.000892s ]
select foldpath,foldpath2,filename from pdf_file where id=824976 limit 1 [ RunTime:0.000457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51021-0200' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.012158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16869244 LIMIT 5 [ RunTime:0.001026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16869244 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16869244 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16869244 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16869244 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772257 LIMIT 5 [ RunTime:0.000928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772257 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772257 ORDER BY `unit` DESC [ RunTime:0.000515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772257 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772257 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667120 LIMIT 5 [ RunTime:0.000542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667120 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667120 ORDER BY `unit` DESC [ RunTime:0.000510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667120 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667120 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747059 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747059 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19747059 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19747059 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19747059 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19846722 LIMIT 5 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846722 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19846722 ORDER BY `unit` DESC [ RunTime:0.000514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19846722 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19846722 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
select * from pdf where partno='51025-03-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.000810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19802520 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19802520 ORDER BY `minOrder` ASC [ RunTime:0.000535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19802520 ORDER BY `unit` DESC [ RunTime:0.000507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19802520 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19802520 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666777 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666777 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19666777 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19666777 LIMIT 2 [ RunTime:0.000492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19666777 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484344 LIMIT 5 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484344 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15484344 ORDER BY `unit` DESC [ RunTime:0.000504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15484344 LIMIT 2 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484344 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19753317 LIMIT 5 [ RunTime:0.000923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19753317 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19753317 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19753317 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19753317 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610356 LIMIT 5 [ RunTime:0.000822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610356 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610356 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610356 LIMIT 2 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610356 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009171s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71807526 LIMIT 5 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807526 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71807526 ORDER BY `unit` DESC [ RunTime:0.000282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71807526 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807526 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='51065-1400' and brandshort='molex' limit 1 [ RunTime:0.001469s ]
select foldpath,foldpath2,filename from pdf_file where id=853304 limit 1 [ RunTime:0.000586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51065-1400' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.005433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71807764 LIMIT 5 [ RunTime:0.000346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807764 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71807764 ORDER BY `unit` DESC [ RunTime:0.000387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71807764 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71807764 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='51067-0300' and brandshort='molex' limit 1 [ RunTime:0.000613s ]
select foldpath,foldpath2,filename from pdf_file where id=828834 limit 1 [ RunTime:0.000574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51067-0300' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.005880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71801077 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71801077 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71801077 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71801077 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71801077 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='5100161-1' and brandshort='te connectivity' limit 1 [ RunTime:0.003306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100161-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696669 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696669 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696669 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696669 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696669 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='510bba100m000aagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.001855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510bba100m000aagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696669 AND `partno` = '510bba100m000aagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276891 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276891 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276891 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276891 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276891 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
select * from pdf where partno='5102154-4' and brandshort='te connectivity' limit 1 [ RunTime:0.000439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102154-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269679 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269679 ORDER BY `minOrder` ASC [ RunTime:0.000766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269679 ORDER BY `unit` DESC [ RunTime:0.000347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269679 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269679 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='5106775-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5106775-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000337s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269679 AND `partno` = '5106775-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32226596 LIMIT 5 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226596 ORDER BY `minOrder` ASC [ RunTime:0.000640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32226596 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32226596 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226596 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='5100h1/5' and brandshort='vcc' limit 1 [ RunTime:0.001006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100h1/5' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32183188 LIMIT 5 [ RunTime:0.000365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32183188 ORDER BY `minOrder` ASC [ RunTime:0.001157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32183188 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32183188 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32183188 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='5100h1/5' and brandshort='vcc' limit 1 [ RunTime:0.000791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100h1/5' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32158888 LIMIT 5 [ RunTime:0.000300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32158888 ORDER BY `minOrder` ASC [ RunTime:0.000851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32158888 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32158888 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32158888 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='5100h1/5' and brandshort='vcc' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100h1/5' OR `brand` LIKE 'vcc%' ) ) LIMIT 1 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309286 LIMIT 5 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309286 ORDER BY `minOrder` ASC [ RunTime:0.000698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309286 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309286 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309286 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='51000k' and brandshort='spotsee' limit 1 [ RunTime:0.000751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51000k' OR `brand` LIKE 'spotsee%' ) ) LIMIT 1 [ RunTime:0.000696s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309286 AND `partno` = '51000k' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%spotsee%' ) [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696670 LIMIT 5 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696670 ORDER BY `minOrder` ASC [ RunTime:0.000402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696670 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696670 LIMIT 2 [ RunTime:0.000327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696670 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='510fba200m000bagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.001442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510fba200m000bagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000411s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696670 AND `partno` = '510fba200m000bagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696598 LIMIT 5 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696598 ORDER BY `minOrder` ASC [ RunTime:0.000625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696598 ORDER BY `unit` DESC [ RunTime:0.000337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696598 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696598 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='510cba125m000aagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.000762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510cba125m000aagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696598 AND `partno` = '510cba125m000aagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696599 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696599 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696599 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696599 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696599 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='510cbb25m0000bagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.001245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510cbb25m0000bagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000399s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696599 AND `partno` = '510cbb25m0000bagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.001291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277098 LIMIT 5 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277098 ORDER BY `minOrder` ASC [ RunTime:0.001685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277098 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277098 LIMIT 2 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277098 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='5102154-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000682s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102154-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129225 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129225 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129225 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129225 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129225 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='510bba25m0000aagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.001021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510bba25m0000aagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000394s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129225 AND `partno` = '510bba25m0000aagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696651 LIMIT 5 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696651 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696651 ORDER BY `unit` DESC [ RunTime:0.000304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696651 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696651 ORDER BY `minOrder` ASC [ RunTime:0.000317s ]
select * from pdf where partno='510cba50m0000aagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.000770s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510cba50m0000aagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000393s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696651 AND `partno` = '510cba50m0000aagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71696611 LIMIT 5 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696611 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71696611 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71696611 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71696611 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='510fba100m000bag' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.001012s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510fba100m000bag' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000454s ]
SELECT `id` FROM `stock` WHERE `id` <> 71696611 AND `partno` = '510fba100m000bag' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.001567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32199721 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32199721 ORDER BY `minOrder` ASC [ RunTime:0.000922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32199721 ORDER BY `unit` DESC [ RunTime:0.000348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32199721 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32199721 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='510cba50m0000bagr' and brandshort='skyworks solutions, inc.' limit 1 [ RunTime:0.000817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510cba50m0000bagr' OR `brand` LIKE 'skyworks solutions, inc.%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 32199721 AND `partno` = '510cba50m0000bagr' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%skyworks solutions, inc.%' ) [ RunTime:0.000419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277315 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277315 ORDER BY `minOrder` ASC [ RunTime:0.001710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277315 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277315 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277315 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='5102156-4' and brandshort='te connectivity' limit 1 [ RunTime:0.000882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102156-4' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276655 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276655 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276655 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276655 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276655 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='5102321-5' and brandshort='te connectivity' limit 1 [ RunTime:0.000818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102321-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009040s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66742712 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66742712 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66742712 ORDER BY `unit` DESC [ RunTime:0.000365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66742712 LIMIT 2 [ RunTime:0.000326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66742712 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
select * from pdf where partno='510211400' and brandshort='Molex' limit 1 [ RunTime:0.000825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510211400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67206895 LIMIT 5 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67206895 ORDER BY `minOrder` ASC [ RunTime:0.000818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67206895 ORDER BY `unit` DESC [ RunTime:0.000345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67206895 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67206895 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='510060200' and brandshort='Molex' limit 1 [ RunTime:0.000774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510060200' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32908134 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908134 ORDER BY `minOrder` ASC [ RunTime:0.000697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32908134 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32908134 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908134 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
select * from pdf where partno='5106' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5106' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32908494 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908494 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32908494 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32908494 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908494 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='5108' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5108' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000396s ]
SELECT `id` FROM `stock` WHERE `id` <> 32908494 AND `partno` = '5108' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18216517 [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66158381 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158381 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66158381 ORDER BY `unit` DESC [ RunTime:0.000343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66158381 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158381 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='5102TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000420s ]
SELECT `id` FROM `stock` WHERE `id` <> 66158381 AND `partno` = '5102TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666788 [ RunTime:0.000361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66158452 LIMIT 5 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158452 ORDER BY `minOrder` ASC [ RunTime:0.000829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66158452 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66158452 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158452 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='5102' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5102' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000392s ]
SELECT `id` FROM `stock` WHERE `id` <> 66158452 AND `partno` = '5102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666777 [ RunTime:0.000380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66158395 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158395 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66158395 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66158395 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158395 ORDER BY `minOrder` ASC [ RunTime:0.000369s ]
select * from pdf where partno='5100TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000389s ]
SELECT `id` FROM `stock` WHERE `id` <> 66158395 AND `partno` = '5100TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19666789 [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66158382 LIMIT 5 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158382 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66158382 ORDER BY `unit` DESC [ RunTime:0.000334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66158382 LIMIT 2 [ RunTime:0.000318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158382 ORDER BY `minOrder` ASC [ RunTime:0.000364s ]
select * from pdf where partno='5104TR' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5104TR' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `id` FROM `stock` WHERE `id` <> 66158382 AND `partno` = '5104TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667298 [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67174686 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67174686 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67174686 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67174686 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67174686 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='510480300' and brandshort='Molex' limit 1 [ RunTime:0.000992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510480300' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66759545 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66759545 ORDER BY `minOrder` ASC [ RunTime:0.000970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66759545 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66759545 LIMIT 2 [ RunTime:0.000321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66759545 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='510971600' and brandshort='Molex' limit 1 [ RunTime:0.001302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510971600' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66242337 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242337 ORDER BY `minOrder` ASC [ RunTime:0.000790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66242337 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66242337 LIMIT 2 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242337 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='5103308-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000414s ]
SELECT `id` FROM `stock` WHERE `id` <> 66242337 AND `partno` = '5103308-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19747059 [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243640 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243640 ORDER BY `minOrder` ASC [ RunTime:0.000716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243640 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243640 LIMIT 2 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243640 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='51025-02-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51025-02-0100-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.000771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66158379 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158379 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66158379 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66158379 LIMIT 2 [ RunTime:0.000272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66158379 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='5104' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.002586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5104' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000402s ]
SELECT `id` FROM `stock` WHERE `id` <> 66158379 AND `partno` = '5104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667120 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32908653 LIMIT 5 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908653 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32908653 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32908653 LIMIT 2 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32908653 ORDER BY `minOrder` ASC [ RunTime:0.000382s ]
select * from pdf where partno='5109' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5109' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32995750 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32995750 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32995750 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32995750 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32995750 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='5107' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5107' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000329s ]
SELECT `id` FROM `stock` WHERE `id` <> 32995750 AND `partno` = '5107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18043387 [ RunTime:0.000577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41361602 LIMIT 5 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41361602 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41361602 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41361602 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41361602 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='5100H5' and brandshort='Visual Communications Company - VCC' limit 1 [ RunTime:0.001243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5100H5' OR `brand` LIKE 'Visual Communications Company - VCC%' ) ) LIMIT 1 [ RunTime:0.000405s ]
SELECT `id` FROM `stock` WHERE `id` <> 41361602 AND `partno` = '5100H5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%visual communications company - vcc%' ) [ RunTime:0.000393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18917800 [ RunTime:0.000555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66242431 LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242431 ORDER BY `minOrder` ASC [ RunTime:0.000678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66242431 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66242431 LIMIT 2 [ RunTime:0.000279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242431 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='5103309-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103309-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000407s ]
SELECT `id` FROM `stock` WHERE `id` <> 66242431 AND `partno` = '5103309-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19753317 [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66242685 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242685 ORDER BY `minOrder` ASC [ RunTime:0.002876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66242685 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66242685 LIMIT 2 [ RunTime:0.000311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66242685 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='5103308-5' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5103308-5' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000341s ]
SELECT `id` FROM `stock` WHERE `id` <> 66242685 AND `partno` = '5103308-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15476840 [ RunTime:0.000805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243879 LIMIT 5 [ RunTime:0.000290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243879 ORDER BY `minOrder` ASC [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243879 ORDER BY `unit` DESC [ RunTime:0.000292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243879 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243879 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='51025-06-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.000730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51025-06-0100-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 66243669 LIMIT 5 [ RunTime:0.000347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243669 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 66243669 ORDER BY `unit` DESC [ RunTime:0.000350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 66243669 LIMIT 2 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 66243669 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='51025-03-0100-01' and brandshort='CNC Tech' limit 1 [ RunTime:0.000958s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '51025-03-0100-01' OR `brand` LIKE 'CNC Tech%' ) ) LIMIT 1 [ RunTime:0.000503s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000741s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000528s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000508s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000509s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000588s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000569s ]
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 '510%' OR `brand` LIKE '510%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839832 LIMIT 5 [ RunTime:0.000289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839832 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839832 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839832 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839832 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='510210200' and brandshort='MOLEX' limit 1 [ RunTime:0.000779s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510210200' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64840201 LIMIT 5 [ RunTime:0.000341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840201 ORDER BY `minOrder` ASC [ RunTime:0.000694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64840201 ORDER BY `unit` DESC [ RunTime:0.000341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64840201 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840201 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='510210600' and brandshort='MOLEX' limit 1 [ RunTime:0.000759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510210600' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64840196 LIMIT 5 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840196 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64840196 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64840196 LIMIT 2 [ RunTime:0.000271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64840196 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='510210500' and brandshort='MOLEX' limit 1 [ RunTime:0.000732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510210500' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64839571 LIMIT 5 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839571 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64839571 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64839571 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64839571 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
select * from pdf where partno='510210400' and brandshort='MOLEX' limit 1 [ RunTime:0.000656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510210400' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51014750 LIMIT 5 [ RunTime:0.000348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014750 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51014750 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51014750 LIMIT 2 [ RunTime:0.000320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51014750 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='510211000' and brandshort='MOLEX' limit 1 [ RunTime:0.000761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '510211000' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.005534s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '510%' OR `brand` LIKE '510%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022998s ]