SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001208s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=CLT-113-02-S-D-BE&search=1' [ RunTime:0.016408s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001142s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007449s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001735s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006179s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002027s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.016083s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001341s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CLT-113-02-S-D-BE' LIMIT 1 [ RunTime:0.012084s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-25 14:48:52' WHERE `partno` = 'CLT-113-02-S-D-BE' [ RunTime:0.009802s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002554s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015671s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521323 LIMIT 5 [ RunTime:0.010075s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521323 ORDER BY `minOrder` ASC [ RunTime:0.018566s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11521323 ORDER BY `unit` DESC [ RunTime:0.043789s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11521323 LIMIT 2 [ RunTime:0.047838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11521323 ORDER BY `minOrder` ASC [ RunTime:0.029163s ]
select * from pdf where partno='CLT-113-02-S-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.085505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701217 LIMIT 5 [ RunTime:0.050651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701217 ORDER BY `minOrder` ASC [ RunTime:0.068071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12701217 ORDER BY `unit` DESC [ RunTime:0.072467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12701217 LIMIT 2 [ RunTime:0.059396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701217 ORDER BY `minOrder` ASC [ RunTime:0.034184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688069 LIMIT 5 [ RunTime:0.049476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688069 ORDER BY `minOrder` ASC [ RunTime:0.008103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688069 ORDER BY `unit` DESC [ RunTime:0.011818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688069 LIMIT 2 [ RunTime:0.025848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688069 ORDER BY `minOrder` ASC [ RunTime:0.038135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685673 LIMIT 5 [ RunTime:0.029573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685673 ORDER BY `minOrder` ASC [ RunTime:0.014124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12685673 ORDER BY `unit` DESC [ RunTime:0.027249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12685673 LIMIT 2 [ RunTime:0.040645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685673 ORDER BY `minOrder` ASC [ RunTime:0.019944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532689 LIMIT 5 [ RunTime:0.034235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532689 ORDER BY `minOrder` ASC [ RunTime:0.038858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11532689 ORDER BY `unit` DESC [ RunTime:0.027782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11532689 LIMIT 2 [ RunTime:0.029036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532689 ORDER BY `minOrder` ASC [ RunTime:0.029443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518222 LIMIT 5 [ RunTime:0.025173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518222 ORDER BY `minOrder` ASC [ RunTime:0.041849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518222 ORDER BY `unit` DESC [ RunTime:0.075144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518222 LIMIT 2 [ RunTime:0.039060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518222 ORDER BY `minOrder` ASC [ RunTime:0.021315s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054222s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59775252 LIMIT 5 [ RunTime:0.103212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775252 ORDER BY `minOrder` ASC [ RunTime:0.132605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59775252 ORDER BY `unit` DESC [ RunTime:0.196370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59775252 LIMIT 2 [ RunTime:0.047756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775252 ORDER BY `minOrder` ASC [ RunTime:0.045767s ]
select * from pdf where partno='CLT-113-02-S-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.074461s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.080131s ]
SELECT `id` FROM `stock` WHERE `id` <> 59775252 AND `partno` = 'CLT-113-02-S-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.110134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521323 [ RunTime:0.036350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59878282 LIMIT 5 [ RunTime:0.009130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878282 ORDER BY `minOrder` ASC [ RunTime:0.009604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59878282 ORDER BY `unit` DESC [ RunTime:0.016780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59878282 LIMIT 2 [ RunTime:0.030907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59878282 ORDER BY `minOrder` ASC [ RunTime:0.018910s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013347s ]
SELECT `id` FROM `stock` WHERE `id` <> 59878282 AND `partno` = 'CLT-113-02-S-D-BE-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59877876 LIMIT 5 [ RunTime:0.014007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877876 ORDER BY `minOrder` ASC [ RunTime:0.021418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59877876 ORDER BY `unit` DESC [ RunTime:0.018242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59877876 LIMIT 2 [ RunTime:0.052352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59877876 ORDER BY `minOrder` ASC [ RunTime:0.009192s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007262s ]
SELECT `id` FROM `stock` WHERE `id` <> 59877876 AND `partno` = 'CLT-113-02-S-D-BE-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59843323 LIMIT 5 [ RunTime:0.014172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843323 ORDER BY `minOrder` ASC [ RunTime:0.015703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59843323 ORDER BY `unit` DESC [ RunTime:0.029940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59843323 LIMIT 2 [ RunTime:0.030417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59843323 ORDER BY `minOrder` ASC [ RunTime:0.005642s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004319s ]
SELECT `id` FROM `stock` WHERE `id` <> 59843323 AND `partno` = 'CLT-113-02-S-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840884 LIMIT 5 [ RunTime:0.044588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840884 ORDER BY `minOrder` ASC [ RunTime:0.015130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840884 ORDER BY `unit` DESC [ RunTime:0.023409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840884 LIMIT 2 [ RunTime:0.010372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840884 ORDER BY `minOrder` ASC [ RunTime:0.004333s ]
select * from pdf where partno='CLT-113-02-S-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021554s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840884 AND `partno` = 'CLT-113-02-S-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.028215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701217 [ RunTime:0.031848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840169 LIMIT 5 [ RunTime:0.047524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840169 ORDER BY `minOrder` ASC [ RunTime:0.036791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840169 ORDER BY `unit` DESC [ RunTime:0.069755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840169 LIMIT 2 [ RunTime:0.039290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840169 ORDER BY `minOrder` ASC [ RunTime:0.002181s ]
select * from pdf where partno='CLT-113-02-S-D-BE-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.061653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.078746s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840169 AND `partno` = 'CLT-113-02-S-D-BE-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59839153 LIMIT 5 [ RunTime:0.048590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839153 ORDER BY `minOrder` ASC [ RunTime:0.047337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59839153 ORDER BY `unit` DESC [ RunTime:0.044064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59839153 LIMIT 2 [ RunTime:0.047381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59839153 ORDER BY `minOrder` ASC [ RunTime:0.017316s ]
select * from pdf where partno='CLT-113-02-S-D-BE-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021955s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043665s ]
SELECT `id` FROM `stock` WHERE `id` <> 59839153 AND `partno` = 'CLT-113-02-S-D-BE-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59837691 LIMIT 5 [ RunTime:0.061022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59837691 ORDER BY `minOrder` ASC [ RunTime:0.075493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59837691 ORDER BY `unit` DESC [ RunTime:0.022420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59837691 LIMIT 2 [ RunTime:0.044651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59837691 ORDER BY `minOrder` ASC [ RunTime:0.017275s ]
select * from pdf where partno='CLT-113-02-S-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029113s ]
SELECT `id` FROM `stock` WHERE `id` <> 59837691 AND `partno` = 'CLT-113-02-S-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.044582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59825396 LIMIT 5 [ RunTime:0.011779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825396 ORDER BY `minOrder` ASC [ RunTime:0.017326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59825396 ORDER BY `unit` DESC [ RunTime:0.010573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59825396 LIMIT 2 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825396 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014907s ]
SELECT `id` FROM `stock` WHERE `id` <> 59825396 AND `partno` = 'CLT-113-02-S-D-BE-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59825372 LIMIT 5 [ RunTime:0.006979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825372 ORDER BY `minOrder` ASC [ RunTime:0.028672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59825372 ORDER BY `unit` DESC [ RunTime:0.004383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59825372 LIMIT 2 [ RunTime:0.006643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59825372 ORDER BY `minOrder` ASC [ RunTime:0.016053s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014273s ]
SELECT `id` FROM `stock` WHERE `id` <> 59825372 AND `partno` = 'CLT-113-02-S-D-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688069 [ RunTime:0.029077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59823226 LIMIT 5 [ RunTime:0.054044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823226 ORDER BY `minOrder` ASC [ RunTime:0.008832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59823226 ORDER BY `unit` DESC [ RunTime:0.062430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59823226 LIMIT 2 [ RunTime:0.025502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823226 ORDER BY `minOrder` ASC [ RunTime:0.008554s ]
select * from pdf where partno='CLT-113-02-S-D-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.040421s ]
SELECT `id` FROM `stock` WHERE `id` <> 59823226 AND `partno` = 'CLT-113-02-S-D-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685673 [ RunTime:0.069596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59821893 LIMIT 5 [ RunTime:0.062096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59821893 ORDER BY `minOrder` ASC [ RunTime:0.037893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59821893 ORDER BY `unit` DESC [ RunTime:0.056754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59821893 LIMIT 2 [ RunTime:0.055528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59821893 ORDER BY `minOrder` ASC [ RunTime:0.062446s ]
select * from pdf where partno='CLT-113-02-S-D-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052872s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023242s ]
SELECT `id` FROM `stock` WHERE `id` <> 59821893 AND `partno` = 'CLT-113-02-S-D-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.058099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59820240 LIMIT 5 [ RunTime:0.047959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820240 ORDER BY `minOrder` ASC [ RunTime:0.051319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59820240 ORDER BY `unit` DESC [ RunTime:0.042624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59820240 LIMIT 2 [ RunTime:0.003732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820240 ORDER BY `minOrder` ASC [ RunTime:0.003974s ]
select * from pdf where partno='CLT-113-02-S-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.045083s ]
SELECT `id` FROM `stock` WHERE `id` <> 59820240 AND `partno` = 'CLT-113-02-S-D-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532689 [ RunTime:0.070250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59767487 LIMIT 5 [ RunTime:0.023923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59767487 ORDER BY `minOrder` ASC [ RunTime:0.004007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59767487 ORDER BY `unit` DESC [ RunTime:0.000895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59767487 LIMIT 2 [ RunTime:0.009967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59767487 ORDER BY `minOrder` ASC [ RunTime:0.013970s ]
select * from pdf where partno='CLT-113-02-S-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019793s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-113-02-S-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002138s ]
SELECT `id` FROM `stock` WHERE `id` <> 59767487 AND `partno` = 'CLT-113-02-S-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.034765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518222 [ RunTime:0.023181s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017525s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014490s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017499s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066721s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057978s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011889s ]
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 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048045s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLT-113-02-S-D-BE%' OR `brand` LIKE 'CLT-113-02-S-D-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.076393s ]