SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002840s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.160708s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19752739 LIMIT 5 [ RunTime:0.039128s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.033912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752739 ORDER BY `minOrder` ASC [ RunTime:0.050855s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19752739 ORDER BY `unit` DESC [ RunTime:0.148432s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19752739 LIMIT 2 [ RunTime:0.051025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19752739 ORDER BY `minOrder` ASC [ RunTime:0.050913s ]
select * from pdf where partno='FTSH-104-04-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773563 LIMIT 5 [ RunTime:0.201183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773563 ORDER BY `minOrder` ASC [ RunTime:0.050650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19773563 ORDER BY `unit` DESC [ RunTime:0.047697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19773563 LIMIT 2 [ RunTime:0.069071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19773563 ORDER BY `minOrder` ASC [ RunTime:0.090397s ]
select * from pdf where partno='FTSH-104-04-L-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.064147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197606 LIMIT 5 [ RunTime:0.053555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197606 ORDER BY `minOrder` ASC [ RunTime:0.089910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197606 ORDER BY `unit` DESC [ RunTime:0.018065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197606 LIMIT 2 [ RunTime:0.105363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197606 ORDER BY `minOrder` ASC [ RunTime:0.005502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851522 LIMIT 5 [ RunTime:0.061768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851522 ORDER BY `minOrder` ASC [ RunTime:0.064584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851522 ORDER BY `unit` DESC [ RunTime:0.040042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851522 LIMIT 2 [ RunTime:0.119564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851522 ORDER BY `minOrder` ASC [ RunTime:0.064501s ]
select * from pdf where partno='FTSH-104-04-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.062903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494240 LIMIT 5 [ RunTime:0.071707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494240 ORDER BY `minOrder` ASC [ RunTime:0.072246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15494240 ORDER BY `unit` DESC [ RunTime:0.072253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15494240 LIMIT 2 [ RunTime:0.071428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15494240 ORDER BY `minOrder` ASC [ RunTime:0.024361s ]
select * from pdf where partno='FTSH-104-04-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19782285 LIMIT 5 [ RunTime:0.036609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19782285 ORDER BY `minOrder` ASC [ RunTime:0.034041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19782285 ORDER BY `unit` DESC [ RunTime:0.023987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19782285 LIMIT 2 [ RunTime:0.039567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19782285 ORDER BY `minOrder` ASC [ RunTime:0.016543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19777694 LIMIT 5 [ RunTime:0.008746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19777694 ORDER BY `minOrder` ASC [ RunTime:0.012590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19777694 ORDER BY `unit` DESC [ RunTime:0.026291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19777694 LIMIT 2 [ RunTime:0.056045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19777694 ORDER BY `minOrder` ASC [ RunTime:0.007381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226753 LIMIT 5 [ RunTime:0.020764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226753 ORDER BY `minOrder` ASC [ RunTime:0.014510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16226753 ORDER BY `unit` DESC [ RunTime:0.021313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16226753 LIMIT 2 [ RunTime:0.003765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16226753 ORDER BY `minOrder` ASC [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203046 LIMIT 5 [ RunTime:0.015053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203046 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16203046 ORDER BY `unit` DESC [ RunTime:0.009598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16203046 LIMIT 2 [ RunTime:0.017262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16203046 ORDER BY `minOrder` ASC [ RunTime:0.010232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489725 LIMIT 5 [ RunTime:0.014722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489725 ORDER BY `minOrder` ASC [ RunTime:0.003603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15489725 ORDER BY `unit` DESC [ RunTime:0.000696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15489725 LIMIT 2 [ RunTime:0.004632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15489725 ORDER BY `minOrder` ASC [ RunTime:0.003863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730160 LIMIT 5 [ RunTime:0.012064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730160 ORDER BY `minOrder` ASC [ RunTime:0.005992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12730160 ORDER BY `unit` DESC [ RunTime:0.007178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12730160 LIMIT 2 [ RunTime:0.002403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730160 ORDER BY `minOrder` ASC [ RunTime:0.001026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567830 LIMIT 5 [ RunTime:0.001441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567830 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11567830 ORDER BY `unit` DESC [ RunTime:0.005595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11567830 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11567830 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002095s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59449603 LIMIT 5 [ RunTime:0.030606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449603 ORDER BY `minOrder` ASC [ RunTime:0.022312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59449603 ORDER BY `unit` DESC [ RunTime:0.002852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59449603 LIMIT 2 [ RunTime:0.004113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449603 ORDER BY `minOrder` ASC [ RunTime:0.005483s ]
select * from pdf where partno='FTSH-104-04-L-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000482s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007961s ]
SELECT `id` FROM `stock` WHERE `id` <> 59449603 AND `partno` = 'FTSH-104-04-L-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851522 [ RunTime:0.037018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59449817 LIMIT 5 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449817 ORDER BY `minOrder` ASC [ RunTime:0.009478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59449817 ORDER BY `unit` DESC [ RunTime:0.002296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59449817 LIMIT 2 [ RunTime:0.009843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59449817 ORDER BY `minOrder` ASC [ RunTime:0.002792s ]
select * from pdf where partno='FTSH-104-04-L-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005927s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002821s ]
SELECT `id` FROM `stock` WHERE `id` <> 59449817 AND `partno` = 'FTSH-104-04-L-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19773563 [ RunTime:0.003916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540310 LIMIT 5 [ RunTime:0.005923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540310 ORDER BY `minOrder` ASC [ RunTime:0.040890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540310 ORDER BY `unit` DESC [ RunTime:0.018129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540310 LIMIT 2 [ RunTime:0.032539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540310 ORDER BY `minOrder` ASC [ RunTime:0.015287s ]
select * from pdf where partno='FTSH-104-04-L-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025912s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540310 AND `partno` = 'FTSH-104-04-L-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.048185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19752739 [ RunTime:0.026900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59540311 LIMIT 5 [ RunTime:0.021561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540311 ORDER BY `minOrder` ASC [ RunTime:0.031934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59540311 ORDER BY `unit` DESC [ RunTime:0.045115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59540311 LIMIT 2 [ RunTime:0.034189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59540311 ORDER BY `minOrder` ASC [ RunTime:0.001536s ]
select * from pdf where partno='FTSH-104-04-L-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.052342s ]
SELECT `id` FROM `stock` WHERE `id` <> 59540311 AND `partno` = 'FTSH-104-04-L-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197606 [ RunTime:0.035917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59444086 LIMIT 5 [ RunTime:0.052066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444086 ORDER BY `minOrder` ASC [ RunTime:0.037082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59444086 ORDER BY `unit` DESC [ RunTime:0.039162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59444086 LIMIT 2 [ RunTime:0.039940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59444086 ORDER BY `minOrder` ASC [ RunTime:0.022445s ]
select * from pdf where partno='FTSH-104-04-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013080s ]
SELECT `id` FROM `stock` WHERE `id` <> 59444086 AND `partno` = 'FTSH-104-04-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.080434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15494240 [ RunTime:0.024051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59649593 LIMIT 5 [ RunTime:0.017228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59649593 ORDER BY `minOrder` ASC [ RunTime:0.080531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59649593 ORDER BY `unit` DESC [ RunTime:0.014516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59649593 LIMIT 2 [ RunTime:0.054426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59649593 ORDER BY `minOrder` ASC [ RunTime:0.049260s ]
select * from pdf where partno='FTSH-104-04-L-DH-C' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DH-C' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044367s ]
SELECT `id` FROM `stock` WHERE `id` <> 59649593 AND `partno` = 'FTSH-104-04-L-DH-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.063784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16203046 [ RunTime:0.071573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59645477 LIMIT 5 [ RunTime:0.038076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59645477 ORDER BY `minOrder` ASC [ RunTime:0.100372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59645477 ORDER BY `unit` DESC [ RunTime:0.031044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59645477 LIMIT 2 [ RunTime:0.074238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59645477 ORDER BY `minOrder` ASC [ RunTime:0.030389s ]
select * from pdf where partno='FTSH-104-04-L-DH' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DH' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.034678s ]
SELECT `id` FROM `stock` WHERE `id` <> 59645477 AND `partno` = 'FTSH-104-04-L-DH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19782285 [ RunTime:0.056156s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59640411 LIMIT 5 [ RunTime:0.039208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59640411 ORDER BY `minOrder` ASC [ RunTime:0.039606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59640411 ORDER BY `unit` DESC [ RunTime:0.034506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59640411 LIMIT 2 [ RunTime:0.007788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59640411 ORDER BY `minOrder` ASC [ RunTime:0.005227s ]
select * from pdf where partno='FTSH-104-04-L-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026044s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022299s ]
SELECT `id` FROM `stock` WHERE `id` <> 59640411 AND `partno` = 'FTSH-104-04-L-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19777694 [ RunTime:0.021398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59637701 LIMIT 5 [ RunTime:0.008995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59637701 ORDER BY `minOrder` ASC [ RunTime:0.015306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59637701 ORDER BY `unit` DESC [ RunTime:0.023653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59637701 LIMIT 2 [ RunTime:0.033997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59637701 ORDER BY `minOrder` ASC [ RunTime:0.028805s ]
select * from pdf where partno='FTSH-104-04-L-DH-C-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.030213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DH-C-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.022056s ]
SELECT `id` FROM `stock` WHERE `id` <> 59637701 AND `partno` = 'FTSH-104-04-L-DH-C-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59636185 LIMIT 5 [ RunTime:0.015046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59636185 ORDER BY `minOrder` ASC [ RunTime:0.041332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59636185 ORDER BY `unit` DESC [ RunTime:0.028549s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59636185 LIMIT 2 [ RunTime:0.019381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59636185 ORDER BY `minOrder` ASC [ RunTime:0.023426s ]
select * from pdf where partno='FTSH-104-04-L-DV-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-A-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.036149s ]
SELECT `id` FROM `stock` WHERE `id` <> 59636185 AND `partno` = 'FTSH-104-04-L-DV-A-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11567830 [ RunTime:0.028365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59634310 LIMIT 5 [ RunTime:0.011460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59634310 ORDER BY `minOrder` ASC [ RunTime:0.080530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59634310 ORDER BY `unit` DESC [ RunTime:0.017917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59634310 LIMIT 2 [ RunTime:0.029411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59634310 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
select * from pdf where partno='FTSH-104-04-L-DH-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DH-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026808s ]
SELECT `id` FROM `stock` WHERE `id` <> 59634310 AND `partno` = 'FTSH-104-04-L-DH-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.071788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730160 [ RunTime:0.049052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59634056 LIMIT 5 [ RunTime:0.037220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59634056 ORDER BY `minOrder` ASC [ RunTime:0.038576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59634056 ORDER BY `unit` DESC [ RunTime:0.038786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59634056 LIMIT 2 [ RunTime:0.095581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59634056 ORDER BY `minOrder` ASC [ RunTime:0.011522s ]
select * from pdf where partno='FTSH-104-04-L-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.057204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028989s ]
SELECT `id` FROM `stock` WHERE `id` <> 59634056 AND `partno` = 'FTSH-104-04-L-DV-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.051333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59508991 LIMIT 5 [ RunTime:0.113333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508991 ORDER BY `minOrder` ASC [ RunTime:0.059531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59508991 ORDER BY `unit` DESC [ RunTime:0.017204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59508991 LIMIT 2 [ RunTime:0.032099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508991 ORDER BY `minOrder` ASC [ RunTime:0.006347s ]
select * from pdf where partno='FTSH-104-04-L-DV-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.068435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.050189s ]
SELECT `id` FROM `stock` WHERE `id` <> 59508991 AND `partno` = 'FTSH-104-04-L-DV-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.041501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16226753 [ RunTime:0.160944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59508594 LIMIT 5 [ RunTime:0.026950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508594 ORDER BY `minOrder` ASC [ RunTime:0.059216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59508594 ORDER BY `unit` DESC [ RunTime:0.096137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59508594 LIMIT 2 [ RunTime:0.041042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59508594 ORDER BY `minOrder` ASC [ RunTime:0.036767s ]
select * from pdf where partno='FTSH-104-04-L-DV-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.066393s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FTSH-104-04-L-DV-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008274s ]
SELECT `id` FROM `stock` WHERE `id` <> 59508594 AND `partno` = 'FTSH-104-04-L-DV-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.039180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15489725 [ RunTime:0.089849s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087677s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.217253s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.134990s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074912s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.170430s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084956s ]
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-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051028s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'FTSH-104-04-L-D%' OR `brand` LIKE 'FTSH-104-04-L-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.164665s ]