扫码关注IPFM了解展会动态获取行业资讯
exhibits
appends
scopes
paginator
elements
obLevel
__env
app
errors
pageGlobal
__currentLoopData
scope
loop
item
index
navigation
navFooter
select * from `pages_global` where `pages_global`.`id` = '1' limit 1
SELECT *
LIMIT
ORDER BY
select * from `navigation` where `lang` = 'zh-CN' and `seo` = '/exhibitors' and `url` = '/exhibits' limit 1
select * from `navigation` where `navigation`.`id` = '27' limit 1
select * from `navigation` where `navigation`.`id` = '16' limit 1
select `id`, `name_zh` as `name`, `parent_id`, `priority` from `ex_scope` order by `priority` desc, `id` asc
SELECT
WHERE
select count(*) as aggregate from `exhibits` as `ts` left join `ex_apply` as `a` on `ts`.`apply_id` = `a`.`id` where `ts`.`type` = '1' and `ts`.`is_show` = '1' and `a`.`status` = '1'
select `ts`.`id`, `ts`.`name_zh` as `name`, `a`.`company_zh` as `company`, `a`.`booth_no`, `ts`.`cover` from `exhibits` as `ts` left join `ex_apply` as `a` on `ts`.`apply_id` = `a`.`id` where `ts`.`type` = '1' and `ts`.`is_show` = '1' and `a`.`status` = '1' order by `a`.`id` desc limit 20 offset 340
select * from `navigation` where `lang` = 'zh-CN' and `footer` = '1' order by `priority` desc