SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001745s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.113' , `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-105-02-F-D-BE&search=1' [ RunTime:0.002215s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003087s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000741s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002376s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.113' ) [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002272s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002244s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CLM-105-02-F-D-BE' LIMIT 1 [ RunTime:0.001002s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-06 17:59:44' WHERE `partno` = 'CLM-105-02-F-D-BE' [ RunTime:0.001915s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002415s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004933s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12670234 LIMIT 5 [ RunTime:0.002050s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12670234 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12670234 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12670234 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12670234 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
select * from pdf where partno='CLM-105-02-F-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681272 LIMIT 5 [ RunTime:0.000846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681272 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681272 ORDER BY `unit` DESC [ RunTime:0.007891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681272 LIMIT 2 [ RunTime:0.000380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681272 ORDER BY `minOrder` ASC [ RunTime:0.000252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679321 LIMIT 5 [ RunTime:0.000833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679321 ORDER BY `minOrder` ASC [ RunTime:0.003033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679321 ORDER BY `unit` DESC [ RunTime:0.003890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679321 LIMIT 2 [ RunTime:0.002395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679321 ORDER BY `minOrder` ASC [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662808 LIMIT 5 [ RunTime:0.002190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662808 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662808 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662808 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662808 ORDER BY `minOrder` ASC [ RunTime:0.003448s ]
select * from pdf where partno='CLM-105-02-F-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11531859 LIMIT 5 [ RunTime:0.004805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11531859 ORDER BY `minOrder` ASC [ RunTime:0.017378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11531859 ORDER BY `unit` DESC [ RunTime:0.008652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11531859 LIMIT 2 [ RunTime:0.009510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11531859 ORDER BY `minOrder` ASC [ RunTime:0.006119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529853 LIMIT 5 [ RunTime:0.002665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529853 ORDER BY `minOrder` ASC [ RunTime:0.022585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11529853 ORDER BY `unit` DESC [ RunTime:0.008200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11529853 LIMIT 2 [ RunTime:0.000811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11529853 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11497768 LIMIT 5 [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497768 ORDER BY `minOrder` ASC [ RunTime:0.019654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11497768 ORDER BY `unit` DESC [ RunTime:0.022192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11497768 LIMIT 2 [ RunTime:0.017019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11497768 ORDER BY `minOrder` ASC [ RunTime:0.003384s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005366s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752116 LIMIT 5 [ RunTime:0.005740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752116 ORDER BY `minOrder` ASC [ RunTime:0.016407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752116 ORDER BY `unit` DESC [ RunTime:0.045910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752116 LIMIT 2 [ RunTime:0.002680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752116 ORDER BY `minOrder` ASC [ RunTime:0.014274s ]
select * from pdf where partno='CLM-105-02-F-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002137s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010392s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752116 AND `partno` = 'CLM-105-02-F-D-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12670234 [ RunTime:0.016905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59856143 LIMIT 5 [ RunTime:0.014989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59856143 ORDER BY `minOrder` ASC [ RunTime:0.005232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59856143 ORDER BY `unit` DESC [ RunTime:0.017112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59856143 LIMIT 2 [ RunTime:0.021970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59856143 ORDER BY `minOrder` ASC [ RunTime:0.002312s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008284s ]
SELECT `id` FROM `stock` WHERE `id` <> 59856143 AND `partno` = 'CLM-105-02-F-D-BE-A-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59854760 LIMIT 5 [ RunTime:0.007054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854760 ORDER BY `minOrder` ASC [ RunTime:0.013774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59854760 ORDER BY `unit` DESC [ RunTime:0.011567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59854760 LIMIT 2 [ RunTime:0.005023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854760 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003418s ]
SELECT `id` FROM `stock` WHERE `id` <> 59854760 AND `partno` = 'CLM-105-02-F-D-BE-A-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11497768 [ RunTime:0.013551s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59853075 LIMIT 5 [ RunTime:0.016624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853075 ORDER BY `minOrder` ASC [ RunTime:0.007187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59853075 ORDER BY `unit` DESC [ RunTime:0.023459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59853075 LIMIT 2 [ RunTime:0.006499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853075 ORDER BY `minOrder` ASC [ RunTime:0.014740s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010581s ]
SELECT `id` FROM `stock` WHERE `id` <> 59853075 AND `partno` = 'CLM-105-02-F-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59852078 LIMIT 5 [ RunTime:0.010618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852078 ORDER BY `minOrder` ASC [ RunTime:0.010288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59852078 ORDER BY `unit` DESC [ RunTime:0.005178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59852078 LIMIT 2 [ RunTime:0.003248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852078 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000974s ]
SELECT `id` FROM `stock` WHERE `id` <> 59852078 AND `partno` = 'CLM-105-02-F-D-BE-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59821318 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59821318 ORDER BY `minOrder` ASC [ RunTime:0.001324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59821318 ORDER BY `unit` DESC [ RunTime:0.013614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59821318 LIMIT 2 [ RunTime:0.010153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59821318 ORDER BY `minOrder` ASC [ RunTime:0.011517s ]
select * from pdf where partno='CLM-105-02-F-D-BE-PA-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-PA-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017678s ]
SELECT `id` FROM `stock` WHERE `id` <> 59821318 AND `partno` = 'CLM-105-02-F-D-BE-PA-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59813733 LIMIT 5 [ RunTime:0.009118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813733 ORDER BY `minOrder` ASC [ RunTime:0.001733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59813733 ORDER BY `unit` DESC [ RunTime:0.000804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59813733 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813733 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001165s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005626s ]
SELECT `id` FROM `stock` WHERE `id` <> 59813733 AND `partno` = 'CLM-105-02-F-D-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59813005 LIMIT 5 [ RunTime:0.003843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813005 ORDER BY `minOrder` ASC [ RunTime:0.002526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59813005 ORDER BY `unit` DESC [ RunTime:0.000460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59813005 LIMIT 2 [ RunTime:0.001635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813005 ORDER BY `minOrder` ASC [ RunTime:0.010221s ]
select * from pdf where partno='CLM-105-02-F-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002829s ]
SELECT `id` FROM `stock` WHERE `id` <> 59813005 AND `partno` = 'CLM-105-02-F-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59809032 LIMIT 5 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59809032 ORDER BY `minOrder` ASC [ RunTime:0.015629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59809032 ORDER BY `unit` DESC [ RunTime:0.002297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59809032 LIMIT 2 [ RunTime:0.003030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59809032 ORDER BY `minOrder` ASC [ RunTime:0.004703s ]
select * from pdf where partno='CLM-105-02-F-D-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003336s ]
SELECT `id` FROM `stock` WHERE `id` <> 59809032 AND `partno` = 'CLM-105-02-F-D-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59806886 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806886 ORDER BY `minOrder` ASC [ RunTime:0.014749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59806886 ORDER BY `unit` DESC [ RunTime:0.012490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59806886 LIMIT 2 [ RunTime:0.002264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806886 ORDER BY `minOrder` ASC [ RunTime:0.006951s ]
select * from pdf where partno='CLM-105-02-F-D-BE-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005042s ]
SELECT `id` FROM `stock` WHERE `id` <> 59806886 AND `partno` = 'CLM-105-02-F-D-BE-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11531859 [ RunTime:0.004850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59802148 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802148 ORDER BY `minOrder` ASC [ RunTime:0.011560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59802148 ORDER BY `unit` DESC [ RunTime:0.006451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59802148 LIMIT 2 [ RunTime:0.010533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802148 ORDER BY `minOrder` ASC [ RunTime:0.013204s ]
select * from pdf where partno='CLM-105-02-F-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001032s ]
SELECT `id` FROM `stock` WHERE `id` <> 59802148 AND `partno` = 'CLM-105-02-F-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681272 [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59801262 LIMIT 5 [ RunTime:0.010612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801262 ORDER BY `minOrder` ASC [ RunTime:0.013774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59801262 ORDER BY `unit` DESC [ RunTime:0.001192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59801262 LIMIT 2 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801262 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='CLM-105-02-F-D-BE-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007652s ]
SELECT `id` FROM `stock` WHERE `id` <> 59801262 AND `partno` = 'CLM-105-02-F-D-BE-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679321 [ RunTime:0.014616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59800390 LIMIT 5 [ RunTime:0.006295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800390 ORDER BY `minOrder` ASC [ RunTime:0.010800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59800390 ORDER BY `unit` DESC [ RunTime:0.016764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59800390 LIMIT 2 [ RunTime:0.008375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800390 ORDER BY `minOrder` ASC [ RunTime:0.007904s ]
select * from pdf where partno='CLM-105-02-F-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015102s ]
SELECT `id` FROM `stock` WHERE `id` <> 59800390 AND `partno` = 'CLM-105-02-F-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11529853 [ RunTime:0.012072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59799066 LIMIT 5 [ RunTime:0.015992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799066 ORDER BY `minOrder` ASC [ RunTime:0.007968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59799066 ORDER BY `unit` DESC [ RunTime:0.014727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59799066 LIMIT 2 [ RunTime:0.009731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799066 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
select * from pdf where partno='CLM-105-02-F-D-BE-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002929s ]
SELECT `id` FROM `stock` WHERE `id` <> 59799066 AND `partno` = 'CLM-105-02-F-D-BE-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59765987 LIMIT 5 [ RunTime:0.010101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765987 ORDER BY `minOrder` ASC [ RunTime:0.006976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59765987 ORDER BY `unit` DESC [ RunTime:0.013260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59765987 LIMIT 2 [ RunTime:0.003657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59765987 ORDER BY `minOrder` ASC [ RunTime:0.004241s ]
select * from pdf where partno='CLM-105-02-F-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-105-02-F-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003856s ]
SELECT `id` FROM `stock` WHERE `id` <> 59765987 AND `partno` = 'CLM-105-02-F-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662808 [ RunTime:0.004938s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002182s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002264s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004583s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009372s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008188s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002462s ]
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-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011599s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLM-105-02-F-D-BE%' OR `brand` LIKE 'CLM-105-02-F-D-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003199s ]