SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001636s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017882s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410359 LIMIT 5 [ RunTime:0.011086s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410359 ORDER BY `minOrder` ASC [ RunTime:0.010713s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410359 ORDER BY `unit` DESC [ RunTime:0.004382s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410359 LIMIT 2 [ RunTime:0.009592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410359 ORDER BY `minOrder` ASC [ RunTime:0.001839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410131 LIMIT 5 [ RunTime:0.016743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410131 ORDER BY `minOrder` ASC [ RunTime:0.053220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16410131 ORDER BY `unit` DESC [ RunTime:0.049053s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16410131 LIMIT 2 [ RunTime:0.022345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16410131 ORDER BY `minOrder` ASC [ RunTime:0.025016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384558 LIMIT 5 [ RunTime:0.046363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384558 ORDER BY `minOrder` ASC [ RunTime:0.035434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14384558 ORDER BY `unit` DESC [ RunTime:0.010328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14384558 LIMIT 2 [ RunTime:0.058765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384558 ORDER BY `minOrder` ASC [ RunTime:0.026743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384489 LIMIT 5 [ RunTime:0.045301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384489 ORDER BY `minOrder` ASC [ RunTime:0.031894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14384489 ORDER BY `unit` DESC [ RunTime:0.027453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14384489 LIMIT 2 [ RunTime:0.066957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14384489 ORDER BY `minOrder` ASC [ RunTime:0.007344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825422 LIMIT 5 [ RunTime:0.025917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825422 ORDER BY `minOrder` ASC [ RunTime:0.036628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13825422 ORDER BY `unit` DESC [ RunTime:0.015516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13825422 LIMIT 2 [ RunTime:0.033486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13825422 ORDER BY `minOrder` ASC [ RunTime:0.025979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13511295 LIMIT 5 [ RunTime:0.024591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13511295 ORDER BY `minOrder` ASC [ RunTime:0.032619s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13511295 ORDER BY `unit` DESC [ RunTime:0.007219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13511295 LIMIT 2 [ RunTime:0.030179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13511295 ORDER BY `minOrder` ASC [ RunTime:0.008960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510940 LIMIT 5 [ RunTime:0.014675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510940 ORDER BY `minOrder` ASC [ RunTime:0.022421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13510940 ORDER BY `unit` DESC [ RunTime:0.007883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13510940 LIMIT 2 [ RunTime:0.009376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510940 ORDER BY `minOrder` ASC [ RunTime:0.003910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510841 LIMIT 5 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510841 ORDER BY `minOrder` ASC [ RunTime:0.019421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13510841 ORDER BY `unit` DESC [ RunTime:0.030418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13510841 LIMIT 2 [ RunTime:0.021701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13510841 ORDER BY `minOrder` ASC [ RunTime:0.006401s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51137339 LIMIT 5 [ RunTime:0.042572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137339 ORDER BY `minOrder` ASC [ RunTime:0.029065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51137339 ORDER BY `unit` DESC [ RunTime:0.029243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51137339 LIMIT 2 [ RunTime:0.040655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51137339 ORDER BY `minOrder` ASC [ RunTime:0.012186s ]
select * from pdf where partno='tfc2002' and brandshort='l-com' limit 1 [ RunTime:0.025377s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tfc2002' OR `brand` LIKE 'l-com%' ) ) LIMIT 1 [ RunTime:0.052565s ]
SELECT `id` FROM `stock` WHERE `id` <> 51137339 AND `partno` = 'tfc2002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.025652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384558 [ RunTime:0.005047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32207747 LIMIT 5 [ RunTime:0.035385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207747 ORDER BY `minOrder` ASC [ RunTime:0.027752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32207747 ORDER BY `unit` DESC [ RunTime:0.015739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32207747 LIMIT 2 [ RunTime:0.013391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207747 ORDER BY `minOrder` ASC [ RunTime:0.001978s ]
select * from pdf where partno='tfc2004' and brandshort='l-com' limit 1 [ RunTime:0.039753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tfc2004' OR `brand` LIKE 'l-com%' ) ) LIMIT 1 [ RunTime:0.021768s ]
SELECT `id` FROM `stock` WHERE `id` <> 32207747 AND `partno` = 'tfc2004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.070114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384489 [ RunTime:0.042879s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63006783 LIMIT 5 [ RunTime:0.050763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006783 ORDER BY `minOrder` ASC [ RunTime:0.004601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63006783 ORDER BY `unit` DESC [ RunTime:0.007401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63006783 LIMIT 2 [ RunTime:0.030864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63006783 ORDER BY `minOrder` ASC [ RunTime:0.024370s ]
select * from pdf where partno='TFC2002' and brandshort='L-com' limit 1 [ RunTime:0.007271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2002' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.008504s ]
SELECT `id` FROM `stock` WHERE `id` <> 63006783 AND `partno` = 'TFC2002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.016646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384558 [ RunTime:0.005288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63037533 LIMIT 5 [ RunTime:0.033080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63037533 ORDER BY `minOrder` ASC [ RunTime:0.056589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63037533 ORDER BY `unit` DESC [ RunTime:0.052147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63037533 LIMIT 2 [ RunTime:0.046803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63037533 ORDER BY `minOrder` ASC [ RunTime:0.005324s ]
select * from pdf where partno='TFC2006' and brandshort='L-com' limit 1 [ RunTime:0.040474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2006' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.048380s ]
SELECT `id` FROM `stock` WHERE `id` <> 63037533 AND `partno` = 'TFC2006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.014219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410359 [ RunTime:0.041804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63036313 LIMIT 5 [ RunTime:0.007473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63036313 ORDER BY `minOrder` ASC [ RunTime:0.028099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63036313 ORDER BY `unit` DESC [ RunTime:0.003963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63036313 LIMIT 2 [ RunTime:0.012573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63036313 ORDER BY `minOrder` ASC [ RunTime:0.022542s ]
select * from pdf where partno='TFC2004-500' and brandshort='L-com' limit 1 [ RunTime:0.014119s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2004-500' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.033334s ]
SELECT `id` FROM `stock` WHERE `id` <> 63036313 AND `partno` = 'TFC2004-500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.016920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16410131 [ RunTime:0.032646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63033850 LIMIT 5 [ RunTime:0.024686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63033850 ORDER BY `minOrder` ASC [ RunTime:0.025519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63033850 ORDER BY `unit` DESC [ RunTime:0.053646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63033850 LIMIT 2 [ RunTime:0.026087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63033850 ORDER BY `minOrder` ASC [ RunTime:0.002337s ]
select * from pdf where partno='TFC2006-500' and brandshort='L-com' limit 1 [ RunTime:0.012850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2006-500' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.050659s ]
SELECT `id` FROM `stock` WHERE `id` <> 63033850 AND `partno` = 'TFC2006-500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.058698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13511295 [ RunTime:0.021036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63032564 LIMIT 5 [ RunTime:0.033229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63032564 ORDER BY `minOrder` ASC [ RunTime:0.025255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63032564 ORDER BY `unit` DESC [ RunTime:0.001894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63032564 LIMIT 2 [ RunTime:0.024008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63032564 ORDER BY `minOrder` ASC [ RunTime:0.007500s ]
select * from pdf where partno='TFC2004-100' and brandshort='L-com' limit 1 [ RunTime:0.031038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2004-100' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.035112s ]
SELECT `id` FROM `stock` WHERE `id` <> 63032564 AND `partno` = 'TFC2004-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.033747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510940 [ RunTime:0.046695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63032265 LIMIT 5 [ RunTime:0.021094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63032265 ORDER BY `minOrder` ASC [ RunTime:0.045552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63032265 ORDER BY `unit` DESC [ RunTime:0.010507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63032265 LIMIT 2 [ RunTime:0.035445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63032265 ORDER BY `minOrder` ASC [ RunTime:0.016496s ]
select * from pdf where partno='TFC2006-100' and brandshort='L-com' limit 1 [ RunTime:0.044844s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2006-100' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.034811s ]
SELECT `id` FROM `stock` WHERE `id` <> 63032265 AND `partno` = 'TFC2006-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.043467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13510841 [ RunTime:0.024442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63010407 LIMIT 5 [ RunTime:0.020721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63010407 ORDER BY `minOrder` ASC [ RunTime:0.038650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63010407 ORDER BY `unit` DESC [ RunTime:0.013147s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63010407 LIMIT 2 [ RunTime:0.092708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63010407 ORDER BY `minOrder` ASC [ RunTime:0.017529s ]
select * from pdf where partno='TFC2004' and brandshort='L-com' limit 1 [ RunTime:0.050052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC2004' OR `brand` LIKE 'L-com%' ) ) LIMIT 1 [ RunTime:0.039530s ]
SELECT `id` FROM `stock` WHERE `id` <> 63010407 AND `partno` = 'TFC2004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%l-com%' ) [ RunTime:0.098197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14384489 [ RunTime:0.012469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58246493 LIMIT 5 [ RunTime:0.047652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246493 ORDER BY `minOrder` ASC [ RunTime:0.033743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58246493 ORDER BY `unit` DESC [ RunTime:0.025204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58246493 LIMIT 2 [ RunTime:0.085292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58246493 ORDER BY `minOrder` ASC [ RunTime:0.057612s ]
select * from pdf where partno='TFC200' and brandshort='Eaton - Bussmann Electrical Division' limit 1 [ RunTime:0.003557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TFC200' OR `brand` LIKE 'Eaton - Bussmann Electrical Division%' ) ) LIMIT 1 [ RunTime:0.045197s ]
SELECT `id` FROM `stock` WHERE `id` <> 58246493 AND `partno` = 'TFC200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - bussmann electrical division%' ) [ RunTime:0.044305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13825422 [ RunTime:0.010486s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037189s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058022s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079289s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037027s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.058207s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059148s ]
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 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018513s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TFC200%' OR `brand` LIKE 'TFC200%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.048031s ]