SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003862s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040473s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.034563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12654862 LIMIT 5 [ RunTime:0.069749s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12654862 ORDER BY `minOrder` ASC [ RunTime:0.040260s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12654862 ORDER BY `unit` DESC [ RunTime:0.028437s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12654862 LIMIT 2 [ RunTime:0.022196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12654862 ORDER BY `minOrder` ASC [ RunTime:0.044741s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534711 LIMIT 5 [ RunTime:0.039653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534711 ORDER BY `minOrder` ASC [ RunTime:0.033972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11534711 ORDER BY `unit` DESC [ RunTime:0.015015s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11534711 LIMIT 2 [ RunTime:0.034700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11534711 ORDER BY `minOrder` ASC [ RunTime:0.012498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533514 LIMIT 5 [ RunTime:0.013730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533514 ORDER BY `minOrder` ASC [ RunTime:0.024114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11533514 ORDER BY `unit` DESC [ RunTime:0.017784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11533514 LIMIT 2 [ RunTime:0.007542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533514 ORDER BY `minOrder` ASC [ RunTime:0.008138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11514737 LIMIT 5 [ RunTime:0.007335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11514737 ORDER BY `minOrder` ASC [ RunTime:0.005182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11514737 ORDER BY `unit` DESC [ RunTime:0.000552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11514737 LIMIT 2 [ RunTime:0.001679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11514737 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='SSM-111-L-DV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11511410 LIMIT 5 [ RunTime:0.001137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11511410 ORDER BY `minOrder` ASC [ RunTime:0.006160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11511410 ORDER BY `unit` DESC [ RunTime:0.002707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11511410 LIMIT 2 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11511410 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
select * from pdf where partno='SSM-111-L-DV-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11510697 LIMIT 5 [ RunTime:0.004538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11510697 ORDER BY `minOrder` ASC [ RunTime:0.009403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11510697 ORDER BY `unit` DESC [ RunTime:0.020897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11510697 LIMIT 2 [ RunTime:0.006209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11510697 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003727s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59844160 LIMIT 5 [ RunTime:0.002687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844160 ORDER BY `minOrder` ASC [ RunTime:0.007092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59844160 ORDER BY `unit` DESC [ RunTime:0.001689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59844160 LIMIT 2 [ RunTime:0.002942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59844160 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005783s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013606s ]
SELECT `id` FROM `stock` WHERE `id` <> 59844160 AND `partno` = 'SSM-111-L-DV-BE-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59842681 LIMIT 5 [ RunTime:0.008754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842681 ORDER BY `minOrder` ASC [ RunTime:0.002294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59842681 ORDER BY `unit` DESC [ RunTime:0.001557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59842681 LIMIT 2 [ RunTime:0.002425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59842681 ORDER BY `minOrder` ASC [ RunTime:0.006478s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005220s ]
SELECT `id` FROM `stock` WHERE `id` <> 59842681 AND `partno` = 'SSM-111-L-DV-BE-LC-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59840665 LIMIT 5 [ RunTime:0.002144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840665 ORDER BY `minOrder` ASC [ RunTime:0.010459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59840665 ORDER BY `unit` DESC [ RunTime:0.012237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59840665 LIMIT 2 [ RunTime:0.004419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59840665 ORDER BY `minOrder` ASC [ RunTime:0.004434s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008184s ]
SELECT `id` FROM `stock` WHERE `id` <> 59840665 AND `partno` = 'SSM-111-L-DV-BE-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59828609 LIMIT 5 [ RunTime:0.014886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59828609 ORDER BY `minOrder` ASC [ RunTime:0.002064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59828609 ORDER BY `unit` DESC [ RunTime:0.002788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59828609 LIMIT 2 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59828609 ORDER BY `minOrder` ASC [ RunTime:0.008051s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015879s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019218s ]
SELECT `id` FROM `stock` WHERE `id` <> 59828609 AND `partno` = 'SSM-111-L-DV-BE-LC-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59823780 LIMIT 5 [ RunTime:0.004284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823780 ORDER BY `minOrder` ASC [ RunTime:0.005456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59823780 ORDER BY `unit` DESC [ RunTime:0.014089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59823780 LIMIT 2 [ RunTime:0.020875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823780 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015477s ]
SELECT `id` FROM `stock` WHERE `id` <> 59823780 AND `partno` = 'SSM-111-L-DV-BE-LC-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59823330 LIMIT 5 [ RunTime:0.020144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823330 ORDER BY `minOrder` ASC [ RunTime:0.004569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59823330 ORDER BY `unit` DESC [ RunTime:0.000823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59823330 LIMIT 2 [ RunTime:0.003715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823330 ORDER BY `minOrder` ASC [ RunTime:0.002136s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001000s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001406s ]
SELECT `id` FROM `stock` WHERE `id` <> 59823330 AND `partno` = 'SSM-111-L-DV-BE-LC-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59817196 LIMIT 5 [ RunTime:0.009347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59817196 ORDER BY `minOrder` ASC [ RunTime:0.020415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59817196 ORDER BY `unit` DESC [ RunTime:0.026347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59817196 LIMIT 2 [ RunTime:0.006853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59817196 ORDER BY `minOrder` ASC [ RunTime:0.004832s ]
select * from pdf where partno='SSM-111-L-DV-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004425s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.008909s ]
SELECT `id` FROM `stock` WHERE `id` <> 59817196 AND `partno` = 'SSM-111-L-DV-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11534711 [ RunTime:0.035784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59813397 LIMIT 5 [ RunTime:0.028002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813397 ORDER BY `minOrder` ASC [ RunTime:0.023861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59813397 ORDER BY `unit` DESC [ RunTime:0.012345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59813397 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813397 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
select * from pdf where partno='SSM-111-L-DV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001496s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004638s ]
SELECT `id` FROM `stock` WHERE `id` <> 59813397 AND `partno` = 'SSM-111-L-DV-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533514 [ RunTime:0.005200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59766556 LIMIT 5 [ RunTime:0.014442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766556 ORDER BY `minOrder` ASC [ RunTime:0.010536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59766556 ORDER BY `unit` DESC [ RunTime:0.004390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59766556 LIMIT 2 [ RunTime:0.007692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59766556 ORDER BY `minOrder` ASC [ RunTime:0.003178s ]
select * from pdf where partno='SSM-111-L-DV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007082s ]
SELECT `id` FROM `stock` WHERE `id` <> 59766556 AND `partno` = 'SSM-111-L-DV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.033735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59764467 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764467 ORDER BY `minOrder` ASC [ RunTime:0.010358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59764467 ORDER BY `unit` DESC [ RunTime:0.006096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59764467 LIMIT 2 [ RunTime:0.002546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59764467 ORDER BY `minOrder` ASC [ RunTime:0.006167s ]
select * from pdf where partno='SSM-111-L-DV-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000434s ]
SELECT `id` FROM `stock` WHERE `id` <> 59764467 AND `partno` = 'SSM-111-L-DV-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762995 LIMIT 5 [ RunTime:0.006522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762995 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762995 ORDER BY `unit` DESC [ RunTime:0.006115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762995 LIMIT 2 [ RunTime:0.008322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762995 ORDER BY `minOrder` ASC [ RunTime:0.006894s ]
select * from pdf where partno='SSM-111-L-DV-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000928s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762995 AND `partno` = 'SSM-111-L-DV-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11514737 [ RunTime:0.003000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762295 LIMIT 5 [ RunTime:0.002290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762295 ORDER BY `minOrder` ASC [ RunTime:0.010373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762295 ORDER BY `unit` DESC [ RunTime:0.011329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762295 LIMIT 2 [ RunTime:0.001476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762295 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
select * from pdf where partno='SSM-111-L-DV-BE-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001106s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762295 AND `partno` = 'SSM-111-L-DV-BE-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12654862 [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762208 LIMIT 5 [ RunTime:0.000836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762208 ORDER BY `minOrder` ASC [ RunTime:0.004735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762208 ORDER BY `unit` DESC [ RunTime:0.000791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762208 LIMIT 2 [ RunTime:0.001623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762208 ORDER BY `minOrder` ASC [ RunTime:0.003467s ]
select * from pdf where partno='SSM-111-L-DV-BE-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005555s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762208 AND `partno` = 'SSM-111-L-DV-BE-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11511410 [ RunTime:0.010347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59762051 LIMIT 5 [ RunTime:0.003015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762051 ORDER BY `minOrder` ASC [ RunTime:0.002097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59762051 ORDER BY `unit` DESC [ RunTime:0.012586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59762051 LIMIT 2 [ RunTime:0.015951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59762051 ORDER BY `minOrder` ASC [ RunTime:0.001325s ]
select * from pdf where partno='SSM-111-L-DV-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004248s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-111-L-DV-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013475s ]
SELECT `id` FROM `stock` WHERE `id` <> 59762051 AND `partno` = 'SSM-111-L-DV-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11510697 [ RunTime:0.006594s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006428s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005154s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009080s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010222s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006942s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003736s ]
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 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014771s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-111-L-DV-BE%' OR `brand` LIKE 'SSM-111-L-DV-BE%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013871s ]