SELECT l.*, b.logo_path
FROM xj_rental_listing l
LEFT JOIN xj_dict_item b ON b.id = l.brand_id
WHERE l.status = '1' AND l.target_phone = '' ORDER BY l.published_at DESC NULLS LAST, l.id DESC LIMIT '21' OFFSET '0' [ RunTime:0.001831s ]
SELECT id, type, parent_id, name, value, logo_path
FROM xj_dict_item
WHERE status = 1
ORDER BY type ASC, parent_id ASC, sort_order ASC, id ASC [ RunTime:0.001193s ]
