应用范围   >>  食品饮料工业
QUERYERRNORESULTRUNTIME
USE a0328101644000 ms
SET NAMES utf80 00.0023 ms
SELECT eb_category.* FROM `eb_category` WHERE parentId=37 ORDER BY `eb_category`.`displayOrder` DESC, `eb_category`.`id` DESC 0 00.0019 ms
SELECT eb_category.* FROM `eb_category` WHERE parentId=20 ORDER BY `eb_category`.`displayOrder` asc LIMIT 0,7 0 70.0019 ms
SELECT eb_config.* FROM `eb_config` WHERE id = 1 LIMIT 0,1 0 10.0018 ms
SELECT eb_area.* FROM `eb_area` WHERE viewStatus=1 and categoryId=33 ORDER BY `eb_area`.`displayOrder` , `eb_area`.`createDate` desc LIMIT 0,15 0 50.0033 ms
SELECT count(*) ResultCount FROM `eb_area` WHERE viewStatus=1 and categoryId=33 ORDER BY `eb_area`.`displayOrder` , `eb_area`.`createDate` desc 0 10.002 ms
SELECT eb_category.* FROM `eb_category` WHERE lefter=1 ORDER BY `eb_category`.`displayOrder` asc LIMIT 0,4 0 40.0017 ms
SELECT eb_category.* FROM `eb_category` WHERE parentId=24 ORDER BY `eb_category`.`displayOrder` asc 0 90.0017 ms
SELECT eb_category.* FROM `eb_category` WHERE id=24 ORDER BY `eb_category`.`displayOrder` asc LIMIT 0,1 0 10.0018 ms
SELECT eb_category.* FROM `eb_category` WHERE id=33 ORDER BY `eb_category`.`displayOrder` asc LIMIT 0,1 0 10.0025 ms
SELECT eb_ad.* FROM `eb_ad` WHERE id = 12 LIMIT 0,1 0 10.0019 ms
Total ProcessTime:0.0229 ms