SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003777s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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-108-02-L-D&search=1' [ RunTime:0.001763s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001829s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001477s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000979s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001019s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MEC1-108-02-L-D' LIMIT 1 [ RunTime:0.001138s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 13:50:26' WHERE `partno` = 'MEC1-108-02-L-D' [ RunTime:0.003136s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001301s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008017s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16341130 LIMIT 5 [ RunTime:0.001109s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16341130 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16341130 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16341130 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16341130 ORDER BY `minOrder` ASC [ RunTime:0.000259s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20048046 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20048046 ORDER BY `minOrder` ASC [ RunTime:0.000808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20048046 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20048046 LIMIT 2 [ RunTime:0.001136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20048046 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-NP-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16277081 LIMIT 5 [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16277081 ORDER BY `minOrder` ASC [ RunTime:0.000544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16277081 ORDER BY `unit` DESC [ RunTime:0.003934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16277081 LIMIT 2 [ RunTime:0.003904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16277081 ORDER BY `minOrder` ASC [ RunTime:0.005370s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19931431 LIMIT 5 [ RunTime:0.003511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19931431 ORDER BY `minOrder` ASC [ RunTime:0.004495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19931431 ORDER BY `unit` DESC [ RunTime:0.001898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19931431 LIMIT 2 [ RunTime:0.004292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19931431 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16347670 LIMIT 5 [ RunTime:0.011476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16347670 ORDER BY `minOrder` ASC [ RunTime:0.006025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16347670 ORDER BY `unit` DESC [ RunTime:0.003183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16347670 LIMIT 2 [ RunTime:0.003065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16347670 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
select * from pdf where partno='MEC1-108-02-L-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17350991 LIMIT 5 [ RunTime:0.011596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17350991 ORDER BY `minOrder` ASC [ RunTime:0.010539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17350991 ORDER BY `unit` DESC [ RunTime:0.008481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17350991 LIMIT 2 [ RunTime:0.003130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17350991 ORDER BY `minOrder` ASC [ RunTime:0.005776s ]
select * from pdf where partno='MEC1-108-02-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16320567 LIMIT 5 [ RunTime:0.005958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16320567 ORDER BY `minOrder` ASC [ RunTime:0.018271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16320567 ORDER BY `unit` DESC [ RunTime:0.009873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16320567 LIMIT 2 [ RunTime:0.015511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16320567 ORDER BY `minOrder` ASC [ RunTime:0.005975s ]
select * from pdf where partno='MEC1-108-02-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869242 LIMIT 5 [ RunTime:0.005439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869242 ORDER BY `minOrder` ASC [ RunTime:0.004680s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869242 ORDER BY `unit` DESC [ RunTime:0.004892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869242 LIMIT 2 [ RunTime:0.009627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869242 ORDER BY `minOrder` ASC [ RunTime:0.009547s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866140 LIMIT 5 [ RunTime:0.015290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866140 ORDER BY `minOrder` ASC [ RunTime:0.031550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19866140 ORDER BY `unit` DESC [ RunTime:0.011438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19866140 LIMIT 2 [ RunTime:0.007052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866140 ORDER BY `minOrder` ASC [ RunTime:0.017367s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20060086 LIMIT 5 [ RunTime:0.012329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060086 ORDER BY `minOrder` ASC [ RunTime:0.013289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20060086 ORDER BY `unit` DESC [ RunTime:0.018732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20060086 LIMIT 2 [ RunTime:0.016992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060086 ORDER BY `minOrder` ASC [ RunTime:0.017714s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20060085 LIMIT 5 [ RunTime:0.007104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060085 ORDER BY `minOrder` ASC [ RunTime:0.004887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20060085 ORDER BY `unit` DESC [ RunTime:0.008552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20060085 LIMIT 2 [ RunTime:0.003300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20060085 ORDER BY `minOrder` ASC [ RunTime:0.003408s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-NP-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20042702 LIMIT 5 [ RunTime:0.014918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20042702 ORDER BY `minOrder` ASC [ RunTime:0.009143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20042702 ORDER BY `unit` DESC [ RunTime:0.011650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20042702 LIMIT 2 [ RunTime:0.014199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20042702 ORDER BY `minOrder` ASC [ RunTime:0.008454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20000554 LIMIT 5 [ RunTime:0.006163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20000554 ORDER BY `minOrder` ASC [ RunTime:0.010331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20000554 ORDER BY `unit` DESC [ RunTime:0.007700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20000554 LIMIT 2 [ RunTime:0.013047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20000554 ORDER BY `minOrder` ASC [ RunTime:0.008966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19994949 LIMIT 5 [ RunTime:0.022887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19994949 ORDER BY `minOrder` ASC [ RunTime:0.009059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19994949 ORDER BY `unit` DESC [ RunTime:0.003182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19994949 LIMIT 2 [ RunTime:0.005902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19994949 ORDER BY `minOrder` ASC [ RunTime:0.010213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869095 LIMIT 5 [ RunTime:0.008439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869095 ORDER BY `minOrder` ASC [ RunTime:0.014246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869095 ORDER BY `unit` DESC [ RunTime:0.006776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869095 LIMIT 2 [ RunTime:0.013686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869095 ORDER BY `minOrder` ASC [ RunTime:0.003902s ]
select * from pdf where partno='MEC1-108-02-L-D-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19867975 LIMIT 5 [ RunTime:0.027670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19867975 ORDER BY `minOrder` ASC [ RunTime:0.009202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19867975 ORDER BY `unit` DESC [ RunTime:0.010492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19867975 LIMIT 2 [ RunTime:0.013793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19867975 ORDER BY `minOrder` ASC [ RunTime:0.001373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866992 LIMIT 5 [ RunTime:0.011972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866992 ORDER BY `minOrder` ASC [ RunTime:0.017692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19866992 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19866992 LIMIT 2 [ RunTime:0.020922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866992 ORDER BY `minOrder` ASC [ RunTime:0.010472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19864949 LIMIT 5 [ RunTime:0.005937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19864949 ORDER BY `minOrder` ASC [ RunTime:0.001658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19864949 ORDER BY `unit` DESC [ RunTime:0.013688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19864949 LIMIT 2 [ RunTime:0.002336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19864949 ORDER BY `minOrder` ASC [ RunTime:0.003267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16338200 LIMIT 5 [ RunTime:0.012379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16338200 ORDER BY `minOrder` ASC [ RunTime:0.006404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16338200 ORDER BY `unit` DESC [ RunTime:0.013795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16338200 LIMIT 2 [ RunTime:0.011574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16338200 ORDER BY `minOrder` ASC [ RunTime:0.005305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16325467 LIMIT 5 [ RunTime:0.009775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16325467 ORDER BY `minOrder` ASC [ RunTime:0.022549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16325467 ORDER BY `unit` DESC [ RunTime:0.014687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16325467 LIMIT 2 [ RunTime:0.011498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16325467 ORDER BY `minOrder` ASC [ RunTime:0.003180s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259699 LIMIT 5 [ RunTime:0.005983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259699 ORDER BY `minOrder` ASC [ RunTime:0.016741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259699 ORDER BY `unit` DESC [ RunTime:0.008324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259699 LIMIT 2 [ RunTime:0.006525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259699 ORDER BY `minOrder` ASC [ RunTime:0.003884s ]
select * from pdf where partno='mec1-108-02-l-d-em2-np' and brandshort='samtec' limit 1 [ RunTime:0.008285s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-em2-np' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.008653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259697 LIMIT 5 [ RunTime:0.010305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259697 ORDER BY `minOrder` ASC [ RunTime:0.003420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259697 ORDER BY `unit` DESC [ RunTime:0.004480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259697 LIMIT 2 [ RunTime:0.003436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259697 ORDER BY `minOrder` ASC [ RunTime:0.005499s ]
select * from pdf where partno='mec1-108-02-l-d-a' and brandshort='samtec' limit 1 [ RunTime:0.012497s ]
select foldpath,foldpath2,filename from pdf_file where id=1921708 limit 1 [ RunTime:0.014226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-a' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.006630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259703 LIMIT 5 [ RunTime:0.009144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259703 ORDER BY `minOrder` ASC [ RunTime:0.004271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259703 ORDER BY `unit` DESC [ RunTime:0.007466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259703 LIMIT 2 [ RunTime:0.005982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259703 ORDER BY `minOrder` ASC [ RunTime:0.003880s ]
select * from pdf where partno='mec1-108-02-l-d-ra1-sl' and brandshort='samtec' limit 1 [ RunTime:0.011663s ]
select foldpath,foldpath2,filename from pdf_file where id=1795258 limit 1 [ RunTime:0.011246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-ra1-sl' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.008373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259698 LIMIT 5 [ RunTime:0.007715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259698 ORDER BY `minOrder` ASC [ RunTime:0.006311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259698 ORDER BY `unit` DESC [ RunTime:0.005166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259698 LIMIT 2 [ RunTime:0.002400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259698 ORDER BY `minOrder` ASC [ RunTime:0.008684s ]
select * from pdf where partno='mec1-108-02-l-d-em2' and brandshort='samtec' limit 1 [ RunTime:0.013502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-em2' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.009345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259702 LIMIT 5 [ RunTime:0.010116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259702 ORDER BY `minOrder` ASC [ RunTime:0.006842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259702 ORDER BY `unit` DESC [ RunTime:0.003265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259702 LIMIT 2 [ RunTime:0.025364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259702 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='mec1-108-02-l-d-ra1-np-sl' and brandshort='samtec' limit 1 [ RunTime:0.012531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-ra1-np-sl' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.008486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259701 LIMIT 5 [ RunTime:0.012565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259701 ORDER BY `minOrder` ASC [ RunTime:0.012135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259701 ORDER BY `unit` DESC [ RunTime:0.004603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259701 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259701 ORDER BY `minOrder` ASC [ RunTime:0.002931s ]
select * from pdf where partno='mec1-108-02-l-d-np-a' and brandshort='samtec' limit 1 [ RunTime:0.008523s ]
select foldpath,foldpath2,filename from pdf_file where id=1920552 limit 1 [ RunTime:0.009505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-np-a' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.016194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259700 LIMIT 5 [ RunTime:0.020268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259700 ORDER BY `minOrder` ASC [ RunTime:0.006332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259700 ORDER BY `unit` DESC [ RunTime:0.011532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259700 LIMIT 2 [ RunTime:0.005628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259700 ORDER BY `minOrder` ASC [ RunTime:0.002486s ]
select * from pdf where partno='mec1-108-02-l-d-em2-tr' and brandshort='samtec' limit 1 [ RunTime:0.015345s ]
select foldpath,foldpath2,filename from pdf_file where id=1820239 limit 1 [ RunTime:0.019503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-108-02-l-d-em2-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.003519s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868745 LIMIT 5 [ RunTime:0.006349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868745 ORDER BY `minOrder` ASC [ RunTime:0.024593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868745 ORDER BY `unit` DESC [ RunTime:0.003982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868745 LIMIT 2 [ RunTime:0.020843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868745 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM2-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021444s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868745 AND `partno` = 'MEC1-108-02-L-D-EM2-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16341130 [ RunTime:0.011082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868429 LIMIT 5 [ RunTime:0.008922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868429 ORDER BY `minOrder` ASC [ RunTime:0.015426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868429 ORDER BY `unit` DESC [ RunTime:0.001708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868429 LIMIT 2 [ RunTime:0.011183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868429 ORDER BY `minOrder` ASC [ RunTime:0.010592s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-NP-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868422 LIMIT 5 [ RunTime:0.005358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868422 ORDER BY `minOrder` ASC [ RunTime:0.008841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868422 ORDER BY `unit` DESC [ RunTime:0.006166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868422 LIMIT 2 [ RunTime:0.002614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868422 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-NP-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA1-NP-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004660s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868422 AND `partno` = 'MEC1-108-02-L-D-RA1-NP-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20048046 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868450 LIMIT 5 [ RunTime:0.007512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868450 ORDER BY `minOrder` ASC [ RunTime:0.007459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868450 ORDER BY `unit` DESC [ RunTime:0.000714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868450 LIMIT 2 [ RunTime:0.010358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868450 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-NP-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA1-NP-SL-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002401s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868450 AND `partno` = 'MEC1-108-02-L-D-RA1-NP-SL-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20060085 [ RunTime:0.002726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868690 LIMIT 5 [ RunTime:0.001900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868690 ORDER BY `minOrder` ASC [ RunTime:0.001533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868690 ORDER BY `unit` DESC [ RunTime:0.004832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868690 LIMIT 2 [ RunTime:0.007891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868690 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA1-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001041s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868690 AND `partno` = 'MEC1-108-02-L-D-RA1-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869242 [ RunTime:0.007449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868399 LIMIT 5 [ RunTime:0.000712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868399 ORDER BY `minOrder` ASC [ RunTime:0.004134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868399 ORDER BY `unit` DESC [ RunTime:0.002043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868399 LIMIT 2 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868399 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-NP-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51870039 LIMIT 5 [ RunTime:0.000919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870039 ORDER BY `minOrder` ASC [ RunTime:0.009099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51870039 ORDER BY `unit` DESC [ RunTime:0.002986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51870039 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870039 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='MEC1-108-02-L-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012926s ]
SELECT `id` FROM `stock` WHERE `id` <> 51870039 AND `partno` = 'MEC1-108-02-L-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16347670 [ RunTime:0.030060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51870045 LIMIT 5 [ RunTime:0.019124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870045 ORDER BY `minOrder` ASC [ RunTime:0.009348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51870045 ORDER BY `unit` DESC [ RunTime:0.017898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51870045 LIMIT 2 [ RunTime:0.020663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870045 ORDER BY `minOrder` ASC [ RunTime:0.015300s ]
select * from pdf where partno='MEC1-108-02-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006626s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015746s ]
SELECT `id` FROM `stock` WHERE `id` <> 51870045 AND `partno` = 'MEC1-108-02-L-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17350991 [ RunTime:0.013436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868668 LIMIT 5 [ RunTime:0.006765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868668 ORDER BY `minOrder` ASC [ RunTime:0.018474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868668 ORDER BY `unit` DESC [ RunTime:0.020579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868668 LIMIT 2 [ RunTime:0.032297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868668 ORDER BY `minOrder` ASC [ RunTime:0.006933s ]
select * from pdf where partno='MEC1-108-02-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025313s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868668 AND `partno` = 'MEC1-108-02-L-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16320567 [ RunTime:0.030493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51869235 LIMIT 5 [ RunTime:0.045033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869235 ORDER BY `minOrder` ASC [ RunTime:0.077743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51869235 ORDER BY `unit` DESC [ RunTime:0.015694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51869235 LIMIT 2 [ RunTime:0.035044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51869235 ORDER BY `minOrder` ASC [ RunTime:0.005370s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003203s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM2' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009102s ]
SELECT `id` FROM `stock` WHERE `id` <> 51869235 AND `partno` = 'MEC1-108-02-L-D-EM2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866140 [ RunTime:0.015335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51919581 LIMIT 5 [ RunTime:0.014766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51919581 ORDER BY `minOrder` ASC [ RunTime:0.014932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51919581 ORDER BY `unit` DESC [ RunTime:0.008879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51919581 LIMIT 2 [ RunTime:0.022180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51919581 ORDER BY `minOrder` ASC [ RunTime:0.004093s ]
select * from pdf where partno='MEC1-108-02-L-D-EM1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013145s ]
SELECT `id` FROM `stock` WHERE `id` <> 51919581 AND `partno` = 'MEC1-108-02-L-D-EM1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11653430 [ RunTime:0.019088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51911984 LIMIT 5 [ RunTime:0.004799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51911984 ORDER BY `minOrder` ASC [ RunTime:0.009098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51911984 ORDER BY `unit` DESC [ RunTime:0.022146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51911984 LIMIT 2 [ RunTime:0.008278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51911984 ORDER BY `minOrder` ASC [ RunTime:0.003791s ]
select * from pdf where partno='MEC1-108-02-L-D-RA2-SL-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA2-SL-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014612s ]
SELECT `id` FROM `stock` WHERE `id` <> 51911984 AND `partno` = 'MEC1-108-02-L-D-RA2-SL-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51909441 LIMIT 5 [ RunTime:0.011719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51909441 ORDER BY `minOrder` ASC [ RunTime:0.006458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51909441 ORDER BY `unit` DESC [ RunTime:0.009618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51909441 LIMIT 2 [ RunTime:0.002769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51909441 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='MEC1-108-02-L-D-RA1-A-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA1-A-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003081s ]
SELECT `id` FROM `stock` WHERE `id` <> 51909441 AND `partno` = 'MEC1-108-02-L-D-RA1-A-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19994949 [ RunTime:0.004742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51901152 LIMIT 5 [ RunTime:0.003294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51901152 ORDER BY `minOrder` ASC [ RunTime:0.002675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51901152 ORDER BY `unit` DESC [ RunTime:0.002890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51901152 LIMIT 2 [ RunTime:0.004141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51901152 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2-NP-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM2-NP-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001877s ]
SELECT `id` FROM `stock` WHERE `id` <> 51901152 AND `partno` = 'MEC1-108-02-L-D-EM2-NP-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51892405 LIMIT 5 [ RunTime:0.010512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51892405 ORDER BY `minOrder` ASC [ RunTime:0.004010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51892405 ORDER BY `unit` DESC [ RunTime:0.004889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51892405 LIMIT 2 [ RunTime:0.000872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51892405 ORDER BY `minOrder` ASC [ RunTime:0.013405s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017020s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-NP-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020656s ]
SELECT `id` FROM `stock` WHERE `id` <> 51892405 AND `partno` = 'MEC1-108-02-L-D-NP-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51888312 LIMIT 5 [ RunTime:0.004811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51888312 ORDER BY `minOrder` ASC [ RunTime:0.013784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51888312 ORDER BY `unit` DESC [ RunTime:0.024983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51888312 LIMIT 2 [ RunTime:0.012921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51888312 ORDER BY `minOrder` ASC [ RunTime:0.017934s ]
select * from pdf where partno='MEC1-108-02-L-D-RA2-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-RA2-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005419s ]
SELECT `id` FROM `stock` WHERE `id` <> 51888312 AND `partno` = 'MEC1-108-02-L-D-RA2-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12849421 [ RunTime:0.005828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51887539 LIMIT 5 [ RunTime:0.012960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51887539 ORDER BY `minOrder` ASC [ RunTime:0.001896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51887539 ORDER BY `unit` DESC [ RunTime:0.000701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51887539 LIMIT 2 [ RunTime:0.011834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51887539 ORDER BY `minOrder` ASC [ RunTime:0.013166s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM2-NP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010346s ]
SELECT `id` FROM `stock` WHERE `id` <> 51887539 AND `partno` = 'MEC1-108-02-L-D-EM2-NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12847747 [ RunTime:0.012793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51883637 LIMIT 5 [ RunTime:0.006722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51883637 ORDER BY `minOrder` ASC [ RunTime:0.017646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51883637 ORDER BY `unit` DESC [ RunTime:0.007083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51883637 LIMIT 2 [ RunTime:0.013533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51883637 ORDER BY `minOrder` ASC [ RunTime:0.012960s ]
select * from pdf where partno='MEC1-108-02-L-D-EM2-NP-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-EM2-NP-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009117s ]
SELECT `id` FROM `stock` WHERE `id` <> 51883637 AND `partno` = 'MEC1-108-02-L-D-EM2-NP-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51880156 LIMIT 5 [ RunTime:0.014838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51880156 ORDER BY `minOrder` ASC [ RunTime:0.008104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51880156 ORDER BY `unit` DESC [ RunTime:0.022458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51880156 LIMIT 2 [ RunTime:0.060387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51880156 ORDER BY `minOrder` ASC [ RunTime:0.007289s ]
select * from pdf where partno='MEC1-108-02-L-D-NP-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-NP-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040672s ]
SELECT `id` FROM `stock` WHERE `id` <> 51880156 AND `partno` = 'MEC1-108-02-L-D-NP-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19867975 [ RunTime:0.025185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51880155 LIMIT 5 [ RunTime:0.036813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51880155 ORDER BY `minOrder` ASC [ RunTime:0.017349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51880155 ORDER BY `unit` DESC [ RunTime:0.055318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51880155 LIMIT 2 [ RunTime:0.029358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51880155 ORDER BY `minOrder` ASC [ RunTime:0.029032s ]
select * from pdf where partno='MEC1-108-02-L-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-108-02-L-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017829s ]
SELECT `id` FROM `stock` WHERE `id` <> 51880155 AND `partno` = 'MEC1-108-02-L-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.099905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15496372 [ RunTime:0.086210s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041642s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038079s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016744s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031037s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051121s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037471s ]
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-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021483s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MEC1-108-02-L-D%' OR `brand` LIKE 'MEC1-108-02-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.022642s ]