SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001025s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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-105-01-L-D&search=1' [ RunTime:0.007525s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001068s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.031016s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001445s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.022276s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001578s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001942s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001150s ]
SELECT * FROM `stock_search` WHERE `partno` = 'FTSH-105-01-L-D' LIMIT 1 [ RunTime:0.005732s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-25 12:05:57' WHERE `partno` = 'FTSH-105-01-L-D' [ RunTime:0.003178s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001367s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070409s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192821 LIMIT 5 [ RunTime:0.056280s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192821 ORDER BY `minOrder` ASC [ RunTime:0.050324s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192821 ORDER BY `unit` DESC [ RunTime:0.012921s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192821 LIMIT 2 [ RunTime:0.071346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192821 ORDER BY `minOrder` ASC [ RunTime:0.009390s ]
select * from pdf where partno='FTSH-105-01-L-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.058836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196037 LIMIT 5 [ RunTime:0.025001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196037 ORDER BY `minOrder` ASC [ RunTime:0.058383s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196037 ORDER BY `unit` DESC [ RunTime:0.045906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196037 LIMIT 2 [ RunTime:0.022599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196037 ORDER BY `minOrder` ASC [ RunTime:0.037860s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.076130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766281 LIMIT 5 [ RunTime:0.076451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766281 ORDER BY `minOrder` ASC [ RunTime:0.017591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19766281 ORDER BY `unit` DESC [ RunTime:0.037569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19766281 LIMIT 2 [ RunTime:0.021031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19766281 ORDER BY `minOrder` ASC [ RunTime:0.021371s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185818 LIMIT 5 [ RunTime:0.060806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185818 ORDER BY `minOrder` ASC [ RunTime:0.028128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16185818 ORDER BY `unit` DESC [ RunTime:0.012559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16185818 LIMIT 2 [ RunTime:0.013773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16185818 ORDER BY `minOrder` ASC [ RunTime:0.002866s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772762 LIMIT 5 [ RunTime:0.003677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772762 ORDER BY `minOrder` ASC [ RunTime:0.002230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772762 ORDER BY `unit` DESC [ RunTime:0.002059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772762 LIMIT 2 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772762 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196021 LIMIT 5 [ RunTime:0.004857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196021 ORDER BY `minOrder` ASC [ RunTime:0.005387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196021 ORDER BY `unit` DESC [ RunTime:0.002436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196021 LIMIT 2 [ RunTime:0.000515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196021 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19759787 LIMIT 5 [ RunTime:0.009986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19759787 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19759787 ORDER BY `unit` DESC [ RunTime:0.000283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19759787 LIMIT 2 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19759787 ORDER BY `minOrder` ASC [ RunTime:0.001829s ]
select * from pdf where partno='FTSH-105-01-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192806 LIMIT 5 [ RunTime:0.001007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192806 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16192806 ORDER BY `unit` DESC [ RunTime:0.000326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16192806 LIMIT 2 [ RunTime:0.000287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16192806 ORDER BY `minOrder` ASC [ RunTime:0.000169s ]
select * from pdf where partno='FTSH-105-01-L-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19836269 LIMIT 5 [ RunTime:0.002566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19836269 ORDER BY `minOrder` ASC [ RunTime:0.001571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19836269 ORDER BY `unit` DESC [ RunTime:0.005087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19836269 LIMIT 2 [ RunTime:0.005520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19836269 ORDER BY `minOrder` ASC [ RunTime:0.000193s ]
select * from pdf where partno='FTSH-105-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15486509 LIMIT 5 [ RunTime:0.010465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486509 ORDER BY `minOrder` ASC [ RunTime:0.005426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15486509 ORDER BY `unit` DESC [ RunTime:0.001715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15486509 LIMIT 2 [ RunTime:0.005812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15486509 ORDER BY `minOrder` ASC [ RunTime:0.001100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196019 LIMIT 5 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196019 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16196019 ORDER BY `unit` DESC [ RunTime:0.007189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16196019 LIMIT 2 [ RunTime:0.002082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16196019 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772750 LIMIT 5 [ RunTime:0.001734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772750 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772750 ORDER BY `unit` DESC [ RunTime:0.000914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772750 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772750 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19832609 LIMIT 5 [ RunTime:0.008852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832609 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19832609 ORDER BY `unit` DESC [ RunTime:0.000707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19832609 LIMIT 2 [ RunTime:0.002558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19832609 ORDER BY `minOrder` ASC [ RunTime:0.005393s ]
select * from pdf where partno='FTSH-105-01-L-DH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19775193 LIMIT 5 [ RunTime:0.001545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775193 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19775193 ORDER BY `unit` DESC [ RunTime:0.006593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19775193 LIMIT 2 [ RunTime:0.000316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19775193 ORDER BY `minOrder` ASC [ RunTime:0.000282s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772083 LIMIT 5 [ RunTime:0.003162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772083 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19772083 ORDER BY `unit` DESC [ RunTime:0.009526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19772083 LIMIT 2 [ RunTime:0.001976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19772083 ORDER BY `minOrder` ASC [ RunTime:0.023213s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16228703 LIMIT 5 [ RunTime:0.003471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16228703 ORDER BY `minOrder` ASC [ RunTime:0.000687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16228703 ORDER BY `unit` DESC [ RunTime:0.002917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16228703 LIMIT 2 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16228703 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='FTSH-105-01-L-D-007-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19844519 LIMIT 5 [ RunTime:0.011733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19844519 ORDER BY `minOrder` ASC [ RunTime:0.000905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19844519 ORDER BY `unit` DESC [ RunTime:0.007777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19844519 LIMIT 2 [ RunTime:0.003246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19844519 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19833803 LIMIT 5 [ RunTime:0.001820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833803 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19833803 ORDER BY `unit` DESC [ RunTime:0.010874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19833803 LIMIT 2 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19833803 ORDER BY `minOrder` ASC [ RunTime:0.001518s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15490776 LIMIT 5 [ RunTime:0.005975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490776 ORDER BY `minOrder` ASC [ RunTime:0.007198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15490776 ORDER BY `unit` DESC [ RunTime:0.017601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15490776 LIMIT 2 [ RunTime:0.005973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15490776 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='FTSH-105-01-L-DH-A-C-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19826695 LIMIT 5 [ RunTime:0.011073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826695 ORDER BY `minOrder` ASC [ RunTime:0.000939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19826695 ORDER BY `unit` DESC [ RunTime:0.009215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19826695 LIMIT 2 [ RunTime:0.013789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19826695 ORDER BY `minOrder` ASC [ RunTime:0.010925s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276964 LIMIT 5 [ RunTime:0.013907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276964 ORDER BY `minOrder` ASC [ RunTime:0.004177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276964 ORDER BY `unit` DESC [ RunTime:0.004497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276964 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276964 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
select * from pdf where partno='ftsh-105-01-l-dv-a-p-tr' and brandshort='samtec' limit 1 [ RunTime:0.001221s ]
select foldpath,foldpath2,filename from pdf_file where id=1917805 limit 1 [ RunTime:0.001373s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ftsh-105-01-l-dv-a-p-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.006568s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434316 LIMIT 5 [ RunTime:0.006274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434316 ORDER BY `minOrder` ASC [ RunTime:0.007495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434316 ORDER BY `unit` DESC [ RunTime:0.002808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434316 LIMIT 2 [ RunTime:0.005658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434316 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
select * from pdf where partno='FTSH-105-01-L-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002967s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434316 AND `partno` = 'FTSH-105-01-L-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192821 [ RunTime:0.027289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434620 LIMIT 5 [ RunTime:0.005373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434620 ORDER BY `minOrder` ASC [ RunTime:0.008379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434620 ORDER BY `unit` DESC [ RunTime:0.005507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434620 LIMIT 2 [ RunTime:0.000451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434620 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434690 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434690 ORDER BY `minOrder` ASC [ RunTime:0.003821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434690 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434690 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434690 ORDER BY `minOrder` ASC [ RunTime:0.001125s ]
select * from pdf where partno='FTSH-105-01-L-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000615s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-D-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001972s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434690 AND `partno` = 'FTSH-105-01-L-D-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192806 [ RunTime:0.024281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434311 LIMIT 5 [ RunTime:0.011350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434311 ORDER BY `minOrder` ASC [ RunTime:0.005906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434311 ORDER BY `unit` DESC [ RunTime:0.007619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434311 LIMIT 2 [ RunTime:0.021766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434311 ORDER BY `minOrder` ASC [ RunTime:0.002035s ]
select * from pdf where partno='FTSH-105-01-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004172s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434311 AND `partno` = 'FTSH-105-01-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19759787 [ RunTime:0.007671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434692 LIMIT 5 [ RunTime:0.010287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434692 ORDER BY `minOrder` ASC [ RunTime:0.005084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434692 ORDER BY `unit` DESC [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434692 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434692 ORDER BY `minOrder` ASC [ RunTime:0.003122s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000754s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434692 AND `partno` = 'FTSH-105-01-L-DV-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196037 [ RunTime:0.018684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434810 LIMIT 5 [ RunTime:0.007645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434810 ORDER BY `minOrder` ASC [ RunTime:0.010648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434810 ORDER BY `unit` DESC [ RunTime:0.016124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434810 LIMIT 2 [ RunTime:0.025191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434810 ORDER BY `minOrder` ASC [ RunTime:0.001065s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-007-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013501s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434810 AND `partno` = 'FTSH-105-01-L-DV-007-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16196021 [ RunTime:0.005281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434849 LIMIT 5 [ RunTime:0.008475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434849 ORDER BY `minOrder` ASC [ RunTime:0.007797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434849 ORDER BY `unit` DESC [ RunTime:0.034969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434849 LIMIT 2 [ RunTime:0.017940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434849 ORDER BY `minOrder` ASC [ RunTime:0.011405s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.037605s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434849 AND `partno` = 'FTSH-105-01-L-DV-K-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16185818 [ RunTime:0.000748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434178 LIMIT 5 [ RunTime:0.009886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434178 ORDER BY `minOrder` ASC [ RunTime:0.013994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434178 ORDER BY `unit` DESC [ RunTime:0.006879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434178 LIMIT 2 [ RunTime:0.007725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434178 ORDER BY `minOrder` ASC [ RunTime:0.007257s ]
select * from pdf where partno='FTSH-105-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000440s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434178 AND `partno` = 'FTSH-105-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19836269 [ RunTime:0.012299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434774 LIMIT 5 [ RunTime:0.004317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434774 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434774 ORDER BY `unit` DESC [ RunTime:0.001200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434774 LIMIT 2 [ RunTime:0.002751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434774 ORDER BY `minOrder` ASC [ RunTime:0.004172s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022047s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434774 AND `partno` = 'FTSH-105-01-L-DV-K-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772083 [ RunTime:0.011723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434685 LIMIT 5 [ RunTime:0.011037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434685 ORDER BY `minOrder` ASC [ RunTime:0.007171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434685 ORDER BY `unit` DESC [ RunTime:0.012174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434685 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434685 ORDER BY `minOrder` ASC [ RunTime:0.003901s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003639s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434685 AND `partno` = 'FTSH-105-01-L-DV-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16192805 [ RunTime:0.009408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438177 LIMIT 5 [ RunTime:0.005732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438177 ORDER BY `minOrder` ASC [ RunTime:0.004312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438177 ORDER BY `unit` DESC [ RunTime:0.003728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438177 LIMIT 2 [ RunTime:0.008332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438177 ORDER BY `minOrder` ASC [ RunTime:0.015903s ]
select * from pdf where partno='FTSH-105-01-L-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008347s ]
SELECT `id` FROM `stock` WHERE `id` <> 59438177 AND `partno` = 'FTSH-105-01-L-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.043746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19828132 [ RunTime:0.005052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59527167 LIMIT 5 [ RunTime:0.004122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59527167 ORDER BY `minOrder` ASC [ RunTime:0.013551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59527167 ORDER BY `unit` DESC [ RunTime:0.006258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59527167 LIMIT 2 [ RunTime:0.007268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59527167 ORDER BY `minOrder` ASC [ RunTime:0.003868s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K-P-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-007-K-P-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014368s ]
SELECT `id` FROM `stock` WHERE `id` <> 59527167 AND `partno` = 'FTSH-105-01-L-DV-007-K-P-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19844519 [ RunTime:0.007851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434658 LIMIT 5 [ RunTime:0.001383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434658 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434658 ORDER BY `unit` DESC [ RunTime:0.003119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434658 LIMIT 2 [ RunTime:0.003810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434658 ORDER BY `minOrder` ASC [ RunTime:0.014568s ]
select * from pdf where partno='FTSH-105-01-L-DH-C-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DH-C-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001868s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434658 AND `partno` = 'FTSH-105-01-L-DH-C-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19766276 [ RunTime:0.006373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59439439 LIMIT 5 [ RunTime:0.005543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439439 ORDER BY `minOrder` ASC [ RunTime:0.014222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59439439 ORDER BY `unit` DESC [ RunTime:0.002972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59439439 LIMIT 2 [ RunTime:0.027876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439439 ORDER BY `minOrder` ASC [ RunTime:0.006632s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.041695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-007-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008874s ]
SELECT `id` FROM `stock` WHERE `id` <> 59439439 AND `partno` = 'FTSH-105-01-L-DV-007-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15477834 [ RunTime:0.024391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434903 LIMIT 5 [ RunTime:0.056470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434903 ORDER BY `minOrder` ASC [ RunTime:0.029446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434903 ORDER BY `unit` DESC [ RunTime:0.030030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434903 LIMIT 2 [ RunTime:0.009640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434903 ORDER BY `minOrder` ASC [ RunTime:0.012535s ]
select * from pdf where partno='FTSH-105-01-L-D-RA-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-D-RA-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.029982s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434903 AND `partno` = 'FTSH-105-01-L-D-RA-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772750 [ RunTime:0.029353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434467 LIMIT 5 [ RunTime:0.040462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434467 ORDER BY `minOrder` ASC [ RunTime:0.067200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434467 ORDER BY `unit` DESC [ RunTime:0.026772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434467 LIMIT 2 [ RunTime:0.011976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434467 ORDER BY `minOrder` ASC [ RunTime:0.023503s ]
select * from pdf where partno='FTSH-105-01-L-DH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DH-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.032290s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434467 AND `partno` = 'FTSH-105-01-L-DH-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19832609 [ RunTime:0.038199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59439325 LIMIT 5 [ RunTime:0.038047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439325 ORDER BY `minOrder` ASC [ RunTime:0.018205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59439325 ORDER BY `unit` DESC [ RunTime:0.035715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59439325 LIMIT 2 [ RunTime:0.007074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59439325 ORDER BY `minOrder` ASC [ RunTime:0.013434s ]
select * from pdf where partno='FTSH-105-01-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.055242s ]
SELECT `id` FROM `stock` WHERE `id` <> 59439325 AND `partno` = 'FTSH-105-01-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19831953 [ RunTime:0.011574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59519566 LIMIT 5 [ RunTime:0.008568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59519566 ORDER BY `minOrder` ASC [ RunTime:0.026122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59519566 ORDER BY `unit` DESC [ RunTime:0.059461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59519566 LIMIT 2 [ RunTime:0.030230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59519566 ORDER BY `minOrder` ASC [ RunTime:0.056951s ]
select * from pdf where partno='FTSH-105-01-L-DV-P-FR' and brandshort='WEC' limit 1 [ RunTime:0.020748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-P-FR' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.061867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59434752 LIMIT 5 [ RunTime:0.059525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434752 ORDER BY `minOrder` ASC [ RunTime:0.026819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59434752 ORDER BY `unit` DESC [ RunTime:0.044113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59434752 LIMIT 2 [ RunTime:0.022968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59434752 ORDER BY `minOrder` ASC [ RunTime:0.010206s ]
select * from pdf where partno='FTSH-105-01-L-DV-007-K-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-007-K-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.050936s ]
SELECT `id` FROM `stock` WHERE `id` <> 59434752 AND `partno` = 'FTSH-105-01-L-DV-007-K-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.052488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19772762 [ RunTime:0.010452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59525806 LIMIT 5 [ RunTime:0.031862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59525806 ORDER BY `minOrder` ASC [ RunTime:0.095159s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59525806 ORDER BY `unit` DESC [ RunTime:0.034972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59525806 LIMIT 2 [ RunTime:0.045587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59525806 ORDER BY `minOrder` ASC [ RunTime:0.026637s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P-FR' and brandshort='WEC' limit 1 [ RunTime:0.060117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-P-FR' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.051537s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016289s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058433s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080673s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055985s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028323s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013212s ]
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-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019967 LIMIT 5 [ RunTime:0.038298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019967 ORDER BY `minOrder` ASC [ RunTime:0.087058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019967 ORDER BY `unit` DESC [ RunTime:0.056276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019967 LIMIT 2 [ RunTime:0.046303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019967 ORDER BY `minOrder` ASC [ RunTime:0.018197s ]
select * from pdf where partno='FTSH-105-01-L-DV-K-P-TR' and brandshort='SAMTEC' limit 1 [ RunTime:0.100344s ]
select foldpath,foldpath2,filename from pdf_file where id=1053154 limit 1 [ RunTime:0.091799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-105-01-L-DV-K-P-TR' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.036322s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-105-01-L-D%' OR `brand` LIKE 'FTSH-105-01-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.039885s ]