GET https://docs.statskenya.co.ke/api/public/cms/counties

Query Metrics

49 Database Queries
3 Different statements
168.75 ms Query time
0 Invalid entities
95 Managed entities

Queries

Group similar statements

# Time Info
1 3.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.plan_type AS plan_type_4, t0.tenant_type AS tenant_type_5, t0.industry AS industry_6, t0.checklist_dismissed_at AS checklist_dismissed_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_active AS is_active_10, t0.is_deleted AS is_deleted_11, t0.is_archived AS is_archived_12, t0.deleted_at AS deleted_at_13, t0.archived_at AS archived_at_14 FROM tenants t0 WHERE t0.slug = ? AND ((t0.is_deleted = false)) LIMIT 1
Parameters:
[
  "datum"
]
2 4.57 ms
SELECT c0_.id AS id_0, c0_.legacy_id AS legacy_id_1, c0_.code AS code_2, c0_.name AS name_3, c0_.capital AS capital_4, c0_.about AS about_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.is_active AS is_active_8, c0_.is_deleted AS is_deleted_9, c0_.is_archived AS is_archived_10, c0_.deleted_at AS deleted_at_11, c0_.archived_at AS archived_at_12, c0_.tenant_id AS tenant_id_13 FROM cms_counties c0_ WHERE (c0_.tenant_id = ? AND c0_.is_deleted = false) AND (c0_.is_deleted = false) ORDER BY c0_.name ASC
Parameters:
[
  Symfony\Component\Uid\UuidV7 {#142
    __toString(): "019dcefc-1401-7abe-81fe-e45861d11394"
  }
]
3 6.72 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-75c1-8611-0bd6aa29bed8"
]
4 5.61 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-78a1-8611-0bd6ad69557d"
]
5 5.48 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-79f1-8611-0bd6ae82e969"
]
6 3.32 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7a4d-8611-0bd6aebf5c33"
]
7 3.42 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-727f-beab-593149a93057"
]
8 3.72 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7648-b6c8-e7957f285f62"
]
9 3.14 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7314-b6c8-e7957bd85f6a"
]
10 3.79 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7b69-8611-0bd6b028e820"
]
11 3.57 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-74cc-b6c8-e7957d6d4d2f"
]
12 3.42 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-77e1-8611-0bd6acb4507d"
]
13 3.73 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7905-8611-0bd6adad8f20"
]
14 3.39 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7841-8611-0bd6ad59c248"
]
15 5.48 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7f28-b6c8-e79582e0b17c"
]
16 2.55 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07a-7f2b-b1a7-4b994e3259b8"
]
17 2.52 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7ddc-b6c8-e79581bd85e2"
]
18 3.78 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7c2d-8611-0bd6b16e6c03"
]
19 4.01 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7b09-8611-0bd6af8b2cbe"
]
20 2.68 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-76c4-b6c8-e7957fb64920"
]
21 2.45 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07a-7cbf-b1a7-4b994dc4b2fb"
]
22 2.38 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-766d-8611-0bd6ab0ea4f3"
]
23 2.68 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7200-b6c8-e7957bcd7cfb"
]
24 1.96 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7728-b6c8-e7957fea86d4"
]
25 1.91 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7794-b6c8-e79580023ea1"
]
26 1.97 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-73f0-b6c8-e7957c302d85"
]
27 2.11 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7460-b6c8-e7957c8aa31d"
]
28 1.87 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7568-b6c8-e7957e35a4e4"
]
29 4.51 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7bc5-8611-0bd6b098ebd8"
]
30 7.37 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07a-7a03-b1a7-4b994cca5751"
]
31 2.98 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7e9c-b6c8-e795822d2c91"
]
32 5.12 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7ce1-8611-0bd6b2eee2b9"
]
33 3.92 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-76f1-8611-0bd6abfb5439"
]
34 6.73 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7459-8611-0bd6a991ffcd"
]
35 5.31 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7775-8611-0bd6ac6de48b"
]
36 4.62 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7c8d-8611-0bd6b22abf41"
]
37 2.36 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-77f0-b6c8-e79580a34caf"
]
38 2.09 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7c2c-b6c8-e795818774e1"
]
39 2.70 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-7107-beab-5931483502e0"
]
40 3.67 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7aad-8611-0bd6aecdbb6e"
]
41 3.41 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7294-b6c8-e7957bd59aa5"
]
42 3.48 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-70c0-b6c8-e7957b8460b4"
]
43 2.63 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-75dc-b6c8-e7957ee75f30"
]
44 1.98 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-71a3-beab-5931491f6b3a"
]
45 2.13 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-700b-beab-593146da09c6"
]
46 1.73 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-720f-beab-593149356a3c"
]
47 3.00 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07d-7965-8611-0bd6ae18f336"
]
48 2.09 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07b-7380-b6c8-e7957be10352"
]
49 1.38 ms
SELECT t0.id AS id_1, t0.legacy_id AS legacy_id_2, t0.info AS info_3, t0.image1_url AS image1_url_4, t0.image2_url AS image2_url_5, t0.image3_url AS image3_url_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.hit_count AS hit_count_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_active AS is_active_13, t0.is_deleted AS is_deleted_14, t0.is_archived AS is_archived_15, t0.deleted_at AS deleted_at_16, t0.archived_at AS archived_at_17, t0.county_id AS county_id_18, t0.tenant_id AS tenant_id_19 FROM cms_county_information t0 WHERE t0.county_id = ? AND ((t0.is_deleted = false))
Parameters:
[
  "019e018e-c07c-7093-beab-593147b78d28"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\County 47
App\Entity\CountyInformation 47
App\Entity\Tenant 1

Entities Mapping

Class Mapping errors
App\Entity\Tenant No errors.
App\Entity\TenantMembership No errors.
App\Entity\County No errors.
App\Entity\CountyInformation No errors.
App\Entity\Article No errors.