SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001750s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004394s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005954s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016317s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086429 LIMIT 5 [ RunTime:0.025745s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086429 ORDER BY `minOrder` ASC [ RunTime:0.032934s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086429 ORDER BY `unit` DESC [ RunTime:0.015813s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086429 LIMIT 2 [ RunTime:0.059260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086429 ORDER BY `minOrder` ASC [ RunTime:0.027692s ]
select * from pdf where partno='40-911-160-psi/kPa-SSFF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.060425s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kPa-SSFF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032949s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086429 AND `partno` = '40-911-160-psi/kPa-SSFF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.051119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086428 LIMIT 5 [ RunTime:0.018483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086428 ORDER BY `minOrder` ASC [ RunTime:0.055575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086428 ORDER BY `unit` DESC [ RunTime:0.064407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086428 LIMIT 2 [ RunTime:0.060435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086428 ORDER BY `minOrder` ASC [ RunTime:0.034857s ]
select * from pdf where partno='40-911-160-psi/bar-SSFF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.031106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/bar-SSFF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.067339s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086428 AND `partno` = '40-911-160-psi/bar-SSFF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.098348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086427 LIMIT 5 [ RunTime:0.071964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086427 ORDER BY `minOrder` ASC [ RunTime:0.065296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086427 ORDER BY `unit` DESC [ RunTime:0.074606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086427 LIMIT 2 [ RunTime:0.086242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086427 ORDER BY `minOrder` ASC [ RunTime:0.033109s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-SSFF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.046916s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-SSFF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019340s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086427 AND `partno` = '40-911-160-psi/kg/cm2-SSFF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.030002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086426 LIMIT 5 [ RunTime:0.045409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086426 ORDER BY `minOrder` ASC [ RunTime:0.075596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086426 ORDER BY `unit` DESC [ RunTime:0.012189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086426 LIMIT 2 [ RunTime:0.027622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086426 ORDER BY `minOrder` ASC [ RunTime:0.050272s ]
select * from pdf where partno='40-911-160-psi-SSFF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi-SSFF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008012s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086426 AND `partno` = '40-911-160-psi-SSFF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.025655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086325 LIMIT 5 [ RunTime:0.007518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086325 ORDER BY `minOrder` ASC [ RunTime:0.016015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086325 ORDER BY `unit` DESC [ RunTime:0.016828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086325 LIMIT 2 [ RunTime:0.026653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086325 ORDER BY `minOrder` ASC [ RunTime:0.008510s ]
select * from pdf where partno='40-911-160-psi/kPa-SSFF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kPa-SSFF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016837s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086325 AND `partno` = '40-911-160-psi/kPa-SSFF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.036849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086324 LIMIT 5 [ RunTime:0.003646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086324 ORDER BY `minOrder` ASC [ RunTime:0.029931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086324 ORDER BY `unit` DESC [ RunTime:0.010548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086324 LIMIT 2 [ RunTime:0.000879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086324 ORDER BY `minOrder` ASC [ RunTime:0.000239s ]
select * from pdf where partno='40-911-160-psi/bar-SSFF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/bar-SSFF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024008s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086324 AND `partno` = '40-911-160-psi/bar-SSFF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.030984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086323 LIMIT 5 [ RunTime:0.056171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086323 ORDER BY `minOrder` ASC [ RunTime:0.019333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086323 ORDER BY `unit` DESC [ RunTime:0.017024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086323 LIMIT 2 [ RunTime:0.028085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086323 ORDER BY `minOrder` ASC [ RunTime:0.010434s ]
select * from pdf where partno='40-911-160-psi-SSFF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.015198s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi-SSFF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016514s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086323 AND `partno` = '40-911-160-psi-SSFF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.027473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086322 LIMIT 5 [ RunTime:0.052286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086322 ORDER BY `minOrder` ASC [ RunTime:0.016742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086322 ORDER BY `unit` DESC [ RunTime:0.021215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086322 LIMIT 2 [ RunTime:0.012487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086322 ORDER BY `minOrder` ASC [ RunTime:0.019273s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-SSFF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.012932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-SSFF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027449s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086322 AND `partno` = '40-911-160-psi/kg/cm2-SSFF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.042101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085266 LIMIT 5 [ RunTime:0.008409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085266 ORDER BY `minOrder` ASC [ RunTime:0.005174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085266 ORDER BY `unit` DESC [ RunTime:0.001065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085266 LIMIT 2 [ RunTime:0.013197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085266 ORDER BY `minOrder` ASC [ RunTime:0.008132s ]
select * from pdf where partno='40-911-160-psi-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009747s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085266 AND `partno` = '40-911-160-psi-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003602s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085265 LIMIT 5 [ RunTime:0.000461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085265 ORDER BY `minOrder` ASC [ RunTime:0.001556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085265 ORDER BY `unit` DESC [ RunTime:0.003982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085265 LIMIT 2 [ RunTime:0.007152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085265 ORDER BY `minOrder` ASC [ RunTime:0.001420s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.009441s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002755s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085265 AND `partno` = '40-911-160-psi/kg/cm2-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085264 LIMIT 5 [ RunTime:0.006664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085264 ORDER BY `minOrder` ASC [ RunTime:0.039654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085264 ORDER BY `unit` DESC [ RunTime:0.021055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085264 LIMIT 2 [ RunTime:0.052289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085264 ORDER BY `minOrder` ASC [ RunTime:0.018510s ]
select * from pdf where partno='40-911-160-psi/bar-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.016911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/bar-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005349s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085264 AND `partno` = '40-911-160-psi/bar-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.040594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085263 LIMIT 5 [ RunTime:0.005269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085263 ORDER BY `minOrder` ASC [ RunTime:0.005939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085263 ORDER BY `unit` DESC [ RunTime:0.020240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085263 LIMIT 2 [ RunTime:0.053272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085263 ORDER BY `minOrder` ASC [ RunTime:0.013560s ]
select * from pdf where partno='40-911-160-psi/kPa-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013139s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kPa-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016566s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085263 AND `partno` = '40-911-160-psi/kPa-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.028239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085245 LIMIT 5 [ RunTime:0.031983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085245 ORDER BY `minOrder` ASC [ RunTime:0.035071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085245 ORDER BY `unit` DESC [ RunTime:0.029810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085245 LIMIT 2 [ RunTime:0.019819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085245 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
select * from pdf where partno='40-911-160-psi/kPa-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.035389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kPa-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.069187s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085245 AND `partno` = '40-911-160-psi/kPa-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.042738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085244 LIMIT 5 [ RunTime:0.021217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085244 ORDER BY `minOrder` ASC [ RunTime:0.045019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085244 ORDER BY `unit` DESC [ RunTime:0.057594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085244 LIMIT 2 [ RunTime:0.042546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085244 ORDER BY `minOrder` ASC [ RunTime:0.029887s ]
select * from pdf where partno='40-911-160-psi-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.034534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027775s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085244 AND `partno` = '40-911-160-psi-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.055045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085243 LIMIT 5 [ RunTime:0.020164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085243 ORDER BY `minOrder` ASC [ RunTime:0.025390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085243 ORDER BY `unit` DESC [ RunTime:0.003039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085243 LIMIT 2 [ RunTime:0.004738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085243 ORDER BY `minOrder` ASC [ RunTime:0.004742s ]
select * from pdf where partno='40-911-160-psi/bar-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/bar-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024165s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085243 AND `partno` = '40-911-160-psi/bar-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085242 LIMIT 5 [ RunTime:0.003596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085242 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085242 ORDER BY `unit` DESC [ RunTime:0.008990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085242 LIMIT 2 [ RunTime:0.015309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085242 ORDER BY `minOrder` ASC [ RunTime:0.001183s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006994s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007617s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085242 AND `partno` = '40-911-160-psi/kg/cm2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.008909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084884 LIMIT 5 [ RunTime:0.013108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084884 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084884 ORDER BY `unit` DESC [ RunTime:0.004840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084884 LIMIT 2 [ RunTime:0.004775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084884 ORDER BY `minOrder` ASC [ RunTime:0.001952s ]
select * from pdf where partno='40-911-160-psi/bar-SSFF-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005145s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/bar-SSFF-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000853s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084884 AND `partno` = '40-911-160-psi/bar-SSFF-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084883 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084883 ORDER BY `minOrder` ASC [ RunTime:0.006780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084883 ORDER BY `unit` DESC [ RunTime:0.016921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084883 LIMIT 2 [ RunTime:0.000504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084883 ORDER BY `minOrder` ASC [ RunTime:0.007769s ]
select * from pdf where partno='40-911-160-psi/kPa-SSFF-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kPa-SSFF-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001539s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084883 AND `partno` = '40-911-160-psi/kPa-SSFF-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084882 LIMIT 5 [ RunTime:0.001256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084882 ORDER BY `minOrder` ASC [ RunTime:0.002424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084882 ORDER BY `unit` DESC [ RunTime:0.008764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084882 LIMIT 2 [ RunTime:0.013052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084882 ORDER BY `minOrder` ASC [ RunTime:0.013515s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-SSFF-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008765s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-SSFF-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002127s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084882 AND `partno` = '40-911-160-psi/kg/cm2-SSFF-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.007196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084842 LIMIT 5 [ RunTime:0.006608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084842 ORDER BY `minOrder` ASC [ RunTime:0.005145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084842 ORDER BY `unit` DESC [ RunTime:0.015419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084842 LIMIT 2 [ RunTime:0.005360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084842 ORDER BY `minOrder` ASC [ RunTime:0.002804s ]
select * from pdf where partno='40-911-160-psi/kg/cm2-SSFF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-160-psi/kg/cm2-SSFF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016756s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084842 AND `partno` = '40-911-160-psi/kg/cm2-SSFF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015792s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005150s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017100s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012774s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014897s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022387s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010894s ]
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 '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006809s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-911-160-psi%' OR `brand` LIKE '40-911-160-psi%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.011636s ]