Query Metrics

69 Database Queries
9 Different statements
37.71 ms Query time
2 Invalid entities
200 Managed entities

Queries

Group similar statements

# Time Info
1 0.66 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "jean-sebastien.leleu@epicture.fr"
]
2 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  "1445"
]
3 1.35 ms
SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = ? AND m2_.route_name = ?
Parameters:
[
  1445
  "news"
]
4 0.63 ms
SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = ? AND s0_.type_thumb = ?
Parameters:
[
  1445
  0
]
5 0.55 ms
SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = ?
Parameters:
[
  1445
]
6 1.09 ms
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = ? ORDER BY m0_.name ASC
Parameters:
[
  3
]
7 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  26
]
8 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  12
]
9 0.74 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  13
]
10 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  141
]
11 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  39
]
12 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  40
]
13 0.61 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  41
]
14 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  42
]
15 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  43
]
16 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  44
]
17 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  10
]
18 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  14
]
19 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  30
]
20 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  3
]
21 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  25
]
22 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  46
]
23 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  24
]
24 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  147
]
25 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  23
]
26 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  28
]
27 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  29
]
28 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  48
]
29 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  18
]
30 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  19
]
31 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  8
]
32 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  35
]
33 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  49
]
34 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  50
]
35 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  15
]
36 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  34
]
37 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  9
]
38 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  51
]
39 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  38
]
40 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  11
]
41 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  5
]
42 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  7
]
43 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  20
]
44 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  4
]
45 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  59
]
46 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  60
]
47 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  61
]
48 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  37
]
49 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  31
]
50 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  52
]
51 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  53
]
52 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  54
]
53 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  45
]
54 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  55
]
55 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  32
]
56 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  62
]
57 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  63
]
58 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  64
]
59 0.60 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  16
]
60 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  36
]
61 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  56
]
62 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  21
]
63 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  57
]
64 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  58
]
65 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  17
]
66 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  6
]
67 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
Parameters:
[
  22
]
68 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = ? LIMIT 1
Parameters:
[
  1445
]
69 0.65 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ?
Parameters:
[
  1445
  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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Mod 65
App\Entity\Product 61
App\Entity\ProductTranslation 61
App\Entity\Location\City 2
App\Entity\Project\Projecttool 2
App\Entity\Project\ProjectProjecttool 2
App\Entity\User 1
App\Entity\AdministratorGroup 1
App\Entity\Project\Project 1
App\Entity\Project\ProjectType 1
App\Entity\Project\Category 1
App\Entity\Project\ProjectMod 1
App\Entity\ToolSite\Site 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Location\City No errors.
App\Entity\AdministratorGroup No errors.
App\Entity\Project\Project No errors.
App\Entity\UserAccess No errors.
App\Entity\Project\ProjectType No errors.
App\Entity\Project\Category No errors.
App\Entity\Intercommunality No errors.
App\Entity\Project\ProjectRefuseAttachment No errors.
App\Entity\Project\ProjectProjecttool No errors.
App\Entity\ToolSite\SiteModule No errors.
App\Entity\Project\ProjectMod No errors.
App\Entity\Project\ProjectRelation No errors.
App\Entity\Project\ProjectContact
  • The field 'App\Entity\Project\ProjectContact#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type.
App\Entity\Order No errors.
App\Entity\Historic\Contract No errors.
App\Entity\Mod No errors.
App\Entity\Project\Projecttool No errors.
App\Entity\Product No errors.
App\Entity\AbstractFile No errors.
App\Entity\ToolSite\SiteThumbnails No errors.
App\Entity\ToolSite\SiteFile
  • The field App\Entity\ToolSite\SiteFile#thumbnails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\SiteThumbnails#originalFile does not contain the required 'inversedBy="thumbnails"' attribute.
  • The field App\Entity\ToolSite\SiteFile#attachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\Files\SiteAttachments#files does not contain the required 'inversedBy="attachments"' attribute.
  • The field App\Entity\ToolSite\SiteFile#appFiles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\App\AppFile#originalFile does not contain the required 'inversedBy="appFiles"' attribute.
App\Entity\ToolSite\SiteNews No errors.
App\Entity\ToolSite\Site No errors.
App\Entity\ProductTranslation No errors.