SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001105s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=MEC1-105-02-L-D&search=1' [ RunTime:0.003214s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001106s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004779s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001567s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.005967s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001538s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002703s ]
SELECT * FROM `stock_search` WHERE `partno` = 'MEC1-105-02-L-D' LIMIT 1 [ RunTime:0.004533s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-29 17:59:45' WHERE `partno` = 'MEC1-105-02-L-D' [ RunTime:0.010570s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001788s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018336s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241141 LIMIT 5 [ RunTime:0.009376s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241141 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16241141 ORDER BY `unit` DESC [ RunTime:0.006851s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16241141 LIMIT 2 [ RunTime:0.001994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16241141 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20048037 LIMIT 5 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20048037 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20048037 ORDER BY `unit` DESC [ RunTime:0.002910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20048037 LIMIT 2 [ RunTime:0.009032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20048037 ORDER BY `minOrder` ASC [ RunTime:0.012022s ]
select * from pdf where partno='MEC1-105-02-L-D-RA1-NP-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16347666 LIMIT 5 [ RunTime:0.009039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16347666 ORDER BY `minOrder` ASC [ RunTime:0.012083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16347666 ORDER BY `unit` DESC [ RunTime:0.007177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16347666 LIMIT 2 [ RunTime:0.001249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16347666 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
select * from pdf where partno='MEC1-105-02-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19873311 LIMIT 5 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19873311 ORDER BY `minOrder` ASC [ RunTime:0.015645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19873311 ORDER BY `unit` DESC [ RunTime:0.026021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19873311 LIMIT 2 [ RunTime:0.015448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19873311 ORDER BY `minOrder` ASC [ RunTime:0.012206s ]
select * from pdf where partno='MEC1-105-02-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866170 LIMIT 5 [ RunTime:0.037211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866170 ORDER BY `minOrder` ASC [ RunTime:0.029421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19866170 ORDER BY `unit` DESC [ RunTime:0.027098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19866170 LIMIT 2 [ RunTime:0.018553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866170 ORDER BY `minOrder` ASC [ RunTime:0.008423s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20052082 LIMIT 5 [ RunTime:0.021830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20052082 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20052082 ORDER BY `unit` DESC [ RunTime:0.059316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20052082 LIMIT 2 [ RunTime:0.041193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20052082 ORDER BY `minOrder` ASC [ RunTime:0.010103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20041428 LIMIT 5 [ RunTime:0.016237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20041428 ORDER BY `minOrder` ASC [ RunTime:0.006741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20041428 ORDER BY `unit` DESC [ RunTime:0.014950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20041428 LIMIT 2 [ RunTime:0.026467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20041428 ORDER BY `minOrder` ASC [ RunTime:0.013521s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20029626 LIMIT 5 [ RunTime:0.010854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20029626 ORDER BY `minOrder` ASC [ RunTime:0.018390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20029626 ORDER BY `unit` DESC [ RunTime:0.000488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20029626 LIMIT 2 [ RunTime:0.005508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20029626 ORDER BY `minOrder` ASC [ RunTime:0.001393s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19981242 LIMIT 5 [ RunTime:0.006174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19981242 ORDER BY `minOrder` ASC [ RunTime:0.015367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19981242 ORDER BY `unit` DESC [ RunTime:0.018377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19981242 LIMIT 2 [ RunTime:0.025390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19981242 ORDER BY `minOrder` ASC [ RunTime:0.008446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19981241 LIMIT 5 [ RunTime:0.021927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19981241 ORDER BY `minOrder` ASC [ RunTime:0.017157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19981241 ORDER BY `unit` DESC [ RunTime:0.024794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19981241 LIMIT 2 [ RunTime:0.019011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19981241 ORDER BY `minOrder` ASC [ RunTime:0.007145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869114 LIMIT 5 [ RunTime:0.023943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869114 ORDER BY `minOrder` ASC [ RunTime:0.012077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869114 ORDER BY `unit` DESC [ RunTime:0.005670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869114 LIMIT 2 [ RunTime:0.010174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869114 ORDER BY `minOrder` ASC [ RunTime:0.004635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869112 LIMIT 5 [ RunTime:0.010167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869112 ORDER BY `minOrder` ASC [ RunTime:0.010948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869112 ORDER BY `unit` DESC [ RunTime:0.003623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869112 LIMIT 2 [ RunTime:0.007739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869112 ORDER BY `minOrder` ASC [ RunTime:0.018036s ]
select * from pdf where partno='MEC1-105-02-L-D-RA1-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19869102 LIMIT 5 [ RunTime:0.025600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869102 ORDER BY `minOrder` ASC [ RunTime:0.021495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19869102 ORDER BY `unit` DESC [ RunTime:0.007559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19869102 LIMIT 2 [ RunTime:0.016275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19869102 ORDER BY `minOrder` ASC [ RunTime:0.001445s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19868803 LIMIT 5 [ RunTime:0.003454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19868803 ORDER BY `minOrder` ASC [ RunTime:0.007919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19868803 ORDER BY `unit` DESC [ RunTime:0.010645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19868803 LIMIT 2 [ RunTime:0.005602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19868803 ORDER BY `minOrder` ASC [ RunTime:0.018906s ]
select * from pdf where partno='MEC1-105-02-L-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866428 LIMIT 5 [ RunTime:0.013265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866428 ORDER BY `minOrder` ASC [ RunTime:0.008930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19866428 ORDER BY `unit` DESC [ RunTime:0.012097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19866428 LIMIT 2 [ RunTime:0.008208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19866428 ORDER BY `minOrder` ASC [ RunTime:0.001360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16345392 LIMIT 5 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16345392 ORDER BY `minOrder` ASC [ RunTime:0.013682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16345392 ORDER BY `unit` DESC [ RunTime:0.008421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16345392 LIMIT 2 [ RunTime:0.009649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16345392 ORDER BY `minOrder` ASC [ RunTime:0.006387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16343345 LIMIT 5 [ RunTime:0.005638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16343345 ORDER BY `minOrder` ASC [ RunTime:0.009276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16343345 ORDER BY `unit` DESC [ RunTime:0.006870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16343345 LIMIT 2 [ RunTime:0.017047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16343345 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16334032 LIMIT 5 [ RunTime:0.002098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16334032 ORDER BY `minOrder` ASC [ RunTime:0.004259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16334032 ORDER BY `unit` DESC [ RunTime:0.002908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16334032 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16334032 ORDER BY `minOrder` ASC [ RunTime:0.008071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16331070 LIMIT 5 [ RunTime:0.009111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16331070 ORDER BY `minOrder` ASC [ RunTime:0.004050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16331070 ORDER BY `unit` DESC [ RunTime:0.002868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16331070 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16331070 ORDER BY `minOrder` ASC [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16325457 LIMIT 5 [ RunTime:0.001023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16325457 ORDER BY `minOrder` ASC [ RunTime:0.017130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16325457 ORDER BY `unit` DESC [ RunTime:0.001233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16325457 LIMIT 2 [ RunTime:0.004185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16325457 ORDER BY `minOrder` ASC [ RunTime:0.001599s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259535 LIMIT 5 [ RunTime:0.020440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259535 ORDER BY `minOrder` ASC [ RunTime:0.010394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259535 ORDER BY `unit` DESC [ RunTime:0.004483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259535 LIMIT 2 [ RunTime:0.002105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259535 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='mec1-105-02-l-d-ra1-np-sl-tr' and brandshort='samtec' limit 1 [ RunTime:0.013409s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-105-02-l-d-ra1-np-sl-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.011648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259537 LIMIT 5 [ RunTime:0.011169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259537 ORDER BY `minOrder` ASC [ RunTime:0.009188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259537 ORDER BY `unit` DESC [ RunTime:0.010292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259537 LIMIT 2 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259537 ORDER BY `minOrder` ASC [ RunTime:0.005208s ]
select * from pdf where partno='mec1-105-02-l-d-np-lc-k-tr' and brandshort='samtec' limit 1 [ RunTime:0.003079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-105-02-l-d-np-lc-k-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.017533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259688 LIMIT 5 [ RunTime:0.008569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259688 ORDER BY `minOrder` ASC [ RunTime:0.011042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259688 ORDER BY `unit` DESC [ RunTime:0.000639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259688 LIMIT 2 [ RunTime:0.005602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259688 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
select * from pdf where partno='mec1-105-02-l-d-np-a-k' and brandshort='samtec' limit 1 [ RunTime:0.009856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-105-02-l-d-np-a-k' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.013579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32259689 LIMIT 5 [ RunTime:0.016748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259689 ORDER BY `minOrder` ASC [ RunTime:0.017953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32259689 ORDER BY `unit` DESC [ RunTime:0.001413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32259689 LIMIT 2 [ RunTime:0.012303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32259689 ORDER BY `minOrder` ASC [ RunTime:0.001387s ]
select * from pdf where partno='mec1-105-02-l-d-np-lc' and brandshort='samtec' limit 1 [ RunTime:0.007956s ]
select foldpath,foldpath2,filename from pdf_file where id=1977027 limit 1 [ RunTime:0.019701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'mec1-105-02-l-d-np-lc' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.030240s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868689 LIMIT 5 [ RunTime:0.004916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868689 ORDER BY `minOrder` ASC [ RunTime:0.010927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868689 ORDER BY `unit` DESC [ RunTime:0.002550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868689 LIMIT 2 [ RunTime:0.006890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868689 ORDER BY `minOrder` ASC [ RunTime:0.002368s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007390s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868689 AND `partno` = 'MEC1-105-02-L-D-NP-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16241141 [ RunTime:0.023652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868974 LIMIT 5 [ RunTime:0.023932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868974 ORDER BY `minOrder` ASC [ RunTime:0.029099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868974 ORDER BY `unit` DESC [ RunTime:0.036498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868974 LIMIT 2 [ RunTime:0.006444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868974 ORDER BY `minOrder` ASC [ RunTime:0.003278s ]
select * from pdf where partno='MEC1-105-02-L-D-RA1-NP-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-RA1-NP-SL-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008671s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868974 AND `partno` = 'MEC1-105-02-L-D-RA1-NP-SL-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20048037 [ RunTime:0.012213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868931 LIMIT 5 [ RunTime:0.002664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868931 ORDER BY `minOrder` ASC [ RunTime:0.007293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868931 ORDER BY `unit` DESC [ RunTime:0.001017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868931 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868931 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
select * from pdf where partno='MEC1-105-02-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029209s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868931 AND `partno` = 'MEC1-105-02-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16347666 [ RunTime:0.023596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51870224 LIMIT 5 [ RunTime:0.014894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870224 ORDER BY `minOrder` ASC [ RunTime:0.016113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51870224 ORDER BY `unit` DESC [ RunTime:0.005780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51870224 LIMIT 2 [ RunTime:0.020712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51870224 ORDER BY `minOrder` ASC [ RunTime:0.006946s ]
select * from pdf where partno='MEC1-105-02-L-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001302s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006738s ]
SELECT `id` FROM `stock` WHERE `id` <> 51870224 AND `partno` = 'MEC1-105-02-L-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19873311 [ RunTime:0.011999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51868933 LIMIT 5 [ RunTime:0.001366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868933 ORDER BY `minOrder` ASC [ RunTime:0.003653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51868933 ORDER BY `unit` DESC [ RunTime:0.004958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51868933 LIMIT 2 [ RunTime:0.016660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51868933 ORDER BY `minOrder` ASC [ RunTime:0.001401s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002914s ]
SELECT `id` FROM `stock` WHERE `id` <> 51868933 AND `partno` = 'MEC1-105-02-L-D-NP-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866170 [ RunTime:0.015727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51913386 LIMIT 5 [ RunTime:0.003579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51913386 ORDER BY `minOrder` ASC [ RunTime:0.007732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51913386 ORDER BY `unit` DESC [ RunTime:0.009908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51913386 LIMIT 2 [ RunTime:0.005611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51913386 ORDER BY `minOrder` ASC [ RunTime:0.006373s ]
select * from pdf where partno='MEC1-105-02-L-D-EM2-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-EM2-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019933s ]
SELECT `id` FROM `stock` WHERE `id` <> 51913386 AND `partno` = 'MEC1-105-02-L-D-EM2-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11651708 [ RunTime:0.022537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51910947 LIMIT 5 [ RunTime:0.007088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51910947 ORDER BY `minOrder` ASC [ RunTime:0.016489s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51910947 ORDER BY `unit` DESC [ RunTime:0.002193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51910947 LIMIT 2 [ RunTime:0.002000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51910947 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='MEC1-105-02-L-D-EM1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-EM1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000864s ]
SELECT `id` FROM `stock` WHERE `id` <> 51910947 AND `partno` = 'MEC1-105-02-L-D-EM1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12853609 [ RunTime:0.008010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51910945 LIMIT 5 [ RunTime:0.006270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51910945 ORDER BY `minOrder` ASC [ RunTime:0.010376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51910945 ORDER BY `unit` DESC [ RunTime:0.006097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51910945 LIMIT 2 [ RunTime:0.017910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51910945 ORDER BY `minOrder` ASC [ RunTime:0.020392s ]
select * from pdf where partno='MEC1-105-02-L-D-EM2-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-EM2-NP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011921s ]
SELECT `id` FROM `stock` WHERE `id` <> 51910945 AND `partno` = 'MEC1-105-02-L-D-EM2-NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51904803 LIMIT 5 [ RunTime:0.010014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51904803 ORDER BY `minOrder` ASC [ RunTime:0.018060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51904803 ORDER BY `unit` DESC [ RunTime:0.016502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51904803 LIMIT 2 [ RunTime:0.004433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51904803 ORDER BY `minOrder` ASC [ RunTime:0.014599s ]
select * from pdf where partno='MEC1-105-02-L-D-RA2-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019364s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-RA2-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019741s ]
SELECT `id` FROM `stock` WHERE `id` <> 51904803 AND `partno` = 'MEC1-105-02-L-D-RA2-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51902376 LIMIT 5 [ RunTime:0.006991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51902376 ORDER BY `minOrder` ASC [ RunTime:0.015873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51902376 ORDER BY `unit` DESC [ RunTime:0.006931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51902376 LIMIT 2 [ RunTime:0.003013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51902376 ORDER BY `minOrder` ASC [ RunTime:0.006742s ]
select * from pdf where partno='MEC1-105-02-L-D-RA2-NP-SL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-RA2-NP-SL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022403s ]
SELECT `id` FROM `stock` WHERE `id` <> 51902376 AND `partno` = 'MEC1-105-02-L-D-RA2-NP-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11650702 [ RunTime:0.010593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51890003 LIMIT 5 [ RunTime:0.016741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51890003 ORDER BY `minOrder` ASC [ RunTime:0.013873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51890003 ORDER BY `unit` DESC [ RunTime:0.007860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51890003 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51890003 ORDER BY `minOrder` ASC [ RunTime:0.003431s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-LC-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043095s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-LC-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007408s ]
SELECT `id` FROM `stock` WHERE `id` <> 51890003 AND `partno` = 'MEC1-105-02-L-D-NP-LC-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51889729 LIMIT 5 [ RunTime:0.006795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51889729 ORDER BY `minOrder` ASC [ RunTime:0.007257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51889729 ORDER BY `unit` DESC [ RunTime:0.009507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51889729 LIMIT 2 [ RunTime:0.003379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51889729 ORDER BY `minOrder` ASC [ RunTime:0.002760s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000834s ]
SELECT `id` FROM `stock` WHERE `id` <> 51889729 AND `partno` = 'MEC1-105-02-L-D-NP-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11637675 [ RunTime:0.008982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51884625 LIMIT 5 [ RunTime:0.013271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51884625 ORDER BY `minOrder` ASC [ RunTime:0.008439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51884625 ORDER BY `unit` DESC [ RunTime:0.001505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51884625 LIMIT 2 [ RunTime:0.002187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51884625 ORDER BY `minOrder` ASC [ RunTime:0.002351s ]
select * from pdf where partno='MEC1-105-02-L-D-EM2-NP-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-EM2-NP-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014910s ]
SELECT `id` FROM `stock` WHERE `id` <> 51884625 AND `partno` = 'MEC1-105-02-L-D-EM2-NP-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19866428 [ RunTime:0.001110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51883940 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51883940 ORDER BY `minOrder` ASC [ RunTime:0.014092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51883940 ORDER BY `unit` DESC [ RunTime:0.008831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51883940 LIMIT 2 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51883940 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
select * from pdf where partno='MEC1-105-02-L-D-EM1-NP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-EM1-NP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000853s ]
SELECT `id` FROM `stock` WHERE `id` <> 51883940 AND `partno` = 'MEC1-105-02-L-D-EM1-NP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12827664 [ RunTime:0.022712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51881078 LIMIT 5 [ RunTime:0.014485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51881078 ORDER BY `minOrder` ASC [ RunTime:0.014298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51881078 ORDER BY `unit` DESC [ RunTime:0.002052s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51881078 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51881078 ORDER BY `minOrder` ASC [ RunTime:0.007598s ]
select * from pdf where partno='MEC1-105-02-L-D-RA1-SL-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-RA1-SL-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `stock` WHERE `id` <> 51881078 AND `partno` = 'MEC1-105-02-L-D-RA1-SL-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14251967 [ RunTime:0.009678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51878878 LIMIT 5 [ RunTime:0.000850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51878878 ORDER BY `minOrder` ASC [ RunTime:0.004080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51878878 ORDER BY `unit` DESC [ RunTime:0.010635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51878878 LIMIT 2 [ RunTime:0.016254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51878878 ORDER BY `minOrder` ASC [ RunTime:0.004258s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004961s ]
SELECT `id` FROM `stock` WHERE `id` <> 51878878 AND `partno` = 'MEC1-105-02-L-D-NP-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16334032 [ RunTime:0.016402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51875774 LIMIT 5 [ RunTime:0.009664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875774 ORDER BY `minOrder` ASC [ RunTime:0.008609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51875774 ORDER BY `unit` DESC [ RunTime:0.007875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51875774 LIMIT 2 [ RunTime:0.008437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875774 ORDER BY `minOrder` ASC [ RunTime:0.002124s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006724s ]
SELECT `id` FROM `stock` WHERE `id` <> 51875774 AND `partno` = 'MEC1-105-02-L-D-NP-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51875664 LIMIT 5 [ RunTime:0.008278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875664 ORDER BY `minOrder` ASC [ RunTime:0.019098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51875664 ORDER BY `unit` DESC [ RunTime:0.004321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51875664 LIMIT 2 [ RunTime:0.004345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875664 ORDER BY `minOrder` ASC [ RunTime:0.005480s ]
select * from pdf where partno='MEC1-105-02-L-D-NP-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-NP-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000772s ]
SELECT `id` FROM `stock` WHERE `id` <> 51875664 AND `partno` = 'MEC1-105-02-L-D-NP-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20029626 [ RunTime:0.009734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51875663 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875663 ORDER BY `minOrder` ASC [ RunTime:0.000674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51875663 ORDER BY `unit` DESC [ RunTime:0.000703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51875663 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875663 ORDER BY `minOrder` ASC [ RunTime:0.005049s ]
select * from pdf where partno='MEC1-105-02-L-D-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000824s ]
SELECT `id` FROM `stock` WHERE `id` <> 51875663 AND `partno` = 'MEC1-105-02-L-D-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16331070 [ RunTime:0.000683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51875201 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875201 ORDER BY `minOrder` ASC [ RunTime:0.004530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51875201 ORDER BY `unit` DESC [ RunTime:0.001546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51875201 LIMIT 2 [ RunTime:0.006521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51875201 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='MEC1-105-02-L-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MEC1-105-02-L-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003983s ]
SELECT `id` FROM `stock` WHERE `id` <> 51875201 AND `partno` = 'MEC1-105-02-L-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16345392 [ RunTime:0.002856s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001368s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001953s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005871s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001554s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012778s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002166s ]
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-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001818s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MEC1-105-02-L-D%' OR `brand` LIKE 'MEC1-105-02-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001540s ]