Query Metrics
4
Database Queries
4
Different statements
0.93 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.52 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:
[
"2"
]
|
| 2 | 0.18 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.is_bkarte AS is_bkarte_25, t0.sms_remaining AS sms_remaining_26, t0.captain_verify AS captain_verify_27, t0.has_default_categories AS has_default_categories_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.active AS active_31, t0.deleted_at AS deleted_at_32, t0.profile_id AS profile_id_33, t0.profile_additional_id AS profile_additional_id_34, t0.created_by AS created_by_35, t0.updated_by AS updated_by_36, t0.deleted_by AS deleted_by_37 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
7455
]
|
| 3 | 0.16 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:
[
7455
]
|
| 4 | 0.08 ms |
SELECT t0.id AS id_1, t0.const_name AS const_name_2, t0.price_ht AS price_ht_3, t0.functionalities AS functionalities_4, t0.stripe_id AS stripe_id_5, t0.is_monthly AS is_monthly_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.active AS active_10, t0.tax_id AS tax_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14 FROM `subscription` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
8
]
|
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\Institution | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\PdfmenuPersonalization | 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. |
| App\Entity\Tax | No errors. |
| App\Entity\SubscriptionTranslation | No errors. |