Untitled

mail@pastecode.io avatar
unknown
plain_text
20 days ago
11 kB
1
Indexable
Never
2|CMS      | Executing (default): SELECT "id", "name", "is_furnished", "createdAt", "updatedAt" FROM "fasilitas_properties" AS "fasilitas_properties" ORDER BY "fasilitas_properties"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS      | GET /api/fasilitasproperty?page=1&size=500 304 6.677 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      | Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
2|CMS      | Executing (default): SELECT count(*) AS "count" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2));
2|CMS      | GET /api/getProvince 304 6.914 ms - -
2|CMS      | Executing (default): SELECT "id", "name", "icon", "price", "duration", "createdAt", "updatedAt" FROM "highlights" AS "highlights" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
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/highlight?page=1&size=500 304 8.402 ms - -
2|CMS      | GET /api/officeagent?page=1&size=500&type=1,2 304 7.703 ms - -
2|CMS      | Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
2|CMS      | GET /api/company/1 304 4.024 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 "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 200 5.828 ms - 90

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  | 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/getProvince 304 27.410 ms - -
2|CMS  | Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
2|CMS  | GET /api/permission/?role=17 304 40.921 ms - -
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "office_agents" AS "office_agent" WHERE ("office_agent"."type" IN (1, 2));
2|CMS  | GET /api/company/1 304 37.001 ms - -
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "fasilitas_properties" AS "fasilitas_properties";
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "building_types" AS "building_types";
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 "id", "name", "is_furnished", "createdAt", "updatedAt" FROM "fasilitas_properties" AS "fasilitas_properties" ORDER BY "fasilitas_properties"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" ORDER BY "building_types"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
2|CMS  | GET /api/fasilitasproperty?page=1&size=500 304 33.353 ms - -
2|CMS  | GET /api/buildingtype?page=1&size=500 304 35.128 ms - -
2|CMS  | GET /api/officeagent?page=1&size=500&type=1,2 304 48.205 ms - -
2|CMS  | Executing (default): SELECT "id", "name", "icon", "price", "duration", "createdAt", "updatedAt" FROM "highlights" AS "highlights" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | GET /api/highlight?page=1&size=500 304 8.929 ms - -
2|CMS  | Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
2|CMS  | GET /api/company/1 304 4.829 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" = 6);
2|CMS  | GET /api/permission/?role=6 304 14.095 ms - -
2|CMS  | Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
2|CMS  | GET /api/company/1 304 3.963 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 "fasilitas_properties" AS "fasilitas_properties";
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "building_types" AS "building_types";
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 "id", "name", "is_furnished", "createdAt", "updatedAt" FROM "fasilitas_properties" AS "fasilitas_properties" ORDER BY "fasilitas_properties"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | Executing (default): SELECT "id", "name", "createdAt", "updatedAt" FROM "building_types" AS "building_types" ORDER BY "building_types"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | Executing (default): SELECT count(*) AS "count" FROM "highlights" AS "highlights";
2|CMS  | GET /api/buildingtype?page=1&size=500 304 6.212 ms - -
2|CMS  | GET /api/officeagent?page=1&size=500&type=1,2 304 9.998 ms - -
2|CMS  | GET /api/fasilitasproperty?page=1&size=500 304 9.097 ms - -
2|CMS  | Executing (default): SELECT "id", "name", "icon", "price", "duration", "createdAt", "updatedAt" FROM "highlights" AS "highlights" ORDER BY "highlights"."createdAt" DESC LIMIT 500 OFFSET 0;
2|CMS  | GET /api/highlight?page=1&size=500 304 6.062 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 4.898 ms - -
2|CMS  | Executing (default): SELECT "id", "title", "logo", "desc", "email", "phone", "fb", "twitter", "ig", "yt", "linknd", "wa", "tiktok", "icon_wa", "icon_mail", "icon_phone", "createdAt", "updatedAt" FROM "companies" AS "companies" WHERE "companies"."id" = 1;
2|CMS  | GET /api/company/1 304 3.541 ms - -
^C
Leave a Comment