SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002478s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.165' , `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-122-01-SM-D&search=1' [ RunTime:0.023019s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002227s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.013499s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002610s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.165' ) [ RunTime:0.015419s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002731s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011568s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001605s ]
SELECT * FROM `stock_search` WHERE `partno` = 'EHT-122-01-SM-D' LIMIT 1 [ RunTime:0.030663s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-26 03:06:18' WHERE `partno` = 'EHT-122-01-SM-D' [ RunTime:0.028008s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002393s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050441s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765645 LIMIT 5 [ RunTime:0.050743s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765645 ORDER BY `minOrder` ASC [ RunTime:0.041844s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765645 ORDER BY `unit` DESC [ RunTime:0.071692s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.036625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765645 LIMIT 2 [ RunTime:0.028417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765645 ORDER BY `minOrder` ASC [ RunTime:0.053943s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-LC-20-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765599 LIMIT 5 [ RunTime:0.047804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765599 ORDER BY `minOrder` ASC [ RunTime:0.020980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765599 ORDER BY `unit` DESC [ RunTime:0.042893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765599 LIMIT 2 [ RunTime:0.041720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765599 ORDER BY `minOrder` ASC [ RunTime:0.025805s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.067327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765559 LIMIT 5 [ RunTime:0.049148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765559 ORDER BY `minOrder` ASC [ RunTime:0.016651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765559 ORDER BY `unit` DESC [ RunTime:0.028030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765559 LIMIT 2 [ RunTime:0.078512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765559 ORDER BY `minOrder` ASC [ RunTime:0.024973s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-20-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765522 LIMIT 5 [ RunTime:0.058694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765522 ORDER BY `minOrder` ASC [ RunTime:0.044956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765522 ORDER BY `unit` DESC [ RunTime:0.021892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765522 LIMIT 2 [ RunTime:0.077668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765522 ORDER BY `minOrder` ASC [ RunTime:0.003368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765483 LIMIT 5 [ RunTime:0.051781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765483 ORDER BY `minOrder` ASC [ RunTime:0.041493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12765483 ORDER BY `unit` DESC [ RunTime:0.050718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12765483 LIMIT 2 [ RunTime:0.060302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12765483 ORDER BY `minOrder` ASC [ RunTime:0.028979s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763654 LIMIT 5 [ RunTime:0.015332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763654 ORDER BY `minOrder` ASC [ RunTime:0.012061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12763654 ORDER BY `unit` DESC [ RunTime:0.017042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12763654 LIMIT 2 [ RunTime:0.020458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12763654 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
select * from pdf where partno='EHT-122-01-SM-D-20' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761886 LIMIT 5 [ RunTime:0.044435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761886 ORDER BY `minOrder` ASC [ RunTime:0.044806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12761886 ORDER BY `unit` DESC [ RunTime:0.040163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12761886 LIMIT 2 [ RunTime:0.005813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12761886 ORDER BY `minOrder` ASC [ RunTime:0.023508s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11590430 LIMIT 5 [ RunTime:0.028088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11590430 ORDER BY `minOrder` ASC [ RunTime:0.042270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11590430 ORDER BY `unit` DESC [ RunTime:0.068408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11590430 LIMIT 2 [ RunTime:0.019913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11590430 ORDER BY `minOrder` ASC [ RunTime:0.032493s ]
select * from pdf where partno='EHT-122-01-SM-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589664 LIMIT 5 [ RunTime:0.018831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589664 ORDER BY `minOrder` ASC [ RunTime:0.039278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11589664 ORDER BY `unit` DESC [ RunTime:0.050317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11589664 LIMIT 2 [ RunTime:0.071576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589664 ORDER BY `minOrder` ASC [ RunTime:0.016524s ]
select * from pdf where partno='EHT-122-01-SM-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589130 LIMIT 5 [ RunTime:0.025084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589130 ORDER BY `minOrder` ASC [ RunTime:0.025388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11589130 ORDER BY `unit` DESC [ RunTime:0.011477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11589130 LIMIT 2 [ RunTime:0.021628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11589130 ORDER BY `minOrder` ASC [ RunTime:0.011290s ]
select * from pdf where partno='EHT-122-01-SM-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015494s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020185s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52882825 LIMIT 5 [ RunTime:0.069121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52882825 ORDER BY `minOrder` ASC [ RunTime:0.036354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52882825 ORDER BY `unit` DESC [ RunTime:0.022892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52882825 LIMIT 2 [ RunTime:0.030831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52882825 ORDER BY `minOrder` ASC [ RunTime:0.032954s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020785s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017790s ]
SELECT `id` FROM `stock` WHERE `id` <> 52882825 AND `partno` = 'EHT-122-01-SM-D-SM-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52881018 LIMIT 5 [ RunTime:0.116838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52881018 ORDER BY `minOrder` ASC [ RunTime:0.124392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52881018 ORDER BY `unit` DESC [ RunTime:0.038174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52881018 LIMIT 2 [ RunTime:0.082127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52881018 ORDER BY `minOrder` ASC [ RunTime:0.039681s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-20-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-20-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.060920s ]
SELECT `id` FROM `stock` WHERE `id` <> 52881018 AND `partno` = 'EHT-122-01-SM-D-SM-20-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.159158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765559 [ RunTime:0.023999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52880201 LIMIT 5 [ RunTime:0.065868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52880201 ORDER BY `minOrder` ASC [ RunTime:0.038231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52880201 ORDER BY `unit` DESC [ RunTime:0.079701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52880201 LIMIT 2 [ RunTime:0.054443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52880201 ORDER BY `minOrder` ASC [ RunTime:0.054568s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-LC-20-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-LC-20-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027875s ]
SELECT `id` FROM `stock` WHERE `id` <> 52880201 AND `partno` = 'EHT-122-01-SM-D-SM-LC-20-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.061900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765645 [ RunTime:0.018170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52880067 LIMIT 5 [ RunTime:0.025856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52880067 ORDER BY `minOrder` ASC [ RunTime:0.031657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52880067 ORDER BY `unit` DESC [ RunTime:0.076103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52880067 LIMIT 2 [ RunTime:0.068734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52880067 ORDER BY `minOrder` ASC [ RunTime:0.018524s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015986s ]
SELECT `id` FROM `stock` WHERE `id` <> 52880067 AND `partno` = 'EHT-122-01-SM-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765599 [ RunTime:0.029374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879854 LIMIT 5 [ RunTime:0.040439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879854 ORDER BY `minOrder` ASC [ RunTime:0.022268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879854 ORDER BY `unit` DESC [ RunTime:0.038956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879854 LIMIT 2 [ RunTime:0.028916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879854 ORDER BY `minOrder` ASC [ RunTime:0.079119s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032447s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879854 AND `partno` = 'EHT-122-01-SM-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.107572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879822 LIMIT 5 [ RunTime:0.070829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879822 ORDER BY `minOrder` ASC [ RunTime:0.105214s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879822 ORDER BY `unit` DESC [ RunTime:0.095391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879822 LIMIT 2 [ RunTime:0.056421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879822 ORDER BY `minOrder` ASC [ RunTime:0.052771s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.095483s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879822 AND `partno` = 'EHT-122-01-SM-D-SM-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.095268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765522 [ RunTime:0.138140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879729 LIMIT 5 [ RunTime:0.135324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879729 ORDER BY `minOrder` ASC [ RunTime:0.068781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879729 ORDER BY `unit` DESC [ RunTime:0.036752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879729 LIMIT 2 [ RunTime:0.065715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879729 ORDER BY `minOrder` ASC [ RunTime:0.022142s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.066302s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879729 AND `partno` = 'EHT-122-01-SM-D-SM-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12765483 [ RunTime:0.057116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52879611 LIMIT 5 [ RunTime:0.023644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879611 ORDER BY `minOrder` ASC [ RunTime:0.023953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52879611 ORDER BY `unit` DESC [ RunTime:0.015376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52879611 LIMIT 2 [ RunTime:0.036307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52879611 ORDER BY `minOrder` ASC [ RunTime:0.033514s ]
select * from pdf where partno='EHT-122-01-SM-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024010s ]
SELECT `id` FROM `stock` WHERE `id` <> 52879611 AND `partno` = 'EHT-122-01-SM-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.059945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11590430 [ RunTime:0.096853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52877615 LIMIT 5 [ RunTime:0.025716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877615 ORDER BY `minOrder` ASC [ RunTime:0.045475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52877615 ORDER BY `unit` DESC [ RunTime:0.025244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52877615 LIMIT 2 [ RunTime:0.017657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52877615 ORDER BY `minOrder` ASC [ RunTime:0.048615s ]
select * from pdf where partno='EHT-122-01-SM-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-SM-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043604s ]
SELECT `id` FROM `stock` WHERE `id` <> 52877615 AND `partno` = 'EHT-122-01-SM-D-SM-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12761886 [ RunTime:0.055941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52876835 LIMIT 5 [ RunTime:0.032872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876835 ORDER BY `minOrder` ASC [ RunTime:0.078405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52876835 ORDER BY `unit` DESC [ RunTime:0.059329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52876835 LIMIT 2 [ RunTime:0.006027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52876835 ORDER BY `minOrder` ASC [ RunTime:0.018220s ]
select * from pdf where partno='EHT-122-01-SM-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.033318s ]
SELECT `id` FROM `stock` WHERE `id` <> 52876835 AND `partno` = 'EHT-122-01-SM-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.050867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589664 [ RunTime:0.069208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52875146 LIMIT 5 [ RunTime:0.068048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875146 ORDER BY `minOrder` ASC [ RunTime:0.059721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52875146 ORDER BY `unit` DESC [ RunTime:0.110799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52875146 LIMIT 2 [ RunTime:0.082239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52875146 ORDER BY `minOrder` ASC [ RunTime:0.057926s ]
select * from pdf where partno='EHT-122-01-SM-D-20' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D-20' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.094942s ]
SELECT `id` FROM `stock` WHERE `id` <> 52875146 AND `partno` = 'EHT-122-01-SM-D-20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12763654 [ RunTime:0.117943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52874885 LIMIT 5 [ RunTime:0.065896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874885 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52874885 ORDER BY `unit` DESC [ RunTime:0.051219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52874885 LIMIT 2 [ RunTime:0.116994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52874885 ORDER BY `minOrder` ASC [ RunTime:0.056009s ]
select * from pdf where partno='EHT-122-01-SM-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EHT-122-01-SM-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.042334s ]
SELECT `id` FROM `stock` WHERE `id` <> 52874885 AND `partno` = 'EHT-122-01-SM-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.064073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11589130 [ RunTime:0.036799s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.122094s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.068152s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050836s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067779s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099558s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.121494s ]
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-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037131s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EHT-122-01-SM-D%' OR `brand` LIKE 'EHT-122-01-SM-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004900s ]