SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001328s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=EHT-113-01-L-D-SM&search=1' [ RunTime:0.006153s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001517s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011321s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002200s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.038397s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001654s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.013654s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001293s ]
SELECT * FROM `stock_search` WHERE `partno` = 'EHT-113-01-L-D-SM' LIMIT 1 [ RunTime:0.101975s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-29 10:55:57' WHERE `partno` = 'EHT-113-01-L-D-SM' [ RunTime:0.016004s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001316s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.110783s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227676 LIMIT 5 [ RunTime:0.059527s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.031540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227676 ORDER BY `minOrder` ASC [ RunTime:0.054240s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.070012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227676 ORDER BY `unit` DESC [ RunTime:0.050859s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227676 LIMIT 2 [ RunTime:0.145537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227676 ORDER BY `minOrder` ASC [ RunTime:0.062686s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.099441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764707 LIMIT 5 [ RunTime:0.052239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764707 ORDER BY `minOrder` ASC [ RunTime:0.043822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12764707 ORDER BY `unit` DESC [ RunTime:0.070300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12764707 LIMIT 2 [ RunTime:0.045122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12764707 ORDER BY `minOrder` ASC [ RunTime:0.022613s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC-13' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.064625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754904 LIMIT 5 [ RunTime:0.070081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754904 ORDER BY `minOrder` ASC [ RunTime:0.085950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12754904 ORDER BY `unit` DESC [ RunTime:0.075110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12754904 LIMIT 2 [ RunTime:0.074041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754904 ORDER BY `minOrder` ASC [ RunTime:0.042943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754018 LIMIT 5 [ RunTime:0.027835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754018 ORDER BY `minOrder` ASC [ RunTime:0.101375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12754018 ORDER BY `unit` DESC [ RunTime:0.014654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12754018 LIMIT 2 [ RunTime:0.066942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12754018 ORDER BY `minOrder` ASC [ RunTime:0.027367s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743841 LIMIT 5 [ RunTime:0.032195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743841 ORDER BY `minOrder` ASC [ RunTime:0.074485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743841 ORDER BY `unit` DESC [ RunTime:0.107096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743841 LIMIT 2 [ RunTime:0.047544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743841 ORDER BY `minOrder` ASC [ RunTime:0.006446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743641 LIMIT 5 [ RunTime:0.041135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743641 ORDER BY `minOrder` ASC [ RunTime:0.023574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743641 ORDER BY `unit` DESC [ RunTime:0.065988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743641 LIMIT 2 [ RunTime:0.060936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743641 ORDER BY `minOrder` ASC [ RunTime:0.052734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589838 LIMIT 5 [ RunTime:0.036369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589838 ORDER BY `minOrder` ASC [ RunTime:0.038511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11589838 ORDER BY `unit` DESC [ RunTime:0.066742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11589838 LIMIT 2 [ RunTime:0.039942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589838 ORDER BY `minOrder` ASC [ RunTime:0.031640s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589709 LIMIT 5 [ RunTime:0.030958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589709 ORDER BY `minOrder` ASC [ RunTime:0.014555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11589709 ORDER BY `unit` DESC [ RunTime:0.020391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11589709 LIMIT 2 [ RunTime:0.039686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589709 ORDER BY `minOrder` ASC [ RunTime:0.021722s ]
select * from pdf where partno='EHT-113-01-L-D-SM-13' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589685 LIMIT 5 [ RunTime:0.014491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589685 ORDER BY `minOrder` ASC [ RunTime:0.040458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11589685 ORDER BY `unit` DESC [ RunTime:0.048437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11589685 LIMIT 2 [ RunTime:0.031627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589685 ORDER BY `minOrder` ASC [ RunTime:0.084656s ]
select * from pdf where partno='EHT-113-01-L-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581311 LIMIT 5 [ RunTime:0.039772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581311 ORDER BY `minOrder` ASC [ RunTime:0.015439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11581311 ORDER BY `unit` DESC [ RunTime:0.018780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11581311 LIMIT 2 [ RunTime:0.030281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11581311 ORDER BY `minOrder` ASC [ RunTime:0.047103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575251 LIMIT 5 [ RunTime:0.041935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575251 ORDER BY `minOrder` ASC [ RunTime:0.118486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11575251 ORDER BY `unit` DESC [ RunTime:0.079416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11575251 LIMIT 2 [ RunTime:0.066607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575251 ORDER BY `minOrder` ASC [ RunTime:0.018180s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044288s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738190 LIMIT 5 [ RunTime:0.022491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738190 ORDER BY `minOrder` ASC [ RunTime:0.028024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738190 ORDER BY `unit` DESC [ RunTime:0.089889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738190 LIMIT 2 [ RunTime:0.036398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738190 ORDER BY `minOrder` ASC [ RunTime:0.007657s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC-13' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007712s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-LC-13' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035445s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738190 AND `partno` = 'EHT-113-01-L-D-SM-LC-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12764707 [ RunTime:0.142446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738067 LIMIT 5 [ RunTime:0.018140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738067 ORDER BY `minOrder` ASC [ RunTime:0.049402s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738067 ORDER BY `unit` DESC [ RunTime:0.011089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738067 LIMIT 2 [ RunTime:0.056129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738067 ORDER BY `minOrder` ASC [ RunTime:0.016097s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.036941s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738067 AND `partno` = 'EHT-113-01-L-D-SM-SR-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.034559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59738036 LIMIT 5 [ RunTime:0.007765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738036 ORDER BY `minOrder` ASC [ RunTime:0.016185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59738036 ORDER BY `unit` DESC [ RunTime:0.047813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59738036 LIMIT 2 [ RunTime:0.026821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59738036 ORDER BY `minOrder` ASC [ RunTime:0.038590s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024749s ]
SELECT `id` FROM `stock` WHERE `id` <> 59738036 AND `partno` = 'EHT-113-01-L-D-SM-SR-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737882 LIMIT 5 [ RunTime:0.028950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737882 ORDER BY `minOrder` ASC [ RunTime:0.018075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737882 ORDER BY `unit` DESC [ RunTime:0.036893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737882 LIMIT 2 [ RunTime:0.006295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737882 ORDER BY `minOrder` ASC [ RunTime:0.039565s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.045647s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737882 AND `partno` = 'EHT-113-01-L-D-SM-SR-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589838 [ RunTime:0.026973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737629 LIMIT 5 [ RunTime:0.014442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737629 ORDER BY `minOrder` ASC [ RunTime:0.035053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737629 ORDER BY `unit` DESC [ RunTime:0.040835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737629 LIMIT 2 [ RunTime:0.035000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737629 ORDER BY `minOrder` ASC [ RunTime:0.014165s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022883s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737629 AND `partno` = 'EHT-113-01-L-D-SM-SR-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737490 LIMIT 5 [ RunTime:0.011038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737490 ORDER BY `minOrder` ASC [ RunTime:0.112343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737490 ORDER BY `unit` DESC [ RunTime:0.028311s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737490 LIMIT 2 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737490 ORDER BY `minOrder` ASC [ RunTime:0.002046s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030488s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737490 AND `partno` = 'EHT-113-01-L-D-SM-SR-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737481 LIMIT 5 [ RunTime:0.012741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737481 ORDER BY `minOrder` ASC [ RunTime:0.041637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737481 ORDER BY `unit` DESC [ RunTime:0.026397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737481 LIMIT 2 [ RunTime:0.002427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737481 ORDER BY `minOrder` ASC [ RunTime:0.005809s ]
select * from pdf where partno='EHT-113-01-L-D-SM-13' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-13' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020642s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737481 AND `partno` = 'EHT-113-01-L-D-SM-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589709 [ RunTime:0.007467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59737434 LIMIT 5 [ RunTime:0.027424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737434 ORDER BY `minOrder` ASC [ RunTime:0.015648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59737434 ORDER BY `unit` DESC [ RunTime:0.008966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59737434 LIMIT 2 [ RunTime:0.066971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59737434 ORDER BY `minOrder` ASC [ RunTime:0.020625s ]
select * from pdf where partno='EHT-113-01-L-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040825s ]
SELECT `id` FROM `stock` WHERE `id` <> 59737434 AND `partno` = 'EHT-113-01-L-D-SM-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.050860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589685 [ RunTime:0.016294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59725897 LIMIT 5 [ RunTime:0.017902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725897 ORDER BY `minOrder` ASC [ RunTime:0.011225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59725897 ORDER BY `unit` DESC [ RunTime:0.021193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59725897 LIMIT 2 [ RunTime:0.010825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59725897 ORDER BY `minOrder` ASC [ RunTime:0.033839s ]
select * from pdf where partno='EHT-113-01-L-D-SM-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.050051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017604s ]
SELECT `id` FROM `stock` WHERE `id` <> 59725897 AND `partno` = 'EHT-113-01-L-D-SM-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59724820 LIMIT 5 [ RunTime:0.021647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724820 ORDER BY `minOrder` ASC [ RunTime:0.017800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59724820 ORDER BY `unit` DESC [ RunTime:0.003238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59724820 LIMIT 2 [ RunTime:0.008085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59724820 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
select * from pdf where partno='EHT-113-01-L-D-SM-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013398s ]
SELECT `id` FROM `stock` WHERE `id` <> 59724820 AND `partno` = 'EHT-113-01-L-D-SM-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59719547 LIMIT 5 [ RunTime:0.024700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719547 ORDER BY `minOrder` ASC [ RunTime:0.035111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59719547 ORDER BY `unit` DESC [ RunTime:0.008334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59719547 LIMIT 2 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59719547 ORDER BY `minOrder` ASC [ RunTime:0.001419s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030432s ]
SELECT `id` FROM `stock` WHERE `id` <> 59719547 AND `partno` = 'EHT-113-01-L-D-SM-SR-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.040572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59713221 LIMIT 5 [ RunTime:0.006316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59713221 ORDER BY `minOrder` ASC [ RunTime:0.010877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59713221 ORDER BY `unit` DESC [ RunTime:0.051844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59713221 LIMIT 2 [ RunTime:0.081808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59713221 ORDER BY `minOrder` ASC [ RunTime:0.032687s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029245s ]
SELECT `id` FROM `stock` WHERE `id` <> 59713221 AND `partno` = 'EHT-113-01-L-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.045529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754904 [ RunTime:0.031560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710573 LIMIT 5 [ RunTime:0.033954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710573 ORDER BY `minOrder` ASC [ RunTime:0.023486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710573 ORDER BY `unit` DESC [ RunTime:0.058661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710573 LIMIT 2 [ RunTime:0.026184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710573 ORDER BY `minOrder` ASC [ RunTime:0.050665s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030527s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710573 AND `partno` = 'EHT-113-01-L-D-SM-SR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12754018 [ RunTime:0.047796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59710051 LIMIT 5 [ RunTime:0.071283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710051 ORDER BY `minOrder` ASC [ RunTime:0.072858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59710051 ORDER BY `unit` DESC [ RunTime:0.051307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59710051 LIMIT 2 [ RunTime:0.035309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59710051 ORDER BY `minOrder` ASC [ RunTime:0.034218s ]
select * from pdf where partno='EHT-113-01-L-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041307s ]
SELECT `id` FROM `stock` WHERE `id` <> 59710051 AND `partno` = 'EHT-113-01-L-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11581311 [ RunTime:0.044518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59706371 LIMIT 5 [ RunTime:0.020644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706371 ORDER BY `minOrder` ASC [ RunTime:0.032239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59706371 ORDER BY `unit` DESC [ RunTime:0.028091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59706371 LIMIT 2 [ RunTime:0.058646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59706371 ORDER BY `minOrder` ASC [ RunTime:0.033222s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020251s ]
SELECT `id` FROM `stock` WHERE `id` <> 59706371 AND `partno` = 'EHT-113-01-L-D-SM-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.071049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705972 LIMIT 5 [ RunTime:0.077392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705972 ORDER BY `minOrder` ASC [ RunTime:0.031374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705972 ORDER BY `unit` DESC [ RunTime:0.013498s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705972 LIMIT 2 [ RunTime:0.015477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705972 ORDER BY `minOrder` ASC [ RunTime:0.014631s ]
select * from pdf where partno='EHT-113-01-L-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011135s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705972 AND `partno` = 'EHT-113-01-L-D-SM-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575251 [ RunTime:0.004441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705757 LIMIT 5 [ RunTime:0.011653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705757 ORDER BY `minOrder` ASC [ RunTime:0.030508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705757 ORDER BY `unit` DESC [ RunTime:0.045966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705757 LIMIT 2 [ RunTime:0.005717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705757 ORDER BY `minOrder` ASC [ RunTime:0.009395s ]
select * from pdf where partno='EHT-113-01-L-D-SM-SR-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-SR-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019754s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705757 AND `partno` = 'EHT-113-01-L-D-SM-SR-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.031478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59705196 LIMIT 5 [ RunTime:0.008882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705196 ORDER BY `minOrder` ASC [ RunTime:0.023418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59705196 ORDER BY `unit` DESC [ RunTime:0.025819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59705196 LIMIT 2 [ RunTime:0.025703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59705196 ORDER BY `minOrder` ASC [ RunTime:0.010987s ]
select * from pdf where partno='EHT-113-01-L-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019329s ]
SELECT `id` FROM `stock` WHERE `id` <> 59705196 AND `partno` = 'EHT-113-01-L-D-SM-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743641 [ RunTime:0.016061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59704140 LIMIT 5 [ RunTime:0.043221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704140 ORDER BY `minOrder` ASC [ RunTime:0.018280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59704140 ORDER BY `unit` DESC [ RunTime:0.009061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59704140 LIMIT 2 [ RunTime:0.004102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59704140 ORDER BY `minOrder` ASC [ RunTime:0.015653s ]
select * from pdf where partno='EHT-113-01-L-D-SM-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012616s ]
SELECT `id` FROM `stock` WHERE `id` <> 59704140 AND `partno` = 'EHT-113-01-L-D-SM-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743841 [ RunTime:0.026840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59511709 LIMIT 5 [ RunTime:0.010087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511709 ORDER BY `minOrder` ASC [ RunTime:0.006286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59511709 ORDER BY `unit` DESC [ RunTime:0.021121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59511709 LIMIT 2 [ RunTime:0.004717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59511709 ORDER BY `minOrder` ASC [ RunTime:0.010073s ]
select * from pdf where partno='EHT-113-01-L-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-113-01-L-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009303s ]
SELECT `id` FROM `stock` WHERE `id` <> 59511709 AND `partno` = 'EHT-113-01-L-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227676 [ RunTime:0.010577s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011300s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010423s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041430s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012292s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003914s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057800s ]
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 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032488s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHT-113-01-L-D-SM%' OR `brand` LIKE 'EHT-113-01-L-D-SM%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.045904s ]