SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001530s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051480s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14168877 LIMIT 5 [ RunTime:0.040089s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14168877 ORDER BY `minOrder` ASC [ RunTime:0.061548s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14168877 ORDER BY `unit` DESC [ RunTime:0.054451s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14168877 LIMIT 2 [ RunTime:0.060501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14168877 ORDER BY `minOrder` ASC [ RunTime:0.036971s ]
select * from pdf where partno='109R0624G401' and brandshort='Sanyo Denki America Inc.' limit 1 [ RunTime:0.072930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596793 LIMIT 5 [ RunTime:0.048382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596793 ORDER BY `minOrder` ASC [ RunTime:0.046596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18596793 ORDER BY `unit` DESC [ RunTime:0.014288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18596793 LIMIT 2 [ RunTime:0.052814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18596793 ORDER BY `minOrder` ASC [ RunTime:0.053472s ]
select * from pdf where partno='109R0624G4011' and brandshort='Sanyo Denki America Inc.' limit 1 [ RunTime:0.041096s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32286515 LIMIT 5 [ RunTime:0.067690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32286515 ORDER BY `minOrder` ASC [ RunTime:0.037822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32286515 ORDER BY `unit` DESC [ RunTime:0.017686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32286515 LIMIT 2 [ RunTime:0.053038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32286515 ORDER BY `minOrder` ASC [ RunTime:0.036788s ]
select * from pdf where partno='109r0624g4011' and brandshort='sanyo denki' limit 1 [ RunTime:0.016112s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109r0624g4011' OR `brand` LIKE 'sanyo denki%' ) ) LIMIT 1 [ RunTime:0.028323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32177297 LIMIT 5 [ RunTime:0.049135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32177297 ORDER BY `minOrder` ASC [ RunTime:0.059095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32177297 ORDER BY `unit` DESC [ RunTime:0.031198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32177297 LIMIT 2 [ RunTime:0.019787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32177297 ORDER BY `minOrder` ASC [ RunTime:0.027475s ]
select * from pdf where partno='109r0624g4011' and brandshort='sanyo denki' limit 1 [ RunTime:0.016406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109r0624g4011' OR `brand` LIKE 'sanyo denki%' ) ) LIMIT 1 [ RunTime:0.000565s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58478798 LIMIT 5 [ RunTime:0.010767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478798 ORDER BY `minOrder` ASC [ RunTime:0.003716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58478798 ORDER BY `unit` DESC [ RunTime:0.017022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58478798 LIMIT 2 [ RunTime:0.030286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58478798 ORDER BY `minOrder` ASC [ RunTime:0.019852s ]
select * from pdf where partno='109R0624G401' and brandshort='Sanyo Denki America Inc.' limit 1 [ RunTime:0.005687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109R0624G401' OR `brand` LIKE 'Sanyo Denki America Inc.%' ) ) LIMIT 1 [ RunTime:0.017205s ]
SELECT `id` FROM `stock` WHERE `id` <> 58478798 AND `partno` = '109R0624G401' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sanyo denki america inc.%' ) [ RunTime:0.016584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14168877 [ RunTime:0.032851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58479281 LIMIT 5 [ RunTime:0.024206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479281 ORDER BY `minOrder` ASC [ RunTime:0.016831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58479281 ORDER BY `unit` DESC [ RunTime:0.029810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58479281 LIMIT 2 [ RunTime:0.026388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58479281 ORDER BY `minOrder` ASC [ RunTime:0.034617s ]
select * from pdf where partno='109R0624G4011' and brandshort='Sanyo Denki America Inc.' limit 1 [ RunTime:0.008342s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '109R0624G4011' OR `brand` LIKE 'Sanyo Denki America Inc.%' ) ) LIMIT 1 [ RunTime:0.015100s ]
SELECT `id` FROM `stock` WHERE `id` <> 58479281 AND `partno` = '109R0624G4011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sanyo denki america inc.%' ) [ RunTime:0.023159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18596793 [ RunTime:0.026197s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008029s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002561s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020599s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025473s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023600s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012518s ]
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 '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009734s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '109R0624G401%' OR `brand` LIKE '109R0624G401%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010955s ]