GET http://www.or4.fr/ia-tools/1

Query Metrics

4 Database Queries
4 Different statements
6.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.id = ?
Parameters:
[
  "1"
]
2 1.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.price_model AS price_model_5, t0.website_url AS website_url_6, t0.api_available AS api_available_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.category_id AS category_id_11, t0.subcategory_id AS subcategory_id_12, t13.id AS id_14, t13.introduction AS introduction_15, t13.advantages AS advantages_16, t13.disadvantages AS disadvantages_17, t13.comparisons AS comparisons_18, t13.conclusion AS conclusion_19, t13.created_at AS created_at_20, t13.updated_at AS updated_at_21, t13.ai_tool_id AS ai_tool_id_22 FROM aitool t0 LEFT JOIN ai_article t13 ON t13.ai_tool_id = t0.id WHERE t0.category_id = ? ORDER BY t0.name ASC LIMIT 5
Parameters:
[
  1
]
3 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM aicategroy t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.57 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.ai_tool_id AS ai_tool_id_5, t0.user_id AS user_id_6 FROM aireview t0 WHERE t0.ai_tool_id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\AiTool No errors.
App\Entity\AiCategory No errors.
App\Entity\AiSubcategory No errors.
App\Entity\AiArticle No errors.
App\Entity\AiReview No errors.
App\Entity\User No errors.