GET https://dev.qrcard.fr/

Query Metrics

19 Database Queries
12 Different statements
14.16 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.is_filter_price AS is_filter_price_2, t0.is_filter_tags AS is_filter_tags_3, t0.url_name AS url_name_4, t0.nb_translate AS nb_translate_5, t0.nb_qr_code_product_command AS nb_qr_code_product_command_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.stripe_subscription_id AS stripe_subscription_id_8, t0.is_menu_auto_added AS is_menu_auto_added_9, t0.restaurant_id AS restaurant_id_10 FROM config_menu_restaurant t0 WHERE t0.url_name = ? LIMIT 1
Parameters:
[
  "dev"
]
2 0.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.visibility AS visibility_6, t0.public_phone AS public_phone_7, t0.view AS view_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.website AS website_12, t0.legal_name AS legal_name_13, t0.vat_number AS vat_number_14, t0.billing_adress AS billing_adress_15, t0.wifi_name AS wifi_name_16, t0.wifi_password AS wifi_password_17, t0.subscription_id AS subscription_id_18, t19.id AS id_20, t19.color1 AS color1_21, t19.color2 AS color2_22, t19.color3 AS color3_23, t19.color4 AS color4_24, t19.restaurant_id AS restaurant_id_25, t26.id AS id_27, t26.is_filter_price AS is_filter_price_28, t26.is_filter_tags AS is_filter_tags_29, t26.url_name AS url_name_30, t26.nb_translate AS nb_translate_31, t26.nb_qr_code_product_command AS nb_qr_code_product_command_32, t26.stripe_customer_id AS stripe_customer_id_33, t26.stripe_subscription_id AS stripe_subscription_id_34, t26.is_menu_auto_added AS is_menu_auto_added_35, t26.restaurant_id AS restaurant_id_36, t37.id AS id_38, t37.content AS content_39, t37.expire_date AS expire_date_40, t37.visibility AS visibility_41, t37.restaurant_id AS restaurant_id_42 FROM restaurant t0 LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id WHERE t0.id = ?
Parameters:
[
  14
]
3 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.visibility AS visibility_3, t0.archive AS archive_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.svg_id AS svg_id_7, t0.restaurant_id AS restaurant_id_8 FROM `group` t0 WHERE t0.archive = ? AND t0.visibility = ? AND ((t0.restaurant_id = '14'))
Parameters:
[
  0
  1
]
4 0.39 ms
"START TRANSACTION"
Parameters:
[]
5 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.visibility AS visibility_6, t0.public_phone AS public_phone_7, t0.view AS view_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.website AS website_12, t0.legal_name AS legal_name_13, t0.vat_number AS vat_number_14, t0.billing_adress AS billing_adress_15, t0.wifi_name AS wifi_name_16, t0.wifi_password AS wifi_password_17, t0.subscription_id AS subscription_id_18, t19.id AS id_20, t19.color1 AS color1_21, t19.color2 AS color2_22, t19.color3 AS color3_23, t19.color4 AS color4_24, t19.restaurant_id AS restaurant_id_25, t26.id AS id_27, t26.is_filter_price AS is_filter_price_28, t26.is_filter_tags AS is_filter_tags_29, t26.url_name AS url_name_30, t26.nb_translate AS nb_translate_31, t26.nb_qr_code_product_command AS nb_qr_code_product_command_32, t26.stripe_customer_id AS stripe_customer_id_33, t26.stripe_subscription_id AS stripe_subscription_id_34, t26.is_menu_auto_added AS is_menu_auto_added_35, t26.restaurant_id AS restaurant_id_36, t37.id AS id_38, t37.content AS content_39, t37.expire_date AS expire_date_40, t37.visibility AS visibility_41, t37.restaurant_id AS restaurant_id_42 FROM restaurant t0 LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id WHERE ((t0.id = '14')) LIMIT 1
Parameters:
[]
6 0.47 ms
UPDATE restaurant SET view = ?, updated_at = ? WHERE id = ?
Parameters:
[
  2211
  "2025-12-31 05:21:57"
  14
]
7 1.20 ms
"COMMIT"
Parameters:
[]
8 0.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.siret AS siret_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.visibility AS visibility_6, t0.public_phone AS public_phone_7, t0.view AS view_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.website AS website_12, t0.legal_name AS legal_name_13, t0.vat_number AS vat_number_14, t0.billing_adress AS billing_adress_15, t0.wifi_name AS wifi_name_16, t0.wifi_password AS wifi_password_17, t0.subscription_id AS subscription_id_18, t19.id AS id_20, t19.color1 AS color1_21, t19.color2 AS color2_22, t19.color3 AS color3_23, t19.color4 AS color4_24, t19.restaurant_id AS restaurant_id_25, t26.id AS id_27, t26.is_filter_price AS is_filter_price_28, t26.is_filter_tags AS is_filter_tags_29, t26.url_name AS url_name_30, t26.nb_translate AS nb_translate_31, t26.nb_qr_code_product_command AS nb_qr_code_product_command_32, t26.stripe_customer_id AS stripe_customer_id_33, t26.stripe_subscription_id AS stripe_subscription_id_34, t26.is_menu_auto_added AS is_menu_auto_added_35, t26.restaurant_id AS restaurant_id_36, t37.id AS id_38, t37.content AS content_39, t37.expire_date AS expire_date_40, t37.visibility AS visibility_41, t37.restaurant_id AS restaurant_id_42 FROM restaurant t0 LEFT JOIN custom_menu_restaurant t19 ON t19.restaurant_id = t0.id LEFT JOIN config_menu_restaurant t26 ON t26.restaurant_id = t0.id LEFT JOIN ardoise t37 ON t37.restaurant_id = t0.id WHERE ((t0.id = '14')) LIMIT 1
Parameters:
[]
9 0.50 ms
SELECT COUNT(*) FROM product t0 WHERE ((t0.restaurant_id = '14'))
Parameters:
[]
10 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.nb_max_product AS nb_max_product_3, t0.nb_max_category AS nb_max_category_4, t0.nb_max_compte AS nb_max_compte_5, t0.nb_max_free_qr_code AS nb_max_free_qr_code_6, t0.nb_max_group AS nb_max_group_7, t0.nb_max_tag AS nb_max_tag_8, t0.img_max_width AS img_max_width_9, t0.img_max_height AS img_max_height_10 FROM subscription t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 1.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.long_name AS long_name_3, t0.lang_long_name AS lang_long_name_4 FROM language t0 INNER JOIN restaurant_language ON t0.id = restaurant_language.language_id WHERE restaurant_language.restaurant_id = ?
Parameters:
[
  14
]
12 1.29 ms
SELECT t0.id AS id_1, t0.svg AS svg_2, t0.name AS name_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  9
]
13 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_cat_id AS group_cat_id_3, t0.language_id AS language_id_4, t0.restaurant_id AS restaurant_id_5 FROM group_translation t0 WHERE t0.group_cat_id = ? AND ((t0.restaurant_id = '14'))
Parameters:
[
  2
]
14 0.51 ms
SELECT t0.id AS id_1, t0.svg AS svg_2, t0.name AS name_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  12
]
15 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_cat_id AS group_cat_id_3, t0.language_id AS language_id_4, t0.restaurant_id AS restaurant_id_5 FROM group_translation t0 WHERE t0.group_cat_id = ? AND ((t0.restaurant_id = '14'))
Parameters:
[
  13
]
16 0.44 ms
SELECT t0.id AS id_1, t0.svg AS svg_2, t0.name AS name_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  13
]
17 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_cat_id AS group_cat_id_3, t0.language_id AS language_id_4, t0.restaurant_id AS restaurant_id_5 FROM group_translation t0 WHERE t0.group_cat_id = ? AND ((t0.restaurant_id = '14'))
Parameters:
[
  14
]
18 0.43 ms
SELECT t0.id AS id_1, t0.svg AS svg_2, t0.name AS name_3 FROM icon t0 WHERE t0.id = ?
Parameters:
[
  10
]
19 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_cat_id AS group_cat_id_3, t0.language_id AS language_id_4, t0.restaurant_id AS restaurant_id_5 FROM group_translation t0 WHERE t0.group_cat_id = ? AND ((t0.restaurant_id = '14'))
Parameters:
[
  20
]

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.