Query Metrics
20
Database Queries
8
Different statements
1366.41 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 162.06 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.start_at AS start_at_1 FROM conference c0_ LEFT JOIN conference_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN conference_conference_tag c3_ ON c0_.id = c3_.conference_id LEFT JOIN conference_tag c2_ ON c2_.id = c3_.conference_tag_id LEFT JOIN conference_company c5_ ON c0_.id = c5_.conference_id LEFT JOIN company c4_ ON c4_.id = c5_.company_id INNER JOIN container c6_ ON c0_.container_id = c6_.id LEFT JOIN rel_conference_speaker r8_ ON c0_.id = r8_.conference_id LEFT JOIN user u7_ ON u7_.id = r8_.user_id LEFT JOIN user_common_category u10_ ON u7_.id = u10_.user_id LEFT JOIN common_category c9_ ON c9_.id = u10_.common_category_id LEFT JOIN common_category c11_ ON c9_.parent_id = c11_.id LEFT JOIN common_category c12_ ON c9_.id = c12_.parent_id LEFT JOIN user_special_title u14_ ON u7_.id = u14_.user_id LEFT JOIN special_title s13_ ON s13_.id = u14_.special_title_id LEFT JOIN rel_user_academic_title r15_ ON u7_.id = r15_.user_id LEFT JOIN academic_title a16_ ON r15_.academic_title_id = a16_.id LEFT JOIN user_email_chanel u18_ ON u7_.id = u18_.user_id LEFT JOIN email_chanel e17_ ON e17_.id = u18_.email_chanel_id LEFT JOIN rel_conference_moderator r20_ ON c0_.id = r20_.conference_id LEFT JOIN user u19_ ON u19_.id = r20_.user_id LEFT JOIN user_common_category u22_ ON u19_.id = u22_.user_id LEFT JOIN common_category c21_ ON c21_.id = u22_.common_category_id LEFT JOIN common_category c23_ ON c21_.parent_id = c23_.id LEFT JOIN common_category c24_ ON c21_.id = c24_.parent_id LEFT JOIN user_special_title u26_ ON u19_.id = u26_.user_id LEFT JOIN special_title s25_ ON s25_.id = u26_.special_title_id LEFT JOIN rel_user_academic_title r27_ ON u19_.id = r27_.user_id LEFT JOIN academic_title a28_ ON r27_.academic_title_id = a28_.id LEFT JOIN user_email_chanel u30_ ON u19_.id = u30_.user_id LEFT JOIN email_chanel e29_ ON e29_.id = u30_.email_chanel_id LEFT JOIN common_category c31_ ON c0_.conference_category_id = c31_.id LEFT JOIN common_category c32_ ON c31_.parent_id = c32_.id LEFT JOIN common_category c33_ ON c31_.id = c33_.parent_id LEFT JOIN conference_credit c34_ ON c0_.id = c34_.conference_id LEFT JOIN credit_category c35_ ON c34_.credit_category_id = c35_.id WHERE c0_.id IN (SELECT c36_.id FROM conference c36_ LEFT JOIN conference_translation c37_ ON c36_.id = c37_.translatable_id LEFT JOIN conference_conference_tag c39_ ON c36_.id = c39_.conference_id LEFT JOIN conference_tag c38_ ON c38_.id = c39_.conference_tag_id LEFT JOIN conference_company c41_ ON c36_.id = c41_.conference_id LEFT JOIN company c40_ ON c40_.id = c41_.company_id WHERE c36_.container_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c36_.is_show_public = 1 AND c36_.is_visible = 1 AND c40_.id = ?) ORDER BY c0_.start_at DESC LIMIT 6
Parameters:
[ "18" "39" "83" "91" "97" "100" "102" "108" "110" "114" "115" "117" "118" "119" "120" "121" "122" "123" "124" "125" "126" "127" "131" "133" "135" "149" "159" "160" "165" "170" "171" "172" "173" "175" "176" "178" "182" "185" "186" "188" "192" "197" "198" "199" "200" "202" "206" "210" "213" "214" "215" "216" "217" "218" "219" "220" "222" "223" "224" "13" ] |
| 2 | 1089.02 ms |
SELECT c0_.id AS id_0, c0_.image_name AS image_name_1, c0_.is_visible AS is_visible_2, c0_.start_at AS start_at_3, c0_.end_at AS end_at_4, c0_.is_reminder_before_start AS is_reminder_before_start_5, c0_.reminder_before_start AS reminder_before_start_6, c0_.ord AS ord_7, c0_.is_show_public AS is_show_public_8, c0_.is_live AS is_live_9, c0_.is_use_user_group AS is_use_user_group_10, c0_.bullet_points AS bullet_points_11, c0_.is_certificate AS is_certificate_12, c0_.watch_time AS watch_time_13, c0_.old_id AS old_id_14, c0_.timezone AS timezone_15, c0_.is_register_enable AS is_register_enable_16, c0_.total_seats AS total_seats_17, c0_.available_seats AS available_seats_18, c0_.is_certificate_for_reply AS is_certificate_for_reply_19, c0_.conference_language AS conference_language_20, c0_.location AS location_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.created_at AS created_at_26, c1_.updated_at AS updated_at_27, c2_.id AS id_28, c2_.name AS name_29, c2_.website AS website_30, c2_.description AS description_31, c2_.external_id AS external_id_32, c2_.details AS details_33, c2_.logo_image_name AS logo_image_name_34, c2_.cover_image_name AS cover_image_name_35, c2_.tagline AS tagline_36, c2_.contact_email AS contact_email_37, c2_.phone AS phone_38, c2_.stream_url AS stream_url_39, c2_.stream_type AS stream_type_40, c2_.total_followers AS total_followers_41, c2_.industry AS industry_42, c2_.size AS size_43, c2_.address1 AS address1_44, c2_.address2 AS address2_45, c2_.city AS city_46, c2_.postal_code AS postal_code_47, c2_.state AS state_48, c2_.country AS country_49, c2_.social_linkedin AS social_linkedin_50, c2_.social_x AS social_x_51, c2_.social_facebook AS social_facebook_52, c2_.social_instagram AS social_instagram_53, c2_.social_youtube AS social_youtube_54, c2_.created_at AS created_at_55, c2_.updated_at AS updated_at_56, c3_.id AS id_57, c3_.domain AS domain_58, c3_.name AS name_59, c3_.container_group AS container_group_60, c3_.storage AS storage_61, c3_.bucket_key AS bucket_key_62, c3_.bucket_secret AS bucket_secret_63, c3_.bucket_name AS bucket_name_64, c3_.bucket_region AS bucket_region_65, c3_.bucket_endpoint AS bucket_endpoint_66, c3_.is_active AS is_active_67, c3_.configuration AS configuration_68, c3_.design_configuration AS design_configuration_69, c3_.description AS description_70, c3_.image_name AS image_name_71, c3_.navigation AS navigation_72, c3_.is_live_now AS is_live_now_73, c3_.video_gallery_ids AS video_gallery_ids_74, c3_.user_static_fields AS user_static_fields_75, c3_.logo_image_name AS logo_image_name_76, c3_.is_show_public AS is_show_public_77, c3_.is_main_container AS is_main_container_78, c3_.is_show_public_container AS is_show_public_container_79, c3_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_80, c3_.old_id AS old_id_81, c3_.is_login_container AS is_login_container_82, c3_.course_commission AS course_commission_83, c3_.created_at AS created_at_84, c3_.updated_at AS updated_at_85, u4_.id AS id_86, u4_.email AS email_87, u4_.password AS password_88, u4_.first_name AS first_name_89, u4_.last_name AS last_name_90, u4_.locale AS locale_91, u4_.status AS status_92, u4_.company AS company_93, u4_.job_title AS job_title_94, u4_.image_name AS image_name_95, u4_.source AS source_96, u4_.is_onboarded AS is_onboarded_97, u4_.is_blocked AS is_blocked_98, u4_.onboarded_at AS onboarded_at_99, u4_.last_login_at AS last_login_at_100, u4_.is_display_as_guest AS is_display_as_guest_101, u4_.is_expose_email AS is_expose_email_102, u4_.is_allow_communication AS is_allow_communication_103, u4_.timezone AS timezone_104, u4_.is_pwd_generated AS is_pwd_generated_105, u4_.is_online AS is_online_106, u4_.is_show_disclaimer AS is_show_disclaimer_107, u4_.sa_linkedin AS sa_linkedin_108, u4_.sa_twitter AS sa_twitter_109, u4_.sa_facebook AS sa_facebook_110, u4_.sa_instagram AS sa_instagram_111, u4_.sa_youtube AS sa_youtube_112, u4_.country AS country_113, u4_.fail_attempt_count AS fail_attempt_count_114, u4_.last_fail_attempt_at AS last_fail_attempt_at_115, u4_.login_block_until_at AS login_block_until_at_116, u4_.is_consider_speaker AS is_consider_speaker_117, u4_.is_consider_moderator AS is_consider_moderator_118, u4_.is_show_public AS is_show_public_119, u4_.is_notification_assign AS is_notification_assign_120, u4_.is_notification_chat AS is_notification_chat_121, u4_.is_notification_follow AS is_notification_follow_122, u4_.gln_number AS gln_number_123, u4_.ord AS ord_124, u4_.ord_state AS ord_state_125, u4_.is_notification_chat_group AS is_notification_chat_group_126, u4_.invite_code AS invite_code_127, u4_.headline AS headline_128, u4_.user_container_domain AS user_container_domain_129, u4_.is_unsubscribed_invite AS is_unsubscribed_invite_130, u4_.is_email_off AS is_email_off_131, u4_.created_at AS created_at_132, u4_.updated_at AS updated_at_133, c5_.id AS id_134, c5_.color AS color_135, c5_.text_color AS text_color_136, c5_.ord AS ord_137, c5_.type AS type_138, c5_.image_name AS image_name_139, c5_.created_at AS created_at_140, c5_.updated_at AS updated_at_141, c6_.id AS id_142, c6_.color AS color_143, c6_.text_color AS text_color_144, c6_.ord AS ord_145, c6_.type AS type_146, c6_.image_name AS image_name_147, c6_.created_at AS created_at_148, c6_.updated_at AS updated_at_149, c7_.id AS id_150, c7_.color AS color_151, c7_.text_color AS text_color_152, c7_.ord AS ord_153, c7_.type AS type_154, c7_.image_name AS image_name_155, c7_.created_at AS created_at_156, c7_.updated_at AS updated_at_157, s8_.id AS id_158, s8_.country AS country_159, s8_.color AS color_160, s8_.text_color AS text_color_161, s8_.created_at AS created_at_162, s8_.updated_at AS updated_at_163, r9_.id AS id_164, r9_.ord AS ord_165, a10_.id AS id_166, a10_.created_at AS created_at_167, a10_.updated_at AS updated_at_168, e11_.id AS id_169, e11_.created_at AS created_at_170, e11_.updated_at AS updated_at_171, u12_.id AS id_172, u12_.email AS email_173, u12_.password AS password_174, u12_.first_name AS first_name_175, u12_.last_name AS last_name_176, u12_.locale AS locale_177, u12_.status AS status_178, u12_.company AS company_179, u12_.job_title AS job_title_180, u12_.image_name AS image_name_181, u12_.source AS source_182, u12_.is_onboarded AS is_onboarded_183, u12_.is_blocked AS is_blocked_184, u12_.onboarded_at AS onboarded_at_185, u12_.last_login_at AS last_login_at_186, u12_.is_display_as_guest AS is_display_as_guest_187, u12_.is_expose_email AS is_expose_email_188, u12_.is_allow_communication AS is_allow_communication_189, u12_.timezone AS timezone_190, u12_.is_pwd_generated AS is_pwd_generated_191, u12_.is_online AS is_online_192, u12_.is_show_disclaimer AS is_show_disclaimer_193, u12_.sa_linkedin AS sa_linkedin_194, u12_.sa_twitter AS sa_twitter_195, u12_.sa_facebook AS sa_facebook_196, u12_.sa_instagram AS sa_instagram_197, u12_.sa_youtube AS sa_youtube_198, u12_.country AS country_199, u12_.fail_attempt_count AS fail_attempt_count_200, u12_.last_fail_attempt_at AS last_fail_attempt_at_201, u12_.login_block_until_at AS login_block_until_at_202, u12_.is_consider_speaker AS is_consider_speaker_203, u12_.is_consider_moderator AS is_consider_moderator_204, u12_.is_show_public AS is_show_public_205, u12_.is_notification_assign AS is_notification_assign_206, u12_.is_notification_chat AS is_notification_chat_207, u12_.is_notification_follow AS is_notification_follow_208, u12_.gln_number AS gln_number_209, u12_.ord AS ord_210, u12_.ord_state AS ord_state_211, u12_.is_notification_chat_group AS is_notification_chat_group_212, u12_.invite_code AS invite_code_213, u12_.headline AS headline_214, u12_.user_container_domain AS user_container_domain_215, u12_.is_unsubscribed_invite AS is_unsubscribed_invite_216, u12_.is_email_off AS is_email_off_217, u12_.created_at AS created_at_218, u12_.updated_at AS updated_at_219, c13_.id AS id_220, c13_.color AS color_221, c13_.text_color AS text_color_222, c13_.ord AS ord_223, c13_.type AS type_224, c13_.image_name AS image_name_225, c13_.created_at AS created_at_226, c13_.updated_at AS updated_at_227, c14_.id AS id_228, c14_.color AS color_229, c14_.text_color AS text_color_230, c14_.ord AS ord_231, c14_.type AS type_232, c14_.image_name AS image_name_233, c14_.created_at AS created_at_234, c14_.updated_at AS updated_at_235, c15_.id AS id_236, c15_.color AS color_237, c15_.text_color AS text_color_238, c15_.ord AS ord_239, c15_.type AS type_240, c15_.image_name AS image_name_241, c15_.created_at AS created_at_242, c15_.updated_at AS updated_at_243, s16_.id AS id_244, s16_.country AS country_245, s16_.color AS color_246, s16_.text_color AS text_color_247, s16_.created_at AS created_at_248, s16_.updated_at AS updated_at_249, r17_.id AS id_250, r17_.ord AS ord_251, a18_.id AS id_252, a18_.created_at AS created_at_253, a18_.updated_at AS updated_at_254, e19_.id AS id_255, e19_.created_at AS created_at_256, e19_.updated_at AS updated_at_257, c20_.id AS id_258, c20_.color AS color_259, c20_.text_color AS text_color_260, c20_.ord AS ord_261, c20_.type AS type_262, c20_.image_name AS image_name_263, c20_.created_at AS created_at_264, c20_.updated_at AS updated_at_265, c21_.id AS id_266, c21_.color AS color_267, c21_.text_color AS text_color_268, c21_.ord AS ord_269, c21_.type AS type_270, c21_.image_name AS image_name_271, c21_.created_at AS created_at_272, c21_.updated_at AS updated_at_273, c22_.id AS id_274, c22_.color AS color_275, c22_.text_color AS text_color_276, c22_.ord AS ord_277, c22_.type AS type_278, c22_.image_name AS image_name_279, c22_.created_at AS created_at_280, c22_.updated_at AS updated_at_281, c23_.id AS id_282, c23_.credit_point AS credit_point_283, c24_.id AS id_284, c24_.created_at AS created_at_285, c24_.updated_at AS updated_at_286, c0_.container_id AS container_id_287, c0_.conference_category_id AS conference_category_id_288, c0_.certificate_template_id AS certificate_template_id_289, c1_.container_id AS container_id_290, c2_.client_id AS client_id_291, c2_.company_category_id AS company_category_id_292, c3_.client_id AS client_id_293, c3_.container_category_id AS container_category_id_294, u4_.client_id AS client_id_295, u4_.relation_manager_id AS relation_manager_id_296, u4_.user_container_id AS user_container_id_297, u4_.organization_id AS organization_id_298, c5_.client_id AS client_id_299, c5_.parent_id AS parent_id_300, c6_.client_id AS client_id_301, c6_.parent_id AS parent_id_302, c7_.client_id AS client_id_303, c7_.parent_id AS parent_id_304, s8_.client_id AS client_id_305, s8_.newsfeed_category_id AS newsfeed_category_id_306, r9_.academic_title_id AS academic_title_id_307, r9_.user_id AS user_id_308, a10_.client_id AS client_id_309, e11_.client_id AS client_id_310, u12_.client_id AS client_id_311, u12_.relation_manager_id AS relation_manager_id_312, u12_.user_container_id AS user_container_id_313, u12_.organization_id AS organization_id_314, c13_.client_id AS client_id_315, c13_.parent_id AS parent_id_316, c14_.client_id AS client_id_317, c14_.parent_id AS parent_id_318, c15_.client_id AS client_id_319, c15_.parent_id AS parent_id_320, s16_.client_id AS client_id_321, s16_.newsfeed_category_id AS newsfeed_category_id_322, r17_.academic_title_id AS academic_title_id_323, r17_.user_id AS user_id_324, a18_.client_id AS client_id_325, e19_.client_id AS client_id_326, c20_.client_id AS client_id_327, c20_.parent_id AS parent_id_328, c21_.client_id AS client_id_329, c21_.parent_id AS parent_id_330, c22_.client_id AS client_id_331, c22_.parent_id AS parent_id_332, c23_.conference_id AS conference_id_333, c23_.credit_category_id AS credit_category_id_334, c24_.client_id AS client_id_335 FROM conference c0_ LEFT JOIN conference_translation c25_ ON c0_.id = c25_.translatable_id LEFT JOIN conference_conference_tag c26_ ON c0_.id = c26_.conference_id LEFT JOIN conference_tag c1_ ON c1_.id = c26_.conference_tag_id LEFT JOIN conference_company c27_ ON c0_.id = c27_.conference_id LEFT JOIN company c2_ ON c2_.id = c27_.company_id INNER JOIN container c3_ ON c0_.container_id = c3_.id LEFT JOIN rel_conference_speaker r28_ ON c0_.id = r28_.conference_id LEFT JOIN user u4_ ON u4_.id = r28_.user_id LEFT JOIN user_common_category u29_ ON u4_.id = u29_.user_id LEFT JOIN common_category c5_ ON c5_.id = u29_.common_category_id LEFT JOIN common_category c6_ ON c5_.parent_id = c6_.id LEFT JOIN common_category c7_ ON c5_.id = c7_.parent_id LEFT JOIN user_special_title u30_ ON u4_.id = u30_.user_id LEFT JOIN special_title s8_ ON s8_.id = u30_.special_title_id LEFT JOIN rel_user_academic_title r9_ ON u4_.id = r9_.user_id LEFT JOIN academic_title a10_ ON r9_.academic_title_id = a10_.id LEFT JOIN user_email_chanel u31_ ON u4_.id = u31_.user_id LEFT JOIN email_chanel e11_ ON e11_.id = u31_.email_chanel_id LEFT JOIN rel_conference_moderator r32_ ON c0_.id = r32_.conference_id LEFT JOIN user u12_ ON u12_.id = r32_.user_id LEFT JOIN user_common_category u33_ ON u12_.id = u33_.user_id LEFT JOIN common_category c13_ ON c13_.id = u33_.common_category_id LEFT JOIN common_category c14_ ON c13_.parent_id = c14_.id LEFT JOIN common_category c15_ ON c13_.id = c15_.parent_id LEFT JOIN user_special_title u34_ ON u12_.id = u34_.user_id LEFT JOIN special_title s16_ ON s16_.id = u34_.special_title_id LEFT JOIN rel_user_academic_title r17_ ON u12_.id = r17_.user_id LEFT JOIN academic_title a18_ ON r17_.academic_title_id = a18_.id LEFT JOIN user_email_chanel u35_ ON u12_.id = u35_.user_id LEFT JOIN email_chanel e19_ ON e19_.id = u35_.email_chanel_id LEFT JOIN common_category c20_ ON c0_.conference_category_id = c20_.id LEFT JOIN common_category c21_ ON c20_.parent_id = c21_.id LEFT JOIN common_category c22_ ON c20_.id = c22_.parent_id LEFT JOIN conference_credit c23_ ON c0_.id = c23_.conference_id LEFT JOIN credit_category c24_ ON c23_.credit_category_id = c24_.id WHERE c0_.id IN (SELECT c36_.id FROM conference c36_ LEFT JOIN conference_translation c37_ ON c36_.id = c37_.translatable_id LEFT JOIN conference_conference_tag c39_ ON c36_.id = c39_.conference_id LEFT JOIN conference_tag c38_ ON c38_.id = c39_.conference_tag_id LEFT JOIN conference_company c41_ ON c36_.id = c41_.conference_id LEFT JOIN company c40_ ON c40_.id = c41_.company_id WHERE c36_.container_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c36_.is_show_public = 1 AND c36_.is_visible = 1 AND c40_.id = ?) AND c0_.id IN (?, ?) ORDER BY c0_.start_at DESC, u4_.last_name ASC, u12_.last_name ASC
Parameters:
[ "18" "39" "83" "91" "97" "100" "102" "108" "110" "114" "115" "117" "118" "119" "120" "121" "122" "123" "124" "125" "126" "127" "131" "133" "135" "149" "159" "160" "165" "170" "171" "172" "173" "175" "176" "178" "182" "185" "186" "188" "192" "197" "198" "199" "200" "202" "206" "210" "213" "214" "215" "216" "217" "218" "219" "220" "222" "223" "224" "13" 1912 1908 ] |
| 3 | 1.30 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = ? OR c0_.domain = ?
Parameters:
[ "global.doclift.com" "www.global.doclift.com" ] |
| 4 | 0.72 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = ? OR c0_.domain = ?
Parameters:
[ "global.doclift.com" "www.global.doclift.com" ] |
| 5 | 0.63 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = ? OR c0_.domain = ?
Parameters:
[ "global.doclift.com" "www.global.doclift.com" ] |
| 6 | 0.61 ms |
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = ? OR c0_.domain = ?
Parameters:
[ "global.doclift.com" "www.global.doclift.com" ] |
| 7 | 1.14 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.translatable_id AS translatable_id_5 FROM conference_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1912
]
|
| 8 | 0.50 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM special_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 9 ] |
| 9 | 0.44 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM academic_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 18 ] |
| 10 | 0.44 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM academic_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 16 ] |
| 11 | 0.43 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM special_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 15 ] |
| 12 | 0.42 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM academic_title_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 20 ] |
| 13 | 0.47 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 7 ] |
| 14 | 0.44 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 33 ] |
| 15 | 0.42 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 30 ] |
| 16 | 0.43 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 31 ] |
| 17 | 0.47 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 29 ] |
| 18 | 0.98 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.translatable_id AS translatable_id_5 FROM conference_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1908
]
|
| 19 | 0.44 ms |
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM credit_category_translation t0 WHERE (t0.locale = ? AND t0.translatable_id = ?)
Parameters:
[ "en" 4 ] |
| 20 | 105.07 ms |
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM conference c0_ LEFT JOIN conference_translation c1_ ON c0_.id = c1_.translatable_id LEFT JOIN conference_conference_tag c3_ ON c0_.id = c3_.conference_id LEFT JOIN conference_tag c2_ ON c2_.id = c3_.conference_tag_id LEFT JOIN conference_company c5_ ON c0_.id = c5_.conference_id LEFT JOIN company c4_ ON c4_.id = c5_.company_id INNER JOIN container c6_ ON c0_.container_id = c6_.id LEFT JOIN rel_conference_speaker r8_ ON c0_.id = r8_.conference_id LEFT JOIN user u7_ ON u7_.id = r8_.user_id LEFT JOIN user_common_category u10_ ON u7_.id = u10_.user_id LEFT JOIN common_category c9_ ON c9_.id = u10_.common_category_id LEFT JOIN common_category c11_ ON c9_.parent_id = c11_.id LEFT JOIN common_category c12_ ON c9_.id = c12_.parent_id LEFT JOIN user_special_title u14_ ON u7_.id = u14_.user_id LEFT JOIN special_title s13_ ON s13_.id = u14_.special_title_id LEFT JOIN rel_user_academic_title r15_ ON u7_.id = r15_.user_id LEFT JOIN academic_title a16_ ON r15_.academic_title_id = a16_.id LEFT JOIN user_email_chanel u18_ ON u7_.id = u18_.user_id LEFT JOIN email_chanel e17_ ON e17_.id = u18_.email_chanel_id LEFT JOIN rel_conference_moderator r20_ ON c0_.id = r20_.conference_id LEFT JOIN user u19_ ON u19_.id = r20_.user_id LEFT JOIN user_common_category u22_ ON u19_.id = u22_.user_id LEFT JOIN common_category c21_ ON c21_.id = u22_.common_category_id LEFT JOIN common_category c23_ ON c21_.parent_id = c23_.id LEFT JOIN common_category c24_ ON c21_.id = c24_.parent_id LEFT JOIN user_special_title u26_ ON u19_.id = u26_.user_id LEFT JOIN special_title s25_ ON s25_.id = u26_.special_title_id LEFT JOIN rel_user_academic_title r27_ ON u19_.id = r27_.user_id LEFT JOIN academic_title a28_ ON r27_.academic_title_id = a28_.id LEFT JOIN user_email_chanel u30_ ON u19_.id = u30_.user_id LEFT JOIN email_chanel e29_ ON e29_.id = u30_.email_chanel_id LEFT JOIN common_category c31_ ON c0_.conference_category_id = c31_.id LEFT JOIN common_category c32_ ON c31_.parent_id = c32_.id LEFT JOIN common_category c33_ ON c31_.id = c33_.parent_id LEFT JOIN conference_credit c34_ ON c0_.id = c34_.conference_id LEFT JOIN credit_category c35_ ON c34_.credit_category_id = c35_.id WHERE c0_.id IN (SELECT c36_.id FROM conference c36_ LEFT JOIN conference_translation c37_ ON c36_.id = c37_.translatable_id LEFT JOIN conference_conference_tag c39_ ON c36_.id = c39_.conference_id LEFT JOIN conference_tag c38_ ON c38_.id = c39_.conference_tag_id LEFT JOIN conference_company c41_ ON c36_.id = c41_.conference_id LEFT JOIN company c40_ ON c40_.id = c41_.company_id WHERE c36_.container_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c36_.is_show_public = 1 AND c36_.is_visible = 1 AND c40_.id = ?)
Parameters:
[ "18" "39" "83" "91" "97" "100" "102" "108" "110" "114" "115" "117" "118" "119" "120" "121" "122" "123" "124" "125" "126" "127" "131" "133" "135" "149" "159" "160" "165" "170" "171" "172" "173" "175" "176" "178" "182" "185" "186" "188" "192" "197" "198" "199" "200" "202" "206" "210" "213" "214" "215" "216" "217" "218" "219" "220" "222" "223" "224" "13" ] |
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.