SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001575s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011876s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060801s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031876s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086727 LIMIT 5 [ RunTime:0.039444s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086727 ORDER BY `minOrder` ASC [ RunTime:0.032183s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086727 ORDER BY `unit` DESC [ RunTime:0.039456s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.010912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086727 LIMIT 2 [ RunTime:0.089761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086727 ORDER BY `minOrder` ASC [ RunTime:0.017473s ]
select * from pdf where partno='25-901-10000-psi/kPa-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.035344s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037188s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086727 AND `partno` = '25-901-10000-psi/kPa-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.041590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086659 LIMIT 5 [ RunTime:0.046775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086659 ORDER BY `minOrder` ASC [ RunTime:0.052579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086659 ORDER BY `unit` DESC [ RunTime:0.016310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086659 LIMIT 2 [ RunTime:0.037721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086659 ORDER BY `minOrder` ASC [ RunTime:0.028628s ]
select * from pdf where partno='25-901-10000-psi/kPa-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.046806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.082737s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086659 AND `partno` = '25-901-10000-psi/kPa-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.034012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086398 LIMIT 5 [ RunTime:0.021666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086398 ORDER BY `minOrder` ASC [ RunTime:0.051970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086398 ORDER BY `unit` DESC [ RunTime:0.113208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086398 LIMIT 2 [ RunTime:0.048258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086398 ORDER BY `minOrder` ASC [ RunTime:0.036090s ]
select * from pdf where partno='25-901-10000-psi/kPa-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.108655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047997s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086398 AND `partno` = '25-901-10000-psi/kPa-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.075726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086254 LIMIT 5 [ RunTime:0.067836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086254 ORDER BY `minOrder` ASC [ RunTime:0.045057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086254 ORDER BY `unit` DESC [ RunTime:0.016590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086254 LIMIT 2 [ RunTime:0.025599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086254 ORDER BY `minOrder` ASC [ RunTime:0.022618s ]
select * from pdf where partno='25-901-10000-psi/kPa-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.054351s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056087s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086254 AND `partno` = '25-901-10000-psi/kPa-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.027909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086228 LIMIT 5 [ RunTime:0.015225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086228 ORDER BY `minOrder` ASC [ RunTime:0.099951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086228 ORDER BY `unit` DESC [ RunTime:0.042259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086228 LIMIT 2 [ RunTime:0.062926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086228 ORDER BY `minOrder` ASC [ RunTime:0.019647s ]
select * from pdf where partno='25-901-10000-psi/kPa-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.036578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034398s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086228 AND `partno` = '25-901-10000-psi/kPa-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.110731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086097 LIMIT 5 [ RunTime:0.031109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086097 ORDER BY `minOrder` ASC [ RunTime:0.055055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086097 ORDER BY `unit` DESC [ RunTime:0.029451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086097 LIMIT 2 [ RunTime:0.047185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086097 ORDER BY `minOrder` ASC [ RunTime:0.044211s ]
select * from pdf where partno='25-901-10000-psi/kPa-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.048661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.042508s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086097 AND `partno` = '25-901-10000-psi/kPa-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.023222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084639 LIMIT 5 [ RunTime:0.027244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084639 ORDER BY `minOrder` ASC [ RunTime:0.025821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084639 ORDER BY `unit` DESC [ RunTime:0.044504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084639 LIMIT 2 [ RunTime:0.042103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084639 ORDER BY `minOrder` ASC [ RunTime:0.009480s ]
select * from pdf where partno='25-901-10000-psi/kPa-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.033054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.053046s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084639 AND `partno` = '25-901-10000-psi/kPa-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.088330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084011 LIMIT 5 [ RunTime:0.022456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084011 ORDER BY `minOrder` ASC [ RunTime:0.046611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084011 ORDER BY `unit` DESC [ RunTime:0.020431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084011 LIMIT 2 [ RunTime:0.034655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084011 ORDER BY `minOrder` ASC [ RunTime:0.025130s ]
select * from pdf where partno='25-901-10000-psi/kPa-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.033830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024384s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084011 AND `partno` = '25-901-10000-psi/kPa-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.029670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083878 LIMIT 5 [ RunTime:0.051947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083878 ORDER BY `minOrder` ASC [ RunTime:0.080288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083878 ORDER BY `unit` DESC [ RunTime:0.050048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083878 LIMIT 2 [ RunTime:0.072396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083878 ORDER BY `minOrder` ASC [ RunTime:0.027834s ]
select * from pdf where partno='25-901-10000-psi/kPa-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.083543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.065354s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083878 AND `partno` = '25-901-10000-psi/kPa-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.107030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083574 LIMIT 5 [ RunTime:0.019799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083574 ORDER BY `minOrder` ASC [ RunTime:0.058155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083574 ORDER BY `unit` DESC [ RunTime:0.047218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083574 LIMIT 2 [ RunTime:0.055412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083574 ORDER BY `minOrder` ASC [ RunTime:0.012826s ]
select * from pdf where partno='25-901-10000-psi/kPa-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.048365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.068061s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083574 AND `partno` = '25-901-10000-psi/kPa-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.055019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083413 LIMIT 5 [ RunTime:0.032366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083413 ORDER BY `minOrder` ASC [ RunTime:0.074508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083413 ORDER BY `unit` DESC [ RunTime:0.056059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083413 LIMIT 2 [ RunTime:0.078449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083413 ORDER BY `minOrder` ASC [ RunTime:0.020566s ]
select * from pdf where partno='25-901-10000-psi/kPa-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.049921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023856s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083413 AND `partno` = '25-901-10000-psi/kPa-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.080247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083377 LIMIT 5 [ RunTime:0.022199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083377 ORDER BY `minOrder` ASC [ RunTime:0.039273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083377 ORDER BY `unit` DESC [ RunTime:0.041041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083377 LIMIT 2 [ RunTime:0.107723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083377 ORDER BY `minOrder` ASC [ RunTime:0.030744s ]
select * from pdf where partno='25-901-10000-psi/kPa-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.025384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.083738s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083377 AND `partno` = '25-901-10000-psi/kPa-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.025485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083371 LIMIT 5 [ RunTime:0.075093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083371 ORDER BY `minOrder` ASC [ RunTime:0.075928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083371 ORDER BY `unit` DESC [ RunTime:0.038060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083371 LIMIT 2 [ RunTime:0.007512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083371 ORDER BY `minOrder` ASC [ RunTime:0.024881s ]
select * from pdf where partno='25-901-10000-psi/kPa-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.045687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039530s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083371 AND `partno` = '25-901-10000-psi/kPa-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.022310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64083219 LIMIT 5 [ RunTime:0.009863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083219 ORDER BY `minOrder` ASC [ RunTime:0.057545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64083219 ORDER BY `unit` DESC [ RunTime:0.007616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64083219 LIMIT 2 [ RunTime:0.081123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64083219 ORDER BY `minOrder` ASC [ RunTime:0.020383s ]
select * from pdf where partno='25-901-10000-psi/kPa' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.075234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035621s ]
SELECT `id` FROM `stock` WHERE `id` <> 64083219 AND `partno` = '25-901-10000-psi/kPa' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.048898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64086760 LIMIT 5 [ RunTime:0.067520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086760 ORDER BY `minOrder` ASC [ RunTime:0.041449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64086760 ORDER BY `unit` DESC [ RunTime:0.024251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64086760 LIMIT 2 [ RunTime:0.028730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64086760 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
select * from pdf where partno='25-901-10000-psi/kPa-DRY-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-DRY-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022349s ]
SELECT `id` FROM `stock` WHERE `id` <> 64086760 AND `partno` = '25-901-10000-psi/kPa-DRY-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085197 LIMIT 5 [ RunTime:0.018178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085197 ORDER BY `minOrder` ASC [ RunTime:0.025976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085197 ORDER BY `unit` DESC [ RunTime:0.015535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085197 LIMIT 2 [ RunTime:0.015938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085197 ORDER BY `minOrder` ASC [ RunTime:0.012424s ]
select * from pdf where partno='25-901-10000-psi/kPa-DRY-RCP-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.015005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-DRY-RCP-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034479s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085197 AND `partno` = '25-901-10000-psi/kPa-DRY-RCP-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.012460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64085045 LIMIT 5 [ RunTime:0.015798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085045 ORDER BY `minOrder` ASC [ RunTime:0.008647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64085045 ORDER BY `unit` DESC [ RunTime:0.024114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64085045 LIMIT 2 [ RunTime:0.030542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64085045 ORDER BY `minOrder` ASC [ RunTime:0.008860s ]
select * from pdf where partno='25-901-10000-psi/kPa-DRY-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-DRY-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009935s ]
SELECT `id` FROM `stock` WHERE `id` <> 64085045 AND `partno` = '25-901-10000-psi/kPa-DRY-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084721 LIMIT 5 [ RunTime:0.008583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084721 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084721 ORDER BY `unit` DESC [ RunTime:0.000914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084721 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084721 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
select * from pdf where partno='25-901-10000-psi/kPa-DRY-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-DRY-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006154s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084721 AND `partno` = '25-901-10000-psi/kPa-DRY-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64084090 LIMIT 5 [ RunTime:0.015378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084090 ORDER BY `minOrder` ASC [ RunTime:0.009310s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64084090 ORDER BY `unit` DESC [ RunTime:0.030796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64084090 LIMIT 2 [ RunTime:0.006225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64084090 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='25-901-10000-psi/kPa-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002055s ]
SELECT `id` FROM `stock` WHERE `id` <> 64084090 AND `partno` = '25-901-10000-psi/kPa-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57279252 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279252 ORDER BY `minOrder` ASC [ RunTime:0.010160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57279252 ORDER BY `unit` DESC [ RunTime:0.008237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57279252 LIMIT 2 [ RunTime:0.006120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279252 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='25-901-10000-psi/kPa-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.004222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-10000-psi/kPa-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005843s ]
SELECT `id` FROM `stock` WHERE `id` <> 57279252 AND `partno` = '25-901-10000-psi/kPa-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001903s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009372s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001879s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015877s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018600s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009344s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005051s ]
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 '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001604s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-901-10000-psi/kPa%' OR `brand` LIKE '25-901-10000-psi/kPa%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010756s ]