SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001481s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.129' , `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-115-01-L-DV-EJ&search=1' [ RunTime:0.005041s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001489s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001711s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001169s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.129' ) [ RunTime:0.017385s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001547s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004113s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001566s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-115-01-L-DV-EJ' LIMIT 1 [ RunTime:0.010125s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 04:03:07' WHERE `partno` = 'FTSH-115-01-L-DV-EJ' [ RunTime:0.022874s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001873s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.152751s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.020415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19841961 LIMIT 5 [ RunTime:0.051157s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19841961 ORDER BY `minOrder` ASC [ RunTime:0.031292s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.052107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19841961 ORDER BY `unit` DESC [ RunTime:0.064131s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19841961 LIMIT 2 [ RunTime:0.022590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19841961 ORDER BY `minOrder` ASC [ RunTime:0.076722s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.062629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774221 LIMIT 5 [ RunTime:0.038318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774221 ORDER BY `minOrder` ASC [ RunTime:0.110930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19774221 ORDER BY `unit` DESC [ RunTime:0.023314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19774221 LIMIT 2 [ RunTime:0.063949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19774221 ORDER BY `minOrder` ASC [ RunTime:0.028015s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833980 LIMIT 5 [ RunTime:0.107351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833980 ORDER BY `minOrder` ASC [ RunTime:0.048141s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833980 ORDER BY `unit` DESC [ RunTime:0.140058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833980 LIMIT 2 [ RunTime:0.210024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833980 ORDER BY `minOrder` ASC [ RunTime:0.177000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227068 LIMIT 5 [ RunTime:0.085063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227068 ORDER BY `minOrder` ASC [ RunTime:0.083328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227068 ORDER BY `unit` DESC [ RunTime:0.070859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227068 LIMIT 2 [ RunTime:0.151694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227068 ORDER BY `minOrder` ASC [ RunTime:0.089178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744407 LIMIT 5 [ RunTime:0.047868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744407 ORDER BY `minOrder` ASC [ RunTime:0.049020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12744407 ORDER BY `unit` DESC [ RunTime:0.094143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12744407 LIMIT 2 [ RunTime:0.027338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12744407 ORDER BY `minOrder` ASC [ RunTime:0.004875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739182 LIMIT 5 [ RunTime:0.014007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739182 ORDER BY `minOrder` ASC [ RunTime:0.014391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12739182 ORDER BY `unit` DESC [ RunTime:0.009940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12739182 LIMIT 2 [ RunTime:0.017913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739182 ORDER BY `minOrder` ASC [ RunTime:0.011669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12736986 LIMIT 5 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12736986 ORDER BY `minOrder` ASC [ RunTime:0.032066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12736986 ORDER BY `unit` DESC [ RunTime:0.019944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12736986 LIMIT 2 [ RunTime:0.026309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12736986 ORDER BY `minOrder` ASC [ RunTime:0.003788s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034419s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52579698 LIMIT 5 [ RunTime:0.051211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52579698 ORDER BY `minOrder` ASC [ RunTime:0.018756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52579698 ORDER BY `unit` DESC [ RunTime:0.054375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52579698 LIMIT 2 [ RunTime:0.014516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52579698 ORDER BY `minOrder` ASC [ RunTime:0.007298s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006190s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016759s ]
SELECT `id` FROM `stock` WHERE `id` <> 52579698 AND `partno` = 'FTSH-115-01-L-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19841961 [ RunTime:0.016951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52836296 LIMIT 5 [ RunTime:0.031402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52836296 ORDER BY `minOrder` ASC [ RunTime:0.037981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52836296 ORDER BY `unit` DESC [ RunTime:0.031833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52836296 LIMIT 2 [ RunTime:0.089507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52836296 ORDER BY `minOrder` ASC [ RunTime:0.001895s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.121450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.080836s ]
SELECT `id` FROM `stock` WHERE `id` <> 52836296 AND `partno` = 'FTSH-115-01-L-DV-EJM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.122762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12744407 [ RunTime:0.102887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52834215 LIMIT 5 [ RunTime:0.118019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52834215 ORDER BY `minOrder` ASC [ RunTime:0.081592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52834215 ORDER BY `unit` DESC [ RunTime:0.072834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52834215 LIMIT 2 [ RunTime:0.081427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52834215 ORDER BY `minOrder` ASC [ RunTime:0.052500s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.051381s ]
SELECT `id` FROM `stock` WHERE `id` <> 52834215 AND `partno` = 'FTSH-115-01-L-DV-EJC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.098186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52834065 LIMIT 5 [ RunTime:0.079168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52834065 ORDER BY `minOrder` ASC [ RunTime:0.041908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52834065 ORDER BY `unit` DESC [ RunTime:0.033176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52834065 LIMIT 2 [ RunTime:0.112761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52834065 ORDER BY `minOrder` ASC [ RunTime:0.060238s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.050644s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.129863s ]
SELECT `id` FROM `stock` WHERE `id` <> 52834065 AND `partno` = 'FTSH-115-01-L-DV-EJ-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.073344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739182 [ RunTime:0.067900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52832072 LIMIT 5 [ RunTime:0.033312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52832072 ORDER BY `minOrder` ASC [ RunTime:0.144021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52832072 ORDER BY `unit` DESC [ RunTime:0.122870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52832072 LIMIT 2 [ RunTime:0.086419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52832072 ORDER BY `minOrder` ASC [ RunTime:0.034095s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.148664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.133213s ]
SELECT `id` FROM `stock` WHERE `id` <> 52832072 AND `partno` = 'FTSH-115-01-L-DV-EJ-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.074630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12736986 [ RunTime:0.067993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52650122 LIMIT 5 [ RunTime:0.054043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52650122 ORDER BY `minOrder` ASC [ RunTime:0.058212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52650122 ORDER BY `unit` DESC [ RunTime:0.129091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52650122 LIMIT 2 [ RunTime:0.037038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52650122 ORDER BY `minOrder` ASC [ RunTime:0.077135s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.159438s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.058768s ]
SELECT `id` FROM `stock` WHERE `id` <> 52650122 AND `partno` = 'FTSH-115-01-L-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.043634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833980 [ RunTime:0.088545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52648870 LIMIT 5 [ RunTime:0.067762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52648870 ORDER BY `minOrder` ASC [ RunTime:0.076584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52648870 ORDER BY `unit` DESC [ RunTime:0.035189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52648870 LIMIT 2 [ RunTime:0.052099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52648870 ORDER BY `minOrder` ASC [ RunTime:0.008027s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039624s ]
SELECT `id` FROM `stock` WHERE `id` <> 52648870 AND `partno` = 'FTSH-115-01-L-DV-EJ-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227068 [ RunTime:0.061392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52589668 LIMIT 5 [ RunTime:0.047151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52589668 ORDER BY `minOrder` ASC [ RunTime:0.094902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52589668 ORDER BY `unit` DESC [ RunTime:0.051606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52589668 LIMIT 2 [ RunTime:0.069155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52589668 ORDER BY `minOrder` ASC [ RunTime:0.038732s ]
select * from pdf where partno='FTSH-115-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-115-01-L-DV-EJ-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001240s ]
SELECT `id` FROM `stock` WHERE `id` <> 52589668 AND `partno` = 'FTSH-115-01-L-DV-EJ-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.095249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19774221 [ RunTime:0.092114s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070688s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063278s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044225s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028252s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087259s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076713s ]
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-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083757s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-115-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-115-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.082303s ]