| 1 |
21.52 ms |
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 = ?
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 = ?
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 = 170;
|