SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003565s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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-107-02-L-SH&search=1' [ RunTime:0.017241s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001343s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.025690s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001787s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.015481s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001447s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015013s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001251s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TSM-107-02-L-SH' LIMIT 1 [ RunTime:0.018422s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-27 06:45:01' WHERE `partno` = 'TSM-107-02-L-SH' [ RunTime:0.027437s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003297s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026041s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19779892 LIMIT 5 [ RunTime:0.013814s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779892 ORDER BY `minOrder` ASC [ RunTime:0.016174s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19779892 ORDER BY `unit` DESC [ RunTime:0.005286s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19779892 LIMIT 2 [ RunTime:0.006002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19779892 ORDER BY `minOrder` ASC [ RunTime:0.006372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748225 LIMIT 5 [ RunTime:0.011057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748225 ORDER BY `minOrder` ASC [ RunTime:0.009407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19748225 ORDER BY `unit` DESC [ RunTime:0.004432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19748225 LIMIT 2 [ RunTime:0.007999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19748225 ORDER BY `minOrder` ASC [ RunTime:0.003977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220444 LIMIT 5 [ RunTime:0.007352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220444 ORDER BY `minOrder` ASC [ RunTime:0.005713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16220444 ORDER BY `unit` DESC [ RunTime:0.025286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16220444 LIMIT 2 [ RunTime:0.002241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16220444 ORDER BY `minOrder` ASC [ RunTime:0.006726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182897 LIMIT 5 [ RunTime:0.013273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182897 ORDER BY `minOrder` ASC [ RunTime:0.014721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16182897 ORDER BY `unit` DESC [ RunTime:0.001194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16182897 LIMIT 2 [ RunTime:0.011517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16182897 ORDER BY `minOrder` ASC [ RunTime:0.001881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487036 LIMIT 5 [ RunTime:0.001950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487036 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15487036 ORDER BY `unit` DESC [ RunTime:0.003644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15487036 LIMIT 2 [ RunTime:0.002962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15487036 ORDER BY `minOrder` ASC [ RunTime:0.004977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473767 LIMIT 5 [ RunTime:0.004608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473767 ORDER BY `minOrder` ASC [ RunTime:0.015184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15473767 ORDER BY `unit` DESC [ RunTime:0.010194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15473767 LIMIT 2 [ RunTime:0.017503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15473767 ORDER BY `minOrder` ASC [ RunTime:0.006456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12733576 LIMIT 5 [ RunTime:0.023587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12733576 ORDER BY `minOrder` ASC [ RunTime:0.043182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12733576 ORDER BY `unit` DESC [ RunTime:0.014957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12733576 LIMIT 2 [ RunTime:0.006870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12733576 ORDER BY `minOrder` ASC [ RunTime:0.008081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732601 LIMIT 5 [ RunTime:0.015577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732601 ORDER BY `minOrder` ASC [ RunTime:0.026269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12732601 ORDER BY `unit` DESC [ RunTime:0.035803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12732601 LIMIT 2 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732601 ORDER BY `minOrder` ASC [ RunTime:0.002622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732101 LIMIT 5 [ RunTime:0.004864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732101 ORDER BY `minOrder` ASC [ RunTime:0.018942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12732101 ORDER BY `unit` DESC [ RunTime:0.021724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12732101 LIMIT 2 [ RunTime:0.011328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12732101 ORDER BY `minOrder` ASC [ RunTime:0.020833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567271 LIMIT 5 [ RunTime:0.011461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567271 ORDER BY `minOrder` ASC [ RunTime:0.004766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11567271 ORDER BY `unit` DESC [ RunTime:0.007041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11567271 LIMIT 2 [ RunTime:0.000464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567271 ORDER BY `minOrder` ASC [ RunTime:0.001333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11563008 LIMIT 5 [ RunTime:0.005729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11563008 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11563008 ORDER BY `unit` DESC [ RunTime:0.002094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11563008 LIMIT 2 [ RunTime:0.008168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11563008 ORDER BY `minOrder` ASC [ RunTime:0.001146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11560062 LIMIT 5 [ RunTime:0.003280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11560062 ORDER BY `minOrder` ASC [ RunTime:0.006801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11560062 ORDER BY `unit` DESC [ RunTime:0.007210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11560062 LIMIT 2 [ RunTime:0.002044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11560062 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001691s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52781356 LIMIT 5 [ RunTime:0.001875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52781356 ORDER BY `minOrder` ASC [ RunTime:0.005975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52781356 ORDER BY `unit` DESC [ RunTime:0.002395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52781356 LIMIT 2 [ RunTime:0.011780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52781356 ORDER BY `minOrder` ASC [ RunTime:0.021175s ]
select * from pdf where partno='TSM-107-02-L-SH-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011699s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002608s ]
SELECT `id` FROM `stock` WHERE `id` <> 52781356 AND `partno` = 'TSM-107-02-L-SH-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19779892 [ RunTime:0.004873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52773218 LIMIT 5 [ RunTime:0.011301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52773218 ORDER BY `minOrder` ASC [ RunTime:0.014915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52773218 ORDER BY `unit` DESC [ RunTime:0.022207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52773218 LIMIT 2 [ RunTime:0.004216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52773218 ORDER BY `minOrder` ASC [ RunTime:0.012946s ]
select * from pdf where partno='TSM-107-02-L-SH-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.060814s ]
SELECT `id` FROM `stock` WHERE `id` <> 52773218 AND `partno` = 'TSM-107-02-L-SH-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.035127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52772466 LIMIT 5 [ RunTime:0.095745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52772466 ORDER BY `minOrder` ASC [ RunTime:0.045064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52772466 ORDER BY `unit` DESC [ RunTime:0.006856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52772466 LIMIT 2 [ RunTime:0.025449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52772466 ORDER BY `minOrder` ASC [ RunTime:0.041171s ]
select * from pdf where partno='TSM-107-02-L-SH-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019086s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032148s ]
SELECT `id` FROM `stock` WHERE `id` <> 52772466 AND `partno` = 'TSM-107-02-L-SH-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12733576 [ RunTime:0.042973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52769859 LIMIT 5 [ RunTime:0.046528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52769859 ORDER BY `minOrder` ASC [ RunTime:0.083988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52769859 ORDER BY `unit` DESC [ RunTime:0.102405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52769859 LIMIT 2 [ RunTime:0.084553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52769859 ORDER BY `minOrder` ASC [ RunTime:0.034226s ]
select * from pdf where partno='TSM-107-02-L-SH-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044948s ]
SELECT `id` FROM `stock` WHERE `id` <> 52769859 AND `partno` = 'TSM-107-02-L-SH-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.043044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732101 [ RunTime:0.008337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52763254 LIMIT 5 [ RunTime:0.056456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52763254 ORDER BY `minOrder` ASC [ RunTime:0.035364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52763254 ORDER BY `unit` DESC [ RunTime:0.021342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52763254 LIMIT 2 [ RunTime:0.106553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52763254 ORDER BY `minOrder` ASC [ RunTime:0.016080s ]
select * from pdf where partno='TSM-107-02-L-SH-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.046873s ]
SELECT `id` FROM `stock` WHERE `id` <> 52763254 AND `partno` = 'TSM-107-02-L-SH-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.089271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11563008 [ RunTime:0.064298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52756071 LIMIT 5 [ RunTime:0.064333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52756071 ORDER BY `minOrder` ASC [ RunTime:0.029003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52756071 ORDER BY `unit` DESC [ RunTime:0.096949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52756071 LIMIT 2 [ RunTime:0.019811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52756071 ORDER BY `minOrder` ASC [ RunTime:0.058673s ]
select * from pdf where partno='TSM-107-02-L-SH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.072415s ]
SELECT `id` FROM `stock` WHERE `id` <> 52756071 AND `partno` = 'TSM-107-02-L-SH-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11560062 [ RunTime:0.009302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52689792 LIMIT 5 [ RunTime:0.003175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52689792 ORDER BY `minOrder` ASC [ RunTime:0.003123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52689792 ORDER BY `unit` DESC [ RunTime:0.001177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52689792 LIMIT 2 [ RunTime:0.003532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52689792 ORDER BY `minOrder` ASC [ RunTime:0.005229s ]
select * from pdf where partno='TSM-107-02-L-SH-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009907s ]
SELECT `id` FROM `stock` WHERE `id` <> 52689792 AND `partno` = 'TSM-107-02-L-SH-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15473767 [ RunTime:0.002533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52689012 LIMIT 5 [ RunTime:0.003050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52689012 ORDER BY `minOrder` ASC [ RunTime:0.008038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52689012 ORDER BY `unit` DESC [ RunTime:0.004623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52689012 LIMIT 2 [ RunTime:0.010136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52689012 ORDER BY `minOrder` ASC [ RunTime:0.023682s ]
select * from pdf where partno='TSM-107-02-L-SH-002' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-002' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005870s ]
SELECT `id` FROM `stock` WHERE `id` <> 52689012 AND `partno` = 'TSM-107-02-L-SH-002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567271 [ RunTime:0.026241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52688919 LIMIT 5 [ RunTime:0.012024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688919 ORDER BY `minOrder` ASC [ RunTime:0.027265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52688919 ORDER BY `unit` DESC [ RunTime:0.019351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52688919 LIMIT 2 [ RunTime:0.063193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688919 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='TSM-107-02-L-SH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028126s ]
SELECT `id` FROM `stock` WHERE `id` <> 52688919 AND `partno` = 'TSM-107-02-L-SH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.045085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19748225 [ RunTime:0.019888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52688702 LIMIT 5 [ RunTime:0.006271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688702 ORDER BY `minOrder` ASC [ RunTime:0.015434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52688702 ORDER BY `unit` DESC [ RunTime:0.021388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52688702 LIMIT 2 [ RunTime:0.019788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688702 ORDER BY `minOrder` ASC [ RunTime:0.039195s ]
select * from pdf where partno='TSM-107-02-L-SH-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.060876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030134s ]
SELECT `id` FROM `stock` WHERE `id` <> 52688702 AND `partno` = 'TSM-107-02-L-SH-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.039621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12732601 [ RunTime:0.057714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52688159 LIMIT 5 [ RunTime:0.059447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688159 ORDER BY `minOrder` ASC [ RunTime:0.043471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52688159 ORDER BY `unit` DESC [ RunTime:0.042598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52688159 LIMIT 2 [ RunTime:0.071877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52688159 ORDER BY `minOrder` ASC [ RunTime:0.052865s ]
select * from pdf where partno='TSM-107-02-L-SH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.031613s ]
SELECT `id` FROM `stock` WHERE `id` <> 52688159 AND `partno` = 'TSM-107-02-L-SH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.132749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16182897 [ RunTime:0.080469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52616802 LIMIT 5 [ RunTime:0.020163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52616802 ORDER BY `minOrder` ASC [ RunTime:0.043131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52616802 ORDER BY `unit` DESC [ RunTime:0.019909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52616802 LIMIT 2 [ RunTime:0.026983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52616802 ORDER BY `minOrder` ASC [ RunTime:0.017572s ]
select * from pdf where partno='TSM-107-02-L-SH-006' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-006' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.053747s ]
SELECT `id` FROM `stock` WHERE `id` <> 52616802 AND `partno` = 'TSM-107-02-L-SH-006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.037617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15487036 [ RunTime:0.009370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52616531 LIMIT 5 [ RunTime:0.051667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52616531 ORDER BY `minOrder` ASC [ RunTime:0.045475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52616531 ORDER BY `unit` DESC [ RunTime:0.034635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52616531 LIMIT 2 [ RunTime:0.100860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52616531 ORDER BY `minOrder` ASC [ RunTime:0.056114s ]
select * from pdf where partno='TSM-107-02-L-SH-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.042599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TSM-107-02-L-SH-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014276s ]
SELECT `id` FROM `stock` WHERE `id` <> 52616531 AND `partno` = 'TSM-107-02-L-SH-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16220444 [ RunTime:0.052306s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010853s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073487s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041445s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020304s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032874s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041567s ]
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-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036189s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TSM-107-02-L-SH%' OR `brand` LIKE 'TSM-107-02-L-SH%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.050831s ]