SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002328s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009580s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16994422 LIMIT 5 [ RunTime:0.012310s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.013126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16994422 ORDER BY `minOrder` ASC [ RunTime:0.009489s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16994422 ORDER BY `unit` DESC [ RunTime:0.014923s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16994422 LIMIT 2 [ RunTime:0.002211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16994422 ORDER BY `minOrder` ASC [ RunTime:0.002417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702861 LIMIT 5 [ RunTime:0.014711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702861 ORDER BY `minOrder` ASC [ RunTime:0.024037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702861 ORDER BY `unit` DESC [ RunTime:0.020484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702861 LIMIT 2 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702861 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702853 LIMIT 5 [ RunTime:0.008146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702853 ORDER BY `minOrder` ASC [ RunTime:0.003805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702853 ORDER BY `unit` DESC [ RunTime:0.034922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702853 LIMIT 2 [ RunTime:0.021288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702853 ORDER BY `minOrder` ASC [ RunTime:0.003779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702665 LIMIT 5 [ RunTime:0.039533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702665 ORDER BY `minOrder` ASC [ RunTime:0.025648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702665 ORDER BY `unit` DESC [ RunTime:0.034539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702665 LIMIT 2 [ RunTime:0.037481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702665 ORDER BY `minOrder` ASC [ RunTime:0.006570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702664 LIMIT 5 [ RunTime:0.022869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702664 ORDER BY `minOrder` ASC [ RunTime:0.021773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702664 ORDER BY `unit` DESC [ RunTime:0.028584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702664 LIMIT 2 [ RunTime:0.011356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702664 ORDER BY `minOrder` ASC [ RunTime:0.013640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702663 LIMIT 5 [ RunTime:0.018782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702663 ORDER BY `minOrder` ASC [ RunTime:0.027594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702663 ORDER BY `unit` DESC [ RunTime:0.025857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702663 LIMIT 2 [ RunTime:0.001785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702663 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702662 LIMIT 5 [ RunTime:0.010125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702662 ORDER BY `minOrder` ASC [ RunTime:0.012340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702662 ORDER BY `unit` DESC [ RunTime:0.007009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702662 LIMIT 2 [ RunTime:0.007423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702662 ORDER BY `minOrder` ASC [ RunTime:0.005636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702602 LIMIT 5 [ RunTime:0.009870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702602 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18702602 ORDER BY `unit` DESC [ RunTime:0.003131s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18702602 LIMIT 2 [ RunTime:0.007830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18702602 ORDER BY `minOrder` ASC [ RunTime:0.001348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206670 LIMIT 5 [ RunTime:0.002161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206670 ORDER BY `minOrder` ASC [ RunTime:0.003350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206670 ORDER BY `unit` DESC [ RunTime:0.005934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206670 LIMIT 2 [ RunTime:0.011118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206670 ORDER BY `minOrder` ASC [ RunTime:0.009183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206669 LIMIT 5 [ RunTime:0.004035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206669 ORDER BY `minOrder` ASC [ RunTime:0.008831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206669 ORDER BY `unit` DESC [ RunTime:0.007965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206669 LIMIT 2 [ RunTime:0.001742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206669 ORDER BY `minOrder` ASC [ RunTime:0.006649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206668 LIMIT 5 [ RunTime:0.004104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206668 ORDER BY `minOrder` ASC [ RunTime:0.013449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206668 ORDER BY `unit` DESC [ RunTime:0.001217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206668 LIMIT 2 [ RunTime:0.001620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206668 ORDER BY `minOrder` ASC [ RunTime:0.006855s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026489s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540575 LIMIT 5 [ RunTime:0.001051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540575 ORDER BY `minOrder` ASC [ RunTime:0.007495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540575 ORDER BY `unit` DESC [ RunTime:0.005752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540575 LIMIT 2 [ RunTime:0.024713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540575 ORDER BY `minOrder` ASC [ RunTime:0.002100s ]
select * from pdf where partno='PTS-30' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.011777s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-30' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.003172s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540575 AND `partno` = 'PTS-30' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.001422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16994422 [ RunTime:0.011806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540768 LIMIT 5 [ RunTime:0.000377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540768 ORDER BY `minOrder` ASC [ RunTime:0.007898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540768 ORDER BY `unit` DESC [ RunTime:0.001068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540768 LIMIT 2 [ RunTime:0.009667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540768 ORDER BY `minOrder` ASC [ RunTime:0.011618s ]
select * from pdf where partno='PTS-30S' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.018325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-30S' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.006389s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540768 AND `partno` = 'PTS-30S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.020618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702853 [ RunTime:0.028399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540819 LIMIT 5 [ RunTime:0.020544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540819 ORDER BY `minOrder` ASC [ RunTime:0.000827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540819 ORDER BY `unit` DESC [ RunTime:0.011183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540819 LIMIT 2 [ RunTime:0.011606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540819 ORDER BY `minOrder` ASC [ RunTime:0.008633s ]
select * from pdf where partno='PTS-300P' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.004034s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300P' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.017340s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540819 AND `partno` = 'PTS-300P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.027609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702602 [ RunTime:0.005462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58540708 LIMIT 5 [ RunTime:0.035899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540708 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58540708 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58540708 LIMIT 2 [ RunTime:0.001371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58540708 ORDER BY `minOrder` ASC [ RunTime:0.012706s ]
select * from pdf where partno='PTS-300' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.006949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.027088s ]
SELECT `id` FROM `stock` WHERE `id` <> 58540708 AND `partno` = 'PTS-300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.007213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702861 [ RunTime:0.007593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541643 LIMIT 5 [ RunTime:0.003935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541643 ORDER BY `minOrder` ASC [ RunTime:0.015440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541643 ORDER BY `unit` DESC [ RunTime:0.019171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541643 LIMIT 2 [ RunTime:0.032443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541643 ORDER BY `minOrder` ASC [ RunTime:0.004290s ]
select * from pdf where partno='PTS-300HDS' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.018159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300HDS' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.013674s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541643 AND `partno` = 'PTS-300HDS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.021043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702665 [ RunTime:0.007359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541642 LIMIT 5 [ RunTime:0.018476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541642 ORDER BY `minOrder` ASC [ RunTime:0.033614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541642 ORDER BY `unit` DESC [ RunTime:0.001759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541642 LIMIT 2 [ RunTime:0.006670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541642 ORDER BY `minOrder` ASC [ RunTime:0.002596s ]
select * from pdf where partno='PTS-300HD' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.021607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300HD' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.011715s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541642 AND `partno` = 'PTS-300HD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.010959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702664 [ RunTime:0.014642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541641 LIMIT 5 [ RunTime:0.016737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541641 ORDER BY `minOrder` ASC [ RunTime:0.016590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541641 ORDER BY `unit` DESC [ RunTime:0.016860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541641 LIMIT 2 [ RunTime:0.003789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541641 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
select * from pdf where partno='PTS-300C' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.015841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300C' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.015259s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541641 AND `partno` = 'PTS-300C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.009775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702663 [ RunTime:0.006362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541640 LIMIT 5 [ RunTime:0.010136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541640 ORDER BY `minOrder` ASC [ RunTime:0.005789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541640 ORDER BY `unit` DESC [ RunTime:0.005776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541640 LIMIT 2 [ RunTime:0.002634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541640 ORDER BY `minOrder` ASC [ RunTime:0.006561s ]
select * from pdf where partno='PTS-300S' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.005782s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-300S' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.002880s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541640 AND `partno` = 'PTS-300S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.001587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18702662 [ RunTime:0.000600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541559 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541559 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541559 ORDER BY `unit` DESC [ RunTime:0.002977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541559 LIMIT 2 [ RunTime:0.001655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541559 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='PTS-30HDS' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.007708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-30HDS' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.001149s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541559 AND `partno` = 'PTS-30HDS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.001039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206670 [ RunTime:0.000750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541558 LIMIT 5 [ RunTime:0.000675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541558 ORDER BY `minOrder` ASC [ RunTime:0.002830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541558 ORDER BY `unit` DESC [ RunTime:0.002202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541558 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541558 ORDER BY `minOrder` ASC [ RunTime:0.003114s ]
select * from pdf where partno='PTS-30C' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.004225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-30C' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.002029s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541558 AND `partno` = 'PTS-30C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.000969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206669 [ RunTime:0.003019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58541557 LIMIT 5 [ RunTime:0.004907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541557 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58541557 ORDER BY `unit` DESC [ RunTime:0.001825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58541557 LIMIT 2 [ RunTime:0.001329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58541557 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
select * from pdf where partno='PTS-30HD' and brandshort='Patco Services Inc' limit 1 [ RunTime:0.001242s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PTS-30HD' OR `brand` LIKE 'Patco Services Inc%' ) ) LIMIT 1 [ RunTime:0.010088s ]
SELECT `id` FROM `stock` WHERE `id` <> 58541557 AND `partno` = 'PTS-30HD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%patco services inc%' ) [ RunTime:0.002392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206668 [ RunTime:0.001300s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001249s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002579s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000949s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005583s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001576s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000835s ]
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 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001558s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PTS-30%' OR `brand` LIKE 'PTS-30%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002194s ]