SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002224s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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-110-01-L-DV-EJ&search=1' [ RunTime:0.001602s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001348s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001239s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001818s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001761s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-110-01-L-DV-EJ' LIMIT 1 [ RunTime:0.007819s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 12:02:21' WHERE `partno` = 'FTSH-110-01-L-DV-EJ' [ RunTime:0.004133s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001166s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016075s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764974 LIMIT 5 [ RunTime:0.001317s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764974 ORDER BY `minOrder` ASC [ RunTime:0.003158s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19764974 ORDER BY `unit` DESC [ RunTime:0.002526s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19764974 LIMIT 2 [ RunTime:0.008258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19764974 ORDER BY `minOrder` ASC [ RunTime:0.003985s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851810 LIMIT 5 [ RunTime:0.007593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851810 ORDER BY `minOrder` ASC [ RunTime:0.002263s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851810 ORDER BY `unit` DESC [ RunTime:0.015378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851810 LIMIT 2 [ RunTime:0.003885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851810 ORDER BY `minOrder` ASC [ RunTime:0.011037s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478145 LIMIT 5 [ RunTime:0.018739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478145 ORDER BY `minOrder` ASC [ RunTime:0.012113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15478145 ORDER BY `unit` DESC [ RunTime:0.005542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15478145 LIMIT 2 [ RunTime:0.005854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15478145 ORDER BY `minOrder` ASC [ RunTime:0.015276s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833753 LIMIT 5 [ RunTime:0.013910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833753 ORDER BY `minOrder` ASC [ RunTime:0.008585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833753 ORDER BY `unit` DESC [ RunTime:0.008035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833753 LIMIT 2 [ RunTime:0.003559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833753 ORDER BY `minOrder` ASC [ RunTime:0.010675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812161 LIMIT 5 [ RunTime:0.003160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812161 ORDER BY `minOrder` ASC [ RunTime:0.005953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19812161 ORDER BY `unit` DESC [ RunTime:0.005711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19812161 LIMIT 2 [ RunTime:0.015038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19812161 ORDER BY `minOrder` ASC [ RunTime:0.014156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19802927 LIMIT 5 [ RunTime:0.021022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19802927 ORDER BY `minOrder` ASC [ RunTime:0.015658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19802927 ORDER BY `unit` DESC [ RunTime:0.005909s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19802927 LIMIT 2 [ RunTime:0.003894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19802927 ORDER BY `minOrder` ASC [ RunTime:0.005157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19757006 LIMIT 5 [ RunTime:0.026560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19757006 ORDER BY `minOrder` ASC [ RunTime:0.004323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19757006 ORDER BY `unit` DESC [ RunTime:0.014029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19757006 LIMIT 2 [ RunTime:0.005816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19757006 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19756978 LIMIT 5 [ RunTime:0.005239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19756978 ORDER BY `minOrder` ASC [ RunTime:0.006843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19756978 ORDER BY `unit` DESC [ RunTime:0.009566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19756978 LIMIT 2 [ RunTime:0.008958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19756978 ORDER BY `minOrder` ASC [ RunTime:0.003850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213831 LIMIT 5 [ RunTime:0.009330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213831 ORDER BY `minOrder` ASC [ RunTime:0.012450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16213831 ORDER BY `unit` DESC [ RunTime:0.009837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16213831 LIMIT 2 [ RunTime:0.005209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16213831 ORDER BY `minOrder` ASC [ RunTime:0.004040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745259 LIMIT 5 [ RunTime:0.007363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745259 ORDER BY `minOrder` ASC [ RunTime:0.005101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12745259 ORDER BY `unit` DESC [ RunTime:0.010387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12745259 LIMIT 2 [ RunTime:0.002918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12745259 ORDER BY `minOrder` ASC [ RunTime:0.006249s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004107s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52585680 LIMIT 5 [ RunTime:0.001849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52585680 ORDER BY `minOrder` ASC [ RunTime:0.015270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52585680 ORDER BY `unit` DESC [ RunTime:0.005736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52585680 LIMIT 2 [ RunTime:0.003182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52585680 ORDER BY `minOrder` ASC [ RunTime:0.005616s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002243s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006756s ]
SELECT `id` FROM `stock` WHERE `id` <> 52585680 AND `partno` = 'FTSH-110-01-L-DV-EJ-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19764974 [ RunTime:0.007875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52680575 LIMIT 5 [ RunTime:0.003375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52680575 ORDER BY `minOrder` ASC [ RunTime:0.007624s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52680575 ORDER BY `unit` DESC [ RunTime:0.002522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52680575 LIMIT 2 [ RunTime:0.016491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52680575 ORDER BY `minOrder` ASC [ RunTime:0.010093s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009369s ]
SELECT `id` FROM `stock` WHERE `id` <> 52680575 AND `partno` = 'FTSH-110-01-L-DV-EJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851810 [ RunTime:0.006453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52589048 LIMIT 5 [ RunTime:0.006884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52589048 ORDER BY `minOrder` ASC [ RunTime:0.008226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52589048 ORDER BY `unit` DESC [ RunTime:0.008974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52589048 LIMIT 2 [ RunTime:0.012291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52589048 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009441s ]
SELECT `id` FROM `stock` WHERE `id` <> 52589048 AND `partno` = 'FTSH-110-01-L-DV-EJ-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15478145 [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52843085 LIMIT 5 [ RunTime:0.001365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843085 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52843085 ORDER BY `unit` DESC [ RunTime:0.003345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52843085 LIMIT 2 [ RunTime:0.004484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843085 ORDER BY `minOrder` ASC [ RunTime:0.008898s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017287s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005766s ]
SELECT `id` FROM `stock` WHERE `id` <> 52843085 AND `partno` = 'FTSH-110-01-L-DV-EJC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52835998 LIMIT 5 [ RunTime:0.008215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52835998 ORDER BY `minOrder` ASC [ RunTime:0.007008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52835998 ORDER BY `unit` DESC [ RunTime:0.021979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52835998 LIMIT 2 [ RunTime:0.008421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52835998 ORDER BY `minOrder` ASC [ RunTime:0.004516s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJM-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018522s ]
SELECT `id` FROM `stock` WHERE `id` <> 52835998 AND `partno` = 'FTSH-110-01-L-DV-EJM-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12745259 [ RunTime:0.026379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52827600 LIMIT 5 [ RunTime:0.005872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827600 ORDER BY `minOrder` ASC [ RunTime:0.017293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52827600 ORDER BY `unit` DESC [ RunTime:0.012222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52827600 LIMIT 2 [ RunTime:0.007941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52827600 ORDER BY `minOrder` ASC [ RunTime:0.012420s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019410s ]
SELECT `id` FROM `stock` WHERE `id` <> 52827600 AND `partno` = 'FTSH-110-01-L-DV-EJ-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52823183 LIMIT 5 [ RunTime:0.024759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52823183 ORDER BY `minOrder` ASC [ RunTime:0.024912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52823183 ORDER BY `unit` DESC [ RunTime:0.003405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52823183 LIMIT 2 [ RunTime:0.012252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52823183 ORDER BY `minOrder` ASC [ RunTime:0.011903s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029874s ]
SELECT `id` FROM `stock` WHERE `id` <> 52823183 AND `partno` = 'FTSH-110-01-L-DV-EJ-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16213831 [ RunTime:0.007969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52821270 LIMIT 5 [ RunTime:0.029158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52821270 ORDER BY `minOrder` ASC [ RunTime:0.035823s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52821270 ORDER BY `unit` DESC [ RunTime:0.016495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52821270 LIMIT 2 [ RunTime:0.010914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52821270 ORDER BY `minOrder` ASC [ RunTime:0.009074s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016886s ]
SELECT `id` FROM `stock` WHERE `id` <> 52821270 AND `partno` = 'FTSH-110-01-L-DV-EJM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.025188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19812161 [ RunTime:0.027827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52818806 LIMIT 5 [ RunTime:0.021344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818806 ORDER BY `minOrder` ASC [ RunTime:0.021733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52818806 ORDER BY `unit` DESC [ RunTime:0.071594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52818806 LIMIT 2 [ RunTime:0.065068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52818806 ORDER BY `minOrder` ASC [ RunTime:0.026861s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.044271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034166s ]
SELECT `id` FROM `stock` WHERE `id` <> 52818806 AND `partno` = 'FTSH-110-01-L-DV-EJ-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.031727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19802927 [ RunTime:0.038024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52707399 LIMIT 5 [ RunTime:0.028904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52707399 ORDER BY `minOrder` ASC [ RunTime:0.046145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52707399 ORDER BY `unit` DESC [ RunTime:0.012531s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52707399 LIMIT 2 [ RunTime:0.034223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52707399 ORDER BY `minOrder` ASC [ RunTime:0.001057s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011861s ]
SELECT `id` FROM `stock` WHERE `id` <> 52707399 AND `partno` = 'FTSH-110-01-L-DV-EJ-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19757006 [ RunTime:0.014252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52707322 LIMIT 5 [ RunTime:0.043172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52707322 ORDER BY `minOrder` ASC [ RunTime:0.023656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52707322 ORDER BY `unit` DESC [ RunTime:0.025518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52707322 LIMIT 2 [ RunTime:0.020266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52707322 ORDER BY `minOrder` ASC [ RunTime:0.000521s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.037730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032200s ]
SELECT `id` FROM `stock` WHERE `id` <> 52707322 AND `partno` = 'FTSH-110-01-L-DV-EJC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19756978 [ RunTime:0.023690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52649883 LIMIT 5 [ RunTime:0.047544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649883 ORDER BY `minOrder` ASC [ RunTime:0.061723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52649883 ORDER BY `unit` DESC [ RunTime:0.039728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52649883 LIMIT 2 [ RunTime:0.015023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649883 ORDER BY `minOrder` ASC [ RunTime:0.016519s ]
select * from pdf where partno='FTSH-110-01-L-DV-EJ-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.021251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-110-01-L-DV-EJ-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026675s ]
SELECT `id` FROM `stock` WHERE `id` <> 52649883 AND `partno` = 'FTSH-110-01-L-DV-EJ-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833753 [ RunTime:0.021146s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020318s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051083s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034844s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012693s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065910s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042895s ]
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-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059106s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-110-01-L-DV-EJ%' OR `brand` LIKE 'FTSH-110-01-L-DV-EJ%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023984s ]