https://smartfocus.ma/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CDefaultController%253A%253AfooterLinkAction

Method
GET
HTTP Status
200
IP
2600:1f28:365:80b0:71e9:e723:c58e:17f
Profiled on
Token
376504

Query Metrics

19 Database Queries
5 Different statements
9.28 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 5.67 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.published = ? ORDER BY t0.forder ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2 0.42 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ? AND t0.published = ?
Parameters: 
[
  "Coordonnées"
  1
]
View formatted query    View runnable query    Explain query
3 0.31 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ? AND t0.published = ?
Parameters: 
[
  "Réseaux sociaux"
  1
]
View formatted query    View runnable query    Explain query
4 0.29 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7 FROM hs_tc_formation_category t0 WHERE t0.published = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5 0.18 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
6 0.15 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
7 0.14 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
8 0.12 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
9 0.12 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
10 0.11 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
11 0.10 ms 
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.category_id = ?
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
12 0.22 ms 
SELECT t0.title AS title_1, t0.url AS url_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7, t0.training_id AS training_id_8, t0.activity_id AS activity_id_9 FROM image t0 WHERE t0.activity_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
13 0.15 ms 
SELECT t0.title AS title_1, t0.url AS url_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7, t0.training_id AS training_id_8, t0.activity_id AS activity_id_9 FROM image t0 WHERE t0.activity_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
14 0.12 ms 
SELECT t0.title AS title_1, t0.url AS url_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7, t0.training_id AS training_id_8, t0.activity_id AS activity_id_9 FROM image t0 WHERE t0.activity_id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
15 0.13 ms 
SELECT t0.title AS title_1, t0.url AS url_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7, t0.training_id AS training_id_8, t0.activity_id AS activity_id_9 FROM image t0 WHERE t0.activity_id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
16 0.12 ms 
SELECT t0.title AS title_1, t0.url AS url_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7, t0.training_id AS training_id_8, t0.activity_id AS activity_id_9 FROM image t0 WHERE t0.activity_id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
17 0.30 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ? AND t0.published = ?
Parameters: 
[
  "Coordonnées"
  1
]
View formatted query    View runnable query    Explain query
18 0.30 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ? AND t0.published = ?
Parameters: 
[
  "Réseaux sociaux"
  1
]
View formatted query    View runnable query    Explain query
19 0.33 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.id AS id_3, t0.create_at AS create_at_4, t0.published AS published_5, t0.published_at AS published_at_6, t0.docs AS docs_7 FROM hs_tc_formation_category t0 WHERE t0.published = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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\Formation\Activity No errors.
App\Entity\Formation\Category No errors.
App\Entity\Formation\Domaine No errors.
App\Entity\Formation\Unite No errors.
App\Entity\Formation\Classe No errors.
App\Entity\Image No errors.
App\Entity\Information No errors.
App\Entity\Formation\Attribution No errors.
App\Entity\Schoolyear No errors.
App\Entity\Formation\Participant No errors.
App\Entity\Formation\Timetable No errors.
App\Entity\User No errors.
App\Entity\Training\Training No errors.
App\Entity\Formation\Intervenant No errors.
App\Entity\Formation\Timetableitem No errors.
App\Entity\Training\Jury No errors.
App\Entity\Formation\Apayment No errors.
App\Entity\Formation\Cost No errors.
App\Entity\Formation\Aabsence No errors.
App\Entity\Training\Former No errors.
App\Entity\Tutoring\Tutor No errors.
App\Entity\Training\Trainee No errors.
App\Entity\Notification No errors.
App\Entity\Training\Groupe No errors.
App\Entity\Tutoring\Course No errors.
App\Entity\Training\Module No errors.
App\Entity\Formation\Aregulation No errors.
App\Entity\Formation\Aseance No errors.
App\Entity\Formation\Apayline No errors.
App\Entity\Training\Assignation No errors.
App\Entity\Training\Fregulation No errors.
App\Entity\Training\Fpayment No errors.
App\Entity\Training\Note No errors.
App\Entity\Training\Nsti No errors.
App\Entity\Training\Fee No errors.
App\Entity\Training\Absence No errors.
App\Entity\Training\Planning No errors.
App\Entity\Training\Schedule No errors.
App\Entity\Tutoring\Level No errors.
App\Entity\Tutoring\Subject No errors.
App\Entity\Tutoring\Rowscourse No errors.
App\Entity\Tutoring\Ressource No errors.
App\Entity\Tutoring\Month No errors.
App\Entity\Tutoring\Regulation No errors.
App\Entity\Training\Notemodule No errors.
App\Entity\Training\Noteassign No errors.
App\Entity\Training\Scheduleitem No errors.
App\Entity\Training\Fpayline No errors.
App\Entity\Training\Creval No errors.
App\Entity\Training\Seance No errors.
App\Entity\Training\Planline No errors.
App\Entity\Training\Scheduleevent No errors.
App\Entity\Tutoring\Branch No errors.
App\Entity\Tutoring\Student No errors.
App\Entity\Tutoring\Owe No errors.
App\Entity\Tutoring\Presence No errors.
App\Entity\Tutoring\Spayment No errors.
App\Entity\Tutoring\Meeting No errors.
App\Entity\Tutoring\Spayline No errors.