SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002253s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038109s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904796 LIMIT 5 [ RunTime:0.024187s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904796 ORDER BY `minOrder` ASC [ RunTime:0.054986s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904796 ORDER BY `unit` DESC [ RunTime:0.032260s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.016353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904796 LIMIT 2 [ RunTime:0.076567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904796 ORDER BY `minOrder` ASC [ RunTime:0.036864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906962 LIMIT 5 [ RunTime:0.033604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906962 ORDER BY `minOrder` ASC [ RunTime:0.038320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18906962 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18906962 LIMIT 2 [ RunTime:0.004202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18906962 ORDER BY `minOrder` ASC [ RunTime:0.044141s ]
select * from pdf where partno='5502307004F' and brandshort='Dialight' limit 1 [ RunTime:0.033568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905784 LIMIT 5 [ RunTime:0.096418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905784 ORDER BY `minOrder` ASC [ RunTime:0.058040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905784 ORDER BY `unit` DESC [ RunTime:0.008965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905784 LIMIT 2 [ RunTime:0.073292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905784 ORDER BY `minOrder` ASC [ RunTime:0.050941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905653 LIMIT 5 [ RunTime:0.037240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905653 ORDER BY `minOrder` ASC [ RunTime:0.045439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18905653 ORDER BY `unit` DESC [ RunTime:0.109179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18905653 LIMIT 2 [ RunTime:0.023643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18905653 ORDER BY `minOrder` ASC [ RunTime:0.027424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904865 LIMIT 5 [ RunTime:0.034328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904865 ORDER BY `minOrder` ASC [ RunTime:0.075668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904865 ORDER BY `unit` DESC [ RunTime:0.096118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904865 LIMIT 2 [ RunTime:0.145477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904865 ORDER BY `minOrder` ASC [ RunTime:0.040060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904748 LIMIT 5 [ RunTime:0.141481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904748 ORDER BY `minOrder` ASC [ RunTime:0.084770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904748 ORDER BY `unit` DESC [ RunTime:0.021988s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904748 LIMIT 2 [ RunTime:0.050104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904748 ORDER BY `minOrder` ASC [ RunTime:0.008440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904618 LIMIT 5 [ RunTime:0.037481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904618 ORDER BY `minOrder` ASC [ RunTime:0.063565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904618 ORDER BY `unit` DESC [ RunTime:0.040162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904618 LIMIT 2 [ RunTime:0.055865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904618 ORDER BY `minOrder` ASC [ RunTime:0.026092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904617 LIMIT 5 [ RunTime:0.058516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904617 ORDER BY `minOrder` ASC [ RunTime:0.038637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904617 ORDER BY `unit` DESC [ RunTime:0.066524s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904617 LIMIT 2 [ RunTime:0.045741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904617 ORDER BY `minOrder` ASC [ RunTime:0.025691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904544 LIMIT 5 [ RunTime:0.046998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904544 ORDER BY `minOrder` ASC [ RunTime:0.068556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18904544 ORDER BY `unit` DESC [ RunTime:0.046218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18904544 LIMIT 2 [ RunTime:0.038302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18904544 ORDER BY `minOrder` ASC [ RunTime:0.018802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034511 LIMIT 5 [ RunTime:0.022799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034511 ORDER BY `minOrder` ASC [ RunTime:0.050622s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034511 ORDER BY `unit` DESC [ RunTime:0.027924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034511 LIMIT 2 [ RunTime:0.060432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034511 ORDER BY `minOrder` ASC [ RunTime:0.011200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17034510 LIMIT 5 [ RunTime:0.029709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034510 ORDER BY `minOrder` ASC [ RunTime:0.004605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17034510 ORDER BY `unit` DESC [ RunTime:0.037092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17034510 LIMIT 2 [ RunTime:0.041142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17034510 ORDER BY `minOrder` ASC [ RunTime:0.041117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249748 LIMIT 5 [ RunTime:0.062923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249748 ORDER BY `minOrder` ASC [ RunTime:0.053602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15249748 ORDER BY `unit` DESC [ RunTime:0.123051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15249748 LIMIT 2 [ RunTime:0.079701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15249748 ORDER BY `minOrder` ASC [ RunTime:0.025800s ]
select * from pdf where partno='5502307100F' and brandshort='Dialight' limit 1 [ RunTime:0.070800s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076317s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.106885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58131816 LIMIT 5 [ RunTime:0.027129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58131816 ORDER BY `minOrder` ASC [ RunTime:0.024670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58131816 ORDER BY `unit` DESC [ RunTime:0.022215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58131816 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58131816 ORDER BY `minOrder` ASC [ RunTime:0.029688s ]
select * from pdf where partno='5502307004F' and brandshort='Dialight' limit 1 [ RunTime:0.036912s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307004F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.043180s ]
SELECT `id` FROM `stock` WHERE `id` <> 58131816 AND `partno` = '5502307004F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.067390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18906962 [ RunTime:0.077261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58130420 LIMIT 5 [ RunTime:0.041033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58130420 ORDER BY `minOrder` ASC [ RunTime:0.034277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58130420 ORDER BY `unit` DESC [ RunTime:0.061495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58130420 LIMIT 2 [ RunTime:0.014490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58130420 ORDER BY `minOrder` ASC [ RunTime:0.054148s ]
select * from pdf where partno='5502307002F' and brandshort='Dialight' limit 1 [ RunTime:0.022074s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307002F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.007370s ]
SELECT `id` FROM `stock` WHERE `id` <> 58130420 AND `partno` = '5502307002F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.024927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905784 [ RunTime:0.068719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58130277 LIMIT 5 [ RunTime:0.123500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58130277 ORDER BY `minOrder` ASC [ RunTime:0.055700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58130277 ORDER BY `unit` DESC [ RunTime:0.063889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58130277 LIMIT 2 [ RunTime:0.086618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58130277 ORDER BY `minOrder` ASC [ RunTime:0.014122s ]
select * from pdf where partno='5502307010F' and brandshort='Dialight' limit 1 [ RunTime:0.054929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307010F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.072803s ]
SELECT `id` FROM `stock` WHERE `id` <> 58130277 AND `partno` = '5502307010F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.062794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18905653 [ RunTime:0.067780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58129278 LIMIT 5 [ RunTime:0.058799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129278 ORDER BY `minOrder` ASC [ RunTime:0.026840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58129278 ORDER BY `unit` DESC [ RunTime:0.027678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58129278 LIMIT 2 [ RunTime:0.046012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129278 ORDER BY `minOrder` ASC [ RunTime:0.025565s ]
select * from pdf where partno='5502307100F' and brandshort='Dialight' limit 1 [ RunTime:0.012945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307100F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.059199s ]
SELECT `id` FROM `stock` WHERE `id` <> 58129278 AND `partno` = '5502307100F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.019495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15249748 [ RunTime:0.046869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58129237 LIMIT 5 [ RunTime:0.029311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129237 ORDER BY `minOrder` ASC [ RunTime:0.050798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58129237 ORDER BY `unit` DESC [ RunTime:0.029679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58129237 LIMIT 2 [ RunTime:0.006423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129237 ORDER BY `minOrder` ASC [ RunTime:0.003682s ]
select * from pdf where partno='5502307811F' and brandshort='Dialight' limit 1 [ RunTime:0.025413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307811F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.023093s ]
SELECT `id` FROM `stock` WHERE `id` <> 58129237 AND `partno` = '5502307811F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.021486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904865 [ RunTime:0.039178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58129169 LIMIT 5 [ RunTime:0.033531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129169 ORDER BY `minOrder` ASC [ RunTime:0.008271s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58129169 ORDER BY `unit` DESC [ RunTime:0.007638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58129169 LIMIT 2 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129169 ORDER BY `minOrder` ASC [ RunTime:0.018643s ]
select * from pdf where partno='5502307808F' and brandshort='Dialight' limit 1 [ RunTime:0.011140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307808F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.031765s ]
SELECT `id` FROM `stock` WHERE `id` <> 58129169 AND `partno` = '5502307808F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.018800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904748 [ RunTime:0.013571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58129016 LIMIT 5 [ RunTime:0.009240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129016 ORDER BY `minOrder` ASC [ RunTime:0.008084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58129016 ORDER BY `unit` DESC [ RunTime:0.005603s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58129016 LIMIT 2 [ RunTime:0.012404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58129016 ORDER BY `minOrder` ASC [ RunTime:0.005108s ]
select * from pdf where partno='5502307801F' and brandshort='Dialight' limit 1 [ RunTime:0.005094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307801F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.046694s ]
SELECT `id` FROM `stock` WHERE `id` <> 58129016 AND `partno` = '5502307801F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.023054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904617 [ RunTime:0.016223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128995 LIMIT 5 [ RunTime:0.017351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128995 ORDER BY `minOrder` ASC [ RunTime:0.033784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128995 ORDER BY `unit` DESC [ RunTime:0.027273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128995 LIMIT 2 [ RunTime:0.024406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128995 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
select * from pdf where partno='5502307804F' and brandshort='Dialight' limit 1 [ RunTime:0.012625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307804F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.031508s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128995 AND `partno` = '5502307804F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.020439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904618 [ RunTime:0.035798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128872 LIMIT 5 [ RunTime:0.037921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128872 ORDER BY `minOrder` ASC [ RunTime:0.010979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128872 ORDER BY `unit` DESC [ RunTime:0.018519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128872 LIMIT 2 [ RunTime:0.048559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128872 ORDER BY `minOrder` ASC [ RunTime:0.029828s ]
select * from pdf where partno='5502307807F' and brandshort='Dialight' limit 1 [ RunTime:0.020424s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307807F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.053815s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128872 AND `partno` = '5502307807F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.036148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904544 [ RunTime:0.079268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58128265 LIMIT 5 [ RunTime:0.068150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128265 ORDER BY `minOrder` ASC [ RunTime:0.060496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58128265 ORDER BY `unit` DESC [ RunTime:0.118188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58128265 LIMIT 2 [ RunTime:0.134543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58128265 ORDER BY `minOrder` ASC [ RunTime:0.046222s ]
select * from pdf where partno='5502307F' and brandshort='Dialight' limit 1 [ RunTime:0.013848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5502307F' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.085632s ]
SELECT `id` FROM `stock` WHERE `id` <> 58128265 AND `partno` = '5502307F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.100679s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18904796 [ RunTime:0.047645s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.124697s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052479s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.087544s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120588s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.136531s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064797s ]
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 '5502307%' OR `brand` LIKE '5502307%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.115468s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5502307%' OR `brand` LIKE '5502307%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.123785s ]