Query Metrics
1
Database Queries
1
Different statements
0.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.55 ms (100.00%) |
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:
[
"4"
]
|
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. |