SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001324s ]
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=CLT-115-02-FM-D-BE&search=1' [ RunTime:0.003604s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001194s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000624s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001969s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.022457s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001451s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.018979s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001174s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CLT-115-02-FM-D-BE' LIMIT 1 [ RunTime:0.032578s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-29 10:38:39' WHERE `partno` = 'CLT-115-02-FM-D-BE' [ RunTime:0.031426s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002263s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043496s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694699 LIMIT 5 [ RunTime:0.052534s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694699 ORDER BY `minOrder` ASC [ RunTime:0.096643s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12694699 ORDER BY `unit` DESC [ RunTime:0.036807s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12694699 LIMIT 2 [ RunTime:0.000740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12694699 ORDER BY `minOrder` ASC [ RunTime:0.060558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681817 LIMIT 5 [ RunTime:0.108528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681817 ORDER BY `minOrder` ASC [ RunTime:0.096805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681817 ORDER BY `unit` DESC [ RunTime:0.046723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681817 LIMIT 2 [ RunTime:0.036829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681817 ORDER BY `minOrder` ASC [ RunTime:0.029983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12636846 LIMIT 5 [ RunTime:0.024336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12636846 ORDER BY `minOrder` ASC [ RunTime:0.068801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12636846 ORDER BY `unit` DESC [ RunTime:0.043378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12636846 LIMIT 2 [ RunTime:0.035131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12636846 ORDER BY `minOrder` ASC [ RunTime:0.012988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11540398 LIMIT 5 [ RunTime:0.025559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11540398 ORDER BY `minOrder` ASC [ RunTime:0.072269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11540398 ORDER BY `unit` DESC [ RunTime:0.054050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11540398 LIMIT 2 [ RunTime:0.087340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11540398 ORDER BY `minOrder` ASC [ RunTime:0.012706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11500174 LIMIT 5 [ RunTime:0.035382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11500174 ORDER BY `minOrder` ASC [ RunTime:0.058240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11500174 ORDER BY `unit` DESC [ RunTime:0.060934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11500174 LIMIT 2 [ RunTime:0.027594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11500174 ORDER BY `minOrder` ASC [ RunTime:0.015344s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.094162s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59865289 LIMIT 5 [ RunTime:0.033545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59865289 ORDER BY `minOrder` ASC [ RunTime:0.050170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59865289 ORDER BY `unit` DESC [ RunTime:0.041271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59865289 LIMIT 2 [ RunTime:0.025579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59865289 ORDER BY `minOrder` ASC [ RunTime:0.018610s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027933s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.073252s ]
SELECT `id` FROM `stock` WHERE `id` <> 59865289 AND `partno` = 'CLT-115-02-FM-D-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59864546 LIMIT 5 [ RunTime:0.021177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864546 ORDER BY `minOrder` ASC [ RunTime:0.012305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59864546 ORDER BY `unit` DESC [ RunTime:0.011257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59864546 LIMIT 2 [ RunTime:0.017438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864546 ORDER BY `minOrder` ASC [ RunTime:0.004836s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014407s ]
SELECT `id` FROM `stock` WHERE `id` <> 59864546 AND `partno` = 'CLT-115-02-FM-D-BE-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59864535 LIMIT 5 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864535 ORDER BY `minOrder` ASC [ RunTime:0.014833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59864535 ORDER BY `unit` DESC [ RunTime:0.007264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59864535 LIMIT 2 [ RunTime:0.002145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864535 ORDER BY `minOrder` ASC [ RunTime:0.002411s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003022s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018223s ]
SELECT `id` FROM `stock` WHERE `id` <> 59864535 AND `partno` = 'CLT-115-02-FM-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59864054 LIMIT 5 [ RunTime:0.011963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864054 ORDER BY `minOrder` ASC [ RunTime:0.009756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59864054 ORDER BY `unit` DESC [ RunTime:0.007349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59864054 LIMIT 2 [ RunTime:0.001687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59864054 ORDER BY `minOrder` ASC [ RunTime:0.003710s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001130s ]
SELECT `id` FROM `stock` WHERE `id` <> 59864054 AND `partno` = 'CLT-115-02-FM-D-BE-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59863273 LIMIT 5 [ RunTime:0.006645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59863273 ORDER BY `minOrder` ASC [ RunTime:0.002574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59863273 ORDER BY `unit` DESC [ RunTime:0.020800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59863273 LIMIT 2 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59863273 ORDER BY `minOrder` ASC [ RunTime:0.020408s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024883s ]
SELECT `id` FROM `stock` WHERE `id` <> 59863273 AND `partno` = 'CLT-115-02-FM-D-BE-A-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59862787 LIMIT 5 [ RunTime:0.003040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59862787 ORDER BY `minOrder` ASC [ RunTime:0.008166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59862787 ORDER BY `unit` DESC [ RunTime:0.000868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59862787 LIMIT 2 [ RunTime:0.002850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59862787 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004195s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001078s ]
SELECT `id` FROM `stock` WHERE `id` <> 59862787 AND `partno` = 'CLT-115-02-FM-D-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11500174 [ RunTime:0.013750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59861787 LIMIT 5 [ RunTime:0.021491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59861787 ORDER BY `minOrder` ASC [ RunTime:0.024682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59861787 ORDER BY `unit` DESC [ RunTime:0.049290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59861787 LIMIT 2 [ RunTime:0.006693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59861787 ORDER BY `minOrder` ASC [ RunTime:0.033387s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022072s ]
SELECT `id` FROM `stock` WHERE `id` <> 59861787 AND `partno` = 'CLT-115-02-FM-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12636846 [ RunTime:0.010942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59861324 LIMIT 5 [ RunTime:0.017069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59861324 ORDER BY `minOrder` ASC [ RunTime:0.017913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59861324 ORDER BY `unit` DESC [ RunTime:0.036589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59861324 LIMIT 2 [ RunTime:0.046171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59861324 ORDER BY `minOrder` ASC [ RunTime:0.011711s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.087846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.038363s ]
SELECT `id` FROM `stock` WHERE `id` <> 59861324 AND `partno` = 'CLT-115-02-FM-D-BE-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59860571 LIMIT 5 [ RunTime:0.080056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59860571 ORDER BY `minOrder` ASC [ RunTime:0.056380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59860571 ORDER BY `unit` DESC [ RunTime:0.064402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59860571 LIMIT 2 [ RunTime:0.039828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59860571 ORDER BY `minOrder` ASC [ RunTime:0.007539s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009476s ]
SELECT `id` FROM `stock` WHERE `id` <> 59860571 AND `partno` = 'CLT-115-02-FM-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59860568 LIMIT 5 [ RunTime:0.029705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59860568 ORDER BY `minOrder` ASC [ RunTime:0.019257s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59860568 ORDER BY `unit` DESC [ RunTime:0.024293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59860568 LIMIT 2 [ RunTime:0.043720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59860568 ORDER BY `minOrder` ASC [ RunTime:0.003287s ]
select * from pdf where partno='CLT-115-02-FM-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057430s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021044s ]
SELECT `id` FROM `stock` WHERE `id` <> 59860568 AND `partno` = 'CLT-115-02-FM-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59835430 LIMIT 5 [ RunTime:0.032493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835430 ORDER BY `minOrder` ASC [ RunTime:0.053117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59835430 ORDER BY `unit` DESC [ RunTime:0.049659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59835430 LIMIT 2 [ RunTime:0.031399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835430 ORDER BY `minOrder` ASC [ RunTime:0.068030s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025859s ]
SELECT `id` FROM `stock` WHERE `id` <> 59835430 AND `partno` = 'CLT-115-02-FM-D-BE-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.057344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831916 LIMIT 5 [ RunTime:0.085397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831916 ORDER BY `minOrder` ASC [ RunTime:0.057423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831916 ORDER BY `unit` DESC [ RunTime:0.076325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831916 LIMIT 2 [ RunTime:0.061496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831916 ORDER BY `minOrder` ASC [ RunTime:0.010386s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.054177s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831916 AND `partno` = 'CLT-115-02-FM-D-BE-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.043034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59830562 LIMIT 5 [ RunTime:0.051752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830562 ORDER BY `minOrder` ASC [ RunTime:0.038307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59830562 ORDER BY `unit` DESC [ RunTime:0.037099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59830562 LIMIT 2 [ RunTime:0.042040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59830562 ORDER BY `minOrder` ASC [ RunTime:0.022418s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010745s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035845s ]
SELECT `id` FROM `stock` WHERE `id` <> 59830562 AND `partno` = 'CLT-115-02-FM-D-BE-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59822756 LIMIT 5 [ RunTime:0.001681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59822756 ORDER BY `minOrder` ASC [ RunTime:0.017414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59822756 ORDER BY `unit` DESC [ RunTime:0.008812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59822756 LIMIT 2 [ RunTime:0.030608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59822756 ORDER BY `minOrder` ASC [ RunTime:0.026287s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009011s ]
SELECT `id` FROM `stock` WHERE `id` <> 59822756 AND `partno` = 'CLT-115-02-FM-D-BE-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11540398 [ RunTime:0.013067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59819874 LIMIT 5 [ RunTime:0.013081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59819874 ORDER BY `minOrder` ASC [ RunTime:0.018866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59819874 ORDER BY `unit` DESC [ RunTime:0.023652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59819874 LIMIT 2 [ RunTime:0.027812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59819874 ORDER BY `minOrder` ASC [ RunTime:0.013417s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 59819874 AND `partno` = 'CLT-115-02-FM-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12694699 [ RunTime:0.010628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59811257 LIMIT 5 [ RunTime:0.012779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811257 ORDER BY `minOrder` ASC [ RunTime:0.016300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59811257 ORDER BY `unit` DESC [ RunTime:0.000801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59811257 LIMIT 2 [ RunTime:0.012678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811257 ORDER BY `minOrder` ASC [ RunTime:0.016232s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007706s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015066s ]
SELECT `id` FROM `stock` WHERE `id` <> 59811257 AND `partno` = 'CLT-115-02-FM-D-BE-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.048733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59808337 LIMIT 5 [ RunTime:0.025743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808337 ORDER BY `minOrder` ASC [ RunTime:0.065878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59808337 ORDER BY `unit` DESC [ RunTime:0.042198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59808337 LIMIT 2 [ RunTime:0.023203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808337 ORDER BY `minOrder` ASC [ RunTime:0.021550s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014559s ]
SELECT `id` FROM `stock` WHERE `id` <> 59808337 AND `partno` = 'CLT-115-02-FM-D-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.107188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59807354 LIMIT 5 [ RunTime:0.030552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59807354 ORDER BY `minOrder` ASC [ RunTime:0.031965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59807354 ORDER BY `unit` DESC [ RunTime:0.029313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59807354 LIMIT 2 [ RunTime:0.132206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59807354 ORDER BY `minOrder` ASC [ RunTime:0.008772s ]
select * from pdf where partno='CLT-115-02-FM-D-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.151616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLT-115-02-FM-D-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028881s ]
SELECT `id` FROM `stock` WHERE `id` <> 59807354 AND `partno` = 'CLT-115-02-FM-D-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.140838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681817 [ RunTime:0.162061s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.306023s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.110005s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.133013s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.091140s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.110609s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082779s ]
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-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104738s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CLT-115-02-FM-D-BE%' OR `brand` LIKE 'CLT-115-02-FM-D-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.186447s ]