Query Metrics
6
Database Queries
4
Different statements
49.95 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
33.76 ms (67.59%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.website AS website_3, c0_.id_number AS id_number_4, c0_.contact_email AS contact_email_5, c0_.contact_phone AS contact_phone_6, c0_.raw_address AS raw_address_7, c0_.raw_city AS raw_city_8, c0_.raw_manager AS raw_manager_9, c0_.raw_staff AS raw_staff_10, c0_.fti AS fti_11, c0_.raw_postal_code AS raw_postal_code_12, c0_.raw_logo_url AS raw_logo_url_13, c0_.raw_description AS raw_description_14, c0_.raw_title AS raw_title_15, c0_.raw_sitename AS raw_sitename_16, c0_.slug AS slug_17, c0_.mautic_id AS mautic_id_18, c0_.verified AS verified_19, c0_.status AS status_20, c0_.web_fti AS web_fti_21, c0_.code AS code_22, c0_.raw404 AS raw404_23, c0_.raw_address_ko AS raw_address_ko_24, c0_.visible AS visible_25, c0_.created_at AS created_at_26, c0_.updated_at AS updated_at_27, c1_.id AS id_28, c1_.position AS position_29, c1_.roles AS roles_30, c1_.owner AS owner_31, m2_.id AS id_32, m2_.status AS status_33, m2_.created_at AS created_at_34, m2_.updated_at AS updated_at_35, p3_.id AS id_36, p3_.title AS title_37, p3_.description AS description_38, p3_.main AS main_39, p3_.visible AS visible_40, p3_.created_at AS created_at_41, p3_.updated_at AS updated_at_42, a4_.id AS id_43, a4_.name AS name_44, a4_.ape AS ape_45, a4_.slug AS slug_46, a4_.apes AS apes_47, a5_.id AS id_48, a5_.type AS type_49, a5_.street AS street_50, a5_.housenumber AS housenumber_51, a5_.locality AS locality_52, a5_.name AS name_53, a5_.postcode AS postcode_54, a5_.citycode AS citycode_55, a5_.city AS city_56, a5_.district AS district_57, a5_.context AS context_58, a5_.dept_number AS dept_number_59, a5_.dept_name AS dept_name_60, a5_.region_name AS region_name_61, a5_.lat AS lat_62, a5_.longi AS longi_63, a5_.x AS x_64, a5_.y AS y_65, k6_.id AS id_66, k6_.name AS name_67, u7_.id AS id_68, u7_.email AS email_69, u7_.roles AS roles_70, u7_.password AS password_71, u7_.firstname AS firstname_72, u7_.lastname AS lastname_73, u7_.description AS description_74, u7_.city AS city_75, u7_.country AS country_76, u7_.postal_code AS postal_code_77, u7_.birth_date AS birth_date_78, u7_.phone AS phone_79, u7_.gender AS gender_80, u7_.admin_public_profile AS admin_public_profile_81, u7_.stripe_id AS stripe_id_82, u7_.fti AS fti_83, u7_.title AS title_84, u7_.notification_token AS notification_token_85, u7_.accept_notification AS accept_notification_86, u7_.google_id AS google_id_87, u7_.google_name AS google_name_88, u7_.delete_request_date AS delete_request_date_89, u7_.created_at AS created_at_90, u7_.updated_at AS updated_at_91, c8_.id AS id_92, c8_.message AS message_93, c8_.status AS status_94, c8_.created_at AS created_at_95, c8_.updated_at AS updated_at_96, d9_.id AS id_97, d9_.title AS title_98, d9_.description AS description_99, d9_.accessibility AS accessibility_100, c0_.activity_id AS activity_id_101, c0_.address_id AS address_id_102, c0_.creator_id AS creator_id_103, c1_.user_id AS user_id_104, c1_.company_id AS company_id_105, m2_.club_id AS club_id_106, m2_.company_id AS company_id_107, p3_.image_large_id AS image_large_id_108, p3_.image_medium_id AS image_medium_id_109, p3_.image_small_id AS image_small_id_110, p3_.user_id AS user_id_111, p3_.company_id AS company_id_112, p3_.club_id AS club_id_113, p3_.post_id AS post_id_114, p3_.ad_id AS ad_id_115, p3_.deal_id AS deal_id_116, p3_.widget_id AS widget_id_117, p3_.alert_id AS alert_id_118, p3_.club_presentation_id AS club_presentation_id_119, c8_.claimer_id AS claimer_id_120, c8_.company_id AS company_id_121, d9_.company_id AS company_id_122, d9_.club_id AS club_id_123 FROM company c0_ LEFT JOIN collaborator c1_ ON c0_.id = c1_.company_id LEFT JOIN membership m2_ ON c0_.id = m2_.company_id LEFT JOIN photo p3_ ON c0_.id = p3_.company_id LEFT JOIN activity a4_ ON c0_.activity_id = a4_.id LEFT JOIN address a5_ ON c0_.address_id = a5_.id LEFT JOIN company_keyword c10_ ON c0_.id = c10_.company_id LEFT JOIN keyword k6_ ON k6_.id = c10_.keyword_id LEFT JOIN user u7_ ON c0_.creator_id = u7_.id LEFT JOIN claiming_request c8_ ON c0_.id = c8_.company_id LEFT JOIN deal d9_ ON c0_.id = d9_.company_id WHERE c0_.id = ?
Parameters:
[
145
]
|
7.95 ms (15.92%) |
3 |
SELECT t0.id AS id_1, t0.filepath AS filepath_2, t0.image_type AS image_type_3, t0.filename AS filename_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM document t0 WHERE t0.id = ?
Parameters:
[
272
]
|
5.91 ms (11.83%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.theme AS theme_3, t0.home_message AS home_message_4, t0.website AS website_5, t0.phone AS phone_6, t0.email AS email_7, t0.address_id AS address_id_8 FROM club t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2.33 ms (4.66%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.main AS main_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_large_id AS image_large_id_8, t0.image_medium_id AS image_medium_id_9, t0.image_small_id AS image_small_id_10, t0.user_id AS user_id_11, t0.company_id AS company_id_12, t0.club_id AS club_id_13, t0.post_id AS post_id_14, t0.ad_id AS ad_id_15, t0.deal_id AS deal_id_16, t0.widget_id AS widget_id_17, t0.alert_id AS alert_id_18, t0.club_presentation_id AS club_presentation_id_19 FROM photo t0 WHERE t0.club_id = ?
Parameters:
[
1
]
|
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\Company | No errors. |
App\Entity\Photo | No errors. |
App\Entity\Activity | No errors. |
App\Entity\User | No errors. |
App\Entity\ClaimingRequest | No errors. |
App\Entity\Collaborator | No errors. |
App\Entity\Membership | No errors. |
App\Entity\Address | No errors. |
App\Entity\Keyword | No errors. |
App\Entity\Deal | No errors. |
App\Entity\Club | No errors. |
App\Entity\Document | No errors. |
App\Entity\Post | No errors. |
App\Entity\Ad | No errors. |
App\Entity\Widget | No errors. |
App\Entity\Alert | No errors. |
App\Entity\ClubPresentation | No errors. |
App\Entity\UserClub | No errors. |
App\Entity\ClubManager | No errors. |