Query Metrics
4
Database Queries
4
Different statements
1.58 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |