SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002126s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=TSM-103-03-T-SH&search=1' [ RunTime:0.002043s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002141s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002108s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002313s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011129s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002552s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TSM-103-03-T-SH' LIMIT 1 [ RunTime:0.002082s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 12:06:51' WHERE `partno` = 'TSM-103-03-T-SH' [ RunTime:0.002862s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002744s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022465s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473664 LIMIT 5 [ RunTime:0.002507s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473664 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473664 ORDER BY `unit` DESC [ RunTime:0.002315s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473664 LIMIT 2 [ RunTime:0.000814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473664 ORDER BY `minOrder` ASC [ RunTime:0.009241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12719718 LIMIT 5 [ RunTime:0.001504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12719718 ORDER BY `minOrder` ASC [ RunTime:0.003094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12719718 ORDER BY `unit` DESC [ RunTime:0.000630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12719718 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12719718 ORDER BY `minOrder` ASC [ RunTime:0.012444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716556 LIMIT 5 [ RunTime:0.002539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716556 ORDER BY `minOrder` ASC [ RunTime:0.000741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12716556 ORDER BY `unit` DESC [ RunTime:0.008377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12716556 LIMIT 2 [ RunTime:0.003179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716556 ORDER BY `minOrder` ASC [ RunTime:0.001725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716108 LIMIT 5 [ RunTime:0.005362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716108 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12716108 ORDER BY `unit` DESC [ RunTime:0.010798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12716108 LIMIT 2 [ RunTime:0.013350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12716108 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12715214 LIMIT 5 [ RunTime:0.001362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12715214 ORDER BY `minOrder` ASC [ RunTime:0.008877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12715214 ORDER BY `unit` DESC [ RunTime:0.013752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12715214 LIMIT 2 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12715214 ORDER BY `minOrder` ASC [ RunTime:0.006403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12714752 LIMIT 5 [ RunTime:0.005778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12714752 ORDER BY `minOrder` ASC [ RunTime:0.005552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12714752 ORDER BY `unit` DESC [ RunTime:0.012666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12714752 LIMIT 2 [ RunTime:0.005255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12714752 ORDER BY `minOrder` ASC [ RunTime:0.001130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12708833 LIMIT 5 [ RunTime:0.012030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12708833 ORDER BY `minOrder` ASC [ RunTime:0.012387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12708833 ORDER BY `unit` DESC [ RunTime:0.006918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12708833 LIMIT 2 [ RunTime:0.033590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12708833 ORDER BY `minOrder` ASC [ RunTime:0.008572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11596367 LIMIT 5 [ RunTime:0.017562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596367 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11596367 ORDER BY `unit` DESC [ RunTime:0.021958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11596367 LIMIT 2 [ RunTime:0.004888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596367 ORDER BY `minOrder` ASC [ RunTime:0.002536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11556652 LIMIT 5 [ RunTime:0.026064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11556652 ORDER BY `minOrder` ASC [ RunTime:0.012845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11556652 ORDER BY `unit` DESC [ RunTime:0.010984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11556652 LIMIT 2 [ RunTime:0.029361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11556652 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017295s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52761226 LIMIT 5 [ RunTime:0.015191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52761226 ORDER BY `minOrder` ASC [ RunTime:0.040041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52761226 ORDER BY `unit` DESC [ RunTime:0.036514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52761226 LIMIT 2 [ RunTime:0.044121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52761226 ORDER BY `minOrder` ASC [ RunTime:0.031722s ]
select * from pdf where partno='TSM-103-03-T-SH-A-003-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022054s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-A-003-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020532s ]
SELECT `id` FROM `stock` WHERE `id` <> 52761226 AND `partno` = 'TSM-103-03-T-SH-A-003-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52761224 LIMIT 5 [ RunTime:0.026705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52761224 ORDER BY `minOrder` ASC [ RunTime:0.026308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52761224 ORDER BY `unit` DESC [ RunTime:0.031742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52761224 LIMIT 2 [ RunTime:0.032070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52761224 ORDER BY `minOrder` ASC [ RunTime:0.011545s ]
select * from pdf where partno='TSM-103-03-T-SH-A-001-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-A-001-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.050392s ]
SELECT `id` FROM `stock` WHERE `id` <> 52761224 AND `partno` = 'TSM-103-03-T-SH-A-001-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52752266 LIMIT 5 [ RunTime:0.023905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52752266 ORDER BY `minOrder` ASC [ RunTime:0.011747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52752266 ORDER BY `unit` DESC [ RunTime:0.022364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52752266 LIMIT 2 [ RunTime:0.006159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52752266 ORDER BY `minOrder` ASC [ RunTime:0.001382s ]
select * from pdf where partno='TSM-103-03-T-SH-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009803s ]
SELECT `id` FROM `stock` WHERE `id` <> 52752266 AND `partno` = 'TSM-103-03-T-SH-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52748882 LIMIT 5 [ RunTime:0.024289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52748882 ORDER BY `minOrder` ASC [ RunTime:0.021372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52748882 ORDER BY `unit` DESC [ RunTime:0.012689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52748882 LIMIT 2 [ RunTime:0.020856s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52748882 ORDER BY `minOrder` ASC [ RunTime:0.009322s ]
select * from pdf where partno='TSM-103-03-T-SH-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006251s ]
SELECT `id` FROM `stock` WHERE `id` <> 52748882 AND `partno` = 'TSM-103-03-T-SH-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.031151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12719718 [ RunTime:0.009429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52748287 LIMIT 5 [ RunTime:0.018609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52748287 ORDER BY `minOrder` ASC [ RunTime:0.023970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52748287 ORDER BY `unit` DESC [ RunTime:0.016015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52748287 LIMIT 2 [ RunTime:0.018256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52748287 ORDER BY `minOrder` ASC [ RunTime:0.004791s ]
select * from pdf where partno='TSM-103-03-T-SH-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009517s ]
SELECT `id` FROM `stock` WHERE `id` <> 52748287 AND `partno` = 'TSM-103-03-T-SH-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11556652 [ RunTime:0.026865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52743573 LIMIT 5 [ RunTime:0.013111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52743573 ORDER BY `minOrder` ASC [ RunTime:0.032396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52743573 ORDER BY `unit` DESC [ RunTime:0.008596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52743573 LIMIT 2 [ RunTime:0.025314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52743573 ORDER BY `minOrder` ASC [ RunTime:0.006176s ]
select * from pdf where partno='TSM-103-03-T-SH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013029s ]
SELECT `id` FROM `stock` WHERE `id` <> 52743573 AND `partno` = 'TSM-103-03-T-SH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716556 [ RunTime:0.013828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52742835 LIMIT 5 [ RunTime:0.007697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52742835 ORDER BY `minOrder` ASC [ RunTime:0.008005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52742835 ORDER BY `unit` DESC [ RunTime:0.007523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52742835 LIMIT 2 [ RunTime:0.012238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52742835 ORDER BY `minOrder` ASC [ RunTime:0.009686s ]
select * from pdf where partno='TSM-103-03-T-SH-002-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-002-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006723s ]
SELECT `id` FROM `stock` WHERE `id` <> 52742835 AND `partno` = 'TSM-103-03-T-SH-002-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12716108 [ RunTime:0.018496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52741447 LIMIT 5 [ RunTime:0.014131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52741447 ORDER BY `minOrder` ASC [ RunTime:0.041738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52741447 ORDER BY `unit` DESC [ RunTime:0.006115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52741447 LIMIT 2 [ RunTime:0.010005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52741447 ORDER BY `minOrder` ASC [ RunTime:0.016642s ]
select * from pdf where partno='TSM-103-03-T-SH-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002993s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012327s ]
SELECT `id` FROM `stock` WHERE `id` <> 52741447 AND `partno` = 'TSM-103-03-T-SH-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12715214 [ RunTime:0.003309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52740699 LIMIT 5 [ RunTime:0.017893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52740699 ORDER BY `minOrder` ASC [ RunTime:0.020165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52740699 ORDER BY `unit` DESC [ RunTime:0.014669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52740699 LIMIT 2 [ RunTime:0.027064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52740699 ORDER BY `minOrder` ASC [ RunTime:0.001788s ]
select * from pdf where partno='TSM-103-03-T-SH-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009190s ]
SELECT `id` FROM `stock` WHERE `id` <> 52740699 AND `partno` = 'TSM-103-03-T-SH-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.058383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12714752 [ RunTime:0.022045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52729557 LIMIT 5 [ RunTime:0.023494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52729557 ORDER BY `minOrder` ASC [ RunTime:0.030259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52729557 ORDER BY `unit` DESC [ RunTime:0.020373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52729557 LIMIT 2 [ RunTime:0.028052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52729557 ORDER BY `minOrder` ASC [ RunTime:0.006038s ]
select * from pdf where partno='TSM-103-03-T-SH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019696s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006637s ]
SELECT `id` FROM `stock` WHERE `id` <> 52729557 AND `partno` = 'TSM-103-03-T-SH-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12708833 [ RunTime:0.008600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52688240 LIMIT 5 [ RunTime:0.017293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688240 ORDER BY `minOrder` ASC [ RunTime:0.026580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52688240 ORDER BY `unit` DESC [ RunTime:0.007141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52688240 LIMIT 2 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688240 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
select * from pdf where partno='TSM-103-03-T-SH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-103-03-T-SH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014156s ]
SELECT `id` FROM `stock` WHERE `id` <> 52688240 AND `partno` = 'TSM-103-03-T-SH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473664 [ RunTime:0.013670s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017699s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023548s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011173s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009847s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013028s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010539s ]
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 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026725s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSM-103-03-T-SH%' OR `brand` LIKE 'TSM-103-03-T-SH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024372s ]