SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001576s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=MEC1-130-02-F-D&search=1' [ RunTime:0.021409s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002190s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000597s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002006s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.042422s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001488s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.025291s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001277s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MEC1-130-02-F-D' LIMIT 1 [ RunTime:0.074090s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 07:40:06' WHERE `partno` = 'MEC1-130-02-F-D' [ RunTime:0.025901s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001391s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033230s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15509182 LIMIT 5 [ RunTime:0.051168s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.032072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509182 ORDER BY `minOrder` ASC [ RunTime:0.020346s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15509182 ORDER BY `unit` DESC [ RunTime:0.044270s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15509182 LIMIT 2 [ RunTime:0.063210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15509182 ORDER BY `minOrder` ASC [ RunTime:0.033287s ]
select * from pdf where partno='MEC1-130-02-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16341131 LIMIT 5 [ RunTime:0.025059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16341131 ORDER BY `minOrder` ASC [ RunTime:0.004025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16341131 ORDER BY `unit` DESC [ RunTime:0.013740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16341131 LIMIT 2 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16341131 ORDER BY `minOrder` ASC [ RunTime:0.012448s ]
select * from pdf where partno='MEC1-130-02-F-D-RA1-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19873322 LIMIT 5 [ RunTime:0.014085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19873322 ORDER BY `minOrder` ASC [ RunTime:0.030447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19873322 ORDER BY `unit` DESC [ RunTime:0.158565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19873322 LIMIT 2 [ RunTime:0.107170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19873322 ORDER BY `minOrder` ASC [ RunTime:0.019823s ]
select * from pdf where partno='MEC1-130-02-F-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869250 LIMIT 5 [ RunTime:0.015608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869250 ORDER BY `minOrder` ASC [ RunTime:0.044909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869250 ORDER BY `unit` DESC [ RunTime:0.107006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869250 LIMIT 2 [ RunTime:0.027594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869250 ORDER BY `minOrder` ASC [ RunTime:0.031108s ]
select * from pdf where partno='MEC1-130-02-F-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20065973 LIMIT 5 [ RunTime:0.016563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065973 ORDER BY `minOrder` ASC [ RunTime:0.014755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20065973 ORDER BY `unit` DESC [ RunTime:0.003465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20065973 LIMIT 2 [ RunTime:0.009183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065973 ORDER BY `minOrder` ASC [ RunTime:0.005209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20065972 LIMIT 5 [ RunTime:0.023873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065972 ORDER BY `minOrder` ASC [ RunTime:0.002092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20065972 ORDER BY `unit` DESC [ RunTime:0.000677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20065972 LIMIT 2 [ RunTime:0.002872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065972 ORDER BY `minOrder` ASC [ RunTime:0.005799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20065971 LIMIT 5 [ RunTime:0.014285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065971 ORDER BY `minOrder` ASC [ RunTime:0.003740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20065971 ORDER BY `unit` DESC [ RunTime:0.020837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20065971 LIMIT 2 [ RunTime:0.007702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20065971 ORDER BY `minOrder` ASC [ RunTime:0.005071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20060642 LIMIT 5 [ RunTime:0.010010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060642 ORDER BY `minOrder` ASC [ RunTime:0.016236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20060642 ORDER BY `unit` DESC [ RunTime:0.007844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20060642 LIMIT 2 [ RunTime:0.006841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060642 ORDER BY `minOrder` ASC [ RunTime:0.001528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869136 LIMIT 5 [ RunTime:0.009473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869136 ORDER BY `minOrder` ASC [ RunTime:0.003983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869136 ORDER BY `unit` DESC [ RunTime:0.006484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869136 LIMIT 2 [ RunTime:0.002127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869136 ORDER BY `minOrder` ASC [ RunTime:0.001315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869119 LIMIT 5 [ RunTime:0.003183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869119 ORDER BY `minOrder` ASC [ RunTime:0.001416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869119 ORDER BY `unit` DESC [ RunTime:0.002377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869119 LIMIT 2 [ RunTime:0.005143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869119 ORDER BY `minOrder` ASC [ RunTime:0.000597s ]
select * from pdf where partno='MEC1-130-02-F-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869115 LIMIT 5 [ RunTime:0.011042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869115 ORDER BY `minOrder` ASC [ RunTime:0.002254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869115 ORDER BY `unit` DESC [ RunTime:0.001512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869115 LIMIT 2 [ RunTime:0.001610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869115 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19868822 LIMIT 5 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19868822 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19868822 ORDER BY `unit` DESC [ RunTime:0.002495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19868822 LIMIT 2 [ RunTime:0.006806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19868822 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866904 LIMIT 5 [ RunTime:0.003847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866904 ORDER BY `minOrder` ASC [ RunTime:0.002434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19866904 ORDER BY `unit` DESC [ RunTime:0.004228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19866904 LIMIT 2 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866904 ORDER BY `minOrder` ASC [ RunTime:0.003126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16345391 LIMIT 5 [ RunTime:0.002795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16345391 ORDER BY `minOrder` ASC [ RunTime:0.000866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16345391 ORDER BY `unit` DESC [ RunTime:0.008845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16345391 LIMIT 2 [ RunTime:0.003025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16345391 ORDER BY `minOrder` ASC [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16336034 LIMIT 5 [ RunTime:0.003917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16336034 ORDER BY `minOrder` ASC [ RunTime:0.004660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16336034 ORDER BY `unit` DESC [ RunTime:0.003822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16336034 LIMIT 2 [ RunTime:0.003501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16336034 ORDER BY `minOrder` ASC [ RunTime:0.004489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241202 LIMIT 5 [ RunTime:0.005672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241202 ORDER BY `minOrder` ASC [ RunTime:0.006465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16241202 ORDER BY `unit` DESC [ RunTime:0.001637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16241202 LIMIT 2 [ RunTime:0.016442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241202 ORDER BY `minOrder` ASC [ RunTime:0.006628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241201 LIMIT 5 [ RunTime:0.002837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241201 ORDER BY `minOrder` ASC [ RunTime:0.004992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16241201 ORDER BY `unit` DESC [ RunTime:0.004283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16241201 LIMIT 2 [ RunTime:0.001632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241201 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241200 LIMIT 5 [ RunTime:0.004688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241200 ORDER BY `minOrder` ASC [ RunTime:0.008587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16241200 ORDER BY `unit` DESC [ RunTime:0.010013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16241200 LIMIT 2 [ RunTime:0.016986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241200 ORDER BY `minOrder` ASC [ RunTime:0.012901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12853611 LIMIT 5 [ RunTime:0.015001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12853611 ORDER BY `minOrder` ASC [ RunTime:0.003232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12853611 ORDER BY `unit` DESC [ RunTime:0.023096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12853611 LIMIT 2 [ RunTime:0.006691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12853611 ORDER BY `minOrder` ASC [ RunTime:0.007036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12853610 LIMIT 5 [ RunTime:0.009959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12853610 ORDER BY `minOrder` ASC [ RunTime:0.000987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12853610 ORDER BY `unit` DESC [ RunTime:0.013008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12853610 LIMIT 2 [ RunTime:0.009297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12853610 ORDER BY `minOrder` ASC [ RunTime:0.004098s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259721 LIMIT 5 [ RunTime:0.005681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259721 ORDER BY `minOrder` ASC [ RunTime:0.007552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259721 ORDER BY `unit` DESC [ RunTime:0.003537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259721 LIMIT 2 [ RunTime:0.006677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259721 ORDER BY `minOrder` ASC [ RunTime:0.008189s ]
select * from pdf where partno='mec1-130-02-f-d-a' and brandshort='samtec' limit 1 [ RunTime:0.002300s ]
select foldpath,foldpath2,filename from pdf_file where id=1781181 limit 1 [ RunTime:0.008175s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-130-02-f-d-a' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.010352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259722 LIMIT 5 [ RunTime:0.009472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259722 ORDER BY `minOrder` ASC [ RunTime:0.004914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259722 ORDER BY `unit` DESC [ RunTime:0.005019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259722 LIMIT 2 [ RunTime:0.014872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259722 ORDER BY `minOrder` ASC [ RunTime:0.005646s ]
select * from pdf where partno='mec1-130-02-f-d-em2-tr' and brandshort='samtec' limit 1 [ RunTime:0.010529s ]
select foldpath,foldpath2,filename from pdf_file where id=1820239 limit 1 [ RunTime:0.005991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-130-02-f-d-em2-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.014027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259152 LIMIT 5 [ RunTime:0.007464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259152 ORDER BY `minOrder` ASC [ RunTime:0.003311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259152 ORDER BY `unit` DESC [ RunTime:0.000622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259152 LIMIT 2 [ RunTime:0.005745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259152 ORDER BY `minOrder` ASC [ RunTime:0.003307s ]
select * from pdf where partno='mec1-130-02-f-d-np-a-k-fr' and brandshort='samtec' limit 1 [ RunTime:0.002026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-130-02-f-d-np-a-k-fr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.007593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259723 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259723 ORDER BY `minOrder` ASC [ RunTime:0.002480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259723 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259723 LIMIT 2 [ RunTime:0.002106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259723 ORDER BY `minOrder` ASC [ RunTime:0.002400s ]
select * from pdf where partno='mec1-130-02-f-d-np-a-k' and brandshort='samtec' limit 1 [ RunTime:0.000642s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-130-02-f-d-np-a-k' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.004082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259724 LIMIT 5 [ RunTime:0.004009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259724 ORDER BY `minOrder` ASC [ RunTime:0.006125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259724 ORDER BY `unit` DESC [ RunTime:0.001366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259724 LIMIT 2 [ RunTime:0.007335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259724 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
select * from pdf where partno='mec1-130-02-f-d-ra1-sl' and brandshort='samtec' limit 1 [ RunTime:0.001434s ]
select foldpath,foldpath2,filename from pdf_file where id=1795258 limit 1 [ RunTime:0.000506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-130-02-f-d-ra1-sl' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.004700s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58734741 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734741 ORDER BY `minOrder` ASC [ RunTime:0.004458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58734741 ORDER BY `unit` DESC [ RunTime:0.005238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58734741 LIMIT 2 [ RunTime:0.005324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734741 ORDER BY `minOrder` ASC [ RunTime:0.002689s ]
select * from pdf where partno='MEC1-130-02-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000331s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58734765 LIMIT 5 [ RunTime:0.004563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734765 ORDER BY `minOrder` ASC [ RunTime:0.002373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58734765 ORDER BY `unit` DESC [ RunTime:0.001924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58734765 LIMIT 2 [ RunTime:0.005160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58734765 ORDER BY `minOrder` ASC [ RunTime:0.007370s ]
select * from pdf where partno='MEC1-130-02-F-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000872s ]
SELECT `id` FROM `stock` WHERE `id` <> 58734765 AND `partno` = 'MEC1-130-02-F-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19873322 [ RunTime:0.003630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58735295 LIMIT 5 [ RunTime:0.007632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735295 ORDER BY `minOrder` ASC [ RunTime:0.005247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58735295 ORDER BY `unit` DESC [ RunTime:0.002128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58735295 LIMIT 2 [ RunTime:0.008678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58735295 ORDER BY `minOrder` ASC [ RunTime:0.007109s ]
select * from pdf where partno='MEC1-130-02-F-D-RA1-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-RA1-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000677s ]
SELECT `id` FROM `stock` WHERE `id` <> 58735295 AND `partno` = 'MEC1-130-02-F-D-RA1-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16341131 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58736659 LIMIT 5 [ RunTime:0.002195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736659 ORDER BY `minOrder` ASC [ RunTime:0.003227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58736659 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58736659 LIMIT 2 [ RunTime:0.003150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736659 ORDER BY `minOrder` ASC [ RunTime:0.003081s ]
select * from pdf where partno='MEC1-130-02-F-D-EM2-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001193s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-EM2-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002501s ]
SELECT `id` FROM `stock` WHERE `id` <> 58736659 AND `partno` = 'MEC1-130-02-F-D-EM2-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12826523 [ RunTime:0.003411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58736383 LIMIT 5 [ RunTime:0.001721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736383 ORDER BY `minOrder` ASC [ RunTime:0.003035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58736383 ORDER BY `unit` DESC [ RunTime:0.000352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58736383 LIMIT 2 [ RunTime:0.003302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58736383 ORDER BY `minOrder` ASC [ RunTime:0.002502s ]
select * from pdf where partno='MEC1-130-02-F-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-EM2' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58803768 LIMIT 5 [ RunTime:0.003241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58803768 ORDER BY `minOrder` ASC [ RunTime:0.002985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58803768 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58803768 LIMIT 2 [ RunTime:0.002394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58803768 ORDER BY `minOrder` ASC [ RunTime:0.003036s ]
select * from pdf where partno='MEC1-130-02-F-D-EM2-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000912s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-EM2-NP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001777s ]
SELECT `id` FROM `stock` WHERE `id` <> 58803768 AND `partno` = 'MEC1-130-02-F-D-EM2-NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16336034 [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58763000 LIMIT 5 [ RunTime:0.000950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58763000 ORDER BY `minOrder` ASC [ RunTime:0.002647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58763000 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58763000 LIMIT 2 [ RunTime:0.003195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58763000 ORDER BY `minOrder` ASC [ RunTime:0.002454s ]
select * from pdf where partno='MEC1-130-02-F-D-RA1-NP-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-RA1-NP-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 58763000 AND `partno` = 'MEC1-130-02-F-D-RA1-NP-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11653427 [ RunTime:0.000810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58762997 LIMIT 5 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762997 ORDER BY `minOrder` ASC [ RunTime:0.002633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58762997 ORDER BY `unit` DESC [ RunTime:0.003817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58762997 LIMIT 2 [ RunTime:0.007010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762997 ORDER BY `minOrder` ASC [ RunTime:0.006756s ]
select * from pdf where partno='MEC1-130-02-F-D-RA2-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003270s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-RA2-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000602s ]
SELECT `id` FROM `stock` WHERE `id` <> 58762997 AND `partno` = 'MEC1-130-02-F-D-RA2-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58762996 LIMIT 5 [ RunTime:0.000825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762996 ORDER BY `minOrder` ASC [ RunTime:0.005779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58762996 ORDER BY `unit` DESC [ RunTime:0.003900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58762996 LIMIT 2 [ RunTime:0.003710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58762996 ORDER BY `minOrder` ASC [ RunTime:0.008981s ]
select * from pdf where partno='MEC1-130-02-F-D-RA2-NP-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-RA2-NP-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008564s ]
SELECT `id` FROM `stock` WHERE `id` <> 58762996 AND `partno` = 'MEC1-130-02-F-D-RA2-NP-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11653431 [ RunTime:0.003733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58761764 LIMIT 5 [ RunTime:0.011491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761764 ORDER BY `minOrder` ASC [ RunTime:0.010661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58761764 ORDER BY `unit` DESC [ RunTime:0.008989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58761764 LIMIT 2 [ RunTime:0.018000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761764 ORDER BY `minOrder` ASC [ RunTime:0.005372s ]
select * from pdf where partno='MEC1-130-02-F-D-NP-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022414s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010385s ]
SELECT `id` FROM `stock` WHERE `id` <> 58761764 AND `partno` = 'MEC1-130-02-F-D-NP-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12853611 [ RunTime:0.016675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58761763 LIMIT 5 [ RunTime:0.015794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761763 ORDER BY `minOrder` ASC [ RunTime:0.011691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58761763 ORDER BY `unit` DESC [ RunTime:0.003879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58761763 LIMIT 2 [ RunTime:0.002689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761763 ORDER BY `minOrder` ASC [ RunTime:0.009855s ]
select * from pdf where partno='MEC1-130-02-F-D-NP-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000930s ]
SELECT `id` FROM `stock` WHERE `id` <> 58761763 AND `partno` = 'MEC1-130-02-F-D-NP-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11652892 [ RunTime:0.002595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58761762 LIMIT 5 [ RunTime:0.003151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761762 ORDER BY `minOrder` ASC [ RunTime:0.005037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58761762 ORDER BY `unit` DESC [ RunTime:0.012604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58761762 LIMIT 2 [ RunTime:0.005976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58761762 ORDER BY `minOrder` ASC [ RunTime:0.006828s ]
select * from pdf where partno='MEC1-130-02-F-D-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002490s ]
SELECT `id` FROM `stock` WHERE `id` <> 58761762 AND `partno` = 'MEC1-130-02-F-D-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12853610 [ RunTime:0.003330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58759352 LIMIT 5 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58759352 ORDER BY `minOrder` ASC [ RunTime:0.008286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58759352 ORDER BY `unit` DESC [ RunTime:0.001649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58759352 LIMIT 2 [ RunTime:0.007141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58759352 ORDER BY `minOrder` ASC [ RunTime:0.006737s ]
select * from pdf where partno='MEC1-130-02-F-D-NP-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000721s ]
SELECT `id` FROM `stock` WHERE `id` <> 58759352 AND `partno` = 'MEC1-130-02-F-D-NP-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58759350 LIMIT 5 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58759350 ORDER BY `minOrder` ASC [ RunTime:0.004883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58759350 ORDER BY `unit` DESC [ RunTime:0.002956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58759350 LIMIT 2 [ RunTime:0.006048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58759350 ORDER BY `minOrder` ASC [ RunTime:0.002891s ]
select * from pdf where partno='MEC1-130-02-F-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000595s ]
SELECT `id` FROM `stock` WHERE `id` <> 58759350 AND `partno` = 'MEC1-130-02-F-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12852161 [ RunTime:0.000792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58756701 LIMIT 5 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58756701 ORDER BY `minOrder` ASC [ RunTime:0.006072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58756701 ORDER BY `unit` DESC [ RunTime:0.000470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58756701 LIMIT 2 [ RunTime:0.004464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58756701 ORDER BY `minOrder` ASC [ RunTime:0.004506s ]
select * from pdf where partno='MEC1-130-02-F-D-NP-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003866s ]
SELECT `id` FROM `stock` WHERE `id` <> 58756701 AND `partno` = 'MEC1-130-02-F-D-NP-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11650985 [ RunTime:0.003814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58756700 LIMIT 5 [ RunTime:0.002726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58756700 ORDER BY `minOrder` ASC [ RunTime:0.007946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58756700 ORDER BY `unit` DESC [ RunTime:0.003842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58756700 LIMIT 2 [ RunTime:0.011354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58756700 ORDER BY `minOrder` ASC [ RunTime:0.009611s ]
select * from pdf where partno='MEC1-130-02-F-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014969s ]
SELECT `id` FROM `stock` WHERE `id` <> 58756700 AND `partno` = 'MEC1-130-02-F-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11650984 [ RunTime:0.007132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58754848 LIMIT 5 [ RunTime:0.020238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58754848 ORDER BY `minOrder` ASC [ RunTime:0.005758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58754848 ORDER BY `unit` DESC [ RunTime:0.003865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58754848 LIMIT 2 [ RunTime:0.013551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58754848 ORDER BY `minOrder` ASC [ RunTime:0.002779s ]
select * from pdf where partno='MEC1-130-02-F-D-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010109s ]
SELECT `id` FROM `stock` WHERE `id` <> 58754848 AND `partno` = 'MEC1-130-02-F-D-NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11650297 [ RunTime:0.008414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58754847 LIMIT 5 [ RunTime:0.003500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58754847 ORDER BY `minOrder` ASC [ RunTime:0.003497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58754847 ORDER BY `unit` DESC [ RunTime:0.003367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58754847 LIMIT 2 [ RunTime:0.006827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58754847 ORDER BY `minOrder` ASC [ RunTime:0.008670s ]
select * from pdf where partno='MEC1-130-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000941s ]
SELECT `id` FROM `stock` WHERE `id` <> 58754847 AND `partno` = 'MEC1-130-02-F-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11650296 [ RunTime:0.003799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58752415 LIMIT 5 [ RunTime:0.007298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58752415 ORDER BY `minOrder` ASC [ RunTime:0.013205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58752415 ORDER BY `unit` DESC [ RunTime:0.003807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58752415 LIMIT 2 [ RunTime:0.004459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58752415 ORDER BY `minOrder` ASC [ RunTime:0.008232s ]
select * from pdf where partno='MEC1-130-02-F-D-RA2-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-RA2-SL-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002233s ]
SELECT `id` FROM `stock` WHERE `id` <> 58752415 AND `partno` = 'MEC1-130-02-F-D-RA2-SL-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866904 [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58748180 LIMIT 5 [ RunTime:0.002422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58748180 ORDER BY `minOrder` ASC [ RunTime:0.009733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58748180 ORDER BY `unit` DESC [ RunTime:0.002124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58748180 LIMIT 2 [ RunTime:0.008185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58748180 ORDER BY `minOrder` ASC [ RunTime:0.004787s ]
select * from pdf where partno='MEC1-130-02-F-D-NP-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-130-02-F-D-NP-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006371s ]
SELECT `id` FROM `stock` WHERE `id` <> 58748180 AND `partno` = 'MEC1-130-02-F-D-NP-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241202 [ RunTime:0.001247s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001435s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001154s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001143s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003860s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010177s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001362s ]
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 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001353s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MEC1-130-02-F-D%' OR `brand` LIKE 'MEC1-130-02-F-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009807s ]