SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001387s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015620s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810309 LIMIT 5 [ RunTime:0.025956s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810309 ORDER BY `minOrder` ASC [ RunTime:0.028286s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19810309 ORDER BY `unit` DESC [ RunTime:0.046186s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19810309 LIMIT 2 [ RunTime:0.017494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19810309 ORDER BY `minOrder` ASC [ RunTime:0.014708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801995 LIMIT 5 [ RunTime:0.045980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801995 ORDER BY `minOrder` ASC [ RunTime:0.029308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801995 ORDER BY `unit` DESC [ RunTime:0.064102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801995 LIMIT 2 [ RunTime:0.063905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801995 ORDER BY `minOrder` ASC [ RunTime:0.028342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797303 LIMIT 5 [ RunTime:0.122859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797303 ORDER BY `minOrder` ASC [ RunTime:0.127365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19797303 ORDER BY `unit` DESC [ RunTime:0.048663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19797303 LIMIT 2 [ RunTime:0.061079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19797303 ORDER BY `minOrder` ASC [ RunTime:0.068210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227340 LIMIT 5 [ RunTime:0.051423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227340 ORDER BY `minOrder` ASC [ RunTime:0.050973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16227340 ORDER BY `unit` DESC [ RunTime:0.050925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16227340 LIMIT 2 [ RunTime:0.050857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16227340 ORDER BY `minOrder` ASC [ RunTime:0.050914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207487 LIMIT 5 [ RunTime:0.051679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207487 ORDER BY `minOrder` ASC [ RunTime:0.051025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16207487 ORDER BY `unit` DESC [ RunTime:0.050879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16207487 LIMIT 2 [ RunTime:0.063511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16207487 ORDER BY `minOrder` ASC [ RunTime:0.072221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484841 LIMIT 5 [ RunTime:0.109278s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484841 ORDER BY `minOrder` ASC [ RunTime:0.162236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15484841 ORDER BY `unit` DESC [ RunTime:0.056110s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15484841 LIMIT 2 [ RunTime:0.104519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15484841 ORDER BY `minOrder` ASC [ RunTime:0.050991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743648 LIMIT 5 [ RunTime:0.030640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743648 ORDER BY `minOrder` ASC [ RunTime:0.070206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12743648 ORDER BY `unit` DESC [ RunTime:0.032882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12743648 LIMIT 2 [ RunTime:0.061654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12743648 ORDER BY `minOrder` ASC [ RunTime:0.028066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740890 LIMIT 5 [ RunTime:0.024778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740890 ORDER BY `minOrder` ASC [ RunTime:0.054482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740890 ORDER BY `unit` DESC [ RunTime:0.035045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740890 LIMIT 2 [ RunTime:0.036546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740890 ORDER BY `minOrder` ASC [ RunTime:0.020232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573248 LIMIT 5 [ RunTime:0.023949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573248 ORDER BY `minOrder` ASC [ RunTime:0.032288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11573248 ORDER BY `unit` DESC [ RunTime:0.072037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11573248 LIMIT 2 [ RunTime:0.025649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11573248 ORDER BY `minOrder` ASC [ RunTime:0.007340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571662 LIMIT 5 [ RunTime:0.042859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571662 ORDER BY `minOrder` ASC [ RunTime:0.019155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11571662 ORDER BY `unit` DESC [ RunTime:0.015886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11571662 LIMIT 2 [ RunTime:0.026362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571662 ORDER BY `minOrder` ASC [ RunTime:0.005626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11570499 LIMIT 5 [ RunTime:0.022867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11570499 ORDER BY `minOrder` ASC [ RunTime:0.088311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11570499 ORDER BY `unit` DESC [ RunTime:0.029658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11570499 LIMIT 2 [ RunTime:0.064445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11570499 ORDER BY `minOrder` ASC [ RunTime:0.062294s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005003s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59693620 LIMIT 5 [ RunTime:0.014919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693620 ORDER BY `minOrder` ASC [ RunTime:0.017444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59693620 ORDER BY `unit` DESC [ RunTime:0.027905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59693620 LIMIT 2 [ RunTime:0.015384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693620 ORDER BY `minOrder` ASC [ RunTime:0.014754s ]
select * from pdf where partno='FTS-120-03-F-DV-S-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023575s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001490s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-S-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.035605s ]
SELECT `id` FROM `stock` WHERE `id` <> 59693620 AND `partno` = 'FTS-120-03-F-DV-S-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.037449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15484841 [ RunTime:0.038455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59693537 LIMIT 5 [ RunTime:0.040346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693537 ORDER BY `minOrder` ASC [ RunTime:0.035203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59693537 ORDER BY `unit` DESC [ RunTime:0.026431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59693537 LIMIT 2 [ RunTime:0.008313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59693537 ORDER BY `minOrder` ASC [ RunTime:0.010785s ]
select * from pdf where partno='FTS-120-03-F-DV-SA-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-SA-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021086s ]
SELECT `id` FROM `stock` WHERE `id` <> 59693537 AND `partno` = 'FTS-120-03-F-DV-SA-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19810309 [ RunTime:0.018841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59692702 LIMIT 5 [ RunTime:0.008474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59692702 ORDER BY `minOrder` ASC [ RunTime:0.019998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59692702 ORDER BY `unit` DESC [ RunTime:0.019370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59692702 LIMIT 2 [ RunTime:0.007960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59692702 ORDER BY `minOrder` ASC [ RunTime:0.009420s ]
select * from pdf where partno='FTS-120-03-F-DV-S-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-S-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008976s ]
SELECT `id` FROM `stock` WHERE `id` <> 59692702 AND `partno` = 'FTS-120-03-F-DV-S-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12743648 [ RunTime:0.014126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59690212 LIMIT 5 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690212 ORDER BY `minOrder` ASC [ RunTime:0.005369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59690212 ORDER BY `unit` DESC [ RunTime:0.003485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59690212 LIMIT 2 [ RunTime:0.001904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690212 ORDER BY `minOrder` ASC [ RunTime:0.006984s ]
select * from pdf where partno='FTS-120-03-F-DV-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005939s ]
SELECT `id` FROM `stock` WHERE `id` <> 59690212 AND `partno` = 'FTS-120-03-F-DV-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11573248 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59690206 LIMIT 5 [ RunTime:0.001828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690206 ORDER BY `minOrder` ASC [ RunTime:0.012478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59690206 ORDER BY `unit` DESC [ RunTime:0.024617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59690206 LIMIT 2 [ RunTime:0.004725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59690206 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
select * from pdf where partno='FTS-120-03-F-DV-SA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-SA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011173s ]
SELECT `id` FROM `stock` WHERE `id` <> 59690206 AND `partno` = 'FTS-120-03-F-DV-SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59688351 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59688351 ORDER BY `minOrder` ASC [ RunTime:0.004570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59688351 ORDER BY `unit` DESC [ RunTime:0.020539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59688351 LIMIT 2 [ RunTime:0.002111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59688351 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='FTS-120-03-F-DV-SA-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-SA-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013067s ]
SELECT `id` FROM `stock` WHERE `id` <> 59688351 AND `partno` = 'FTS-120-03-F-DV-SA-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59687198 LIMIT 5 [ RunTime:0.013122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59687198 ORDER BY `minOrder` ASC [ RunTime:0.024428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59687198 ORDER BY `unit` DESC [ RunTime:0.022375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59687198 LIMIT 2 [ RunTime:0.007948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59687198 ORDER BY `minOrder` ASC [ RunTime:0.002769s ]
select * from pdf where partno='FTS-120-03-F-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017613s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006269s ]
SELECT `id` FROM `stock` WHERE `id` <> 59687198 AND `partno` = 'FTS-120-03-F-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571662 [ RunTime:0.018554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59685843 LIMIT 5 [ RunTime:0.009742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59685843 ORDER BY `minOrder` ASC [ RunTime:0.023237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59685843 ORDER BY `unit` DESC [ RunTime:0.018595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59685843 LIMIT 2 [ RunTime:0.006324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59685843 ORDER BY `minOrder` ASC [ RunTime:0.018273s ]
select * from pdf where partno='FTS-120-03-F-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.077902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025296s ]
SELECT `id` FROM `stock` WHERE `id` <> 59685843 AND `partno` = 'FTS-120-03-F-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801995 [ RunTime:0.010492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59684018 LIMIT 5 [ RunTime:0.024304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59684018 ORDER BY `minOrder` ASC [ RunTime:0.027429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59684018 ORDER BY `unit` DESC [ RunTime:0.012680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59684018 LIMIT 2 [ RunTime:0.026862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59684018 ORDER BY `minOrder` ASC [ RunTime:0.019063s ]
select * from pdf where partno='FTS-120-03-F-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.098239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.078751s ]
SELECT `id` FROM `stock` WHERE `id` <> 59684018 AND `partno` = 'FTS-120-03-F-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.098709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740890 [ RunTime:0.042165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59683241 LIMIT 5 [ RunTime:0.027649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683241 ORDER BY `minOrder` ASC [ RunTime:0.063114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59683241 ORDER BY `unit` DESC [ RunTime:0.084300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59683241 LIMIT 2 [ RunTime:0.101282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59683241 ORDER BY `minOrder` ASC [ RunTime:0.031068s ]
select * from pdf where partno='FTS-120-03-F-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.201505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.115901s ]
SELECT `id` FROM `stock` WHERE `id` <> 59683241 AND `partno` = 'FTS-120-03-F-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.155414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11570499 [ RunTime:0.090275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59677434 LIMIT 5 [ RunTime:0.050727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59677434 ORDER BY `minOrder` ASC [ RunTime:0.069441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59677434 ORDER BY `unit` DESC [ RunTime:0.033765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59677434 LIMIT 2 [ RunTime:0.171104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59677434 ORDER BY `minOrder` ASC [ RunTime:0.073538s ]
select * from pdf where partno='FTS-120-03-F-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.105532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.051566s ]
SELECT `id` FROM `stock` WHERE `id` <> 59677434 AND `partno` = 'FTS-120-03-F-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.090382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19797303 [ RunTime:0.162033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59673489 LIMIT 5 [ RunTime:0.050998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59673489 ORDER BY `minOrder` ASC [ RunTime:0.096999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59673489 ORDER BY `unit` DESC [ RunTime:0.063293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59673489 LIMIT 2 [ RunTime:0.147280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59673489 ORDER BY `minOrder` ASC [ RunTime:0.051303s ]
select * from pdf where partno='FTS-120-03-F-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.101933s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.134599s ]
SELECT `id` FROM `stock` WHERE `id` <> 59673489 AND `partno` = 'FTS-120-03-F-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.080884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16207487 [ RunTime:0.095039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59510424 LIMIT 5 [ RunTime:0.087169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510424 ORDER BY `minOrder` ASC [ RunTime:0.020541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59510424 ORDER BY `unit` DESC [ RunTime:0.055274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59510424 LIMIT 2 [ RunTime:0.081939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59510424 ORDER BY `minOrder` ASC [ RunTime:0.054915s ]
select * from pdf where partno='FTS-120-03-F-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTS-120-03-F-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044248s ]
SELECT `id` FROM `stock` WHERE `id` <> 59510424 AND `partno` = 'FTS-120-03-F-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.072805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16227340 [ RunTime:0.086955s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030779s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090689s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015618s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028117s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035970s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027528s ]
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 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016138s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTS-120-03-F-DV%' OR `brand` LIKE 'FTS-120-03-F-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024736s ]