SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001261s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002698s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003679s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237060 LIMIT 5 [ RunTime:0.001737s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.014003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237060 ORDER BY `minOrder` ASC [ RunTime:0.008720s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237060 ORDER BY `unit` DESC [ RunTime:0.007806s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237060 LIMIT 2 [ RunTime:0.007608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237060 ORDER BY `minOrder` ASC [ RunTime:0.020605s ]
select * from pdf where partno='nhd-4.0-480480af-asxp-ctp' and brandshort='newhaven display' limit 1 [ RunTime:0.027190s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001293s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'nhd-4.0-480480af-asxp-ctp' OR `brand` LIKE 'newhaven display%' ) ) LIMIT 1 [ RunTime:0.030209s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237060 AND `partno` = 'nhd-4.0-480480af-asxp-ctp' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display%' ) [ RunTime:0.022235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133732 [ RunTime:0.012755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237057 LIMIT 5 [ RunTime:0.009645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237057 ORDER BY `minOrder` ASC [ RunTime:0.016265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237057 ORDER BY `unit` DESC [ RunTime:0.005937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237057 LIMIT 2 [ RunTime:0.019613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237057 ORDER BY `minOrder` ASC [ RunTime:0.010566s ]
select * from pdf where partno='nhd-4.0-480480af-asxp-t' and brandshort='newhaven display' limit 1 [ RunTime:0.015935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'nhd-4.0-480480af-asxp-t' OR `brand` LIKE 'newhaven display%' ) ) LIMIT 1 [ RunTime:0.023776s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237057 AND `partno` = 'nhd-4.0-480480af-asxp-t' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display%' ) [ RunTime:0.015525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133716 [ RunTime:0.022681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237056 LIMIT 5 [ RunTime:0.006102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237056 ORDER BY `minOrder` ASC [ RunTime:0.019964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237056 ORDER BY `unit` DESC [ RunTime:0.039477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237056 LIMIT 2 [ RunTime:0.013666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237056 ORDER BY `minOrder` ASC [ RunTime:0.016275s ]
select * from pdf where partno='nhd-4.0-480480af-asxp' and brandshort='newhaven display' limit 1 [ RunTime:0.019565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'nhd-4.0-480480af-asxp' OR `brand` LIKE 'newhaven display%' ) ) LIMIT 1 [ RunTime:0.024285s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237056 AND `partno` = 'nhd-4.0-480480af-asxp' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display%' ) [ RunTime:0.016776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133703 [ RunTime:0.020851s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133716 LIMIT 5 [ RunTime:0.014912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133716 ORDER BY `minOrder` ASC [ RunTime:0.012072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133716 ORDER BY `unit` DESC [ RunTime:0.013992s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133716 LIMIT 2 [ RunTime:0.020554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133716 ORDER BY `minOrder` ASC [ RunTime:0.013238s ]
select * from pdf where partno='NHD-4.0-480480AF-ASXP-T' and brandshort='Newhaven Display Intl' limit 1 [ RunTime:0.011253s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NHD-4.0-480480AF-ASXP-T' OR `brand` LIKE 'Newhaven Display Intl%' ) ) LIMIT 1 [ RunTime:0.015105s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133716 AND `partno` = 'NHD-4.0-480480AF-ASXP-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display intl%' ) [ RunTime:0.017938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133732 LIMIT 5 [ RunTime:0.006263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133732 ORDER BY `minOrder` ASC [ RunTime:0.018934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133732 ORDER BY `unit` DESC [ RunTime:0.013442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133732 LIMIT 2 [ RunTime:0.029776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133732 ORDER BY `minOrder` ASC [ RunTime:0.023006s ]
select * from pdf where partno='NHD-4.0-480480AF-ASXP-CTP' and brandshort='Newhaven Display Intl' limit 1 [ RunTime:0.002328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NHD-4.0-480480AF-ASXP-CTP' OR `brand` LIKE 'Newhaven Display Intl%' ) ) LIMIT 1 [ RunTime:0.008235s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133732 AND `partno` = 'NHD-4.0-480480AF-ASXP-CTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display intl%' ) [ RunTime:0.001083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133703 LIMIT 5 [ RunTime:0.008839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133703 ORDER BY `minOrder` ASC [ RunTime:0.003070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133703 ORDER BY `unit` DESC [ RunTime:0.014344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133703 LIMIT 2 [ RunTime:0.017004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133703 ORDER BY `minOrder` ASC [ RunTime:0.002074s ]
select * from pdf where partno='NHD-4.0-480480AF-ASXP' and brandshort='Newhaven Display Intl' limit 1 [ RunTime:0.003519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'NHD-4.0-480480AF-ASXP' OR `brand` LIKE 'Newhaven Display Intl%' ) ) LIMIT 1 [ RunTime:0.003982s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133703 AND `partno` = 'NHD-4.0-480480AF-ASXP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%newhaven display intl%' ) [ RunTime:0.001696s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001783s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002768s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003398s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006584s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001370s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001928s ]
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 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004305s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'nhd-4.0-480480af-asxp%' OR `brand` LIKE 'nhd-4.0-480480af-asxp%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001199s ]