Query Metrics
48
Database Queries
25
Different statements
22.02 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.51 ms (11.38%) |
12 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.tag AS tag_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `locale_front` t0 WHERE t0.tag = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"fr"
]
|
|
2.37 ms (10.77%) |
1 |
SELECT t0.id AS id_1, t0.selling_price_ttc AS selling_price_ttc_2, t0.reduced_price AS reduced_price_3, t0.reduced_price_start AS reduced_price_start_4, t0.reduced_price_end AS reduced_price_end_5, t0.position AS position_6, t0.highlight AS highlight_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.deleted_at AS deleted_at_11, t0.image_id AS image_id_12, t0.dish_category_id AS dish_category_id_13, t0.institution_id AS institution_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17 FROM `dish` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
"40"
]
|
|
1.31 ms (5.94%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.institution_id AS institution_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_by AS deleted_by_9 FROM `capacity` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
102
]
|
|
1.24 ms (5.65%) |
3 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.beer_id AS beer_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `beer_price` t0 WHERE t0.beer_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
5
]
|
|
1.21 ms (5.48%) |
1 |
SELECT t0.id AS id_1, t0.public_path AS public_path_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.file_id AS file_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_by AS deleted_by_9 FROM `allergen` t0 INNER JOIN dishes_allergens ON t0.id = dishes_allergens.allergen_id WHERE dishes_allergens.dish_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
40
]
|
|
1.11 ms (5.02%) |
3 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12
]
|
|
1.07 ms (4.84%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.beer_color_id AS beer_color_id_6, t0.locale_front_id AS locale_front_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM `beer_color_translation` t0 WHERE (t0.locale_front_id = ? AND t0.beer_color_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 2 ] |
|
1.04 ms (4.71%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.appellation AS appellation_3, t0.winery AS winery_4, t0.description AS description_5, t0.review AS review_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.wine_id AS wine_id_10, t0.locale_front_id AS locale_front_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14 FROM `wine_translation` t0 WHERE (t0.locale_front_id = ? AND t0.wine_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 12 ] |
|
1.02 ms (4.64%) |
1 |
SELECT t0.id AS id_1, t0.location AS location_2, t0.vintage AS vintage_3, t0.video AS video_4, t0.organic AS organic_5, t0.local AS local_6, t0.strength AS strength_7, t0.sweetness AS sweetness_8, t0.tannins AS tannins_9, t0.fruity AS fruity_10, t0.reduced_price_start AS reduced_price_start_11, t0.reduced_price_end AS reduced_price_end_12, t0.position AS position_13, t0.highlight AS highlight_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.active AS active_17, t0.deleted_at AS deleted_at_18, t0.wine_category_id AS wine_category_id_19, t0.image_id AS image_id_20, t0.review_file_id AS review_file_id_21, t0.wine_color_id AS wine_color_id_22, t0.institution_id AS institution_id_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t0.deleted_by AS deleted_by_26 FROM `wine` t0 WHERE t0.institution_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
2
]
|
|
0.89 ms (4.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.phone AS phone_4, t0.is_default AS is_default_5, t0.facebook AS facebook_6, t0.instagram AS instagram_7, t0.facebook_token AS facebook_token_8, t0.sender_sms AS sender_sms_9, t0.hash AS hash_10, t0.qr_code_last_download_at AS qr_code_last_download_at_11, t0.description AS description_12, t0.is_pdf_menu_active AS is_pdf_menu_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.active AS active_17, t0.document_id AS document_id_18, t0.user_id AS user_id_19, t0.address_id AS address_id_20, t0.qr_code_id AS qr_code_id_21, t22.id AS id_23, t22.title AS title_24, t22.sub_title AS sub_title_25, t22.background_color AS background_color_26, t22.title_color AS title_color_27, t22.sub_title_color AS sub_title_color_28, t22.button_background_color AS button_background_color_29, t22.button_text_color AS button_text_color_30, t22.display_logo AS display_logo_31, t22.display_mode AS display_mode_32, t22.created_at AS created_at_33, t22.updated_at AS updated_at_34, t22.deleted_at AS deleted_at_35, t22.institution_id AS institution_id_36, t22.created_by AS created_by_37, t22.updated_by AS updated_by_38, t22.deleted_by AS deleted_by_39, t40.id AS id_41, t40.primary_color AS primary_color_42, t40.primary_variant_color AS primary_variant_color_43, t40.text_over_primary_color AS text_over_primary_color_44, t40.created_at AS created_at_45, t40.updated_at AS updated_at_46, t40.deleted_at AS deleted_at_47, t40.institution_id AS institution_id_48, t40.created_by AS created_by_49, t40.updated_by AS updated_by_50, t40.deleted_by AS deleted_by_51, t52.id AS id_53, t52.average_review_score AS average_review_score_54, t52.one_star_number AS one_star_number_55, t52.two_star_number AS two_star_number_56, t52.three_star_number AS three_star_number_57, t52.four_star_number AS four_star_number_58, t52.five_star_number AS five_star_number_59, t52.created_at AS created_at_60, t52.updated_at AS updated_at_61, t52.deleted_at AS deleted_at_62, t52.institution_id AS institution_id_63, t52.created_by AS created_by_64, t52.updated_by AS updated_by_65, t52.deleted_by AS deleted_by_66, t0.created_by AS created_by_67, t0.updated_by AS updated_by_68, t0.deleted_by AS deleted_by_69 FROM `institution` t0 LEFT JOIN `pdfmenu_personalization` t22 ON t22.institution_id = t0.id LEFT JOIN `institution_app_personalization` t40 ON t40.institution_id = t0.id LEFT JOIN `institution_review_summary` t52 ON t52.institution_id = t0.id WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
|
0.79 ms (3.59%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_id AS dish_id_6, t0.wine_id AS wine_id_7, t0.institution_id AS institution_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_pairing` t0 WHERE t0.dish_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
40
]
|
|
0.77 ms (3.52%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_id AS dish_id_6, t0.beer_id AS beer_id_7, t0.institution_id AS institution_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `beer_pairing` t0 WHERE t0.dish_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
40
]
|
|
0.77 ms (3.48%) |
1 |
SELECT t0.id AS id_1, t0.location AS location_2, t0.vintage AS vintage_3, t0.video AS video_4, t0.organic AS organic_5, t0.local AS local_6, t0.strength AS strength_7, t0.sweetness AS sweetness_8, t0.tannins AS tannins_9, t0.fruity AS fruity_10, t0.reduced_price_start AS reduced_price_start_11, t0.reduced_price_end AS reduced_price_end_12, t0.position AS position_13, t0.highlight AS highlight_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.active AS active_17, t0.deleted_at AS deleted_at_18, t0.wine_category_id AS wine_category_id_19, t0.image_id AS image_id_20, t0.review_file_id AS review_file_id_21, t0.wine_color_id AS wine_color_id_22, t0.institution_id AS institution_id_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t0.deleted_by AS deleted_by_26 FROM `wine` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
12
]
|
|
0.73 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.reduced_price_start AS reduced_price_start_2, t0.reduced_price_end AS reduced_price_end_3, t0.position AS position_4, t0.highlight AS highlight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.active AS active_8, t0.deleted_at AS deleted_at_9, t0.beer_category_id AS beer_category_id_10, t0.beer_color_id AS beer_color_id_11, t0.review_file_id AS review_file_id_12, t0.image_id AS image_id_13, t0.institution_id AS institution_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17 FROM `beer` t0 WHERE t0.institution_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
2
]
|
|
0.71 ms (3.24%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.wine_color_id AS wine_color_id_6, t0.locale_front_id AS locale_front_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM `wine_color_translation` t0 WHERE (t0.locale_front_id = ? AND t0.wine_color_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 2 ] |
|
0.70 ms (3.17%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.file_size AS file_size_4, t0.path AS path_5, t0.extension AS extension_6, t0.mime_type AS mime_type_7, t0.hash AS hash_8, t0.hidden AS hidden_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.user_id AS user_id_13, t0.folder_id AS folder_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17 FROM `document` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
117
]
|
|
0.62 ms (2.82%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.drink_id AS drink_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `drink_price` t0 WHERE t0.drink_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
8
]
|
|
0.55 ms (2.51%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.review AS review_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.beer_id AS beer_id_8, t0.locale_front_id AS locale_front_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_by AS deleted_by_12 FROM `beer_translation` t0 WHERE (t0.locale_front_id = ? AND t0.beer_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 5 ] |
|
0.42 ms (1.89%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_category_id AS dish_category_id_6, t0.locale_front_id AS locale_front_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM `dish_category_translation` t0 WHERE (t0.locale_front_id = ? AND t0.dish_category_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 61 ] |
|
0.41 ms (1.88%) |
1 |
SELECT t0.id AS id_1, t0.color AS color_2, t0.const_name AS const_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_by AS deleted_by_9 FROM `wine_color` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
|
0.41 ms (1.87%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.analyse AS analyse_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.institution_id AS institution_id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.deleted_by AS deleted_by_10 FROM `dish_category` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
61
]
|
|
0.40 ms (1.84%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.additional_information AS additional_information_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.dish_id AS dish_id_8, t0.locale_front_id AS locale_front_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.deleted_by AS deleted_by_12 FROM `dish_translation` t0 WHERE (t0.locale_front_id = ? AND t0.dish_id = ?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 40 ] |
|
0.39 ms (1.75%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.public_path AS public_path_3, t0.is_dish AS is_dish_4, t0.is_wine AS is_wine_5, t0.is_beer AS is_beer_6, t0.is_drink AS is_drink_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.deleted_by AS deleted_by_13 FROM `label` t0 INNER JOIN dish_label ON t0.id = dish_label.label_id WHERE dish_label.dish_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
40
]
|
|
0.32 ms (1.48%) |
1 |
SELECT t0.id AS id_1, t0.color AS color_2, t0.const_name AS const_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_by AS deleted_by_9 FROM `beer_color` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
|
0.26 ms (1.17%) |
1 |
SELECT t0.id AS id_1, t0.reduced_price_start AS reduced_price_start_2, t0.reduced_price_end AS reduced_price_end_3, t0.position AS position_4, t0.highlight AS highlight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.active AS active_8, t0.deleted_at AS deleted_at_9, t0.drink_category_id AS drink_category_id_10, t0.image_id AS image_id_11, t0.institution_id AS institution_id_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.deleted_by AS deleted_by_15 FROM `drink` t0 WHERE t0.institution_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
2
]
|
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\Dish | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\DishCategory | No errors. |
| App\Entity\Institution | No errors. |
| App\Entity\User | No errors. |
| App\Entity\DishTranslation | No errors. |
| App\Entity\Allergen | No errors. |
| App\Entity\Label | No errors. |
| App\Entity\WinePairing | No errors. |
| App\Entity\BeerPairing | No errors. |
| App\Entity\LocaleFront | No errors. |
| App\Entity\DrinkTranslation | No errors. |
| App\Entity\WineTranslation | No errors. |
| App\Entity\BeerTranslation | No errors. |
| App\Entity\MenuTranslation | No errors. |
| App\Entity\GrapeTranslation | No errors. |
| App\Entity\InstitutionLocaleFront | No errors. |
| App\Entity\AllergenTranslation | No errors. |
| App\Entity\DishCategoryTranslation | No errors. |
| App\Entity\DrinkCategoryTranslation | No errors. |
| App\Entity\BeerCategoryTranslation | No errors. |
| App\Entity\WineCategoryTranslation | No errors. |
| App\Entity\MenuCategoryTranslation | No errors. |
| App\Entity\LabelTranslation | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Wine | No errors. |
| App\Entity\WineCategory | No errors. |
| App\Entity\WineColor | No errors. |
| App\Entity\WinePrice | No errors. |
| App\Entity\Grape | No errors. |
| App\Entity\Capacity | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\PdfmenuPersonalization | No errors. |
| App\Entity\InstitutionAppPersonalization | No errors. |
| App\Entity\InstitutionReviewSummary | No errors. |
| App\Entity\BeerCategory | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MenuCategory | No errors. |
| App\Entity\Offer | No errors. |
| App\Entity\DrinkCategory | No errors. |
| App\Entity\Drink | No errors. |
| App\Entity\Beer | No errors. |
| App\Entity\Creation | No errors. |
| App\Entity\CreationCategory | No errors. |
| App\Entity\PdfmenuDocument | No errors. |
| App\Entity\OpeningHour | No errors. |
| App\Entity\InstitutionReview | No errors. |
| App\Entity\Contest | No errors. |
| App\Entity\Analysis | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\ProductCategoryPosition | No errors. |
| App\Entity\BeerColor | No errors. |
| App\Entity\BeerPrice | No errors. |
| App\Entity\DrinkPrice | No errors. |
| App\Entity\WineColorTranslation |
|
| App\Entity\DocumentFolder | No errors. |
| App\Entity\BeerColorTranslation |
|