SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002279s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042143s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859605 LIMIT 5 [ RunTime:0.026844s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.019271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859605 ORDER BY `minOrder` ASC [ RunTime:0.014219s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002463s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859605 ORDER BY `unit` DESC [ RunTime:0.028944s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859605 LIMIT 2 [ RunTime:0.015412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859605 ORDER BY `minOrder` ASC [ RunTime:0.013304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859576 LIMIT 5 [ RunTime:0.033322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859576 ORDER BY `minOrder` ASC [ RunTime:0.002585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859576 ORDER BY `unit` DESC [ RunTime:0.009492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859576 LIMIT 2 [ RunTime:0.042629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859576 ORDER BY `minOrder` ASC [ RunTime:0.009707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026000 LIMIT 5 [ RunTime:0.041813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026000 ORDER BY `minOrder` ASC [ RunTime:0.061153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17026000 ORDER BY `unit` DESC [ RunTime:0.006818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17026000 LIMIT 2 [ RunTime:0.021800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17026000 ORDER BY `minOrder` ASC [ RunTime:0.022881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025985 LIMIT 5 [ RunTime:0.041300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025985 ORDER BY `minOrder` ASC [ RunTime:0.061296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025985 ORDER BY `unit` DESC [ RunTime:0.022520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025985 LIMIT 2 [ RunTime:0.092722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025985 ORDER BY `minOrder` ASC [ RunTime:0.030325s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.092320s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063141s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475996 LIMIT 5 [ RunTime:0.036482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475996 ORDER BY `minOrder` ASC [ RunTime:0.093009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475996 ORDER BY `unit` DESC [ RunTime:0.078151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475996 LIMIT 2 [ RunTime:0.033215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475996 ORDER BY `minOrder` ASC [ RunTime:0.003571s ]
select * from pdf where partno='40-911-5000-psi/kg/cm2-SSRF-BT8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.050562s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-5000-psi/kg/cm2-SSRF-BT8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.035589s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475996 AND `partno` = '40-911-5000-psi/kg/cm2-SSRF-BT8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.097049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17026000 [ RunTime:0.035125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475953 LIMIT 5 [ RunTime:0.050172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475953 ORDER BY `minOrder` ASC [ RunTime:0.025995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475953 ORDER BY `unit` DESC [ RunTime:0.007677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475953 LIMIT 2 [ RunTime:0.015438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475953 ORDER BY `minOrder` ASC [ RunTime:0.022444s ]
select * from pdf where partno='40-911-5000-psi/kg/cm2-SSRF-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.033161s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-5000-psi/kg/cm2-SSRF-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.040471s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475953 AND `partno` = '40-911-5000-psi/kg/cm2-SSRF-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.037180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025985 [ RunTime:0.017490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475065 LIMIT 5 [ RunTime:0.012364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475065 ORDER BY `minOrder` ASC [ RunTime:0.018541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475065 ORDER BY `unit` DESC [ RunTime:0.021449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475065 LIMIT 2 [ RunTime:0.016782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475065 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='40-911-5000-psi/kg/cm2-SSRF-BT8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013977s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-5000-psi/kg/cm2-SSRF-BT8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006830s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475065 AND `partno` = '40-911-5000-psi/kg/cm2-SSRF-BT8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.037252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859605 [ RunTime:0.003418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37475037 LIMIT 5 [ RunTime:0.012938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475037 ORDER BY `minOrder` ASC [ RunTime:0.006958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37475037 ORDER BY `unit` DESC [ RunTime:0.012445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37475037 LIMIT 2 [ RunTime:0.026711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37475037 ORDER BY `minOrder` ASC [ RunTime:0.008026s ]
select * from pdf where partno='40-911-5000-psi/kg/cm2-SSRF' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '40-911-5000-psi/kg/cm2-SSRF' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.013614s ]
SELECT `id` FROM `stock` WHERE `id` <> 37475037 AND `partno` = '40-911-5000-psi/kg/cm2-SSRF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859576 [ RunTime:0.002691s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039297s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039214s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063087s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061370s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022578s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033156s ]
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-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054522s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '40-911-5000-psi/kg/cm2-SSRF%' OR `brand` LIKE '40-911-5000-psi/kg/cm2-SSRF%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.085706s ]