SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002264s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=FTSH-114-02-L-D&search=1' [ RunTime:0.002837s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002164s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003064s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000404s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002539s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002553s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-114-02-L-D' LIMIT 1 [ RunTime:0.003414s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-24 01:07:56' WHERE `partno` = 'FTSH-114-02-L-D' [ RunTime:0.003128s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004065s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010538s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19832420 LIMIT 5 [ RunTime:0.000822s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832420 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19832420 ORDER BY `unit` DESC [ RunTime:0.003324s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19832420 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832420 ORDER BY `minOrder` ASC [ RunTime:0.005205s ]
select * from pdf where partno='FTSH-114-02-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810203 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810203 ORDER BY `minOrder` ASC [ RunTime:0.000717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810203 ORDER BY `unit` DESC [ RunTime:0.003434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810203 LIMIT 2 [ RunTime:0.004757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810203 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19807597 LIMIT 5 [ RunTime:0.014290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19807597 ORDER BY `minOrder` ASC [ RunTime:0.006095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19807597 ORDER BY `unit` DESC [ RunTime:0.002383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19807597 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19807597 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801143 LIMIT 5 [ RunTime:0.000921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801143 ORDER BY `minOrder` ASC [ RunTime:0.003502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801143 ORDER BY `unit` DESC [ RunTime:0.000594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801143 LIMIT 2 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801143 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213915 LIMIT 5 [ RunTime:0.003097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213915 ORDER BY `minOrder` ASC [ RunTime:0.001021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213915 ORDER BY `unit` DESC [ RunTime:0.001385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213915 LIMIT 2 [ RunTime:0.000500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213915 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209606 LIMIT 5 [ RunTime:0.001072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209606 ORDER BY `minOrder` ASC [ RunTime:0.004067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209606 ORDER BY `unit` DESC [ RunTime:0.002837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209606 LIMIT 2 [ RunTime:0.001953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209606 ORDER BY `minOrder` ASC [ RunTime:0.003031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209237 LIMIT 5 [ RunTime:0.001360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209237 ORDER BY `minOrder` ASC [ RunTime:0.000484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209237 ORDER BY `unit` DESC [ RunTime:0.002448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209237 LIMIT 2 [ RunTime:0.009314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209237 ORDER BY `minOrder` ASC [ RunTime:0.000405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15490022 LIMIT 5 [ RunTime:0.001940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490022 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15490022 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15490022 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490022 ORDER BY `minOrder` ASC [ RunTime:0.000326s ]
select * from pdf where partno='FTSH-114-02-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12755331 LIMIT 5 [ RunTime:0.003248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12755331 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12755331 ORDER BY `unit` DESC [ RunTime:0.006146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12755331 LIMIT 2 [ RunTime:0.002649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12755331 ORDER BY `minOrder` ASC [ RunTime:0.004388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751253 LIMIT 5 [ RunTime:0.003660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751253 ORDER BY `minOrder` ASC [ RunTime:0.002780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12751253 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12751253 LIMIT 2 [ RunTime:0.001509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12751253 ORDER BY `minOrder` ASC [ RunTime:0.009398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742109 LIMIT 5 [ RunTime:0.005529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742109 ORDER BY `minOrder` ASC [ RunTime:0.008440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12742109 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12742109 LIMIT 2 [ RunTime:0.001165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742109 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742108 LIMIT 5 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742108 ORDER BY `minOrder` ASC [ RunTime:0.002225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12742108 ORDER BY `unit` DESC [ RunTime:0.006638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12742108 LIMIT 2 [ RunTime:0.008691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12742108 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741061 LIMIT 5 [ RunTime:0.001332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741061 ORDER BY `minOrder` ASC [ RunTime:0.006123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741061 ORDER BY `unit` DESC [ RunTime:0.003642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741061 LIMIT 2 [ RunTime:0.015796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741061 ORDER BY `minOrder` ASC [ RunTime:0.002255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741060 LIMIT 5 [ RunTime:0.014467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741060 ORDER BY `minOrder` ASC [ RunTime:0.007548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741060 ORDER BY `unit` DESC [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741060 LIMIT 2 [ RunTime:0.002227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741060 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740026 LIMIT 5 [ RunTime:0.001038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740026 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740026 ORDER BY `unit` DESC [ RunTime:0.000798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740026 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740026 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738745 LIMIT 5 [ RunTime:0.001000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738745 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12738745 ORDER BY `unit` DESC [ RunTime:0.008768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12738745 LIMIT 2 [ RunTime:0.001883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12738745 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737073 LIMIT 5 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737073 ORDER BY `minOrder` ASC [ RunTime:0.000705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12737073 ORDER BY `unit` DESC [ RunTime:0.006076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12737073 LIMIT 2 [ RunTime:0.002570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12737073 ORDER BY `minOrder` ASC [ RunTime:0.005616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11596249 LIMIT 5 [ RunTime:0.001988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596249 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11596249 ORDER BY `unit` DESC [ RunTime:0.006699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11596249 LIMIT 2 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596249 ORDER BY `minOrder` ASC [ RunTime:0.001260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573381 LIMIT 5 [ RunTime:0.001180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573381 ORDER BY `minOrder` ASC [ RunTime:0.002808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11573381 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11573381 LIMIT 2 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573381 ORDER BY `minOrder` ASC [ RunTime:0.001954s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012628s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52846282 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52846282 ORDER BY `minOrder` ASC [ RunTime:0.005094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52846282 ORDER BY `unit` DESC [ RunTime:0.018219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52846282 LIMIT 2 [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52846282 ORDER BY `minOrder` ASC [ RunTime:0.003097s ]
select * from pdf where partno='FTSH-114-02-L-DV-EC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007905s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002466s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-EC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009752s ]
SELECT `id` FROM `stock` WHERE `id` <> 52846282 AND `partno` = 'FTSH-114-02-L-DV-EC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12751253 [ RunTime:0.006592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52845127 LIMIT 5 [ RunTime:0.001830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52845127 ORDER BY `minOrder` ASC [ RunTime:0.001203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52845127 ORDER BY `unit` DESC [ RunTime:0.013137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52845127 LIMIT 2 [ RunTime:0.014694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52845127 ORDER BY `minOrder` ASC [ RunTime:0.010769s ]
select * from pdf where partno='FTSH-114-02-L-DH-A-C' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DH-A-C' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000914s ]
SELECT `id` FROM `stock` WHERE `id` <> 52845127 AND `partno` = 'FTSH-114-02-L-DH-A-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12755331 [ RunTime:0.005056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52833268 LIMIT 5 [ RunTime:0.001817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52833268 ORDER BY `minOrder` ASC [ RunTime:0.014140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52833268 ORDER BY `unit` DESC [ RunTime:0.008411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52833268 LIMIT 2 [ RunTime:0.020329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52833268 ORDER BY `minOrder` ASC [ RunTime:0.011179s ]
select * from pdf where partno='FTSH-114-02-L-DV-ES-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-ES-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001552s ]
SELECT `id` FROM `stock` WHERE `id` <> 52833268 AND `partno` = 'FTSH-114-02-L-DV-ES-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12738745 [ RunTime:0.004358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52833010 LIMIT 5 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52833010 ORDER BY `minOrder` ASC [ RunTime:0.002594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52833010 ORDER BY `unit` DESC [ RunTime:0.002269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52833010 LIMIT 2 [ RunTime:0.004633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52833010 ORDER BY `minOrder` ASC [ RunTime:0.002254s ]
select * from pdf where partno='FTSH-114-02-L-DV-ES-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-ES-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005631s ]
SELECT `id` FROM `stock` WHERE `id` <> 52833010 AND `partno` = 'FTSH-114-02-L-DV-ES-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573381 [ RunTime:0.001810s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52831893 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52831893 ORDER BY `minOrder` ASC [ RunTime:0.012899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52831893 ORDER BY `unit` DESC [ RunTime:0.003297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52831893 LIMIT 2 [ RunTime:0.005438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52831893 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='FTSH-114-02-L-DH-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DH-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008020s ]
SELECT `id` FROM `stock` WHERE `id` <> 52831893 AND `partno` = 'FTSH-114-02-L-DH-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742108 [ RunTime:0.000470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52831818 LIMIT 5 [ RunTime:0.000896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52831818 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52831818 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52831818 LIMIT 2 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52831818 ORDER BY `minOrder` ASC [ RunTime:0.000338s ]
select * from pdf where partno='FTSH-114-02-L-DV-EL' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-EL' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006722s ]
SELECT `id` FROM `stock` WHERE `id` <> 52831818 AND `partno` = 'FTSH-114-02-L-DV-EL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12742109 [ RunTime:0.001127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52829784 LIMIT 5 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52829784 ORDER BY `minOrder` ASC [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52829784 ORDER BY `unit` DESC [ RunTime:0.006092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52829784 LIMIT 2 [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52829784 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='FTSH-114-02-L-DV-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 52829784 AND `partno` = 'FTSH-114-02-L-DV-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741061 [ RunTime:0.001820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52829783 LIMIT 5 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52829783 ORDER BY `minOrder` ASC [ RunTime:0.000607s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52829783 ORDER BY `unit` DESC [ RunTime:0.001781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52829783 LIMIT 2 [ RunTime:0.001997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52829783 ORDER BY `minOrder` ASC [ RunTime:0.000248s ]
select * from pdf where partno='FTSH-114-02-L-D-RA-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-D-RA-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004585s ]
SELECT `id` FROM `stock` WHERE `id` <> 52829783 AND `partno` = 'FTSH-114-02-L-D-RA-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741060 [ RunTime:0.000533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52828632 LIMIT 5 [ RunTime:0.001427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52828632 ORDER BY `minOrder` ASC [ RunTime:0.010703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52828632 ORDER BY `unit` DESC [ RunTime:0.006852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52828632 LIMIT 2 [ RunTime:0.003486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52828632 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
select * from pdf where partno='FTSH-114-02-L-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000728s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002140s ]
SELECT `id` FROM `stock` WHERE `id` <> 52828632 AND `partno` = 'FTSH-114-02-L-DH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52827805 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827805 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52827805 ORDER BY `unit` DESC [ RunTime:0.000433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52827805 LIMIT 2 [ RunTime:0.003786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827805 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='FTSH-114-02-L-D-EP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-D-EP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001413s ]
SELECT `id` FROM `stock` WHERE `id` <> 52827805 AND `partno` = 'FTSH-114-02-L-D-EP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740026 [ RunTime:0.000492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52825913 LIMIT 5 [ RunTime:0.001291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825913 ORDER BY `minOrder` ASC [ RunTime:0.003667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52825913 ORDER BY `unit` DESC [ RunTime:0.002073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52825913 LIMIT 2 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825913 ORDER BY `minOrder` ASC [ RunTime:0.000277s ]
select * from pdf where partno='FTSH-114-02-L-DV-ES-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-ES-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016660s ]
SELECT `id` FROM `stock` WHERE `id` <> 52825913 AND `partno` = 'FTSH-114-02-L-DV-ES-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19807597 [ RunTime:0.008994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52825598 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825598 ORDER BY `minOrder` ASC [ RunTime:0.000938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52825598 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52825598 LIMIT 2 [ RunTime:0.001420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825598 ORDER BY `minOrder` ASC [ RunTime:0.001508s ]
select * from pdf where partno='FTSH-114-02-L-D-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-D-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004195s ]
SELECT `id` FROM `stock` WHERE `id` <> 52825598 AND `partno` = 'FTSH-114-02-L-D-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52825082 LIMIT 5 [ RunTime:0.004783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825082 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52825082 ORDER BY `unit` DESC [ RunTime:0.004977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52825082 LIMIT 2 [ RunTime:0.002715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52825082 ORDER BY `minOrder` ASC [ RunTime:0.003193s ]
select * from pdf where partno='FTSH-114-02-L-DH-A-C-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018397s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DH-A-C-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012712s ]
SELECT `id` FROM `stock` WHERE `id` <> 52825082 AND `partno` = 'FTSH-114-02-L-DH-A-C-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213915 [ RunTime:0.012721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52823431 LIMIT 5 [ RunTime:0.015481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52823431 ORDER BY `minOrder` ASC [ RunTime:0.013543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52823431 ORDER BY `unit` DESC [ RunTime:0.004027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52823431 LIMIT 2 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52823431 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
select * from pdf where partno='FTSH-114-02-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017533s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007133s ]
SELECT `id` FROM `stock` WHERE `id` <> 52823431 AND `partno` = 'FTSH-114-02-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52822634 LIMIT 5 [ RunTime:0.009536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52822634 ORDER BY `minOrder` ASC [ RunTime:0.025401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52822634 ORDER BY `unit` DESC [ RunTime:0.019354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52822634 LIMIT 2 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52822634 ORDER BY `minOrder` ASC [ RunTime:0.000539s ]
select * from pdf where partno='FTSH-114-02-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008599s ]
SELECT `id` FROM `stock` WHERE `id` <> 52822634 AND `partno` = 'FTSH-114-02-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12737073 [ RunTime:0.000821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52819078 LIMIT 5 [ RunTime:0.001871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52819078 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52819078 ORDER BY `unit` DESC [ RunTime:0.006193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52819078 LIMIT 2 [ RunTime:0.005161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52819078 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='FTSH-114-02-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013515s ]
SELECT `id` FROM `stock` WHERE `id` <> 52819078 AND `partno` = 'FTSH-114-02-L-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810203 [ RunTime:0.020681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52818094 LIMIT 5 [ RunTime:0.007042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818094 ORDER BY `minOrder` ASC [ RunTime:0.008896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52818094 ORDER BY `unit` DESC [ RunTime:0.000847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52818094 LIMIT 2 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818094 ORDER BY `minOrder` ASC [ RunTime:0.002984s ]
select * from pdf where partno='FTSH-114-02-L-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006348s ]
SELECT `id` FROM `stock` WHERE `id` <> 52818094 AND `partno` = 'FTSH-114-02-L-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801143 [ RunTime:0.015370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52814347 LIMIT 5 [ RunTime:0.003393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52814347 ORDER BY `minOrder` ASC [ RunTime:0.006539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52814347 ORDER BY `unit` DESC [ RunTime:0.000778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52814347 LIMIT 2 [ RunTime:0.006719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52814347 ORDER BY `minOrder` ASC [ RunTime:0.011158s ]
select * from pdf where partno='FTSH-114-02-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002217s ]
SELECT `id` FROM `stock` WHERE `id` <> 52814347 AND `partno` = 'FTSH-114-02-L-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209606 [ RunTime:0.003002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52813494 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52813494 ORDER BY `minOrder` ASC [ RunTime:0.003751s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52813494 ORDER BY `unit` DESC [ RunTime:0.001836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52813494 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52813494 ORDER BY `minOrder` ASC [ RunTime:0.000418s ]
select * from pdf where partno='FTSH-114-02-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002886s ]
SELECT `id` FROM `stock` WHERE `id` <> 52813494 AND `partno` = 'FTSH-114-02-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209237 [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52649487 LIMIT 5 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649487 ORDER BY `minOrder` ASC [ RunTime:0.008153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52649487 ORDER BY `unit` DESC [ RunTime:0.000953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52649487 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649487 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='FTSH-114-02-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-114-02-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000898s ]
SELECT `id` FROM `stock` WHERE `id` <> 52649487 AND `partno` = 'FTSH-114-02-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15490022 [ RunTime:0.000473s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028423s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001670s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003702s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013400s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010267s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003498s ]
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 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001235s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-114-02-L-D%' OR `brand` LIKE 'FTSH-114-02-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011817s ]