SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001868s ]
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=QTH-060-01-C-D-A&search=1' [ RunTime:0.009137s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001325s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001755s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001785s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.002751s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001205s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001202s ]
SELECT * FROM `stock_search` WHERE `partno` = 'QTH-060-01-C-D-A' LIMIT 1 [ RunTime:0.006733s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-07-27 09:34:56' WHERE `partno` = 'QTH-060-01-C-D-A' [ RunTime:0.027472s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001590s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043654s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792657 LIMIT 5 [ RunTime:0.043452s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792657 ORDER BY `minOrder` ASC [ RunTime:0.038703s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12792657 ORDER BY `unit` DESC [ RunTime:0.047934s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.019680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12792657 LIMIT 2 [ RunTime:0.104902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12792657 ORDER BY `minOrder` ASC [ RunTime:0.022123s ]
select * from pdf where partno='QTH-060-01-C-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.077029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609745 LIMIT 5 [ RunTime:0.111189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609745 ORDER BY `minOrder` ASC [ RunTime:0.091019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609745 ORDER BY `unit` DESC [ RunTime:0.092632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609745 LIMIT 2 [ RunTime:0.028212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609745 ORDER BY `minOrder` ASC [ RunTime:0.042970s ]
select * from pdf where partno='QTH-060-01-C-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.058407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609402 LIMIT 5 [ RunTime:0.031469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609402 ORDER BY `minOrder` ASC [ RunTime:0.052537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11609402 ORDER BY `unit` DESC [ RunTime:0.066119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11609402 LIMIT 2 [ RunTime:0.041924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11609402 ORDER BY `minOrder` ASC [ RunTime:0.026764s ]
select * from pdf where partno='QTH-060-01-C-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787969 LIMIT 5 [ RunTime:0.023823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787969 ORDER BY `minOrder` ASC [ RunTime:0.056362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12787969 ORDER BY `unit` DESC [ RunTime:0.063931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12787969 LIMIT 2 [ RunTime:0.029986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787969 ORDER BY `minOrder` ASC [ RunTime:0.039994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787514 LIMIT 5 [ RunTime:0.024774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787514 ORDER BY `minOrder` ASC [ RunTime:0.030624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12787514 ORDER BY `unit` DESC [ RunTime:0.027008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12787514 LIMIT 2 [ RunTime:0.011765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12787514 ORDER BY `minOrder` ASC [ RunTime:0.021517s ]
select * from pdf where partno='QTH-060-01-C-D-A-L' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.058530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786579 LIMIT 5 [ RunTime:0.039005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786579 ORDER BY `minOrder` ASC [ RunTime:0.048997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12786579 ORDER BY `unit` DESC [ RunTime:0.018819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12786579 LIMIT 2 [ RunTime:0.019475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786579 ORDER BY `minOrder` ASC [ RunTime:0.022795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786578 LIMIT 5 [ RunTime:0.030828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786578 ORDER BY `minOrder` ASC [ RunTime:0.008098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12786578 ORDER BY `unit` DESC [ RunTime:0.048567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12786578 LIMIT 2 [ RunTime:0.008455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786578 ORDER BY `minOrder` ASC [ RunTime:0.004778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786137 LIMIT 5 [ RunTime:0.020120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786137 ORDER BY `minOrder` ASC [ RunTime:0.014648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12786137 ORDER BY `unit` DESC [ RunTime:0.003723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12786137 LIMIT 2 [ RunTime:0.004256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12786137 ORDER BY `minOrder` ASC [ RunTime:0.010752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11608765 LIMIT 5 [ RunTime:0.005225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608765 ORDER BY `minOrder` ASC [ RunTime:0.008173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11608765 ORDER BY `unit` DESC [ RunTime:0.003699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11608765 LIMIT 2 [ RunTime:0.003859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11608765 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='QTH-060-01-C-D-A-RT1-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11607222 LIMIT 5 [ RunTime:0.001295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607222 ORDER BY `minOrder` ASC [ RunTime:0.007187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11607222 ORDER BY `unit` DESC [ RunTime:0.035293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11607222 LIMIT 2 [ RunTime:0.007057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11607222 ORDER BY `minOrder` ASC [ RunTime:0.006883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606313 LIMIT 5 [ RunTime:0.026170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606313 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11606313 ORDER BY `unit` DESC [ RunTime:0.009637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11606313 LIMIT 2 [ RunTime:0.019349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606313 ORDER BY `minOrder` ASC [ RunTime:0.006882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606275 LIMIT 5 [ RunTime:0.022388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606275 ORDER BY `minOrder` ASC [ RunTime:0.012362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11606275 ORDER BY `unit` DESC [ RunTime:0.022556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11606275 LIMIT 2 [ RunTime:0.012807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11606275 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269069 LIMIT 5 [ RunTime:0.001821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269069 ORDER BY `minOrder` ASC [ RunTime:0.002798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269069 ORDER BY `unit` DESC [ RunTime:0.009573s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269069 LIMIT 2 [ RunTime:0.013952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269069 ORDER BY `minOrder` ASC [ RunTime:0.002437s ]
select * from pdf where partno='qth-060-01-c-d-a-k-tr' and brandshort='samtec' limit 1 [ RunTime:0.002804s ]
select foldpath,foldpath2,filename from pdf_file where id=1919552 limit 1 [ RunTime:0.014910s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002409s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'qth-060-01-c-d-a-k-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.017284s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52501235 LIMIT 5 [ RunTime:0.020259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501235 ORDER BY `minOrder` ASC [ RunTime:0.006810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52501235 ORDER BY `unit` DESC [ RunTime:0.000946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52501235 LIMIT 2 [ RunTime:0.004709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501235 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='QTH-060-01-C-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001183s ]
SELECT `id` FROM `stock` WHERE `id` <> 52501235 AND `partno` = 'QTH-060-01-C-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609402 [ RunTime:0.000722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52501188 LIMIT 5 [ RunTime:0.008330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501188 ORDER BY `minOrder` ASC [ RunTime:0.008728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52501188 ORDER BY `unit` DESC [ RunTime:0.005229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52501188 LIMIT 2 [ RunTime:0.008644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501188 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='QTH-060-01-C-D-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000951s ]
SELECT `id` FROM `stock` WHERE `id` <> 52501188 AND `partno` = 'QTH-060-01-C-D-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12792657 [ RunTime:0.013423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52501238 LIMIT 5 [ RunTime:0.012580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501238 ORDER BY `minOrder` ASC [ RunTime:0.014334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52501238 ORDER BY `unit` DESC [ RunTime:0.000722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52501238 LIMIT 2 [ RunTime:0.002812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52501238 ORDER BY `minOrder` ASC [ RunTime:0.005096s ]
select * from pdf where partno='QTH-060-01-C-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 52501238 AND `partno` = 'QTH-060-01-C-D-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11609745 [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52518970 LIMIT 5 [ RunTime:0.012458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52518970 ORDER BY `minOrder` ASC [ RunTime:0.010625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52518970 ORDER BY `unit` DESC [ RunTime:0.020248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52518970 LIMIT 2 [ RunTime:0.003466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52518970 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='QTH-060-01-C-D-A-GP-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001170s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-GP-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004517s ]
SELECT `id` FROM `stock` WHERE `id` <> 52518970 AND `partno` = 'QTH-060-01-C-D-A-GP-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11607222 [ RunTime:0.010399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52518204 LIMIT 5 [ RunTime:0.021561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52518204 ORDER BY `minOrder` ASC [ RunTime:0.018867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52518204 ORDER BY `unit` DESC [ RunTime:0.005583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52518204 LIMIT 2 [ RunTime:0.005284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52518204 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='QTH-060-01-C-D-A-RT1' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-RT1' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012795s ]
SELECT `id` FROM `stock` WHERE `id` <> 52518204 AND `partno` = 'QTH-060-01-C-D-A-RT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787969 [ RunTime:0.016672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52517178 LIMIT 5 [ RunTime:0.008920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52517178 ORDER BY `minOrder` ASC [ RunTime:0.016869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52517178 ORDER BY `unit` DESC [ RunTime:0.008761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52517178 LIMIT 2 [ RunTime:0.026641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52517178 ORDER BY `minOrder` ASC [ RunTime:0.011105s ]
select * from pdf where partno='QTH-060-01-C-D-A-L-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-L-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039100s ]
SELECT `id` FROM `stock` WHERE `id` <> 52517178 AND `partno` = 'QTH-060-01-C-D-A-L-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606313 [ RunTime:0.030671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52517006 LIMIT 5 [ RunTime:0.020616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52517006 ORDER BY `minOrder` ASC [ RunTime:0.018455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52517006 ORDER BY `unit` DESC [ RunTime:0.029847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52517006 LIMIT 2 [ RunTime:0.012112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52517006 ORDER BY `minOrder` ASC [ RunTime:0.010750s ]
select * from pdf where partno='QTH-060-01-C-D-A-L' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-L' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.050964s ]
SELECT `id` FROM `stock` WHERE `id` <> 52517006 AND `partno` = 'QTH-060-01-C-D-A-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12787514 [ RunTime:0.031974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52516801 LIMIT 5 [ RunTime:0.024210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52516801 ORDER BY `minOrder` ASC [ RunTime:0.027832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52516801 ORDER BY `unit` DESC [ RunTime:0.044145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52516801 LIMIT 2 [ RunTime:0.015896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52516801 ORDER BY `minOrder` ASC [ RunTime:0.024512s ]
select * from pdf where partno='QTH-060-01-C-D-A-RT1-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.047461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-RT1-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.047874s ]
SELECT `id` FROM `stock` WHERE `id` <> 52516801 AND `partno` = 'QTH-060-01-C-D-A-RT1-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023601s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11606275 [ RunTime:0.046896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52515899 LIMIT 5 [ RunTime:0.053544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515899 ORDER BY `minOrder` ASC [ RunTime:0.044964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52515899 ORDER BY `unit` DESC [ RunTime:0.031061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52515899 LIMIT 2 [ RunTime:0.041237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515899 ORDER BY `minOrder` ASC [ RunTime:0.020209s ]
select * from pdf where partno='QTH-060-01-C-D-A-GP-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-GP-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027962s ]
SELECT `id` FROM `stock` WHERE `id` <> 52515899 AND `partno` = 'QTH-060-01-C-D-A-GP-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52515898 LIMIT 5 [ RunTime:0.112145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515898 ORDER BY `minOrder` ASC [ RunTime:0.050990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52515898 ORDER BY `unit` DESC [ RunTime:0.014030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52515898 LIMIT 2 [ RunTime:0.034231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515898 ORDER BY `minOrder` ASC [ RunTime:0.014499s ]
select * from pdf where partno='QTH-060-01-C-D-A-FL-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-FL-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008462s ]
SELECT `id` FROM `stock` WHERE `id` <> 52515898 AND `partno` = 'QTH-060-01-C-D-A-FL-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786579 [ RunTime:0.021428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52515895 LIMIT 5 [ RunTime:0.028090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515895 ORDER BY `minOrder` ASC [ RunTime:0.028059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52515895 ORDER BY `unit` DESC [ RunTime:0.049345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52515895 LIMIT 2 [ RunTime:0.029513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52515895 ORDER BY `minOrder` ASC [ RunTime:0.035678s ]
select * from pdf where partno='QTH-060-01-C-D-A-GP-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.051035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-GP-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013161s ]
SELECT `id` FROM `stock` WHERE `id` <> 52515895 AND `partno` = 'QTH-060-01-C-D-A-GP-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786578 [ RunTime:0.017708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52514094 LIMIT 5 [ RunTime:0.076197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52514094 ORDER BY `minOrder` ASC [ RunTime:0.037516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52514094 ORDER BY `unit` DESC [ RunTime:0.025329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52514094 LIMIT 2 [ RunTime:0.019970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52514094 ORDER BY `minOrder` ASC [ RunTime:0.026100s ]
select * from pdf where partno='QTH-060-01-C-D-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'QTH-060-01-C-D-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039872s ]
SELECT `id` FROM `stock` WHERE `id` <> 52514094 AND `partno` = 'QTH-060-01-C-D-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12786137 [ RunTime:0.053228s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048062s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020880s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020666s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025262s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051824s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052611s ]
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 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027353s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'QTH-060-01-C-D-A%' OR `brand` LIKE 'QTH-060-01-C-D-A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012731s ]