GET https://www.mcc.gov.mg/

Query Metrics

13 Database Queries
4 Different statements
8.35 ms Query time
0 Invalid entities
910 Managed entities

Queries

Group similar statements

# Time Info
1 0.50 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.title = ?
Parameters:
[
  "Slides"
]
2 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.title = ?
Parameters:
[
  "Actualités"
]
3 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.title = ?
Parameters:
[
  "Conseil"
]
4 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.title = ?
Parameters:
[
  "Communication"
]
5 0.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.parent_id AS parent_id_6 FROM category t0 WHERE t0.title = ?
Parameters:
[
  "Culture"
]
6 0.17 ms
SELECT m0_.id AS id_0, m0_.firstname AS firstname_1, m0_.lastname AS lastname_2, m0_.photo AS photo_3, m0_.start_date AS start_date_4, m0_.end_date AS end_date_5, m0_.created_at AS created_at_6, m0_.content AS content_7 FROM ministre m0_ ORDER BY m0_.id DESC LIMIT 1
Parameters:
[]
7 1.47 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
  "Mission"
]
8 1.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 WHERE t0.title = ? LIMIT 1
Parameters:
[
  "Organigramme"
]
9 0.30 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 INNER JOIN article_category ON t0.id = article_category.article_id WHERE article_category.category_id = ?
Parameters:
[
  6
]
10 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 INNER JOIN article_category ON t0.id = article_category.article_id WHERE article_category.category_id = ?
Parameters:
[
  4
]
11 0.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 INNER JOIN article_category ON t0.id = article_category.article_id WHERE article_category.category_id = ?
Parameters:
[
  2
]
12 1.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 INNER JOIN article_category ON t0.id = article_category.article_id WHERE article_category.category_id = ?
Parameters:
[
  3
]
13 1.81 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.publish_date AS publish_date_4, t0.created_at AS created_at_5, t0.publish AS publish_6, t0.image AS image_7, t0.author_id AS author_id_8 FROM article t0 INNER JOIN article_category ON t0.id = article_category.article_id WHERE article_category.category_id = ?
Parameters:
[
  5
]

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\Article\Article 903
App\Entity\Article\Category 5
App\Entity\Direction\Ministre 1
App\Entity\Backend\User\User 1

Entities Mapping