SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002736s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061932s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829192 LIMIT 5 [ RunTime:0.031636s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829192 ORDER BY `minOrder` ASC [ RunTime:0.067996s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.024154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19829192 ORDER BY `unit` DESC [ RunTime:0.031247s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19829192 LIMIT 2 [ RunTime:0.049690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19829192 ORDER BY `minOrder` ASC [ RunTime:0.031262s ]
select * from pdf where partno='15550122701000' and brandshort='HARTING' limit 1 [ RunTime:0.040731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768234 LIMIT 5 [ RunTime:0.091592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768234 ORDER BY `minOrder` ASC [ RunTime:0.027918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19768234 ORDER BY `unit` DESC [ RunTime:0.047891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19768234 LIMIT 2 [ RunTime:0.062905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19768234 ORDER BY `minOrder` ASC [ RunTime:0.046144s ]
select * from pdf where partno='15550022601000' and brandshort='HARTING' limit 1 [ RunTime:0.061816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615167 LIMIT 5 [ RunTime:0.058492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615167 ORDER BY `minOrder` ASC [ RunTime:0.077338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615167 ORDER BY `unit` DESC [ RunTime:0.105327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615167 LIMIT 2 [ RunTime:0.055802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615167 ORDER BY `minOrder` ASC [ RunTime:0.053071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615166 LIMIT 5 [ RunTime:0.105323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615166 ORDER BY `minOrder` ASC [ RunTime:0.059406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615166 ORDER BY `unit` DESC [ RunTime:0.016499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615166 LIMIT 2 [ RunTime:0.056306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615166 ORDER BY `minOrder` ASC [ RunTime:0.013281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274478 LIMIT 5 [ RunTime:0.042146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274478 ORDER BY `minOrder` ASC [ RunTime:0.077261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274478 ORDER BY `unit` DESC [ RunTime:0.130506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274478 LIMIT 2 [ RunTime:0.011911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274478 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526255 LIMIT 5 [ RunTime:0.038949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526255 ORDER BY `minOrder` ASC [ RunTime:0.011563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526255 ORDER BY `unit` DESC [ RunTime:0.005792s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526255 LIMIT 2 [ RunTime:0.044956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526255 ORDER BY `minOrder` ASC [ RunTime:0.039361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11583621 LIMIT 5 [ RunTime:0.010274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11583621 ORDER BY `minOrder` ASC [ RunTime:0.009438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11583621 ORDER BY `unit` DESC [ RunTime:0.001865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11583621 LIMIT 2 [ RunTime:0.018179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11583621 ORDER BY `minOrder` ASC [ RunTime:0.009289s ]
select * from pdf where partno='15550122601000' and brandshort='HARTING' limit 1 [ RunTime:0.007119s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053094s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59506515 LIMIT 5 [ RunTime:0.010176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59506515 ORDER BY `minOrder` ASC [ RunTime:0.023784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59506515 ORDER BY `unit` DESC [ RunTime:0.007725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59506515 LIMIT 2 [ RunTime:0.039395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59506515 ORDER BY `minOrder` ASC [ RunTime:0.000582s ]
select * from pdf where partno='15550122701000' and brandshort='HARTING' limit 1 [ RunTime:0.022613s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550122701000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.017188s ]
SELECT `id` FROM `stock` WHERE `id` <> 59506515 AND `partno` = '15550122701000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.013238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19829192 [ RunTime:0.024125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59450619 LIMIT 5 [ RunTime:0.064825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450619 ORDER BY `minOrder` ASC [ RunTime:0.014527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59450619 ORDER BY `unit` DESC [ RunTime:0.072970s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59450619 LIMIT 2 [ RunTime:0.030005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59450619 ORDER BY `minOrder` ASC [ RunTime:0.038469s ]
select * from pdf where partno='15550022601000' and brandshort='HARTING' limit 1 [ RunTime:0.014852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550022601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.022647s ]
SELECT `id` FROM `stock` WHERE `id` <> 59450619 AND `partno` = '15550022601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.028892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19768234 [ RunTime:0.022014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63432157 LIMIT 5 [ RunTime:0.008753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63432157 ORDER BY `minOrder` ASC [ RunTime:0.018941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63432157 ORDER BY `unit` DESC [ RunTime:0.035106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63432157 LIMIT 2 [ RunTime:0.068838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63432157 ORDER BY `minOrder` ASC [ RunTime:0.096558s ]
select * from pdf where partno='1555000' and brandshort='Rittal' limit 1 [ RunTime:0.116314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1555000' OR `brand` LIKE 'Rittal%' ) ) LIMIT 1 [ RunTime:0.142802s ]
SELECT `id` FROM `stock` WHERE `id` <> 63432157 AND `partno` = '1555000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rittal%' ) [ RunTime:0.082584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274478 [ RunTime:0.056575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518021 LIMIT 5 [ RunTime:0.177415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518021 ORDER BY `minOrder` ASC [ RunTime:0.142574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518021 ORDER BY `unit` DESC [ RunTime:0.073800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518021 LIMIT 2 [ RunTime:0.167736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518021 ORDER BY `minOrder` ASC [ RunTime:0.083623s ]
select * from pdf where partno='15550' and brandshort='Brady Corporation' limit 1 [ RunTime:0.042917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027405s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518021 AND `partno` = '15550' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.133787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526255 [ RunTime:0.049301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63370852 LIMIT 5 [ RunTime:0.116841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63370852 ORDER BY `minOrder` ASC [ RunTime:0.081188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63370852 ORDER BY `unit` DESC [ RunTime:0.090376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63370852 LIMIT 2 [ RunTime:0.076230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63370852 ORDER BY `minOrder` ASC [ RunTime:0.010826s ]
select * from pdf where partno='15550' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.051895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.055491s ]
SELECT `id` FROM `stock` WHERE `id` <> 63370852 AND `partno` = '15550' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.144646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63370851 LIMIT 5 [ RunTime:0.031267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63370851 ORDER BY `minOrder` ASC [ RunTime:0.119599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63370851 ORDER BY `unit` DESC [ RunTime:0.069460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63370851 LIMIT 2 [ RunTime:0.036557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63370851 ORDER BY `minOrder` ASC [ RunTime:0.030215s ]
select * from pdf where partno='15550B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.037620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.012584s ]
SELECT `id` FROM `stock` WHERE `id` <> 63370851 AND `partno` = '15550B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.035918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60503127 LIMIT 5 [ RunTime:0.027276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60503127 ORDER BY `minOrder` ASC [ RunTime:0.035137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60503127 ORDER BY `unit` DESC [ RunTime:0.090612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60503127 LIMIT 2 [ RunTime:0.108641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60503127 ORDER BY `minOrder` ASC [ RunTime:0.094705s ]
select * from pdf where partno='1555060000' and brandshort='Weidmüller' limit 1 [ RunTime:0.022091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1555060000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.065909s ]
SELECT `id` FROM `stock` WHERE `id` <> 60503127 AND `partno` = '1555060000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.063293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615167 [ RunTime:0.051939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60503126 LIMIT 5 [ RunTime:0.057893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60503126 ORDER BY `minOrder` ASC [ RunTime:0.077043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60503126 ORDER BY `unit` DESC [ RunTime:0.056803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60503126 LIMIT 2 [ RunTime:0.049174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60503126 ORDER BY `minOrder` ASC [ RunTime:0.008568s ]
select * from pdf where partno='1555010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1555010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.029065s ]
SELECT `id` FROM `stock` WHERE `id` <> 60503126 AND `partno` = '1555010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.054294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615166 [ RunTime:0.010326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 45827313 LIMIT 5 [ RunTime:0.036457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 45827313 ORDER BY `minOrder` ASC [ RunTime:0.056653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 45827313 ORDER BY `unit` DESC [ RunTime:0.007101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 45827313 LIMIT 2 [ RunTime:0.039271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 45827313 ORDER BY `minOrder` ASC [ RunTime:0.007962s ]
select * from pdf where partno='15550122601000' and brandshort='HARTING' limit 1 [ RunTime:0.016796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550122601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.014010s ]
SELECT `id` FROM `stock` WHERE `id` <> 45827313 AND `partno` = '15550122601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.017710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11583621 [ RunTime:0.026355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42739071 LIMIT 5 [ RunTime:0.022428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42739071 ORDER BY `minOrder` ASC [ RunTime:0.027750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42739071 ORDER BY `unit` DESC [ RunTime:0.037334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42739071 LIMIT 2 [ RunTime:0.007890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42739071 ORDER BY `minOrder` ASC [ RunTime:0.020161s ]
select * from pdf where partno='15550122601000' and brandshort='HARTING' limit 1 [ RunTime:0.002464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15550122601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005371s ]
SELECT `id` FROM `stock` WHERE `id` <> 42739071 AND `partno` = '15550122601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.009762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11583621 [ RunTime:0.019787s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015758s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030357s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015437s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010876s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017340s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002551s ]
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 '15550%' OR `brand` LIKE '15550%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007935s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15550%' OR `brand` LIKE '15550%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.062040s ]