SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003021s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027930s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495829 LIMIT 5 [ RunTime:0.038688s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495829 ORDER BY `minOrder` ASC [ RunTime:0.011003s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16495829 ORDER BY `unit` DESC [ RunTime:0.023354s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.024151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16495829 LIMIT 2 [ RunTime:0.017254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495829 ORDER BY `minOrder` ASC [ RunTime:0.010320s ]
select * from pdf where partno='UTP28SP43YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.030733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495828 LIMIT 5 [ RunTime:0.018810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495828 ORDER BY `minOrder` ASC [ RunTime:0.001846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16495828 ORDER BY `unit` DESC [ RunTime:0.007489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16495828 LIMIT 2 [ RunTime:0.019618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495828 ORDER BY `minOrder` ASC [ RunTime:0.012505s ]
select * from pdf where partno='UTP28SP43VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.055881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495827 LIMIT 5 [ RunTime:0.037373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495827 ORDER BY `minOrder` ASC [ RunTime:0.027967s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16495827 ORDER BY `unit` DESC [ RunTime:0.053347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16495827 LIMIT 2 [ RunTime:0.060564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495827 ORDER BY `minOrder` ASC [ RunTime:0.007985s ]
select * from pdf where partno='UTP28SP43GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.070322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495826 LIMIT 5 [ RunTime:0.029036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495826 ORDER BY `minOrder` ASC [ RunTime:0.049538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16495826 ORDER BY `unit` DESC [ RunTime:0.059252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16495826 LIMIT 2 [ RunTime:0.198951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495826 ORDER BY `minOrder` ASC [ RunTime:0.061956s ]
select * from pdf where partno='UTP28SP43BU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.059179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495825 LIMIT 5 [ RunTime:0.031393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495825 ORDER BY `minOrder` ASC [ RunTime:0.149376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16495825 ORDER BY `unit` DESC [ RunTime:0.157139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16495825 LIMIT 2 [ RunTime:0.083956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16495825 ORDER BY `minOrder` ASC [ RunTime:0.030201s ]
select * from pdf where partno='UTP28SP43BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.077961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504191 LIMIT 5 [ RunTime:0.092336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504191 ORDER BY `minOrder` ASC [ RunTime:0.063381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14504191 ORDER BY `unit` DESC [ RunTime:0.110243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14504191 LIMIT 2 [ RunTime:0.084506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504191 ORDER BY `minOrder` ASC [ RunTime:0.060283s ]
select * from pdf where partno='UTP28SP43RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.047855s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504190 LIMIT 5 [ RunTime:0.091159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504190 ORDER BY `minOrder` ASC [ RunTime:0.139653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14504190 ORDER BY `unit` DESC [ RunTime:0.153949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14504190 LIMIT 2 [ RunTime:0.036213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504190 ORDER BY `minOrder` ASC [ RunTime:0.026943s ]
select * from pdf where partno='UTP28SP43OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.045054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504189 LIMIT 5 [ RunTime:0.033419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504189 ORDER BY `minOrder` ASC [ RunTime:0.063856s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14504189 ORDER BY `unit` DESC [ RunTime:0.181569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14504189 LIMIT 2 [ RunTime:0.082123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504189 ORDER BY `minOrder` ASC [ RunTime:0.047900s ]
select * from pdf where partno='UTP28SP43GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.059388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504188 LIMIT 5 [ RunTime:0.033186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504188 ORDER BY `minOrder` ASC [ RunTime:0.144268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14504188 ORDER BY `unit` DESC [ RunTime:0.105220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14504188 LIMIT 2 [ RunTime:0.063162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14504188 ORDER BY `minOrder` ASC [ RunTime:0.015393s ]
select * from pdf where partno='UTP28SP43' and brandshort='Panduit Corp' limit 1 [ RunTime:0.074276s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055142s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584719 LIMIT 5 [ RunTime:0.012107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584719 ORDER BY `minOrder` ASC [ RunTime:0.055053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584719 ORDER BY `unit` DESC [ RunTime:0.058742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584719 LIMIT 2 [ RunTime:0.034310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584719 ORDER BY `minOrder` ASC [ RunTime:0.031255s ]
select * from pdf where partno='UTP28SP43YL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.027504s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43YL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.022269s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584719 AND `partno` = 'UTP28SP43YL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.022725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495829 [ RunTime:0.007139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584718 LIMIT 5 [ RunTime:0.028288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584718 ORDER BY `minOrder` ASC [ RunTime:0.009110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584718 ORDER BY `unit` DESC [ RunTime:0.015824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584718 LIMIT 2 [ RunTime:0.014637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584718 ORDER BY `minOrder` ASC [ RunTime:0.020242s ]
select * from pdf where partno='UTP28SP43VL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.009062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43VL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005560s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584718 AND `partno` = 'UTP28SP43VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.008175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495828 [ RunTime:0.005805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584717 LIMIT 5 [ RunTime:0.001022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584717 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584717 ORDER BY `unit` DESC [ RunTime:0.000492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584717 LIMIT 2 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584717 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='UTP28SP43RD' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43RD' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.000438s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584717 AND `partno` = 'UTP28SP43RD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504191 [ RunTime:0.000403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584716 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584716 ORDER BY `minOrder` ASC [ RunTime:0.010186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584716 ORDER BY `unit` DESC [ RunTime:0.004575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584716 LIMIT 2 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584716 ORDER BY `minOrder` ASC [ RunTime:0.011692s ]
select * from pdf where partno='UTP28SP43OR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43OR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.005813s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584716 AND `partno` = 'UTP28SP43OR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.007498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504190 [ RunTime:0.002964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584715 LIMIT 5 [ RunTime:0.009771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584715 ORDER BY `minOrder` ASC [ RunTime:0.006842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584715 ORDER BY `unit` DESC [ RunTime:0.007088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584715 LIMIT 2 [ RunTime:0.008165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584715 ORDER BY `minOrder` ASC [ RunTime:0.009423s ]
select * from pdf where partno='UTP28SP43GY' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43GY' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.003762s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584715 AND `partno` = 'UTP28SP43GY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.003938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504189 [ RunTime:0.000707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584714 LIMIT 5 [ RunTime:0.011322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584714 ORDER BY `minOrder` ASC [ RunTime:0.005460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584714 ORDER BY `unit` DESC [ RunTime:0.008747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584714 LIMIT 2 [ RunTime:0.017495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584714 ORDER BY `minOrder` ASC [ RunTime:0.004591s ]
select * from pdf where partno='UTP28SP43GR' and brandshort='Panduit Corp' limit 1 [ RunTime:0.000701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43GR' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.018714s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584714 AND `partno` = 'UTP28SP43GR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.016437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495827 [ RunTime:0.008504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584713 LIMIT 5 [ RunTime:0.005124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584713 ORDER BY `minOrder` ASC [ RunTime:0.011673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584713 ORDER BY `unit` DESC [ RunTime:0.035102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584713 LIMIT 2 [ RunTime:0.020303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584713 ORDER BY `minOrder` ASC [ RunTime:0.002962s ]
select * from pdf where partno='UTP28SP43BU' and brandshort='Panduit Corp' limit 1 [ RunTime:0.003524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43BU' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.023431s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584713 AND `partno` = 'UTP28SP43BU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.010121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495826 [ RunTime:0.019261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584712 LIMIT 5 [ RunTime:0.008091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584712 ORDER BY `minOrder` ASC [ RunTime:0.011093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584712 ORDER BY `unit` DESC [ RunTime:0.006988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584712 LIMIT 2 [ RunTime:0.012073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584712 ORDER BY `minOrder` ASC [ RunTime:0.015891s ]
select * from pdf where partno='UTP28SP43BL' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007401s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43BL' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.009075s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584712 AND `partno` = 'UTP28SP43BL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.026682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16495825 [ RunTime:0.021554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55584711 LIMIT 5 [ RunTime:0.007349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584711 ORDER BY `minOrder` ASC [ RunTime:0.017794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55584711 ORDER BY `unit` DESC [ RunTime:0.016984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55584711 LIMIT 2 [ RunTime:0.010377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55584711 ORDER BY `minOrder` ASC [ RunTime:0.034515s ]
select * from pdf where partno='UTP28SP43' and brandshort='Panduit Corp' limit 1 [ RunTime:0.007417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UTP28SP43' OR `brand` LIKE 'Panduit Corp%' ) ) LIMIT 1 [ RunTime:0.006760s ]
SELECT `id` FROM `stock` WHERE `id` <> 55584711 AND `partno` = 'UTP28SP43' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panduit corp%' ) [ RunTime:0.017822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14504188 [ RunTime:0.025142s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012459s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010732s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011139s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035915s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015289s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034317s ]
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 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027905s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UTP28SP43%' OR `brand` LIKE 'UTP28SP43%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012756s ]