SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001748s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093857s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.031708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16641170 LIMIT 5 [ RunTime:0.010526s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16641170 ORDER BY `minOrder` ASC [ RunTime:0.029918s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16641170 ORDER BY `unit` DESC [ RunTime:0.050699s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16641170 LIMIT 2 [ RunTime:0.013368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16641170 ORDER BY `minOrder` ASC [ RunTime:0.045506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16640771 LIMIT 5 [ RunTime:0.055402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16640771 ORDER BY `minOrder` ASC [ RunTime:0.073714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16640771 ORDER BY `unit` DESC [ RunTime:0.016757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16640771 LIMIT 2 [ RunTime:0.044771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16640771 ORDER BY `minOrder` ASC [ RunTime:0.031783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16640149 LIMIT 5 [ RunTime:0.060153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16640149 ORDER BY `minOrder` ASC [ RunTime:0.026375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16640149 ORDER BY `unit` DESC [ RunTime:0.042281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16640149 LIMIT 2 [ RunTime:0.038751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16640149 ORDER BY `minOrder` ASC [ RunTime:0.033794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14776580 LIMIT 5 [ RunTime:0.022840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14776580 ORDER BY `minOrder` ASC [ RunTime:0.014274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14776580 ORDER BY `unit` DESC [ RunTime:0.024120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14776580 LIMIT 2 [ RunTime:0.012584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14776580 ORDER BY `minOrder` ASC [ RunTime:0.019941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13882824 LIMIT 5 [ RunTime:0.023508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13882824 ORDER BY `minOrder` ASC [ RunTime:0.006333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13882824 ORDER BY `unit` DESC [ RunTime:0.014323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13882824 LIMIT 2 [ RunTime:0.014539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13882824 ORDER BY `minOrder` ASC [ RunTime:0.007530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13882086 LIMIT 5 [ RunTime:0.105203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13882086 ORDER BY `minOrder` ASC [ RunTime:0.027519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13882086 ORDER BY `unit` DESC [ RunTime:0.091178s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13882086 LIMIT 2 [ RunTime:0.079596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13882086 ORDER BY `minOrder` ASC [ RunTime:0.042593s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052003s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64348878 LIMIT 5 [ RunTime:0.012299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64348878 ORDER BY `minOrder` ASC [ RunTime:0.016251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64348878 ORDER BY `unit` DESC [ RunTime:0.004852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64348878 LIMIT 2 [ RunTime:0.009661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64348878 ORDER BY `minOrder` ASC [ RunTime:0.025419s ]
select * from pdf where partno='REC3-0512DRW/H2/C/M/SMD' and brandshort='Recom Power' limit 1 [ RunTime:0.011658s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002266s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/M/SMD' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.000415s ]
SELECT `id` FROM `stock` WHERE `id` <> 64348878 AND `partno` = 'REC3-0512DRW/H2/C/M/SMD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.004193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14776580 [ RunTime:0.011572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64348294 LIMIT 5 [ RunTime:0.010565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64348294 ORDER BY `minOrder` ASC [ RunTime:0.001725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64348294 ORDER BY `unit` DESC [ RunTime:0.002230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64348294 LIMIT 2 [ RunTime:0.018182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64348294 ORDER BY `minOrder` ASC [ RunTime:0.017821s ]
select * from pdf where partno='REC3-0512DRW/H2/C/M/SMD-R' and brandshort='Recom Power' limit 1 [ RunTime:0.019208s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/M/SMD-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.019639s ]
SELECT `id` FROM `stock` WHERE `id` <> 64348294 AND `partno` = 'REC3-0512DRW/H2/C/M/SMD-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.008445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16641170 [ RunTime:0.020467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64347652 LIMIT 5 [ RunTime:0.019422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64347652 ORDER BY `minOrder` ASC [ RunTime:0.010713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64347652 ORDER BY `unit` DESC [ RunTime:0.017423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64347652 LIMIT 2 [ RunTime:0.020010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64347652 ORDER BY `minOrder` ASC [ RunTime:0.007486s ]
select * from pdf where partno='REC3-0512DRW/H2/C/SMD' and brandshort='Recom Power' limit 1 [ RunTime:0.014306s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/SMD' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.014233s ]
SELECT `id` FROM `stock` WHERE `id` <> 64347652 AND `partno` = 'REC3-0512DRW/H2/C/SMD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.024192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13882824 [ RunTime:0.028147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64347046 LIMIT 5 [ RunTime:0.062934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64347046 ORDER BY `minOrder` ASC [ RunTime:0.033801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64347046 ORDER BY `unit` DESC [ RunTime:0.023050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64347046 LIMIT 2 [ RunTime:0.052084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64347046 ORDER BY `minOrder` ASC [ RunTime:0.016824s ]
select * from pdf where partno='REC3-0512DRW/H2/C/SMD-R' and brandshort='Recom Power' limit 1 [ RunTime:0.029154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/SMD-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.030236s ]
SELECT `id` FROM `stock` WHERE `id` <> 64347046 AND `partno` = 'REC3-0512DRW/H2/C/SMD-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.029546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16640771 [ RunTime:0.067180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64345311 LIMIT 5 [ RunTime:0.026838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64345311 ORDER BY `minOrder` ASC [ RunTime:0.028071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64345311 ORDER BY `unit` DESC [ RunTime:0.015416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64345311 LIMIT 2 [ RunTime:0.048721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64345311 ORDER BY `minOrder` ASC [ RunTime:0.011621s ]
select * from pdf where partno='REC3-0512DRW/H2/C' and brandshort='Recom Power' limit 1 [ RunTime:0.041921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.031619s ]
SELECT `id` FROM `stock` WHERE `id` <> 64345311 AND `partno` = 'REC3-0512DRW/H2/C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.027882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13882086 [ RunTime:0.021482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50537637 LIMIT 5 [ RunTime:0.020761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50537637 ORDER BY `minOrder` ASC [ RunTime:0.034923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50537637 ORDER BY `unit` DESC [ RunTime:0.033331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50537637 LIMIT 2 [ RunTime:0.041570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50537637 ORDER BY `minOrder` ASC [ RunTime:0.018249s ]
select * from pdf where partno='REC3-0512DRW/H2/C/M' and brandshort='Recom Power' limit 1 [ RunTime:0.013497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/M' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.019508s ]
SELECT `id` FROM `stock` WHERE `id` <> 50537637 AND `partno` = 'REC3-0512DRW/H2/C/M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.019776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16640149 [ RunTime:0.067533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37770924 LIMIT 5 [ RunTime:0.035922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37770924 ORDER BY `minOrder` ASC [ RunTime:0.024804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37770924 ORDER BY `unit` DESC [ RunTime:0.019713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37770924 LIMIT 2 [ RunTime:0.042447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37770924 ORDER BY `minOrder` ASC [ RunTime:0.001646s ]
select * from pdf where partno='REC3-0512DRW/H2/C/M' and brandshort='Recom Power' limit 1 [ RunTime:0.009272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'REC3-0512DRW/H2/C/M' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.009045s ]
SELECT `id` FROM `stock` WHERE `id` <> 37770924 AND `partno` = 'REC3-0512DRW/H2/C/M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.015402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16640149 [ RunTime:0.013558s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010142s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012297s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022053s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010545s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010753s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020299s ]
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 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028829s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'REC3-0512DRW/H2/C%' OR `brand` LIKE 'REC3-0512DRW/H2/C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.044402s ]