| 1 |
0.96 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.payment_uid AS payment_uid_3, c0_.is_cgu AS is_cgu_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.code AS code_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.created_at AS created_at_12, u1_.updated_at AS updated_at_13, u1_.last_login AS last_login_14, u1_.name AS name_15, u1_.category AS category_16, u1_.active AS active_17, u1_.ban_start AS ban_start_18, u1_.ban_end AS ban_end_19, u1_.reset_token AS reset_token_20, u1_.first_name AS first_name_21, u1_.last_name AS last_name_22, u1_.country AS country_23, u1_.`function` AS function_24, u1_.phone AS phone_25, u1_.username AS username_26, u1_.quotas AS quotas_27, u1_.quotas_type AS quotas_type_28, u1_.email_updated_at AS email_updated_at_29, u1_.email_validated_at AS email_validated_at_30, u1_.status AS status_31, u1_.device_os AS device_os_32, u1_.device_token AS device_token_33, u1_.device_name AS device_name_34, u1_.device_active AS device_active_35, u1_.device_update AS device_update_36, u1_.newsletter AS newsletter_37, u1_.newsletter_date AS newsletter_date_38, u1_.first_login AS first_login_39, u1_.home_survey AS home_survey_40, u1_.display_teamplay_tuto AS display_teamplay_tuto_41, u1_.live AS live_42, u1_.tv AS tv_43, c2_.id AS id_44, c2_.name AS name_45, c2_.image AS image_46, c2_.updated_at AS updated_at_47, c2_.presentation AS presentation_48, c2_.presentation_title AS presentation_title_49, c2_.siret AS siret_50, c2_.phone AS phone_51, c2_.created_at AS created_at_52, c2_.company_code AS company_code_53, c2_.visio_allowed AS visio_allowed_54, c2_.visio_payment_allowed AS visio_payment_allowed_55, c2_.force_segmentation AS force_segmentation_56, c2_.siren AS siren_57, c2_.status AS status_58, c2_.active AS active_59, c2_.subscription_start AS subscription_start_60, c2_.subscription_end AS subscription_end_61, c2_.clients_count AS clients_count_62, c2_.messages AS messages_63, c2_.max_clients AS max_clients_64, c2_.plan AS plan_65, c2_.slug AS slug_66, c2_.ips AS ips_67, c2_.domain AS domain_68, c2_.hourly_restriction AS hourly_restriction_69, c2_.customizable AS customizable_70, c2_.cms AS cms_71, c2_.cms_title AS cms_title_72, c2_.cms_text AS cms_text_73, c2_.cms_cta_text AS cms_cta_text_74, c2_.cms_cta_url AS cms_cta_url_75, c2_.resa_link_active AS resa_link_active_76, c2_.email AS email_77, c2_.live AS live_78, c2_.tv AS tv_79, c2_.consult_link AS consult_link_80, c2_.street AS street_81, c2_.zip_code AS zip_code_82, c2_.town AS town_83, c2_.longitude AS longitude_84, c2_.latitude AS latitude_85, c2_.country AS country_86, c2_.code AS code_87, m3_.id AS id_88, m3_.file_path AS file_path_89, m3_.mime_type AS mime_type_90, m3_.size AS size_91, m3_.extra AS extra_92, m3_.created_at AS created_at_93, m3_.name AS name_94, s4_.id AS id_95, s4_.name AS name_96, s4_.alone AS alone_97, s4_.active AS active_98, s4_.ranked AS ranked_99, s4_.`rank` AS rank_100, s4_.created_at AS created_at_101, s4_.updated_at AS updated_at_102, c5_.id AS id_103, c5_.name AS name_104, c5_.image AS image_105, c5_.updated_at AS updated_at_106, c5_.presentation AS presentation_107, c5_.presentation_title AS presentation_title_108, c5_.siret AS siret_109, c5_.phone AS phone_110, c5_.created_at AS created_at_111, c5_.company_code AS company_code_112, c5_.visio_allowed AS visio_allowed_113, c5_.visio_payment_allowed AS visio_payment_allowed_114, c5_.force_segmentation AS force_segmentation_115, c5_.siren AS siren_116, c5_.status AS status_117, c5_.active AS active_118, c5_.subscription_start AS subscription_start_119, c5_.subscription_end AS subscription_end_120, c5_.clients_count AS clients_count_121, c5_.messages AS messages_122, c5_.max_clients AS max_clients_123, c5_.plan AS plan_124, c5_.slug AS slug_125, c5_.ips AS ips_126, c5_.domain AS domain_127, c5_.hourly_restriction AS hourly_restriction_128, c5_.customizable AS customizable_129, c5_.cms AS cms_130, c5_.cms_title AS cms_title_131, c5_.cms_text AS cms_text_132, c5_.cms_cta_text AS cms_cta_text_133, c5_.cms_cta_url AS cms_cta_url_134, c5_.resa_link_active AS resa_link_active_135, c5_.email AS email_136, c5_.live AS live_137, c5_.tv AS tv_138, c5_.consult_link AS consult_link_139, c5_.street AS street_140, c5_.zip_code AS zip_code_141, c5_.town AS town_142, c5_.longitude AS longitude_143, c5_.latitude AS latitude_144, c5_.country AS country_145, c5_.code AS code_146, m6_.id AS id_147, m6_.file_path AS file_path_148, m6_.mime_type AS mime_type_149, m6_.size AS size_150, m6_.extra AS extra_151, m6_.created_at AS created_at_152, m6_.name AS name_153, a7_.id AS id_154, a7_.name AS name_155, a7_.short_description AS short_description_156, a7_.content AS content_157, a7_.link_url AS link_url_158, a7_.active AS active_159, a7_.created_at AS created_at_160, a7_.updated_at AS updated_at_161, m8_.id AS id_162, m8_.file_path AS file_path_163, m8_.mime_type AS mime_type_164, m8_.size AS size_165, m8_.extra AS extra_166, m8_.created_at AS created_at_167, m8_.name AS name_168, c0_.dtype AS dtype_169, c0_.user_id AS user_id_170, c0_.company_id AS company_id_171, c0_.segmentation_id AS segmentation_id_172, c0_.association_id AS association_id_173, c0_.avatar_id AS avatar_id_174, u1_.segmentation_id AS segmentation_id_175, c2_.dtype AS dtype_176, c2_.user_id AS user_id_177, c2_.logo_id AS logo_id_178, c2_.cms_img_id AS cms_img_id_179, s4_.company_id AS company_id_180, s4_.parent_id AS parent_id_181, c5_.dtype AS dtype_182, c5_.user_id AS user_id_183, c5_.logo_id AS logo_id_184, c5_.cms_img_id AS cms_img_id_185, a7_.preview_id AS preview_id_186, a7_.picture_id AS picture_id_187, a7_.illustration_id AS illustration_id_188 FROM client c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN company c2_ ON c0_.company_id = c2_.id AND c2_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m3_ ON c2_.logo_id = m3_.id LEFT JOIN segmentation s4_ ON c0_.segmentation_id = s4_.id LEFT JOIN company c5_ ON s4_.company_id = c5_.id AND c5_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m6_ ON c5_.logo_id = m6_.id LEFT JOIN association a7_ ON c0_.association_id = a7_.id LEFT JOIN media_object m8_ ON c0_.avatar_id = m8_.id WHERE (c0_.id = ?) AND c0_.dtype IN ('client', 'externalclient')
SELECT
c0_.id AS id_0,
c0_.first_name AS first_name_1,
c0_.last_name AS last_name_2,
c0_.payment_uid AS payment_uid_3,
c0_.is_cgu AS is_cgu_4,
c0_.created_at AS created_at_5,
c0_.updated_at AS updated_at_6,
c0_.code AS code_7,
u1_.id AS id_8,
u1_.email AS email_9,
u1_.roles AS roles_10,
u1_.password AS password_11,
u1_.created_at AS created_at_12,
u1_.updated_at AS updated_at_13,
u1_.last_login AS last_login_14,
u1_.name AS name_15,
u1_.category AS category_16,
u1_.active AS active_17,
u1_.ban_start AS ban_start_18,
u1_.ban_end AS ban_end_19,
u1_.reset_token AS reset_token_20,
u1_.first_name AS first_name_21,
u1_.last_name AS last_name_22,
u1_.country AS country_23,
u1_.`function` AS function_24,
u1_.phone AS phone_25,
u1_.username AS username_26,
u1_.quotas AS quotas_27,
u1_.quotas_type AS quotas_type_28,
u1_.email_updated_at AS email_updated_at_29,
u1_.email_validated_at AS email_validated_at_30,
u1_.status AS status_31,
u1_.device_os AS device_os_32,
u1_.device_token AS device_token_33,
u1_.device_name AS device_name_34,
u1_.device_active AS device_active_35,
u1_.device_update AS device_update_36,
u1_.newsletter AS newsletter_37,
u1_.newsletter_date AS newsletter_date_38,
u1_.first_login AS first_login_39,
u1_.home_survey AS home_survey_40,
u1_.display_teamplay_tuto AS display_teamplay_tuto_41,
u1_.live AS live_42,
u1_.tv AS tv_43,
c2_.id AS id_44,
c2_.name AS name_45,
c2_.image AS image_46,
c2_.updated_at AS updated_at_47,
c2_.presentation AS presentation_48,
c2_.presentation_title AS presentation_title_49,
c2_.siret AS siret_50,
c2_.phone AS phone_51,
c2_.created_at AS created_at_52,
c2_.company_code AS company_code_53,
c2_.visio_allowed AS visio_allowed_54,
c2_.visio_payment_allowed AS visio_payment_allowed_55,
c2_.force_segmentation AS force_segmentation_56,
c2_.siren AS siren_57,
c2_.status AS status_58,
c2_.active AS active_59,
c2_.subscription_start AS subscription_start_60,
c2_.subscription_end AS subscription_end_61,
c2_.clients_count AS clients_count_62,
c2_.messages AS messages_63,
c2_.max_clients AS max_clients_64,
c2_.plan AS plan_65,
c2_.slug AS slug_66,
c2_.ips AS ips_67,
c2_.domain AS domain_68,
c2_.hourly_restriction AS hourly_restriction_69,
c2_.customizable AS customizable_70,
c2_.cms AS cms_71,
c2_.cms_title AS cms_title_72,
c2_.cms_text AS cms_text_73,
c2_.cms_cta_text AS cms_cta_text_74,
c2_.cms_cta_url AS cms_cta_url_75,
c2_.resa_link_active AS resa_link_active_76,
c2_.email AS email_77,
c2_.live AS live_78,
c2_.tv AS tv_79,
c2_.consult_link AS consult_link_80,
c2_.street AS street_81,
c2_.zip_code AS zip_code_82,
c2_.town AS town_83,
c2_.longitude AS longitude_84,
c2_.latitude AS latitude_85,
c2_.country AS country_86,
c2_.code AS code_87,
m3_.id AS id_88,
m3_.file_path AS file_path_89,
m3_.mime_type AS mime_type_90,
m3_.size AS size_91,
m3_.extra AS extra_92,
m3_.created_at AS created_at_93,
m3_.name AS name_94,
s4_.id AS id_95,
s4_.name AS name_96,
s4_.alone AS alone_97,
s4_.active AS active_98,
s4_.ranked AS ranked_99,
s4_.`rank` AS rank_100,
s4_.created_at AS created_at_101,
s4_.updated_at AS updated_at_102,
c5_.id AS id_103,
c5_.name AS name_104,
c5_.image AS image_105,
c5_.updated_at AS updated_at_106,
c5_.presentation AS presentation_107,
c5_.presentation_title AS presentation_title_108,
c5_.siret AS siret_109,
c5_.phone AS phone_110,
c5_.created_at AS created_at_111,
c5_.company_code AS company_code_112,
c5_.visio_allowed AS visio_allowed_113,
c5_.visio_payment_allowed AS visio_payment_allowed_114,
c5_.force_segmentation AS force_segmentation_115,
c5_.siren AS siren_116,
c5_.status AS status_117,
c5_.active AS active_118,
c5_.subscription_start AS subscription_start_119,
c5_.subscription_end AS subscription_end_120,
c5_.clients_count AS clients_count_121,
c5_.messages AS messages_122,
c5_.max_clients AS max_clients_123,
c5_.plan AS plan_124,
c5_.slug AS slug_125,
c5_.ips AS ips_126,
c5_.domain AS domain_127,
c5_.hourly_restriction AS hourly_restriction_128,
c5_.customizable AS customizable_129,
c5_.cms AS cms_130,
c5_.cms_title AS cms_title_131,
c5_.cms_text AS cms_text_132,
c5_.cms_cta_text AS cms_cta_text_133,
c5_.cms_cta_url AS cms_cta_url_134,
c5_.resa_link_active AS resa_link_active_135,
c5_.email AS email_136,
c5_.live AS live_137,
c5_.tv AS tv_138,
c5_.consult_link AS consult_link_139,
c5_.street AS street_140,
c5_.zip_code AS zip_code_141,
c5_.town AS town_142,
c5_.longitude AS longitude_143,
c5_.latitude AS latitude_144,
c5_.country AS country_145,
c5_.code AS code_146,
m6_.id AS id_147,
m6_.file_path AS file_path_148,
m6_.mime_type AS mime_type_149,
m6_.size AS size_150,
m6_.extra AS extra_151,
m6_.created_at AS created_at_152,
m6_.name AS name_153,
a7_.id AS id_154,
a7_.name AS name_155,
a7_.short_description AS short_description_156,
a7_.content AS content_157,
a7_.link_url AS link_url_158,
a7_.active AS active_159,
a7_.created_at AS created_at_160,
a7_.updated_at AS updated_at_161,
m8_.id AS id_162,
m8_.file_path AS file_path_163,
m8_.mime_type AS mime_type_164,
m8_.size AS size_165,
m8_.extra AS extra_166,
m8_.created_at AS created_at_167,
m8_.name AS name_168,
c0_.dtype AS dtype_169,
c0_.user_id AS user_id_170,
c0_.company_id AS company_id_171,
c0_.segmentation_id AS segmentation_id_172,
c0_.association_id AS association_id_173,
c0_.avatar_id AS avatar_id_174,
u1_.segmentation_id AS segmentation_id_175,
c2_.dtype AS dtype_176,
c2_.user_id AS user_id_177,
c2_.logo_id AS logo_id_178,
c2_.cms_img_id AS cms_img_id_179,
s4_.company_id AS company_id_180,
s4_.parent_id AS parent_id_181,
c5_.dtype AS dtype_182,
c5_.user_id AS user_id_183,
c5_.logo_id AS logo_id_184,
c5_.cms_img_id AS cms_img_id_185,
a7_.preview_id AS preview_id_186,
a7_.picture_id AS picture_id_187,
a7_.illustration_id AS illustration_id_188
FROM
client c0_
INNER JOIN `user` u1_ ON c0_.user_id = u1_.id
INNER JOIN company c2_ ON c0_.company_id = c2_.id
AND c2_.dtype IN ('company', 'externalcompany')
LEFT JOIN media_object m3_ ON c2_.logo_id = m3_.id
LEFT JOIN segmentation s4_ ON c0_.segmentation_id = s4_.id
LEFT JOIN company c5_ ON s4_.company_id = c5_.id
AND c5_.dtype IN ('company', 'externalcompany')
LEFT JOIN media_object m6_ ON c5_.logo_id = m6_.id
LEFT JOIN association a7_ ON c0_.association_id = a7_.id
LEFT JOIN media_object m8_ ON c0_.avatar_id = m8_.id
WHERE
(c0_.id = ?)
AND c0_.dtype IN ('client', 'externalclient')
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.payment_uid AS payment_uid_3, c0_.is_cgu AS is_cgu_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.code AS code_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.created_at AS created_at_12, u1_.updated_at AS updated_at_13, u1_.last_login AS last_login_14, u1_.name AS name_15, u1_.category AS category_16, u1_.active AS active_17, u1_.ban_start AS ban_start_18, u1_.ban_end AS ban_end_19, u1_.reset_token AS reset_token_20, u1_.first_name AS first_name_21, u1_.last_name AS last_name_22, u1_.country AS country_23, u1_.`function` AS function_24, u1_.phone AS phone_25, u1_.username AS username_26, u1_.quotas AS quotas_27, u1_.quotas_type AS quotas_type_28, u1_.email_updated_at AS email_updated_at_29, u1_.email_validated_at AS email_validated_at_30, u1_.status AS status_31, u1_.device_os AS device_os_32, u1_.device_token AS device_token_33, u1_.device_name AS device_name_34, u1_.device_active AS device_active_35, u1_.device_update AS device_update_36, u1_.newsletter AS newsletter_37, u1_.newsletter_date AS newsletter_date_38, u1_.first_login AS first_login_39, u1_.home_survey AS home_survey_40, u1_.display_teamplay_tuto AS display_teamplay_tuto_41, u1_.live AS live_42, u1_.tv AS tv_43, c2_.id AS id_44, c2_.name AS name_45, c2_.image AS image_46, c2_.updated_at AS updated_at_47, c2_.presentation AS presentation_48, c2_.presentation_title AS presentation_title_49, c2_.siret AS siret_50, c2_.phone AS phone_51, c2_.created_at AS created_at_52, c2_.company_code AS company_code_53, c2_.visio_allowed AS visio_allowed_54, c2_.visio_payment_allowed AS visio_payment_allowed_55, c2_.force_segmentation AS force_segmentation_56, c2_.siren AS siren_57, c2_.status AS status_58, c2_.active AS active_59, c2_.subscription_start AS subscription_start_60, c2_.subscription_end AS subscription_end_61, c2_.clients_count AS clients_count_62, c2_.messages AS messages_63, c2_.max_clients AS max_clients_64, c2_.plan AS plan_65, c2_.slug AS slug_66, c2_.ips AS ips_67, c2_.domain AS domain_68, c2_.hourly_restriction AS hourly_restriction_69, c2_.customizable AS customizable_70, c2_.cms AS cms_71, c2_.cms_title AS cms_title_72, c2_.cms_text AS cms_text_73, c2_.cms_cta_text AS cms_cta_text_74, c2_.cms_cta_url AS cms_cta_url_75, c2_.resa_link_active AS resa_link_active_76, c2_.email AS email_77, c2_.live AS live_78, c2_.tv AS tv_79, c2_.consult_link AS consult_link_80, c2_.street AS street_81, c2_.zip_code AS zip_code_82, c2_.town AS town_83, c2_.longitude AS longitude_84, c2_.latitude AS latitude_85, c2_.country AS country_86, c2_.code AS code_87, m3_.id AS id_88, m3_.file_path AS file_path_89, m3_.mime_type AS mime_type_90, m3_.size AS size_91, m3_.extra AS extra_92, m3_.created_at AS created_at_93, m3_.name AS name_94, s4_.id AS id_95, s4_.name AS name_96, s4_.alone AS alone_97, s4_.active AS active_98, s4_.ranked AS ranked_99, s4_.`rank` AS rank_100, s4_.created_at AS created_at_101, s4_.updated_at AS updated_at_102, c5_.id AS id_103, c5_.name AS name_104, c5_.image AS image_105, c5_.updated_at AS updated_at_106, c5_.presentation AS presentation_107, c5_.presentation_title AS presentation_title_108, c5_.siret AS siret_109, c5_.phone AS phone_110, c5_.created_at AS created_at_111, c5_.company_code AS company_code_112, c5_.visio_allowed AS visio_allowed_113, c5_.visio_payment_allowed AS visio_payment_allowed_114, c5_.force_segmentation AS force_segmentation_115, c5_.siren AS siren_116, c5_.status AS status_117, c5_.active AS active_118, c5_.subscription_start AS subscription_start_119, c5_.subscription_end AS subscription_end_120, c5_.clients_count AS clients_count_121, c5_.messages AS messages_122, c5_.max_clients AS max_clients_123, c5_.plan AS plan_124, c5_.slug AS slug_125, c5_.ips AS ips_126, c5_.domain AS domain_127, c5_.hourly_restriction AS hourly_restriction_128, c5_.customizable AS customizable_129, c5_.cms AS cms_130, c5_.cms_title AS cms_title_131, c5_.cms_text AS cms_text_132, c5_.cms_cta_text AS cms_cta_text_133, c5_.cms_cta_url AS cms_cta_url_134, c5_.resa_link_active AS resa_link_active_135, c5_.email AS email_136, c5_.live AS live_137, c5_.tv AS tv_138, c5_.consult_link AS consult_link_139, c5_.street AS street_140, c5_.zip_code AS zip_code_141, c5_.town AS town_142, c5_.longitude AS longitude_143, c5_.latitude AS latitude_144, c5_.country AS country_145, c5_.code AS code_146, m6_.id AS id_147, m6_.file_path AS file_path_148, m6_.mime_type AS mime_type_149, m6_.size AS size_150, m6_.extra AS extra_151, m6_.created_at AS created_at_152, m6_.name AS name_153, a7_.id AS id_154, a7_.name AS name_155, a7_.short_description AS short_description_156, a7_.content AS content_157, a7_.link_url AS link_url_158, a7_.active AS active_159, a7_.created_at AS created_at_160, a7_.updated_at AS updated_at_161, m8_.id AS id_162, m8_.file_path AS file_path_163, m8_.mime_type AS mime_type_164, m8_.size AS size_165, m8_.extra AS extra_166, m8_.created_at AS created_at_167, m8_.name AS name_168, c0_.dtype AS dtype_169, c0_.user_id AS user_id_170, c0_.company_id AS company_id_171, c0_.segmentation_id AS segmentation_id_172, c0_.association_id AS association_id_173, c0_.avatar_id AS avatar_id_174, u1_.segmentation_id AS segmentation_id_175, c2_.dtype AS dtype_176, c2_.user_id AS user_id_177, c2_.logo_id AS logo_id_178, c2_.cms_img_id AS cms_img_id_179, s4_.company_id AS company_id_180, s4_.parent_id AS parent_id_181, c5_.dtype AS dtype_182, c5_.user_id AS user_id_183, c5_.logo_id AS logo_id_184, c5_.cms_img_id AS cms_img_id_185, a7_.preview_id AS preview_id_186, a7_.picture_id AS picture_id_187, a7_.illustration_id AS illustration_id_188 FROM client c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN company c2_ ON c0_.company_id = c2_.id AND c2_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m3_ ON c2_.logo_id = m3_.id LEFT JOIN segmentation s4_ ON c0_.segmentation_id = s4_.id LEFT JOIN company c5_ ON s4_.company_id = c5_.id AND c5_.dtype IN ('company', 'externalcompany') LEFT JOIN media_object m6_ ON c5_.logo_id = m6_.id LEFT JOIN association a7_ ON c0_.association_id = a7_.id LEFT JOIN media_object m8_ ON c0_.avatar_id = m8_.id WHERE (c0_.id = 18131) AND c0_.dtype IN ('client', 'externalclient');
|