https://smartfocus.ma/

Query Metrics

21 Database Queries
5 Different statements
5.61 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.73 ms
SELECT t0.title AS title_1, t0.sub_title AS sub_title_2, t0.slug AS slug_3, t0.link AS link_4, t0.image1_name AS image1_name_5, t0.image2_name AS image2_name_6, t0.featured AS featured_7, t0.start_at AS start_at_8, t0.end_at AS end_at_9, t0.abstract AS abstract_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.published AS published_13, t0.published_at AS published_at_14, t0.docs AS docs_15 FROM hs_training_center_news t0 WHERE t0.published = ? AND t0.featured = ? ORDER BY t0.create_at DESC LIMIT 3
Parameters:
[
  1
  1
]
2 0.23 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
]
3 0.26 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
]
4 0.36 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
]
5 0.17 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
]
6 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:
[
  4
]
7 0.13 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
]
8 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
]
9 0.13 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
]
10 0.41 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
]
11 0.28 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
]
12 0.36 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
]
13 0.28 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
]
14 0.17 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
]
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:
[
  1
]
16 0.18 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
]
17 0.14 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
]
18 0.32 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
]
19 0.38 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
]
20 0.40 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
]
21 0.25 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
]

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\News No errors.
App\Entity\Formation\Category No errors.
App\Entity\Formation\Activity 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.