SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002169s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006131s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000899s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003181s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56214871 LIMIT 5 [ RunTime:0.003886s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56214871 ORDER BY `minOrder` ASC [ RunTime:0.002431s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56214871 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56214871 LIMIT 2 [ RunTime:0.000273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56214871 ORDER BY `minOrder` ASC [ RunTime:0.003490s ]
select * from pdf where partno='0046119' and brandshort='LAPP' limit 1 [ RunTime:0.002196s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046119' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.001681s ]
SELECT `id` FROM `stock` WHERE `id` <> 56214871 AND `partno` = '0046119' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.003966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56214228 LIMIT 5 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56214228 ORDER BY `minOrder` ASC [ RunTime:0.005805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56214228 ORDER BY `unit` DESC [ RunTime:0.003371s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56214228 LIMIT 2 [ RunTime:0.001669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56214228 ORDER BY `minOrder` ASC [ RunTime:0.000487s ]
select * from pdf where partno='0046117' and brandshort='LAPP' limit 1 [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046117' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.000955s ]
SELECT `id` FROM `stock` WHERE `id` <> 56214228 AND `partno` = '0046117' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.001043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56213861 LIMIT 5 [ RunTime:0.005581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213861 ORDER BY `minOrder` ASC [ RunTime:0.016605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56213861 ORDER BY `unit` DESC [ RunTime:0.005312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56213861 LIMIT 2 [ RunTime:0.002454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213861 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
select * from pdf where partno='00461433' and brandshort='LAPP' limit 1 [ RunTime:0.001200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '00461433' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.004584s ]
SELECT `id` FROM `stock` WHERE `id` <> 56213861 AND `partno` = '00461433' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.012846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56213379 LIMIT 5 [ RunTime:0.003472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213379 ORDER BY `minOrder` ASC [ RunTime:0.006166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56213379 ORDER BY `unit` DESC [ RunTime:0.000758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56213379 LIMIT 2 [ RunTime:0.001866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213379 ORDER BY `minOrder` ASC [ RunTime:0.001356s ]
select * from pdf where partno='00461423' and brandshort='LAPP' limit 1 [ RunTime:0.003237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '00461423' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.005213s ]
SELECT `id` FROM `stock` WHERE `id` <> 56213379 AND `partno` = '00461423' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.005330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56213315 LIMIT 5 [ RunTime:0.008414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213315 ORDER BY `minOrder` ASC [ RunTime:0.010504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56213315 ORDER BY `unit` DESC [ RunTime:0.003256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56213315 LIMIT 2 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56213315 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='0046116' and brandshort='LAPP' limit 1 [ RunTime:0.001175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046116' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.005079s ]
SELECT `id` FROM `stock` WHERE `id` <> 56213315 AND `partno` = '0046116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.002202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56212762 LIMIT 5 [ RunTime:0.002241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212762 ORDER BY `minOrder` ASC [ RunTime:0.003887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56212762 ORDER BY `unit` DESC [ RunTime:0.002846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56212762 LIMIT 2 [ RunTime:0.001982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212762 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
select * from pdf where partno='00461333' and brandshort='LAPP' limit 1 [ RunTime:0.001058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '00461333' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.002456s ]
SELECT `id` FROM `stock` WHERE `id` <> 56212762 AND `partno` = '00461333' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.013944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56212229 LIMIT 5 [ RunTime:0.004829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212229 ORDER BY `minOrder` ASC [ RunTime:0.002804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56212229 ORDER BY `unit` DESC [ RunTime:0.002516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56212229 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56212229 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='0046141' and brandshort='LAPP' limit 1 [ RunTime:0.000945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046141' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.003696s ]
SELECT `id` FROM `stock` WHERE `id` <> 56212229 AND `partno` = '0046141' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.005652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56211662 LIMIT 5 [ RunTime:0.000614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56211662 ORDER BY `minOrder` ASC [ RunTime:0.004728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56211662 ORDER BY `unit` DESC [ RunTime:0.004563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56211662 LIMIT 2 [ RunTime:0.001682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56211662 ORDER BY `minOrder` ASC [ RunTime:0.001170s ]
select * from pdf where partno='00461323' and brandshort='LAPP' limit 1 [ RunTime:0.001076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '00461323' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.000972s ]
SELECT `id` FROM `stock` WHERE `id` <> 56211662 AND `partno` = '00461323' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56210580 LIMIT 5 [ RunTime:0.006295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56210580 ORDER BY `minOrder` ASC [ RunTime:0.018311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56210580 ORDER BY `unit` DESC [ RunTime:0.001268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56210580 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56210580 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='0046131' and brandshort='LAPP' limit 1 [ RunTime:0.001066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046131' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.009972s ]
SELECT `id` FROM `stock` WHERE `id` <> 56210580 AND `partno` = '0046131' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.009138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56210078 LIMIT 5 [ RunTime:0.006630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56210078 ORDER BY `minOrder` ASC [ RunTime:0.006978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56210078 ORDER BY `unit` DESC [ RunTime:0.006482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56210078 LIMIT 2 [ RunTime:0.015393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56210078 ORDER BY `minOrder` ASC [ RunTime:0.004243s ]
select * from pdf where partno='0046115' and brandshort='LAPP' limit 1 [ RunTime:0.010983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046115' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.012915s ]
SELECT `id` FROM `stock` WHERE `id` <> 56210078 AND `partno` = '0046115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.006979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56208342 LIMIT 5 [ RunTime:0.007850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56208342 ORDER BY `minOrder` ASC [ RunTime:0.010648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56208342 ORDER BY `unit` DESC [ RunTime:0.016586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56208342 LIMIT 2 [ RunTime:0.009236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56208342 ORDER BY `minOrder` ASC [ RunTime:0.002885s ]
select * from pdf where partno='0046110' and brandshort='LAPP' limit 1 [ RunTime:0.019508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '0046110' OR `brand` LIKE 'LAPP%' ) ) LIMIT 1 [ RunTime:0.026934s ]
SELECT `id` FROM `stock` WHERE `id` <> 56208342 AND `partno` = '0046110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lapp%' ) [ RunTime:0.011939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32566400 LIMIT 5 [ RunTime:0.030033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32566400 ORDER BY `minOrder` ASC [ RunTime:0.023351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32566400 ORDER BY `unit` DESC [ RunTime:0.013533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32566400 LIMIT 2 [ RunTime:0.028590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32566400 ORDER BY `minOrder` ASC [ RunTime:0.006997s ]
select * from pdf where partno='00461' and brandshort='Greenlee Communications' limit 1 [ RunTime:0.014108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '00461' OR `brand` LIKE 'Greenlee Communications%' ) ) LIMIT 1 [ RunTime:0.022228s ]
SELECT `id` FROM `stock` WHERE `id` <> 32566400 AND `partno` = '00461' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%greenlee communications%' ) [ RunTime:0.009844s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002185s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017396s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051628s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010376s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004490s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005588s ]
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 '00461%' OR `brand` LIKE '00461%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024297s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '00461%' OR `brand` LIKE '00461%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003861s ]