SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002089s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023608s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637925 LIMIT 5 [ RunTime:0.025568s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637925 ORDER BY `minOrder` ASC [ RunTime:0.033004s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16637925 ORDER BY `unit` DESC [ RunTime:0.047699s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16637925 LIMIT 2 [ RunTime:0.091477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16637925 ORDER BY `minOrder` ASC [ RunTime:0.121036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772334 LIMIT 5 [ RunTime:0.075283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772334 ORDER BY `minOrder` ASC [ RunTime:0.016245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14772334 ORDER BY `unit` DESC [ RunTime:0.058817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14772334 LIMIT 2 [ RunTime:0.202673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14772334 ORDER BY `minOrder` ASC [ RunTime:0.039802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771933 LIMIT 5 [ RunTime:0.104321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771933 ORDER BY `minOrder` ASC [ RunTime:0.228006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14771933 ORDER BY `unit` DESC [ RunTime:0.052436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14771933 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14771933 ORDER BY `minOrder` ASC [ RunTime:0.020261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879458 LIMIT 5 [ RunTime:0.165402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879458 ORDER BY `minOrder` ASC [ RunTime:0.082234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13879458 ORDER BY `unit` DESC [ RunTime:0.063576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13879458 LIMIT 2 [ RunTime:0.057633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13879458 ORDER BY `minOrder` ASC [ RunTime:0.027850s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.145488s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57529142 LIMIT 5 [ RunTime:0.137155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529142 ORDER BY `minOrder` ASC [ RunTime:0.107406s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57529142 ORDER BY `unit` DESC [ RunTime:0.084876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57529142 LIMIT 2 [ RunTime:0.042652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57529142 ORDER BY `minOrder` ASC [ RunTime:0.004527s ]
select * from pdf where partno='R0.25D12-1224/HP' and brandshort='Recom Power' limit 1 [ RunTime:0.030479s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-1224/HP' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.103029s ]
SELECT `id` FROM `stock` WHERE `id` <> 57529142 AND `partno` = 'R0.25D12-1224/HP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.051533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13879458 [ RunTime:0.065335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57528829 LIMIT 5 [ RunTime:0.060009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528829 ORDER BY `minOrder` ASC [ RunTime:0.068295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57528829 ORDER BY `unit` DESC [ RunTime:0.110714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57528829 LIMIT 2 [ RunTime:0.039590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57528829 ORDER BY `minOrder` ASC [ RunTime:0.158950s ]
select * from pdf where partno='R0.25D12-1224/HP-R' and brandshort='Recom Power' limit 1 [ RunTime:0.112981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-1224/HP-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.066878s ]
SELECT `id` FROM `stock` WHERE `id` <> 57528829 AND `partno` = 'R0.25D12-1224/HP-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.287319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16637925 [ RunTime:0.052125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57527344 LIMIT 5 [ RunTime:0.130206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57527344 ORDER BY `minOrder` ASC [ RunTime:0.078299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57527344 ORDER BY `unit` DESC [ RunTime:0.125772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57527344 LIMIT 2 [ RunTime:0.168071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57527344 ORDER BY `minOrder` ASC [ RunTime:0.098382s ]
select * from pdf where partno='R0.25D12-1224/H' and brandshort='Recom Power' limit 1 [ RunTime:0.052628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-1224/H' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.076812s ]
SELECT `id` FROM `stock` WHERE `id` <> 57527344 AND `partno` = 'R0.25D12-1224/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.055116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14771933 [ RunTime:0.209209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57526532 LIMIT 5 [ RunTime:0.024674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526532 ORDER BY `minOrder` ASC [ RunTime:0.048236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57526532 ORDER BY `unit` DESC [ RunTime:0.037701s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57526532 LIMIT 2 [ RunTime:0.060817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57526532 ORDER BY `minOrder` ASC [ RunTime:0.035977s ]
select * from pdf where partno='R0.25D12-1224/H-R' and brandshort='Recom Power' limit 1 [ RunTime:0.018137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'R0.25D12-1224/H-R' OR `brand` LIKE 'Recom Power%' ) ) LIMIT 1 [ RunTime:0.018472s ]
SELECT `id` FROM `stock` WHERE `id` <> 57526532 AND `partno` = 'R0.25D12-1224/H-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%recom power%' ) [ RunTime:0.123372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14772334 [ RunTime:0.077107s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034475s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047388s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049235s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052015s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045084s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030617s ]
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 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033228s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'R0.25D12-1224/H%' OR `brand` LIKE 'R0.25D12-1224/H%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034517s ]