SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001676s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005543s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859552 LIMIT 5 [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859552 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859552 ORDER BY `unit` DESC [ RunTime:0.003856s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.030566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859552 LIMIT 2 [ RunTime:0.013581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859552 ORDER BY `minOrder` ASC [ RunTime:0.017170s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017673s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64090044 LIMIT 5 [ RunTime:0.023948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64090044 ORDER BY `minOrder` ASC [ RunTime:0.028428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64090044 ORDER BY `unit` DESC [ RunTime:0.169649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64090044 LIMIT 2 [ RunTime:0.007200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64090044 ORDER BY `minOrder` ASC [ RunTime:0.043273s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-MIP-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.048611s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-MIP-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.050872s ]
SELECT `id` FROM `stock` WHERE `id` <> 64090044 AND `partno` = '40-911-15-psi/kPa-SSFF-MIP-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.058459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64090040 LIMIT 5 [ RunTime:0.053841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64090040 ORDER BY `minOrder` ASC [ RunTime:0.055065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64090040 ORDER BY `unit` DESC [ RunTime:0.049345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64090040 LIMIT 2 [ RunTime:0.035094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64090040 ORDER BY `minOrder` ASC [ RunTime:0.009096s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.035660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030442s ]
SELECT `id` FROM `stock` WHERE `id` <> 64090040 AND `partno` = '40-911-15-psi/kPa-SSFF-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.052899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089755 LIMIT 5 [ RunTime:0.015421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089755 ORDER BY `minOrder` ASC [ RunTime:0.048274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089755 ORDER BY `unit` DESC [ RunTime:0.010855s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089755 LIMIT 2 [ RunTime:0.006334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089755 ORDER BY `minOrder` ASC [ RunTime:0.022823s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.011121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022759s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089755 AND `partno` = '40-911-15-psi/kPa-SSFF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089715 LIMIT 5 [ RunTime:0.024538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089715 ORDER BY `minOrder` ASC [ RunTime:0.044994s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089715 ORDER BY `unit` DESC [ RunTime:0.017143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089715 LIMIT 2 [ RunTime:0.022758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089715 ORDER BY `minOrder` ASC [ RunTime:0.031272s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.008396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004130s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089715 AND `partno` = '40-911-15-psi/kPa-SSFF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.025638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089410 LIMIT 5 [ RunTime:0.027691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089410 ORDER BY `minOrder` ASC [ RunTime:0.007974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089410 ORDER BY `unit` DESC [ RunTime:0.012862s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089410 LIMIT 2 [ RunTime:0.003174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089410 ORDER BY `minOrder` ASC [ RunTime:0.007852s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-MIP-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-MIP-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009028s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089410 AND `partno` = '40-911-15-psi/kPa-SSFF-MIP-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089407 LIMIT 5 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089407 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089407 ORDER BY `unit` DESC [ RunTime:0.002780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089407 LIMIT 2 [ RunTime:0.001147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089407 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002938s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089407 AND `partno` = '40-911-15-psi/kPa-SSFF-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089071 LIMIT 5 [ RunTime:0.001212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089071 ORDER BY `minOrder` ASC [ RunTime:0.005544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089071 ORDER BY `unit` DESC [ RunTime:0.001465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089071 LIMIT 2 [ RunTime:0.004225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089071 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002855s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089071 AND `partno` = '40-911-15-psi/kPa-SSFF-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089025 LIMIT 5 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089025 ORDER BY `minOrder` ASC [ RunTime:0.002041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089025 ORDER BY `unit` DESC [ RunTime:0.000542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089025 LIMIT 2 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089025 ORDER BY `minOrder` ASC [ RunTime:0.003399s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.000957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002417s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089025 AND `partno` = '40-911-15-psi/kPa-SSFF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089019 LIMIT 5 [ RunTime:0.001479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089019 ORDER BY `minOrder` ASC [ RunTime:0.003217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089019 ORDER BY `unit` DESC [ RunTime:0.001339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089019 LIMIT 2 [ RunTime:0.003891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089019 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001194s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005742s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089019 AND `partno` = '40-911-15-psi/kPa-SSFF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089017 LIMIT 5 [ RunTime:0.004929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089017 ORDER BY `minOrder` ASC [ RunTime:0.003798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089017 ORDER BY `unit` DESC [ RunTime:0.011463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089017 LIMIT 2 [ RunTime:0.008350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089017 ORDER BY `minOrder` ASC [ RunTime:0.000932s ]
select * from pdf where partno='40-911-15-psi/kPa-SSFF-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002595s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-15-psi/kPa-SSFF-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020620s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089017 AND `partno` = '40-911-15-psi/kPa-SSFF-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.001107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859552 [ RunTime:0.009947s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007735s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007667s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008048s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024748s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011892s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030314s ]
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-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017589s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-911-15-psi/kPa-SSFF%' OR `brand` LIKE '40-911-15-psi/kPa-SSFF%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003146s ]