https://dev.mizogoo.fr/api/pdfmenu/personalization/23

Query Metrics

4 Database Queries
4 Different statements
1.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.background_color AS background_color_4, t0.title_color AS title_color_5, t0.sub_title_color AS sub_title_color_6, t0.button_background_color AS button_background_color_7, t0.button_text_color AS button_text_color_8, t0.display_logo AS display_logo_9, t0.display_mode AS display_mode_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_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 `pdfmenu_personalization` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "23"
]
2 0.25 ms
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:
[
  23
]
3 0.27 ms
SELECT t0.id AS id_1, t0.password AS password_2, t0.email AS email_3, t0.google_id AS google_id_4, t0.facebook_id AS facebook_id_5, t0.stripe_id AS stripe_id_6, t0.username AS username_7, t0.civility AS civility_8, t0.lastname AS lastname_9, t0.firstname AS firstname_10, t0.password_token AS password_token_11, t0.password_request_at AS password_request_at_12, t0.tva AS tva_13, t0.siret AS siret_14, t0.company AS company_15, t0.brand AS brand_16, t0.available AS available_17, t0.validated AS validated_18, t0.last_connection AS last_connection_19, t0.hash AS hash_20, t0.registration_validation_token AS registration_validation_token_21, t0.registration_validation_request_at AS registration_validation_request_at_22, t0.is_emenu AS is_emenu_23, t0.is_distrimenu AS is_distrimenu_24, t0.sms_remaining AS sms_remaining_25, t0.captain_verify AS captain_verify_26, t0.has_default_categories AS has_default_categories_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.active AS active_30, t0.deleted_at AS deleted_at_31, t0.profile_id AS profile_id_32, t0.profile_additional_id AS profile_additional_id_33, t0.created_by AS created_by_34, t0.updated_by AS updated_by_35, t0.deleted_by AS deleted_by_36 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  7474
]
4 0.19 ms
SELECT t0.id AS id_1, t0.current AS current_2, t0.is_valid AS is_valid_3, t0.stripe_id AS stripe_id_4, t0.is_free AS is_free_5, t0.finished_at AS finished_at_6, t0.cancel_at AS cancel_at_7, t0.promotion_finished_at AS promotion_finished_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.user_id AS user_id_12, t0.subscription_id AS subscription_id_13, t0.next_subscription_id AS next_subscription_id_14, t0.billing_address_id AS billing_address_id_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.deleted_by AS deleted_by_18 FROM `user_subscription` t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.created_at DESC
Parameters:
[
  7474
]

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\PdfmenuPersonalization No errors.
App\Entity\Institution No errors.
App\Entity\User No errors.
App\Entity\Document No errors.
App\Entity\Address No errors.
App\Entity\InstitutionAppPersonalization No errors.
App\Entity\InstitutionReviewSummary No errors.
App\Entity\DishCategory No errors.
App\Entity\WineCategory No errors.
App\Entity\BeerCategory No errors.
App\Entity\Dish No errors.
App\Entity\Menu No errors.
App\Entity\MenuCategory No errors.
App\Entity\Offer No errors.
App\Entity\Wine No errors.
App\Entity\DrinkCategory No errors.
App\Entity\Drink No errors.
App\Entity\Beer No errors.
App\Entity\Capacity No errors.
App\Entity\Creation No errors.
App\Entity\CreationCategory No errors.
App\Entity\WinePairing No errors.
App\Entity\BeerPairing No errors.
App\Entity\PdfmenuDocument No errors.
App\Entity\OpeningHour No errors.
App\Entity\Grape No errors.
App\Entity\InstitutionLocaleFront 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\Profile No errors.
App\Entity\ProductStep No errors.
App\Entity\CreationComment No errors.
App\Entity\UserFavoriteElement No errors.
App\Entity\UserFavoriteImage No errors.
App\Entity\Cart No errors.
App\Entity\OrderStep No errors.
App\Entity\OrderStepTime No errors.
App\Entity\UserSubscription No errors.
App\Entity\Notification No errors.
App\Entity\Onboarding No errors.
App\Entity\UserConnection No errors.
App\Entity\PromotionUsedUser No errors.
App\Entity\Matrix No errors.
App\Entity\MatrixSet No errors.
App\Entity\Subscription No errors.