GET https://tressol.yeah.agency/recrutement-tressol-chabrier/offres

Query Metrics

32 Database Queries
16 Different statements
46.15 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 10.86 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.type AS type_2, o0_.ville AS ville_3, o0_.postcode AS postcode_4, o0_.experience AS experience_5, o0_.content AS content_6, o0_.position AS position_7, o0_.profile AS profile_8, o0_.image AS image_9, o0_.ats AS ats_10, o0_.ats_id AS ats_id_11, o0_.email AS email_12, o0_.url AS url_13, o0_.state AS state_14, o0_.work_time AS work_time_15, o0_.education AS education_16, o0_.driving_licence AS driving_licence_17, o0_.employment_date AS employment_date_18, o0_.salary_type AS salary_type_19, o0_.salary AS salary_20, o0_.benefits AS benefits_21, o0_.rome AS rome_22, o0_.region AS region_23, o0_.latitude AS latitude_24, o0_.longtitude AS longtitude_25, o0_.date AS date_26, o0_.category_id AS category_id_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, j1_.id AS id_30, j1_.title AS title_31, j1_.photos AS photos_32, j1_.code_romes AS code_romes_33, j1_.family AS family_34, j1_.nature_du_travail AS nature_du_travail_35, j1_.tasks AS tasks_36, j1_.quality AS quality_37, j1_.skills AS skills_38, j1_.les_profils_qui_nous_plaisent AS les_profils_qui_nous_plaisent_39, j1_.univers_du_poste AS univers_du_poste_40, j1_.evolution AS evolution_41, j1_.category_id AS category_id_42 FROM offre o0_ LEFT JOIN job_offre j2_ ON o0_.id = j2_.offre_id LEFT JOIN job j1_ ON j1_.id = j2_.job_id WHERE o0_.state = 1 ORDER BY o0_.date DESC) dctrn_result) dctrn_table
Parameters:
[]
2 0.87 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, date_26 FROM (SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.type AS type_2, o0_.ville AS ville_3, o0_.postcode AS postcode_4, o0_.experience AS experience_5, o0_.content AS content_6, o0_.position AS position_7, o0_.profile AS profile_8, o0_.image AS image_9, o0_.ats AS ats_10, o0_.ats_id AS ats_id_11, o0_.email AS email_12, o0_.url AS url_13, o0_.state AS state_14, o0_.work_time AS work_time_15, o0_.education AS education_16, o0_.driving_licence AS driving_licence_17, o0_.employment_date AS employment_date_18, o0_.salary_type AS salary_type_19, o0_.salary AS salary_20, o0_.benefits AS benefits_21, o0_.rome AS rome_22, o0_.region AS region_23, o0_.latitude AS latitude_24, o0_.longtitude AS longtitude_25, o0_.date AS date_26, o0_.category_id AS category_id_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, j1_.id AS id_30, j1_.title AS title_31, j1_.photos AS photos_32, j1_.code_romes AS code_romes_33, j1_.family AS family_34, j1_.nature_du_travail AS nature_du_travail_35, j1_.tasks AS tasks_36, j1_.quality AS quality_37, j1_.skills AS skills_38, j1_.les_profils_qui_nous_plaisent AS les_profils_qui_nous_plaisent_39, j1_.univers_du_poste AS univers_du_poste_40, j1_.evolution AS evolution_41, j1_.category_id AS category_id_42 FROM offre o0_ LEFT JOIN job_offre j2_ ON o0_.id = j2_.offre_id LEFT JOIN job j1_ ON j1_.id = j2_.job_id WHERE o0_.state = 1) dctrn_result_inner ORDER BY date_26 DESC) dctrn_result LIMIT 20
Parameters:
[]
3 7.88 ms
SELECT o0_.id AS id_0, o0_.titre AS titre_1, o0_.type AS type_2, o0_.ville AS ville_3, o0_.postcode AS postcode_4, o0_.experience AS experience_5, o0_.content AS content_6, o0_.position AS position_7, o0_.profile AS profile_8, o0_.image AS image_9, o0_.ats AS ats_10, o0_.ats_id AS ats_id_11, o0_.email AS email_12, o0_.url AS url_13, o0_.state AS state_14, o0_.work_time AS work_time_15, o0_.education AS education_16, o0_.driving_licence AS driving_licence_17, o0_.employment_date AS employment_date_18, o0_.salary_type AS salary_type_19, o0_.salary AS salary_20, o0_.benefits AS benefits_21, o0_.rome AS rome_22, o0_.region AS region_23, o0_.latitude AS latitude_24, o0_.longtitude AS longtitude_25, o0_.date AS date_26, o0_.category_id AS category_id_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, j1_.id AS id_30, j1_.title AS title_31, j1_.photos AS photos_32, j1_.code_romes AS code_romes_33, j1_.family AS family_34, j1_.nature_du_travail AS nature_du_travail_35, j1_.tasks AS tasks_36, j1_.quality AS quality_37, j1_.skills AS skills_38, j1_.les_profils_qui_nous_plaisent AS les_profils_qui_nous_plaisent_39, j1_.univers_du_poste AS univers_du_poste_40, j1_.evolution AS evolution_41, j1_.category_id AS category_id_42 FROM offre o0_ LEFT JOIN job_offre j2_ ON o0_.id = j2_.offre_id LEFT JOIN job j1_ ON j1_.id = j2_.job_id WHERE o0_.state = 1 AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.date DESC
Parameters:
[
  109
  110
  111
  112
  113
  114
  115
  116
  117
  118
  119
  120
  121
  122
  123
  124
  125
  126
  127
  128
]
4 0.57 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_nos_offres"
]
5 0.27 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
6 0.33 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
7 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_nos_offres"
]
8 0.19 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
9 0.18 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
10 0.50 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
11 0.23 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "USED_CAR"
]
12 0.37 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.route_name AS route_name_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_h1 AS seo_h1_7, t0.hektor_text_logged AS hektor_text_logged_8, t0.hektor_text_not_logged AS hektor_text_not_logged_9, t0.hektor_text_is_differnet AS hektor_text_is_differnet_10 FROM cms_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "tressol_nos_offres"
]
13 1.53 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.identifier AS identifier_4, t0.content AS content_5, t0.hektor_text_logged AS hektor_text_logged_6, t0.hektor_text_not_logged AS hektor_text_not_logged_7, t0.hektor_text_is_differnet AS hektor_text_is_differnet_8, t0.cms_page_id AS cms_page_id_9 FROM cms_bloc t0 WHERE t0.cms_page_id = ?
Parameters:
[
  14
]
14 0.32 ms
SELECT DATABASE()
Parameters:
[]
15 1.03 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "tressol-chabrier"
]
16 0.14 ms
SELECT DATABASE()
Parameters:
[]
17 0.66 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "tressol-chabrier"
]
18 0.16 ms
SELECT DATABASE()
Parameters:
[]
19 0.45 ms
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
            ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
20 0.13 ms
SELECT DATABASE()
Parameters:
[]
21 1.02 ms
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'tressol-chabrier' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
22 13.24 ms
SELECT       c.COLUMN_NAME        AS field,
           IF(
        x.CHECK_CLAUSE IS NOT NULL AND c.COLUMN_TYPE = 'longtext',
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
    LEFT JOIN information_schema.CHECK_CONSTRAINTS x
    ON (
        c.TABLE_SCHEMA = x.CONSTRAINT_SCHEMA
        AND c.TABLE_NAME = x.TABLE_NAME
        AND x.CHECK_CLAUSE = CONCAT('json_valid(`', c.COLUMN_NAME , '`)')
    ) WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "tressol-chabrier"
  "tressol-chabrier"
  "doctrine_migration_versions"
]
23 0.27 ms
SELECT DATABASE()
Parameters:
[]
24 0.28 ms
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "tressol-chabrier"
  "doctrine_migration_versions"
]
25 0.21 ms
SELECT * FROM doctrine_migration_versions
Parameters:
[]
26 0.14 ms
SELECT DATABASE()
Parameters:
[]
27 0.29 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.legales_text AS legales_text_5, t0.url AS url_6 FROM promo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
28 2.22 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.opening_hours_periods AS opening_hours_periods_2, e0_.adresse AS adresse_3, e0_.postal_code AS postal_code_4, e0_.ville AS ville_5, e0_.telephone AS telephone_6, e0_.email AS email_7, e0_.concession_email AS concession_email_8, e0_.concession_telephone AS concession_telephone_9, e0_.latitude AS latitude_10, e0_.longtitude AS longtitude_11, e0_.detail_stockage AS detail_stockage_12, c1_.name AS name_13 FROM etablissement e0_ LEFT JOIN etablissement_car_marque e2_ ON e0_.id = e2_.etablissement_id LEFT JOIN car_marque c1_ ON c1_.id = e2_.car_marque_id WHERE ((e0_.latitude IS NOT NULL AND (e0_.count_car > 0 OR e0_.show_if_no_stock = 1) AND e0_.longtitude IS NOT NULL AND e0_.publie = 1) OR e0_.id = ?) AND e0_.detail_stockage IS NULL ORDER BY e0_.name ASC
Parameters:
[
  158
]
29 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_for_meeting AS name_for_meeting_3, t0.description AS description_4, t0.image_id AS image_id_5 FROM expert t0
Parameters:
[]
30 0.38 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]
31 0.16 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "BRAND"
]
32 0.47 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.data_count AS data_count_3, t0.update_at AS update_at_4 FROM data_count t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "totalConcession"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
internal doctrine.dbal.internal_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
internal doctrine.orm.internal_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Offre No errors.
App\Entity\Job No errors.
App\Entity\CmsPage No errors.
App\Entity\CmsBloc No errors.
App\Entity\DataCount No errors.
App\Entity\Promo No errors.
App\Entity\PromoSlider No errors.
App\Entity\Etablissement No errors.
App\Entity\CarMarque No errors.
App\Entity\Expert No errors.
App\Entity\Upload No errors.
App\Entity\ExpertContact No errors.
App\Entity\User No errors.
App\Entity\EtablissementService No errors.
App\Entity\ReviewDetail No errors.
App\Entity\LeadEstimate No errors.
App\Entity\PrendreRdv No errors.
App\Entity\Meeting No errors.
App\Entity\ClientRequest No errors.
App\Entity\Car No errors.
App\Entity\GroupEtablissement No errors.
App\Entity\Lead No errors.
App\Entity\CarModele No errors.
App\Entity\MarqueNews No errors.
App\Entity\Bca No errors.
App\Entity\Role No errors.
App\Entity\Newsletters No errors.
App\Entity\VehicleAlert No errors.
App\Entity\Favorite No errors.
App\Entity\Comparative No errors.
App\Entity\UserVehicle No errors.
App\Entity\UserPayment No errors.
App\Entity\MyBuyProject No errors.
App\Entity\Configurator No errors.
App\Entity\NewsletterSubscription No errors.
App\Entity\Document No errors.
App\Entity\MyMaintainProjectAction No errors.
App\Entity\CarMedia No errors.
App\Entity\CarAddition No errors.
App\Entity\CarEntretien No errors.

internal entity manager

No loaded entities.