Untitled
unknown
plain_text
a year ago
42 kB
4
Indexable
2|CMS | GET /api/permission/?role=17 304 41.634 ms - -
2|CMS | GET /api/ads/config?page=1&size=10&type=4 200 46.348 ms - 89
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2));
2|CMS | Executing (default): SELECT "id", "nib", "type", "tagline", "name", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2)) ORDER BY "office_agent"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS | GET /api/officeagent?page=1&size=500&type=1,2 304 5.843 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "ads_configs" AS "ads_configs" WHERE "ads_configs"."type" = 4;
2|CMS | Executing (default): SELECT "ads_configs"."id", "ads_configs"."ads_id", "ads_configs"."office_id", "ads_configs"."type", "ads_configs"."project_id", "ads_configs"."agent_id", "ads_configs"."start_date", "ads_configs"."end_date", "ads_configs"."status", "ads_configs"."createdAt", "ads_configs"."updatedAt", "advertise"."id" AS "advertise.id", "advertise"."office_id" AS "advertise.office_id", "advertise"."ads_id" AS "advertise.ads_id", "advertise"."agent_id" AS "advertise.agent_id", "advertise"."project_id" AS "advertise.project_id", "advertise"."rental_type" AS "advertise.rental_type", "advertise"."is_publish" AS "advertise.is_publish", "advertise"."is_highlights" AS "advertise.is_highlights", "advertise"."province_id" AS "advertise.province_id", "advertise"."city_id" AS "advertise.city_id", "advertise"."district_id" AS "advertise.district_id", "advertise"."nib" AS "advertise.nib", "advertise"."location" AS "advertise.location", "advertise"."lat" AS "advertise.lat", "advertise"."long" AS "advertise.long", "advertise"."zip" AS "advertise.zip", "advertise"."regency" AS "advertise.regency", "advertise"."subdistrict" AS "advertise.subdistrict", "advertise"."province" AS "advertise.province", "advertise"."property_type" AS "advertise.property_type", "advertise"."ownership_certificate" AS "advertise.ownership_certificate", "advertise"."listing_type" AS "advertise.listing_type", "advertise"."name" AS "advertise.name", "advertise"."desc" AS "advertise.desc", "advertise"."price" AS "advertise.price", "advertise"."building_type_id" AS "advertise.building_type_id", "advertise"."size_land" AS "advertise.size_land", "advertise"."size_building" AS "advertise.size_building", "advertise"."rooms" AS "advertise.rooms", "advertise"."bathroom" AS "advertise.bathroom", "advertise"."carport" AS "advertise.carport", "advertise"."garage" AS "advertise.garage", "advertise"."electricity" AS "advertise.electricity", "advertise"."highlight_id" AS "advertise.highlight_id", "advertise"."report_desc" AS "advertise.report_desc", "advertise"."user_report" AS "advertise.user_report", "advertise"."unit" AS "advertise.unit", "advertise"."deletedAt" AS "advertise.deletedAt", "advertise"."reason" AS "advertise.reason", "advertise"."exp_heighlight" AS "advertise.exp_heighlight", "advertise"."created_by" AS "advertise.created_by", "advertise"."updated_by" AS "advertise.updated_by", "advertise"."createdAt" AS "advertise.createdAt", "advertise"."updatedAt" AS "advertise.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt", "project"."id" AS "project.id", "project"."province_id" AS "project.province_id", "project"."city_id" AS "project.city_id", "project"."district_id" AS "project.district_id", "project"."park" AS "project.park", "project"."office_id" AS "project.office_id", "project"."agent_id" AS "project.agent_id", "project"."swimming_pool" AS "project.swimming_pool", "project"."gym" AS "project.gym", "project"."image_park" AS "project.image_park", "project"."image_gym" AS "project.image_gym", "project"."image_swimming_pool" AS "project.image_swimming_pool", "project"."image_security" AS "project.image_security", "project"."security" AS "project.security", "project"."lat" AS "project.lat", "project"."long" AS "project.long", "project"."price" AS "project.price", "project"."min_price" AS "project.min_price", "project"."name" AS "project.name", "project"."subdistrict" AS "project.subdistrict", "project"."province" AS "project.province", "project"."city" AS "project.city", "project"."desc" AS "project.desc", "project"."building_type_id" AS "project.building_type_id", "project"."certificate" AS "project.certificate", "project"."unit_available" AS "project.unit_available", "project"."land" AS "project.land", "project"."size_building" AS "project.size_building", "project"."building_date" AS "project.building_date", "project"."file" AS "project.file", "project"."is_active" AS "project.is_active", "project"."video" AS "project.video", "project"."banner" AS "project.banner", "project"."deletedAt" AS "project.deletedAt", "project"."createdAt" AS "project.createdAt", "project"."updatedAt" AS "project.updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt" FROM "ads_configs" AS "ads_configs" LEFT OUTER JOIN "advertises" AS "advertise" ON "ads_configs"."ads_id" = "advertise"."id" LEFT OUTER JOIN "agents" AS "agent" ON "ads_configs"."agent_id" = "agent"."id" LEFT OUTER JOIN "projects" AS "project" ON "ads_configs"."project_id" = "project"."id" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "ads_configs"."office_id" = "office_agent"."id" WHERE "ads_configs"."type" = 4 ORDER BY "ads_configs"."createdAt" DESC LIMIT 10 OFFSET 0;
2|CMS | GET /api/ads/config?page=1&size=10&type=4 304 15.727 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (2));
2|CMS | Executing (default): SELECT "id", "nib", "type", "tagline", "name", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (2)) ORDER BY "office_agent"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS | GET /api/officeagent?page=1&size=500&type=2 200 6.747 ms - 90
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "ads_configs" AS "ads_configs" WHERE "ads_configs"."type" = 3;
2|CMS | Executing (default): SELECT "ads_configs"."id", "ads_configs"."ads_id", "ads_configs"."office_id", "ads_configs"."type", "ads_configs"."project_id", "ads_configs"."agent_id", "ads_configs"."start_date", "ads_configs"."end_date", "ads_configs"."status", "ads_configs"."createdAt", "ads_configs"."updatedAt", "advertise"."id" AS "advertise.id", "advertise"."office_id" AS "advertise.office_id", "advertise"."ads_id" AS "advertise.ads_id", "advertise"."agent_id" AS "advertise.agent_id", "advertise"."project_id" AS "advertise.project_id", "advertise"."rental_type" AS "advertise.rental_type", "advertise"."is_publish" AS "advertise.is_publish", "advertise"."is_highlights" AS "advertise.is_highlights", "advertise"."province_id" AS "advertise.province_id", "advertise"."city_id" AS "advertise.city_id", "advertise"."district_id" AS "advertise.district_id", "advertise"."nib" AS "advertise.nib", "advertise"."location" AS "advertise.location", "advertise"."lat" AS "advertise.lat", "advertise"."long" AS "advertise.long", "advertise"."zip" AS "advertise.zip", "advertise"."regency" AS "advertise.regency", "advertise"."subdistrict" AS "advertise.subdistrict", "advertise"."province" AS "advertise.province", "advertise"."property_type" AS "advertise.property_type", "advertise"."ownership_certificate" AS "advertise.ownership_certificate", "advertise"."listing_type" AS "advertise.listing_type", "advertise"."name" AS "advertise.name", "advertise"."desc" AS "advertise.desc", "advertise"."price" AS "advertise.price", "advertise"."building_type_id" AS "advertise.building_type_id", "advertise"."size_land" AS "advertise.size_land", "advertise"."size_building" AS "advertise.size_building", "advertise"."rooms" AS "advertise.rooms", "advertise"."bathroom" AS "advertise.bathroom", "advertise"."carport" AS "advertise.carport", "advertise"."garage" AS "advertise.garage", "advertise"."electricity" AS "advertise.electricity", "advertise"."highlight_id" AS "advertise.highlight_id", "advertise"."report_desc" AS "advertise.report_desc", "advertise"."user_report" AS "advertise.user_report", "advertise"."unit" AS "advertise.unit", "advertise"."deletedAt" AS "advertise.deletedAt", "advertise"."reason" AS "advertise.reason", "advertise"."exp_heighlight" AS "advertise.exp_heighlight", "advertise"."created_by" AS "advertise.created_by", "advertise"."updated_by" AS "advertise.updated_by", "advertise"."createdAt" AS "advertise.createdAt", "advertise"."updatedAt" AS "advertise.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt", "project"."id" AS "project.id", "project"."province_id" AS "project.province_id", "project"."city_id" AS "project.city_id", "project"."district_id" AS "project.district_id", "project"."park" AS "project.park", "project"."office_id" AS "project.office_id", "project"."agent_id" AS "project.agent_id", "project"."swimming_pool" AS "project.swimming_pool", "project"."gym" AS "project.gym", "project"."image_park" AS "project.image_park", "project"."image_gym" AS "project.image_gym", "project"."image_swimming_pool" AS "project.image_swimming_pool", "project"."image_security" AS "project.image_security", "project"."security" AS "project.security", "project"."lat" AS "project.lat", "project"."long" AS "project.long", "project"."price" AS "project.price", "project"."min_price" AS "project.min_price", "project"."name" AS "project.name", "project"."subdistrict" AS "project.subdistrict", "project"."province" AS "project.province", "project"."city" AS "project.city", "project"."desc" AS "project.desc", "project"."building_type_id" AS "project.building_type_id", "project"."certificate" AS "project.certificate", "project"."unit_available" AS "project.unit_available", "project"."land" AS "project.land", "project"."size_building" AS "project.size_building", "project"."building_date" AS "project.building_date", "project"."file" AS "project.file", "project"."is_active" AS "project.is_active", "project"."video" AS "project.video", "project"."banner" AS "project.banner", "project"."deletedAt" AS "project.deletedAt", "project"."createdAt" AS "project.createdAt", "project"."updatedAt" AS "project.updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt" FROM "ads_configs" AS "ads_configs" LEFT OUTER JOIN "advertises" AS "advertise" ON "ads_configs"."ads_id" = "advertise"."id" LEFT OUTER JOIN "agents" AS "agent" ON "ads_configs"."agent_id" = "agent"."id" LEFT OUTER JOIN "projects" AS "project" ON "ads_configs"."project_id" = "project"."id" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "ads_configs"."office_id" = "office_agent"."id" WHERE "ads_configs"."type" = 3 ORDER BY "ads_configs"."createdAt" DESC LIMIT 10 OFFSET 0;
2|CMS | GET /api/ads/config?page=1&size=10&type=3 200 41.744 ms - 89
2|CMS | Executing (default): SELECT "roles"."id", "roles"."name", "roles"."createdAt", "roles"."updatedAt", "permissions"."id" AS "permissions.id", "permissions"."role_id" AS "permissions.role_id", "permissions"."menu_id" AS "permissions.menu_id", "permissions"."createdAt" AS "permissions.createdAt", "permissions"."updatedAt" AS "permissions.updatedAt", "permissions->menu_role"."id" AS "permissions.menu_role.id", "permissions->menu_role"."name" AS "permissions.menu_role.name", "permissions->menu_role"."type" AS "permissions.menu_role.type", "permissions->menu_role"."position" AS "permissions.menu_role.position", "permissions->menu_role"."parent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 17);
2|CMS | GET /api/permission/?role=17 304 19.351 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3, 4));
2|CMS | Executing (default): SELECT "id", "office_id", "duration_qouta", "office", "image", "pic_name", "phone", "province_id", "city_id", "district_id", "city", "province", "district", "is_priority", "desc", "email", "type_agent", "user_id", "quota", "is_active", "is_trusted", "is_spesialis", "is_gold_seller", "reason", "link", "twitter", "ig", "yt", "fb", "tmp_pwd", "createdAt", "updatedAt", CASE WHEN type_agent = '3' THEN 'Agent Corporate' WHEN type_agent = '4' THEN 'Property Developer' ELSE '-' END AS "type_agent_label" FROM "agents" AS "agents" WHERE ("agents"."type_agent" IN (0, 3, 4)) ORDER BY "agents"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS | GET /api/agent?page=1&size=500&level=3,4 200 29.533 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "ads_configs" AS "ads_configs" WHERE "ads_configs"."type" = 3;
2|CMS | Executing (default): SELECT "ads_configs"."id", "ads_configs"."ads_id", "ads_configs"."office_id", "ads_configs"."type", "ads_configs"."project_id", "ads_configs"."agent_id", "ads_configs"."start_date", "ads_configs"."end_date", "ads_configs"."status", "ads_configs"."createdAt", "ads_configs"."updatedAt", "advertise"."id" AS "advertise.id", "advertise"."office_id" AS "advertise.office_id", "advertise"."ads_id" AS "advertise.ads_id", "advertise"."agent_id" AS "advertise.agent_id", "advertise"."project_id" AS "advertise.project_id", "advertise"."rental_type" AS "advertise.rental_type", "advertise"."is_publish" AS "advertise.is_publish", "advertise"."is_highlights" AS "advertise.is_highlights", "advertise"."province_id" AS "advertise.province_id", "advertise"."city_id" AS "advertise.city_id", "advertise"."district_id" AS "advertise.district_id", "advertise"."nib" AS "advertise.nib", "advertise"."location" AS "advertise.location", "advertise"."lat" AS "advertise.lat", "advertise"."long" AS "advertise.long", "advertise"."zip" AS "advertise.zip", "advertise"."regency" AS "advertise.regency", "advertise"."subdistrict" AS "advertise.subdistrict", "advertise"."province" AS "advertise.province", "advertise"."property_type" AS "advertise.property_type", "advertise"."ownership_certificate" AS "advertise.ownership_certificate", "advertise"."listing_type" AS "advertise.listing_type", "advertise"."name" AS "advertise.name", "advertise"."desc" AS "advertise.desc", "advertise"."price" AS "advertise.price", "advertise"."building_type_id" AS "advertise.building_type_id", "advertise"."size_land" AS "advertise.size_land", "advertise"."size_building" AS "advertise.size_building", "advertise"."rooms" AS "advertise.rooms", "advertise"."bathroom" AS "advertise.bathroom", "advertise"."carport" AS "advertise.carport", "advertise"."garage" AS "advertise.garage", "advertise"."electricity" AS "advertise.electricity", "advertise"."highlight_id" AS "advertise.highlight_id", "advertise"."report_desc" AS "advertise.report_desc", "advertise"."user_report" AS "advertise.user_report", "advertise"."unit" AS "advertise.unit", "advertise"."deletedAt" AS "advertise.deletedAt", "advertise"."reason" AS "advertise.reason", "advertise"."exp_heighlight" AS "advertise.exp_heighlight", "advertise"."created_by" AS "advertise.created_by", "advertise"."updated_by" AS "advertise.updated_by", "advertise"."createdAt" AS "advertise.createdAt", "advertise"."updatedAt" AS "advertise.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt", "project"."id" AS "project.id", "project"."province_id" AS "project.province_id", "project"."city_id" AS "project.city_id", "project"."district_id" AS "project.district_id", "project"."park" AS "project.park", "project"."office_id" AS "project.office_id", "project"."agent_id" AS "project.agent_id", "project"."swimming_pool" AS "project.swimming_pool", "project"."gym" AS "project.gym", "project"."image_park" AS "project.image_park", "project"."image_gym" AS "project.image_gym", "project"."image_swimming_pool" AS "project.image_swimming_pool", "project"."image_security" AS "project.image_security", "project"."security" AS "project.security", "project"."lat" AS "project.lat", "project"."long" AS "project.long", "project"."price" AS "project.price", "project"."min_price" AS "project.min_price", "project"."name" AS "project.name", "project"."subdistrict" AS "project.subdistrict", "project"."province" AS "project.province", "project"."city" AS "project.city", "project"."desc" AS "project.desc", "project"."building_type_id" AS "project.building_type_id", "project"."certificate" AS "project.certificate", "project"."unit_available" AS "project.unit_available", "project"."land" AS "project.land", "project"."size_building" AS "project.size_building", "project"."building_date" AS "project.building_date", "project"."file" AS "project.file", "project"."is_active" AS "project.is_active", "project"."video" AS "project.video", "project"."banner" AS "project.banner", "project"."deletedAt" AS "project.deletedAt", "project"."createdAt" AS "project.createdAt", "project"."updatedAt" AS "project.updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt" FROM "ads_configs" AS "ads_configs" LEFT OUTER JOIN "advertises" AS "advertise" ON "ads_configs"."ads_id" = "advertise"."id" LEFT OUTER JOIN "agents" AS "agent" ON "ads_configs"."agent_id" = "agent"."id" LEFT OUTER JOIN "projects" AS "project" ON "ads_configs"."project_id" = "project"."id" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "ads_configs"."office_id" = "office_agent"."id" WHERE "ads_configs"."type" = 3 ORDER BY "ads_configs"."createdAt" DESC LIMIT 10 OFFSET 0;
2|CMS | GET /api/ads/config?page=1&size=10&type=3 304 15.560 ms - -
2|CMS | Executing (default): SELECT "roles"."id", "roles"."name", "roles"."createdAt", "roles"."updatedAt", "permissions"."id" AS "permissions.id", "permissions"."role_id" AS "permissions.role_id", "permissions"."menu_id" AS "permissions.menu_id", "permissions"."createdAt" AS "permissions.createdAt", "permissions"."updatedAt" AS "permissions.updatedAt", "permissions->menu_role"."id" AS "permissions.menu_role.id", "permissions->menu_role"."name" AS "permissions.menu_role.name", "permissions->menu_role"."type" AS "permissions.menu_role.type", "permissions->menu_role"."position" AS "permissions.menu_role.position", "permissions->menu_role"."parent_id" AS "permissions.menu_role.parent_id", "permissions->menu_role"."icon" AS "permissions.menu_role.icon", "permissions->menu_role"."link" AS "permissions.menu_role.link", "permissions->menu_role"."sort" AS "permissions.menu_role.sort", "permissions->menu_role"."createdAt" AS "permissions.menu_role.createdAt", "permissions->menu_role"."updatedAt" AS "permissions.menu_role.updatedAt" FROM "roles" AS "roles" LEFT OUTER JOIN "permissions" AS "permissions" ON "roles"."id" = "permissions"."role_id" LEFT OUTER JOIN "menu_roles" AS "permissions->menu_role" ON "permissions"."menu_id" = "permissions->menu_role"."id" WHERE ("roles"."id" = 17);
2|CMS | GET /api/permission/?role=17 304 16.682 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2));
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "ads_configs" AS "ads_configs" WHERE "ads_configs"."type" = 4;
2|CMS | Executing (default): SELECT "id", "nib", "type", "tagline", "name", "address", "pic", "phone", "npwp", "email", "image", "desc", "is_official_developer", "is_trusted_developer", "is_trusted_prop_agency", "link", "twitter", "ig", "yt", "fb", "createdAt", "updatedAt" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2)) ORDER BY "office_agent"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS | Executing (default): SELECT "ads_configs"."id", "ads_configs"."ads_id", "ads_configs"."office_id", "ads_configs"."type", "ads_configs"."project_id", "ads_configs"."agent_id", "ads_configs"."start_date", "ads_configs"."end_date", "ads_configs"."status", "ads_configs"."createdAt", "ads_configs"."updatedAt", "advertise"."id" AS "advertise.id", "advertise"."office_id" AS "advertise.office_id", "advertise"."ads_id" AS "advertise.ads_id", "advertise"."agent_id" AS "advertise.agent_id", "advertise"."project_id" AS "advertise.project_id", "advertise"."rental_type" AS "advertise.rental_type", "advertise"."is_publish" AS "advertise.is_publish", "advertise"."is_highlights" AS "advertise.is_highlights", "advertise"."province_id" AS "advertise.province_id", "advertise"."city_id" AS "advertise.city_id", "advertise"."district_id" AS "advertise.district_id", "advertise"."nib" AS "advertise.nib", "advertise"."location" AS "advertise.location", "advertise"."lat" AS "advertise.lat", "advertise"."long" AS "advertise.long", "advertise"."zip" AS "advertise.zip", "advertise"."regency" AS "advertise.regency", "advertise"."subdistrict" AS "advertise.subdistrict", "advertise"."province" AS "advertise.province", "advertise"."property_type" AS "advertise.property_type", "advertise"."ownership_certificate" AS "advertise.ownership_certificate", "advertise"."listing_type" AS "advertise.listing_type", "advertise"."name" AS "advertise.name", "advertise"."desc" AS "advertise.desc", "advertise"."price" AS "advertise.price", "advertise"."building_type_id" AS "advertise.building_type_id", "advertise"."size_land" AS "advertise.size_land", "advertise"."size_building" AS "advertise.size_building", "advertise"."rooms" AS "advertise.rooms", "advertise"."bathroom" AS "advertise.bathroom", "advertise"."carport" AS "advertise.carport", "advertise"."garage" AS "advertise.garage", "advertise"."electricity" AS "advertise.electricity", "advertise"."highlight_id" AS "advertise.highlight_id", "advertise"."report_desc" AS "advertise.report_desc", "advertise"."user_report" AS "advertise.user_report", "advertise"."unit" AS "advertise.unit", "advertise"."deletedAt" AS "advertise.deletedAt", "advertise"."reason" AS "advertise.reason", "advertise"."exp_heighlight" AS "advertise.exp_heighlight", "advertise"."created_by" AS "advertise.created_by", "advertise"."updated_by" AS "advertise.updated_by", "advertise"."createdAt" AS "advertise.createdAt", "advertise"."updatedAt" AS "advertise.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt", "project"."id" AS "project.id", "project"."province_id" AS "project.province_id", "project"."city_id" AS "project.city_id", "project"."district_id" AS "project.district_id", "project"."park" AS "project.park", "project"."office_id" AS "project.office_id", "project"."agent_id" AS "project.agent_id", "project"."swimming_pool" AS "project.swimming_pool", "project"."gym" AS "project.gym", "project"."image_park" AS "project.image_park", "project"."image_gym" AS "project.image_gym", "project"."image_swimming_pool" AS "project.image_swimming_pool", "project"."image_security" AS "project.image_security", "project"."security" AS "project.security", "project"."lat" AS "project.lat", "project"."long" AS "project.long", "project"."price" AS "project.price", "project"."min_price" AS "project.min_price", "project"."name" AS "project.name", "project"."subdistrict" AS "project.subdistrict", "project"."province" AS "project.province", "project"."city" AS "project.city", "project"."desc" AS "project.desc", "project"."building_type_id" AS "project.building_type_id", "project"."certificate" AS "project.certificate", "project"."unit_available" AS "project.unit_available", "project"."land" AS "project.land", "project"."size_building" AS "project.size_building", "project"."building_date" AS "project.building_date", "project"."file" AS "project.file", "project"."is_active" AS "project.is_active", "project"."video" AS "project.video", "project"."banner" AS "project.banner", "project"."deletedAt" AS "project.deletedAt", "project"."createdAt" AS "project.createdAt", "project"."updatedAt" AS "project.updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt" FROM "ads_configs" AS "ads_configs" LEFT OUTER JOIN "advertises" AS "advertise" ON "ads_configs"."ads_id" = "advertise"."id" LEFT OUTER JOIN "agents" AS "agent" ON "ads_configs"."agent_id" = "agent"."id" LEFT OUTER JOIN "projects" AS "project" ON "ads_configs"."project_id" = "project"."id" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "ads_configs"."office_id" = "office_agent"."id" WHERE "ads_configs"."type" = 4 ORDER BY "ads_configs"."createdAt" DESC LIMIT 10 OFFSET 0;
2|CMS | GET /api/officeagent?page=1&size=500&type=1,2 304 12.614 ms - -
2|CMS | GET /api/ads/config?page=1&size=10&type=4 304 13.516 ms - -
2|CMS | Executing (default): SELECT count(*) AS "count" FROM "ads_configs" AS "ads_configs" WHERE "ads_configs"."type" = 4;
2|CMS | Executing (default): SELECT "ads_configs"."id", "ads_configs"."ads_id", "ads_configs"."office_id", "ads_configs"."type", "ads_configs"."project_id", "ads_configs"."agent_id", "ads_configs"."start_date", "ads_configs"."end_date", "ads_configs"."status", "ads_configs"."createdAt", "ads_configs"."updatedAt", "advertise"."id" AS "advertise.id", "advertise"."office_id" AS "advertise.office_id", "advertise"."ads_id" AS "advertise.ads_id", "advertise"."agent_id" AS "advertise.agent_id", "advertise"."project_id" AS "advertise.project_id", "advertise"."rental_type" AS "advertise.rental_type", "advertise"."is_publish" AS "advertise.is_publish", "advertise"."is_highlights" AS "advertise.is_highlights", "advertise"."province_id" AS "advertise.province_id", "advertise"."city_id" AS "advertise.city_id", "advertise"."district_id" AS "advertise.district_id", "advertise"."nib" AS "advertise.nib", "advertise"."location" AS "advertise.location", "advertise"."lat" AS "advertise.lat", "advertise"."long" AS "advertise.long", "advertise"."zip" AS "advertise.zip", "advertise"."regency" AS "advertise.regency", "advertise"."subdistrict" AS "advertise.subdistrict", "advertise"."province" AS "advertise.province", "advertise"."property_type" AS "advertise.property_type", "advertise"."ownership_certificate" AS "advertise.ownership_certificate", "advertise"."listing_type" AS "advertise.listing_type", "advertise"."name" AS "advertise.name", "advertise"."desc" AS "advertise.desc", "advertise"."price" AS "advertise.price", "advertise"."building_type_id" AS "advertise.building_type_id", "advertise"."size_land" AS "advertise.size_land", "advertise"."size_building" AS "advertise.size_building", "advertise"."rooms" AS "advertise.rooms", "advertise"."bathroom" AS "advertise.bathroom", "advertise"."carport" AS "advertise.carport", "advertise"."garage" AS "advertise.garage", "advertise"."electricity" AS "advertise.electricity", "advertise"."highlight_id" AS "advertise.highlight_id", "advertise"."report_desc" AS "advertise.report_desc", "advertise"."user_report" AS "advertise.user_report", "advertise"."unit" AS "advertise.unit", "advertise"."deletedAt" AS "advertise.deletedAt", "advertise"."reason" AS "advertise.reason", "advertise"."exp_heighlight" AS "advertise.exp_heighlight", "advertise"."created_by" AS "advertise.created_by", "advertise"."updated_by" AS "advertise.updated_by", "advertise"."createdAt" AS "advertise.createdAt", "advertise"."updatedAt" AS "advertise.updatedAt", "agent"."id" AS "agent.id", "agent"."office_id" AS "agent.office_id", "agent"."duration_qouta" AS "agent.duration_qouta", "agent"."office" AS "agent.office", "agent"."image" AS "agent.image", "agent"."pic_name" AS "agent.pic_name", "agent"."phone" AS "agent.phone", "agent"."province_id" AS "agent.province_id", "agent"."city_id" AS "agent.city_id", "agent"."district_id" AS "agent.district_id", "agent"."city" AS "agent.city", "agent"."province" AS "agent.province", "agent"."district" AS "agent.district", "agent"."is_priority" AS "agent.is_priority", "agent"."desc" AS "agent.desc", "agent"."email" AS "agent.email", "agent"."type_agent" AS "agent.type_agent", "agent"."user_id" AS "agent.user_id", "agent"."quota" AS "agent.quota", "agent"."is_active" AS "agent.is_active", "agent"."is_trusted" AS "agent.is_trusted", "agent"."is_spesialis" AS "agent.is_spesialis", "agent"."is_gold_seller" AS "agent.is_gold_seller", "agent"."reason" AS "agent.reason", "agent"."link" AS "agent.link", "agent"."twitter" AS "agent.twitter", "agent"."ig" AS "agent.ig", "agent"."yt" AS "agent.yt", "agent"."fb" AS "agent.fb", "agent"."tmp_pwd" AS "agent.tmp_pwd", "agent"."createdAt" AS "agent.createdAt", "agent"."updatedAt" AS "agent.updatedAt", "project"."id" AS "project.id", "project"."province_id" AS "project.province_id", "project"."city_id" AS "project.city_id", "project"."district_id" AS "project.district_id", "project"."park" AS "project.park", "project"."office_id" AS "project.office_id", "project"."agent_id" AS "project.agent_id", "project"."swimming_pool" AS "project.swimming_pool", "project"."gym" AS "project.gym", "project"."image_park" AS "project.image_park", "project"."image_gym" AS "project.image_gym", "project"."image_swimming_pool" AS "project.image_swimming_pool", "project"."image_security" AS "project.image_security", "project"."security" AS "project.security", "project"."lat" AS "project.lat", "project"."long" AS "project.long", "project"."price" AS "project.price", "project"."min_price" AS "project.min_price", "project"."name" AS "project.name", "project"."subdistrict" AS "project.subdistrict", "project"."province" AS "project.province", "project"."city" AS "project.city", "project"."desc" AS "project.desc", "project"."building_type_id" AS "project.building_type_id", "project"."certificate" AS "project.certificate", "project"."unit_available" AS "project.unit_available", "project"."land" AS "project.land", "project"."size_building" AS "project.size_building", "project"."building_date" AS "project.building_date", "project"."file" AS "project.file", "project"."is_active" AS "project.is_active", "project"."video" AS "project.video", "project"."banner" AS "project.banner", "project"."deletedAt" AS "project.deletedAt", "project"."createdAt" AS "project.createdAt", "project"."updatedAt" AS "project.updatedAt", "office_agent"."id" AS "office_agent.id", "office_agent"."nib" AS "office_agent.nib", "office_agent"."type" AS "office_agent.type", "office_agent"."tagline" AS "office_agent.tagline", "office_agent"."name" AS "office_agent.name", "office_agent"."address" AS "office_agent.address", "office_agent"."pic" AS "office_agent.pic", "office_agent"."phone" AS "office_agent.phone", "office_agent"."npwp" AS "office_agent.npwp", "office_agent"."email" AS "office_agent.email", "office_agent"."image" AS "office_agent.image", "office_agent"."desc" AS "office_agent.desc", "office_agent"."is_official_developer" AS "office_agent.is_official_developer", "office_agent"."is_trusted_developer" AS "office_agent.is_trusted_developer", "office_agent"."is_trusted_prop_agency" AS "office_agent.is_trusted_prop_agency", "office_agent"."link" AS "office_agent.link", "office_agent"."twitter" AS "office_agent.twitter", "office_agent"."ig" AS "office_agent.ig", "office_agent"."yt" AS "office_agent.yt", "office_agent"."fb" AS "office_agent.fb", "office_agent"."createdAt" AS "office_agent.createdAt", "office_agent"."updatedAt" AS "office_agent.updatedAt" FROM "ads_configs" AS "ads_configs" LEFT OUTER JOIN "advertises" AS "advertise" ON "ads_configs"."ads_id" = "advertise"."id" LEFT OUTER JOIN "agents" AS "agent" ON "ads_configs"."agent_id" = "agent"."id" LEFT OUTER JOIN "projects" AS "project" ON "ads_configs"."project_id" = "project"."id" LEFT OUTER JOIN "office_agents" AS "office_agent" ON "ads_configs"."office_id" = "office_agent"."id" WHERE "ads_configs"."type" = 4 ORDER BY "ads_configs"."createdAt" DESC LIMIT 10 OFFSET 0;
2|CMS | GET /api/ads/config?page=1&size=10&type=4 304 17.878 ms - -
2|CMS | Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_map", "latitude", "longitude", "population", "zoom_level", "image", "show", "sort", "createdAt", "updatedAt" FROM "master_propinsis" AS "master_propinsi" ORDER BY "master_propinsi"."sort" ASC;
2|CMS | GET /api/getProvince 304 6.280 ms - -
2|CMS | Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "image", "show_project", "show_agent", "lokasi_propinsi", "lokasi_kabupatenkota", "sort", "createdAt", "updatedAt" FROM "master_kabkos" AS "master_kabko" WHERE "master_kabko"."lokasi_propinsi" = 31 ORDER BY "master_kabko"."sort" ASC;
2|CMS | GET /api/getCity/31 304 4.642 ms - -
2|CMS | Executing (default): SELECT "lokasi_id", "lokasi_kode", "lokasi_nama", "lokasi_propinsi", "lokasi_kabupatenkota", "lokasi_kecamatan", "createdAt", "updatedAt" FROM "master_kecamatans" AS "master_kecamatan" WHERE "master_kecamatan"."lokasi_propinsi" = 31 AND "master_kecamatan"."lokasi_kabupatenkota" = 73;
2|CMS | GET /api/getSubdistrict/31/73 304 6.366 ms - -
Editor is loading...
Leave a Comment