SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001731s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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-109-03-F-DV&search=1' [ RunTime:0.002703s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001107s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001211s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001002s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000223s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002392s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-109-03-F-DV' LIMIT 1 [ RunTime:0.003077s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 08:15:00' WHERE `partno` = 'FTSH-109-03-F-DV' [ RunTime:0.001738s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002179s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005467s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.000904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833377 LIMIT 5 [ RunTime:0.005763s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833377 ORDER BY `minOrder` ASC [ RunTime:0.009766s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833377 ORDER BY `unit` DESC [ RunTime:0.017725s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833377 LIMIT 2 [ RunTime:0.026159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833377 ORDER BY `minOrder` ASC [ RunTime:0.002824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830557 LIMIT 5 [ RunTime:0.001711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830557 ORDER BY `minOrder` ASC [ RunTime:0.019494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19830557 ORDER BY `unit` DESC [ RunTime:0.014307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19830557 LIMIT 2 [ RunTime:0.047669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830557 ORDER BY `minOrder` ASC [ RunTime:0.016797s ]
select * from pdf where partno='FTSH-109-03-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19804926 LIMIT 5 [ RunTime:0.023066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804926 ORDER BY `minOrder` ASC [ RunTime:0.053729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19804926 ORDER BY `unit` DESC [ RunTime:0.030323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19804926 LIMIT 2 [ RunTime:0.047352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19804926 ORDER BY `minOrder` ASC [ RunTime:0.057282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801597 LIMIT 5 [ RunTime:0.017295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801597 ORDER BY `minOrder` ASC [ RunTime:0.016841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801597 ORDER BY `unit` DESC [ RunTime:0.014993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801597 LIMIT 2 [ RunTime:0.037233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801597 ORDER BY `minOrder` ASC [ RunTime:0.005408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19800101 LIMIT 5 [ RunTime:0.040818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19800101 ORDER BY `minOrder` ASC [ RunTime:0.055338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19800101 ORDER BY `unit` DESC [ RunTime:0.039993s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19800101 LIMIT 2 [ RunTime:0.037737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19800101 ORDER BY `minOrder` ASC [ RunTime:0.093542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796007 LIMIT 5 [ RunTime:0.032155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796007 ORDER BY `minOrder` ASC [ RunTime:0.037330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19796007 ORDER BY `unit` DESC [ RunTime:0.034824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19796007 LIMIT 2 [ RunTime:0.083919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19796007 ORDER BY `minOrder` ASC [ RunTime:0.003735s ]
select * from pdf where partno='FTSH-109-03-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783915 LIMIT 5 [ RunTime:0.065572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783915 ORDER BY `minOrder` ASC [ RunTime:0.046849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19783915 ORDER BY `unit` DESC [ RunTime:0.054294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19783915 LIMIT 2 [ RunTime:0.058571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19783915 ORDER BY `minOrder` ASC [ RunTime:0.034695s ]
select * from pdf where partno='FTSH-109-03-F-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209036 LIMIT 5 [ RunTime:0.021909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209036 ORDER BY `minOrder` ASC [ RunTime:0.057205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209036 ORDER BY `unit` DESC [ RunTime:0.038898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209036 LIMIT 2 [ RunTime:0.021528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209036 ORDER BY `minOrder` ASC [ RunTime:0.035102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209035 LIMIT 5 [ RunTime:0.028633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209035 ORDER BY `minOrder` ASC [ RunTime:0.025701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16209035 ORDER BY `unit` DESC [ RunTime:0.025002s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16209035 LIMIT 2 [ RunTime:0.069159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16209035 ORDER BY `minOrder` ASC [ RunTime:0.021515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16200824 LIMIT 5 [ RunTime:0.057663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200824 ORDER BY `minOrder` ASC [ RunTime:0.010389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16200824 ORDER BY `unit` DESC [ RunTime:0.036271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16200824 LIMIT 2 [ RunTime:0.066005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16200824 ORDER BY `minOrder` ASC [ RunTime:0.048125s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037974s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52812469 LIMIT 5 [ RunTime:0.035122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52812469 ORDER BY `minOrder` ASC [ RunTime:0.027329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52812469 ORDER BY `unit` DESC [ RunTime:0.053144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52812469 LIMIT 2 [ RunTime:0.078562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52812469 ORDER BY `minOrder` ASC [ RunTime:0.011074s ]
select * from pdf where partno='FTSH-109-03-F-DV-EL-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039499s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-EL-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044843s ]
SELECT `id` FROM `stock` WHERE `id` <> 52812469 AND `partno` = 'FTSH-109-03-F-DV-EL-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.082757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19804926 [ RunTime:0.037889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52808419 LIMIT 5 [ RunTime:0.040334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52808419 ORDER BY `minOrder` ASC [ RunTime:0.029786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52808419 ORDER BY `unit` DESC [ RunTime:0.016638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52808419 LIMIT 2 [ RunTime:0.031027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52808419 ORDER BY `minOrder` ASC [ RunTime:0.028584s ]
select * from pdf where partno='FTSH-109-03-F-DV-ES-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.043349s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-ES-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.060127s ]
SELECT `id` FROM `stock` WHERE `id` <> 52808419 AND `partno` = 'FTSH-109-03-F-DV-ES-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.056882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801597 [ RunTime:0.065289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52806627 LIMIT 5 [ RunTime:0.076665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52806627 ORDER BY `minOrder` ASC [ RunTime:0.036778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52806627 ORDER BY `unit` DESC [ RunTime:0.115019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52806627 LIMIT 2 [ RunTime:0.067148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52806627 ORDER BY `minOrder` ASC [ RunTime:0.046406s ]
select * from pdf where partno='FTSH-109-03-F-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041376s ]
SELECT `id` FROM `stock` WHERE `id` <> 52806627 AND `partno` = 'FTSH-109-03-F-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.051797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19800101 [ RunTime:0.013276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52802884 LIMIT 5 [ RunTime:0.042066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802884 ORDER BY `minOrder` ASC [ RunTime:0.014967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52802884 ORDER BY `unit` DESC [ RunTime:0.077199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52802884 LIMIT 2 [ RunTime:0.031850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802884 ORDER BY `minOrder` ASC [ RunTime:0.004878s ]
select * from pdf where partno='FTSH-109-03-F-DV-EP' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-EP' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025677s ]
SELECT `id` FROM `stock` WHERE `id` <> 52802884 AND `partno` = 'FTSH-109-03-F-DV-EP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.056357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209035 [ RunTime:0.026741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52802883 LIMIT 5 [ RunTime:0.034205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802883 ORDER BY `minOrder` ASC [ RunTime:0.031076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52802883 ORDER BY `unit` DESC [ RunTime:0.036322s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52802883 LIMIT 2 [ RunTime:0.071438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802883 ORDER BY `minOrder` ASC [ RunTime:0.006922s ]
select * from pdf where partno='FTSH-109-03-F-DV-ES' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-ES' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014015s ]
SELECT `id` FROM `stock` WHERE `id` <> 52802883 AND `partno` = 'FTSH-109-03-F-DV-ES' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16209036 [ RunTime:0.034591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52801122 LIMIT 5 [ RunTime:0.020239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52801122 ORDER BY `minOrder` ASC [ RunTime:0.028592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52801122 ORDER BY `unit` DESC [ RunTime:0.039246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52801122 LIMIT 2 [ RunTime:0.044815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52801122 ORDER BY `minOrder` ASC [ RunTime:0.013822s ]
select * from pdf where partno='FTSH-109-03-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020673s ]
SELECT `id` FROM `stock` WHERE `id` <> 52801122 AND `partno` = 'FTSH-109-03-F-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19796007 [ RunTime:0.005433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52798059 LIMIT 5 [ RunTime:0.006767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798059 ORDER BY `minOrder` ASC [ RunTime:0.020549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52798059 ORDER BY `unit` DESC [ RunTime:0.013631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52798059 LIMIT 2 [ RunTime:0.009984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52798059 ORDER BY `minOrder` ASC [ RunTime:0.001032s ]
select * from pdf where partno='FTSH-109-03-F-DV-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.036272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019392s ]
SELECT `id` FROM `stock` WHERE `id` <> 52798059 AND `partno` = 'FTSH-109-03-F-DV-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52792046 LIMIT 5 [ RunTime:0.037811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52792046 ORDER BY `minOrder` ASC [ RunTime:0.017414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52792046 ORDER BY `unit` DESC [ RunTime:0.038955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52792046 LIMIT 2 [ RunTime:0.031731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52792046 ORDER BY `minOrder` ASC [ RunTime:0.019907s ]
select * from pdf where partno='FTSH-109-03-F-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007273s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006082s ]
SELECT `id` FROM `stock` WHERE `id` <> 52792046 AND `partno` = 'FTSH-109-03-F-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19783915 [ RunTime:0.006959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52790230 LIMIT 5 [ RunTime:0.031553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52790230 ORDER BY `minOrder` ASC [ RunTime:0.016718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52790230 ORDER BY `unit` DESC [ RunTime:0.026858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52790230 LIMIT 2 [ RunTime:0.015578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52790230 ORDER BY `minOrder` ASC [ RunTime:0.013497s ]
select * from pdf where partno='FTSH-109-03-F-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020677s ]
SELECT `id` FROM `stock` WHERE `id` <> 52790230 AND `partno` = 'FTSH-109-03-F-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16200824 [ RunTime:0.022541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52649297 LIMIT 5 [ RunTime:0.012550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649297 ORDER BY `minOrder` ASC [ RunTime:0.022260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52649297 ORDER BY `unit` DESC [ RunTime:0.003357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52649297 LIMIT 2 [ RunTime:0.007028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52649297 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
select * from pdf where partno='FTSH-109-03-F-DV-EL-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV-EL-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010256s ]
SELECT `id` FROM `stock` WHERE `id` <> 52649297 AND `partno` = 'FTSH-109-03-F-DV-EL-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833377 [ RunTime:0.008970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52642725 LIMIT 5 [ RunTime:0.008665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52642725 ORDER BY `minOrder` ASC [ RunTime:0.026513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52642725 ORDER BY `unit` DESC [ RunTime:0.025028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52642725 LIMIT 2 [ RunTime:0.012821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52642725 ORDER BY `minOrder` ASC [ RunTime:0.016609s ]
select * from pdf where partno='FTSH-109-03-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-109-03-F-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010178s ]
SELECT `id` FROM `stock` WHERE `id` <> 52642725 AND `partno` = 'FTSH-109-03-F-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830557 [ RunTime:0.015591s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008940s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006566s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012019s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011730s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012839s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009147s ]
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-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006116s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-109-03-F-DV%' OR `brand` LIKE 'FTSH-109-03-F-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007622s ]