SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001597s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=CLM-108-02-H-D&search=1' [ RunTime:0.016349s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001717s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011087s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001372s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.008616s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002825s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009888s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002272s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CLM-108-02-H-D' LIMIT 1 [ RunTime:0.009826s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 11:56:11' WHERE `partno` = 'CLM-108-02-H-D' [ RunTime:0.010367s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001490s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008672s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699136 LIMIT 5 [ RunTime:0.025572s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699136 ORDER BY `minOrder` ASC [ RunTime:0.006484s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12699136 ORDER BY `unit` DESC [ RunTime:0.020553s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.020473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12699136 LIMIT 2 [ RunTime:0.028582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699136 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12687102 LIMIT 5 [ RunTime:0.011511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687102 ORDER BY `minOrder` ASC [ RunTime:0.023291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12687102 ORDER BY `unit` DESC [ RunTime:0.017281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12687102 LIMIT 2 [ RunTime:0.033717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12687102 ORDER BY `minOrder` ASC [ RunTime:0.014790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646656 LIMIT 5 [ RunTime:0.075944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646656 ORDER BY `minOrder` ASC [ RunTime:0.098657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12646656 ORDER BY `unit` DESC [ RunTime:0.072224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12646656 LIMIT 2 [ RunTime:0.018904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646656 ORDER BY `minOrder` ASC [ RunTime:0.015912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646655 LIMIT 5 [ RunTime:0.044676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646655 ORDER BY `minOrder` ASC [ RunTime:0.088164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12646655 ORDER BY `unit` DESC [ RunTime:0.018617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12646655 LIMIT 2 [ RunTime:0.048599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646655 ORDER BY `minOrder` ASC [ RunTime:0.070445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646247 LIMIT 5 [ RunTime:0.053009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646247 ORDER BY `minOrder` ASC [ RunTime:0.028966s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12646247 ORDER BY `unit` DESC [ RunTime:0.043780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12646247 LIMIT 2 [ RunTime:0.053042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12646247 ORDER BY `minOrder` ASC [ RunTime:0.024718s ]
select * from pdf where partno='CLM-108-02-H-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11543222 LIMIT 5 [ RunTime:0.041221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543222 ORDER BY `minOrder` ASC [ RunTime:0.067727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11543222 ORDER BY `unit` DESC [ RunTime:0.081785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11543222 LIMIT 2 [ RunTime:0.019640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11543222 ORDER BY `minOrder` ASC [ RunTime:0.025078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534034 LIMIT 5 [ RunTime:0.039563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534034 ORDER BY `minOrder` ASC [ RunTime:0.031501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534034 ORDER BY `unit` DESC [ RunTime:0.038380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534034 LIMIT 2 [ RunTime:0.027622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534034 ORDER BY `minOrder` ASC [ RunTime:0.022491s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015115s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59879502 LIMIT 5 [ RunTime:0.014696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59879502 ORDER BY `minOrder` ASC [ RunTime:0.059349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59879502 ORDER BY `unit` DESC [ RunTime:0.092189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59879502 LIMIT 2 [ RunTime:0.036273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59879502 ORDER BY `minOrder` ASC [ RunTime:0.026100s ]
select * from pdf where partno='CLM-108-02-H-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026067s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019847s ]
SELECT `id` FROM `stock` WHERE `id` <> 59879502 AND `partno` = 'CLM-108-02-H-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878801 LIMIT 5 [ RunTime:0.027576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878801 ORDER BY `minOrder` ASC [ RunTime:0.063701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878801 ORDER BY `unit` DESC [ RunTime:0.027805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878801 LIMIT 2 [ RunTime:0.048766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878801 ORDER BY `minOrder` ASC [ RunTime:0.006691s ]
select * from pdf where partno='CLM-108-02-H-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043079s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878801 AND `partno` = 'CLM-108-02-H-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.068131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878384 LIMIT 5 [ RunTime:0.038277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878384 ORDER BY `minOrder` ASC [ RunTime:0.052263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878384 ORDER BY `unit` DESC [ RunTime:0.030548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878384 LIMIT 2 [ RunTime:0.092516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878384 ORDER BY `minOrder` ASC [ RunTime:0.019846s ]
select * from pdf where partno='CLM-108-02-H-D-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.055190s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878384 AND `partno` = 'CLM-108-02-H-D-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.095654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878075 LIMIT 5 [ RunTime:0.045290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878075 ORDER BY `minOrder` ASC [ RunTime:0.026998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878075 ORDER BY `unit` DESC [ RunTime:0.025235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878075 LIMIT 2 [ RunTime:0.016441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878075 ORDER BY `minOrder` ASC [ RunTime:0.012039s ]
select * from pdf where partno='CLM-108-02-H-D-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.063147s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878075 AND `partno` = 'CLM-108-02-H-D-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.066775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646655 [ RunTime:0.057063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877926 LIMIT 5 [ RunTime:0.038286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877926 ORDER BY `minOrder` ASC [ RunTime:0.052951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877926 ORDER BY `unit` DESC [ RunTime:0.028054s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877926 LIMIT 2 [ RunTime:0.074155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877926 ORDER BY `minOrder` ASC [ RunTime:0.053787s ]
select * from pdf where partno='CLM-108-02-H-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045975s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022850s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877926 AND `partno` = 'CLM-108-02-H-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877478 LIMIT 5 [ RunTime:0.028982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877478 ORDER BY `minOrder` ASC [ RunTime:0.067531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877478 ORDER BY `unit` DESC [ RunTime:0.048332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877478 LIMIT 2 [ RunTime:0.046934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877478 ORDER BY `minOrder` ASC [ RunTime:0.015289s ]
select * from pdf where partno='CLM-108-02-H-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017880s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877478 AND `partno` = 'CLM-108-02-H-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646247 [ RunTime:0.018869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59876300 LIMIT 5 [ RunTime:0.078250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876300 ORDER BY `minOrder` ASC [ RunTime:0.026768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59876300 ORDER BY `unit` DESC [ RunTime:0.022045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59876300 LIMIT 2 [ RunTime:0.011011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59876300 ORDER BY `minOrder` ASC [ RunTime:0.013287s ]
select * from pdf where partno='CLM-108-02-H-D-BE-A-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-BE-A-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022572s ]
SELECT `id` FROM `stock` WHERE `id` <> 59876300 AND `partno` = 'CLM-108-02-H-D-BE-A-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59873596 LIMIT 5 [ RunTime:0.032339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59873596 ORDER BY `minOrder` ASC [ RunTime:0.046449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59873596 ORDER BY `unit` DESC [ RunTime:0.035585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59873596 LIMIT 2 [ RunTime:0.031025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59873596 ORDER BY `minOrder` ASC [ RunTime:0.013641s ]
select * from pdf where partno='CLM-108-02-H-D-A-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017682s ]
SELECT `id` FROM `stock` WHERE `id` <> 59873596 AND `partno` = 'CLM-108-02-H-D-A-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.043394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12646656 [ RunTime:0.045807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59871895 LIMIT 5 [ RunTime:0.027554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59871895 ORDER BY `minOrder` ASC [ RunTime:0.048165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59871895 ORDER BY `unit` DESC [ RunTime:0.059075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59871895 LIMIT 2 [ RunTime:0.049311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59871895 ORDER BY `minOrder` ASC [ RunTime:0.054604s ]
select * from pdf where partno='CLM-108-02-H-D-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.061785s ]
SELECT `id` FROM `stock` WHERE `id` <> 59871895 AND `partno` = 'CLM-108-02-H-D-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.090035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59845548 LIMIT 5 [ RunTime:0.083144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845548 ORDER BY `minOrder` ASC [ RunTime:0.042850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59845548 ORDER BY `unit` DESC [ RunTime:0.069499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59845548 LIMIT 2 [ RunTime:0.037026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59845548 ORDER BY `minOrder` ASC [ RunTime:0.069329s ]
select * from pdf where partno='CLM-108-02-H-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025831s ]
SELECT `id` FROM `stock` WHERE `id` <> 59845548 AND `partno` = 'CLM-108-02-H-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11543222 [ RunTime:0.026852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59844513 LIMIT 5 [ RunTime:0.013768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844513 ORDER BY `minOrder` ASC [ RunTime:0.067041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59844513 ORDER BY `unit` DESC [ RunTime:0.025849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59844513 LIMIT 2 [ RunTime:0.090265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844513 ORDER BY `minOrder` ASC [ RunTime:0.027934s ]
select * from pdf where partno='CLM-108-02-H-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025410s ]
SELECT `id` FROM `stock` WHERE `id` <> 59844513 AND `partno` = 'CLM-108-02-H-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59843512 LIMIT 5 [ RunTime:0.004940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843512 ORDER BY `minOrder` ASC [ RunTime:0.014357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59843512 ORDER BY `unit` DESC [ RunTime:0.021703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59843512 LIMIT 2 [ RunTime:0.008755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843512 ORDER BY `minOrder` ASC [ RunTime:0.011754s ]
select * from pdf where partno='CLM-108-02-H-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025375s ]
SELECT `id` FROM `stock` WHERE `id` <> 59843512 AND `partno` = 'CLM-108-02-H-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699136 [ RunTime:0.019711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59842998 LIMIT 5 [ RunTime:0.023831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842998 ORDER BY `minOrder` ASC [ RunTime:0.019004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59842998 ORDER BY `unit` DESC [ RunTime:0.021579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59842998 LIMIT 2 [ RunTime:0.016154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842998 ORDER BY `minOrder` ASC [ RunTime:0.005948s ]
select * from pdf where partno='CLM-108-02-H-D-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010771s ]
SELECT `id` FROM `stock` WHERE `id` <> 59842998 AND `partno` = 'CLM-108-02-H-D-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59841839 LIMIT 5 [ RunTime:0.009331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841839 ORDER BY `minOrder` ASC [ RunTime:0.023027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59841839 ORDER BY `unit` DESC [ RunTime:0.012854s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59841839 LIMIT 2 [ RunTime:0.013229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841839 ORDER BY `minOrder` ASC [ RunTime:0.007416s ]
select * from pdf where partno='CLM-108-02-H-D-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014775s ]
SELECT `id` FROM `stock` WHERE `id` <> 59841839 AND `partno` = 'CLM-108-02-H-D-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840538 LIMIT 5 [ RunTime:0.011606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840538 ORDER BY `minOrder` ASC [ RunTime:0.014769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840538 ORDER BY `unit` DESC [ RunTime:0.009641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840538 LIMIT 2 [ RunTime:0.019295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840538 ORDER BY `minOrder` ASC [ RunTime:0.007069s ]
select * from pdf where partno='CLM-108-02-H-D-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006425s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840538 AND `partno` = 'CLM-108-02-H-D-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59826661 LIMIT 5 [ RunTime:0.017591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59826661 ORDER BY `minOrder` ASC [ RunTime:0.023653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59826661 ORDER BY `unit` DESC [ RunTime:0.009977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59826661 LIMIT 2 [ RunTime:0.014628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59826661 ORDER BY `minOrder` ASC [ RunTime:0.007440s ]
select * from pdf where partno='CLM-108-02-H-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021873s ]
SELECT `id` FROM `stock` WHERE `id` <> 59826661 AND `partno` = 'CLM-108-02-H-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12687102 [ RunTime:0.027612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59825197 LIMIT 5 [ RunTime:0.012869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825197 ORDER BY `minOrder` ASC [ RunTime:0.029124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59825197 ORDER BY `unit` DESC [ RunTime:0.023680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59825197 LIMIT 2 [ RunTime:0.023226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825197 ORDER BY `minOrder` ASC [ RunTime:0.003765s ]
select * from pdf where partno='CLM-108-02-H-D-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024464s ]
SELECT `id` FROM `stock` WHERE `id` <> 59825197 AND `partno` = 'CLM-108-02-H-D-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534034 [ RunTime:0.036542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59819777 LIMIT 5 [ RunTime:0.030595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59819777 ORDER BY `minOrder` ASC [ RunTime:0.018931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59819777 ORDER BY `unit` DESC [ RunTime:0.022787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59819777 LIMIT 2 [ RunTime:0.028041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59819777 ORDER BY `minOrder` ASC [ RunTime:0.011671s ]
select * from pdf where partno='CLM-108-02-H-D-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-108-02-H-D-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010082s ]
SELECT `id` FROM `stock` WHERE `id` <> 59819777 AND `partno` = 'CLM-108-02-H-D-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005461s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019626s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011608s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012604s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022990s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010830s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041938s ]
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 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053902s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLM-108-02-H-D%' OR `brand` LIKE 'CLM-108-02-H-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.047783s ]