Symfony Profiler

Query Metrics

47 Database Queries

20 Different statements

8.52 ms Query time

1 Invalid entities

Queries


SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.address AS address_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.website AS website_10, t0.github AS github_11, t0.gitlab AS gitlab_12, t0.bitbucket AS bitbucket_13, t0.logo AS logo_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.instagram AS instagram_18, t0.youtube AS youtube_19, t0.research_gate AS research_gate_20, t0.academia AS academia_21, t0.review AS review_22 FROM lab t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ?
SELECT t0.id AS id_1, t0.original_lab_id AS original_lab_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.address AS address_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.created_at AS created_at_12, t3.website AS website_13, t3.github AS github_14, t3.gitlab AS gitlab_15, t3.bitbucket AS bitbucket_16, t3.logo AS logo_17, t3.linked_in AS linked_in_18, t3.twitter AS twitter_19, t3.facebook AS facebook_20, t3.instagram AS instagram_21, t3.youtube AS youtube_22, t3.research_gate AS research_gate_23, t3.academia AS academia_24, t3.review AS review_25, t0.edited_lab_id AS edited_lab_id_26, t27.id AS id_28, t27.name AS name_29, t27.acronym AS acronym_30, t27.description AS description_31, t27.address AS address_32, t27.translation AS translation_33, t27.slug AS slug_34, t27.status AS status_35, t27.created_at AS created_at_36, t27.website AS website_37, t27.github AS github_38, t27.gitlab AS gitlab_39, t27.bitbucket AS bitbucket_40, t27.logo AS logo_41, t27.linked_in AS linked_in_42, t27.twitter AS twitter_43, t27.facebook AS facebook_44, t27.instagram AS instagram_45, t27.youtube AS youtube_46, t27.research_gate AS research_gate_47, t27.academia AS academia_48, t27.review AS review_49 FROM lab_copy t0 LEFT JOIN lab t3 ON t0.original_lab_id = t3.id LEFT JOIN lab t27 ON t0.edited_lab_id = t27.id WHERE t0.edited_lab_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_lab ON t0.id = user_lab.user_id WHERE user_lab.lab_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_lab ON t0.id = software_lab.software_id WHERE software_lab.lab_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.address AS address_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.logo AS logo_10, t0.linked_in AS linked_in_11, t0.twitter AS twitter_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.review AS review_16 FROM institution t0 INNER JOIN lab_institution ON t0.id = lab_institution.institution_id WHERE lab_institution.lab_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ?
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ?
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?)
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?)
SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.logo AS logo_13, t0.linked_in AS linked_in_14, t0.twitter AS twitter_15, t0.facebook AS facebook_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.research_gate AS research_gate_19, t0.academia AS academia_20, t0.members AS members_21, t0.review AS review_22, t0.geolocation_id AS geolocation_id_23 FROM team t0 INNER JOIN lab_team ON t0.id = lab_team.team_id WHERE lab_team.lab_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?)
SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?)
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?)
SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?)
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?)
SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?)
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?)
SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ?
SELECT t0.id AS id_1, t0.domain AS domain_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM domain t0 INNER JOIN lab_domain ON t0.id = lab_domain.domain_id WHERE lab_domain.lab_id = ?
SELECT t0.id AS id_1, t0.discipline AS discipline_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM discipline t0 INNER JOIN lab_discipline ON t0.id = lab_discipline.discipline_id WHERE lab_discipline.lab_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.review AS review_6, t0.author_id AS author_id_7 FROM keyword t0 INNER JOIN keyword_lab ON t0.id = keyword_lab.keyword_id WHERE keyword_lab.lab_id = ?
SELECT t0.id AS id_1, t0.continent AS continent_2, t0.country AS country_3, t0.region AS region_4, t0.department AS department_5, t0.city AS city_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.zip_code AS zip_code_9, t0.address AS address_10, t0.department_num AS department_num_11 FROM geolocation t0 INNER JOIN lab_geolocation ON t0.id = lab_geolocation.geolocation_id WHERE lab_geolocation.lab_id = ?

#▲	Time	Info
1	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.address AS address_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.website AS website_10, t0.github AS github_11, t0.gitlab AS gitlab_12, t0.bitbucket AS bitbucket_13, t0.logo AS logo_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.instagram AS instagram_18, t0.youtube AS youtube_19, t0.research_gate AS research_gate_20, t0.academia AS academia_21, t0.review AS review_22 FROM lab t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"institut-de-recherche-en-informatique-de-toulouse-irit-jhom96aq-2"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.address AS address_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.website AS website_10, t0.github AS github_11, t0.gitlab AS gitlab_12, t0.bitbucket AS bitbucket_13, t0.logo AS logo_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.instagram AS instagram_18, t0.youtube AS youtube_19, t0.research_gate AS research_gate_20, t0.academia AS academia_21, t0.review AS review_22 FROM lab t0 WHERE t0.slug = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.address AS address_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.website AS website_10, t0.github AS github_11, t0.gitlab AS gitlab_12, t0.bitbucket AS bitbucket_13, t0.logo AS logo_14, t0.linked_in AS linked_in_15, t0.twitter AS twitter_16, t0.facebook AS facebook_17, t0.instagram AS instagram_18, t0.youtube AS youtube_19, t0.research_gate AS research_gate_20, t0.academia AS academia_21, t0.review AS review_22 FROM lab t0 WHERE t0.slug = 'institut-de-recherche-en-informatique-de-toulouse-irit-jhom96aq-2' LIMIT 1;
2	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_lab ON t0.id = media_lab.media_id WHERE media_lab.lab_id = 18;
3	0.31 ms	SELECT t0.id AS id_1, t0.original_lab_id AS original_lab_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.address AS address_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.created_at AS created_at_12, t3.website AS website_13, t3.github AS github_14, t3.gitlab AS gitlab_15, t3.bitbucket AS bitbucket_16, t3.logo AS logo_17, t3.linked_in AS linked_in_18, t3.twitter AS twitter_19, t3.facebook AS facebook_20, t3.instagram AS instagram_21, t3.youtube AS youtube_22, t3.research_gate AS research_gate_23, t3.academia AS academia_24, t3.review AS review_25, t0.edited_lab_id AS edited_lab_id_26, t27.id AS id_28, t27.name AS name_29, t27.acronym AS acronym_30, t27.description AS description_31, t27.address AS address_32, t27.translation AS translation_33, t27.slug AS slug_34, t27.status AS status_35, t27.created_at AS created_at_36, t27.website AS website_37, t27.github AS github_38, t27.gitlab AS gitlab_39, t27.bitbucket AS bitbucket_40, t27.logo AS logo_41, t27.linked_in AS linked_in_42, t27.twitter AS twitter_43, t27.facebook AS facebook_44, t27.instagram AS instagram_45, t27.youtube AS youtube_46, t27.research_gate AS research_gate_47, t27.academia AS academia_48, t27.review AS review_49 FROM lab_copy t0 LEFT JOIN lab t3 ON t0.original_lab_id = t3.id LEFT JOIN lab t27 ON t0.edited_lab_id = t27.id WHERE t0.edited_lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_lab_id AS original_lab_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.address AS address_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.created_at AS created_at_12, t3.website AS website_13, t3.github AS github_14, t3.gitlab AS gitlab_15, t3.bitbucket AS bitbucket_16, t3.logo AS logo_17, t3.linked_in AS linked_in_18, t3.twitter AS twitter_19, t3.facebook AS facebook_20, t3.instagram AS instagram_21, t3.youtube AS youtube_22, t3.research_gate AS research_gate_23, t3.academia AS academia_24, t3.review AS review_25, t0.edited_lab_id AS edited_lab_id_26, t27.id AS id_28, t27.name AS name_29, t27.acronym AS acronym_30, t27.description AS description_31, t27.address AS address_32, t27.translation AS translation_33, t27.slug AS slug_34, t27.status AS status_35, t27.created_at AS created_at_36, t27.website AS website_37, t27.github AS github_38, t27.gitlab AS gitlab_39, t27.bitbucket AS bitbucket_40, t27.logo AS logo_41, t27.linked_in AS linked_in_42, t27.twitter AS twitter_43, t27.facebook AS facebook_44, t27.instagram AS instagram_45, t27.youtube AS youtube_46, t27.research_gate AS research_gate_47, t27.academia AS academia_48, t27.review AS review_49 FROM lab_copy t0 LEFT JOIN lab t3 ON t0.original_lab_id = t3.id LEFT JOIN lab t27 ON t0.edited_lab_id = t27.id WHERE t0.edited_lab_id = ? SELECT t0.id AS id_1, t0.original_lab_id AS original_lab_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.description AS description_7, t3.address AS address_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.created_at AS created_at_12, t3.website AS website_13, t3.github AS github_14, t3.gitlab AS gitlab_15, t3.bitbucket AS bitbucket_16, t3.logo AS logo_17, t3.linked_in AS linked_in_18, t3.twitter AS twitter_19, t3.facebook AS facebook_20, t3.instagram AS instagram_21, t3.youtube AS youtube_22, t3.research_gate AS research_gate_23, t3.academia AS academia_24, t3.review AS review_25, t0.edited_lab_id AS edited_lab_id_26, t27.id AS id_28, t27.name AS name_29, t27.acronym AS acronym_30, t27.description AS description_31, t27.address AS address_32, t27.translation AS translation_33, t27.slug AS slug_34, t27.status AS status_35, t27.created_at AS created_at_36, t27.website AS website_37, t27.github AS github_38, t27.gitlab AS gitlab_39, t27.bitbucket AS bitbucket_40, t27.logo AS logo_41, t27.linked_in AS linked_in_42, t27.twitter AS twitter_43, t27.facebook AS facebook_44, t27.instagram AS instagram_45, t27.youtube AS youtube_46, t27.research_gate AS research_gate_47, t27.academia AS academia_48, t27.review AS review_49 FROM lab_copy t0 LEFT JOIN lab t3 ON t0.original_lab_id = t3.id LEFT JOIN lab t27 ON t0.edited_lab_id = t27.id WHERE t0.edited_lab_id = 18;
4	0.25 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_lab ON t0.id = user_lab.user_id WHERE user_lab.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_lab ON t0.id = user_lab.user_id WHERE user_lab.lab_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_lab ON t0.id = user_lab.user_id WHERE user_lab.lab_id = 18;
5	0.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_lab ON t0.id = software_lab.software_id WHERE software_lab.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_lab ON t0.id = software_lab.software_id WHERE software_lab.lab_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_lab ON t0.id = software_lab.software_id WHERE software_lab.lab_id = 18;
6	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.address AS address_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.logo AS logo_10, t0.linked_in AS linked_in_11, t0.twitter AS twitter_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.review AS review_16 FROM institution t0 INNER JOIN lab_institution ON t0.id = lab_institution.institution_id WHERE lab_institution.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.address AS address_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.logo AS logo_10, t0.linked_in AS linked_in_11, t0.twitter AS twitter_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.review AS review_16 FROM institution t0 INNER JOIN lab_institution ON t0.id = lab_institution.institution_id WHERE lab_institution.lab_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.address AS address_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.logo AS logo_10, t0.linked_in AS linked_in_11, t0.twitter AS twitter_12, t0.facebook AS facebook_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.review AS review_16 FROM institution t0 INNER JOIN lab_institution ON t0.id = lab_institution.institution_id WHERE lab_institution.lab_id = 18;
7	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ? Parameters: [`104`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = 104;
8	0.29 ms	SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?) Parameters: [`104`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?) SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (104);
9	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ? Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_institution ON t0.id = media_institution.media_id WHERE media_institution.institution_id = 123;
10	0.21 ms	SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?) Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (?) SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.original_institution_id IN (123);
11	0.22 ms	SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?) Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?) SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (123);
12	0.21 ms	SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?) Parameters: [`104`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (?) SELECT t0.id AS id_1, t0.original_institution_id AS original_institution_id_2, t3.id AS id_4, t3.name AS name_5, t3.acronym AS acronym_6, t3.address AS address_7, t3.translation AS translation_8, t3.slug AS slug_9, t3.status AS status_10, t3.created_at AS created_at_11, t3.website AS website_12, t3.logo AS logo_13, t3.linked_in AS linked_in_14, t3.twitter AS twitter_15, t3.facebook AS facebook_16, t3.instagram AS instagram_17, t3.youtube AS youtube_18, t3.review AS review_19, t0.copy_institution_id AS copy_institution_id_20, t21.id AS id_22, t21.name AS name_23, t21.acronym AS acronym_24, t21.address AS address_25, t21.translation AS translation_26, t21.slug AS slug_27, t21.status AS status_28, t21.created_at AS created_at_29, t21.website AS website_30, t21.logo AS logo_31, t21.linked_in AS linked_in_32, t21.twitter AS twitter_33, t21.facebook AS facebook_34, t21.instagram AS instagram_35, t21.youtube AS youtube_36, t21.review AS review_37 FROM institution_copy t0 LEFT JOIN institution t3 ON t0.original_institution_id = t3.id LEFT JOIN institution t21 ON t0.copy_institution_id = t21.id WHERE t0.copy_institution_id IN (104);
13	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.logo AS logo_13, t0.linked_in AS linked_in_14, t0.twitter AS twitter_15, t0.facebook AS facebook_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.research_gate AS research_gate_19, t0.academia AS academia_20, t0.members AS members_21, t0.review AS review_22, t0.geolocation_id AS geolocation_id_23 FROM team t0 INNER JOIN lab_team ON t0.id = lab_team.team_id WHERE lab_team.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.logo AS logo_13, t0.linked_in AS linked_in_14, t0.twitter AS twitter_15, t0.facebook AS facebook_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.research_gate AS research_gate_19, t0.academia AS academia_20, t0.members AS members_21, t0.review AS review_22, t0.geolocation_id AS geolocation_id_23 FROM team t0 INNER JOIN lab_team ON t0.id = lab_team.team_id WHERE lab_team.lab_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.description AS description_4, t0.translation AS translation_5, t0.slug AS slug_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.logo AS logo_13, t0.linked_in AS linked_in_14, t0.twitter AS twitter_15, t0.facebook AS facebook_16, t0.instagram AS instagram_17, t0.youtube AS youtube_18, t0.research_gate AS research_gate_19, t0.academia AS academia_20, t0.members AS members_21, t0.review AS review_22, t0.geolocation_id AS geolocation_id_23 FROM team t0 INNER JOIN lab_team ON t0.id = lab_team.team_id WHERE lab_team.lab_id = 18;
14	0.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`184`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 184;
15	0.21 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = 8;
16	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (8);
17	0.23 ms	SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (8);
18	0.20 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? Parameters: [`65`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = 65;
19	0.16 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) Parameters: [`65`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (65);
20	0.20 ms	SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) Parameters: [`65`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (65);
21	0.17 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? Parameters: [`232`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = 232;
22	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) Parameters: [`232`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (232);
23	0.21 ms	SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) Parameters: [`232`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (232);
24	0.16 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? Parameters: [`277`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN software_user ON t0.id = software_user.user_id WHERE software_user.software_id = 277;
25	0.12 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) Parameters: [`277`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (?) SELECT t0.id AS id_1, t0.name AS name_2, t0.technical_description AS technical_description_3, t0.image_name AS image_name_4, t0.image_root AS image_root_5, t0.type AS type_6, t0.url AS url_7, t0.status AS status_8, t0.created_at AS created_at_9, t0.software_id AS software_id_10 FROM container t0 WHERE t0.software_id IN (277);
26	0.16 ms	SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) Parameters: [`277`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (?) SELECT t0.id AS id_1, t0.original_software_id AS original_software_id_2, t3.id AS id_4, t3.name AS name_5, t3.description AS description_6, t3.version AS version_7, t3.created_at AS created_at_8, t3.translation AS translation_9, t3.slug AS slug_10, t3.status AS status_11, t3.website AS website_12, t3.github AS github_13, t3.gitlab AS gitlab_14, t3.bitbucket AS bitbucket_15, t3.id_hal AS id_hal_16, t3.bibtex AS bibtex_17, t3.logo AS logo_18, t3.developers AS developers_19, t3.os AS os_20, t3.project AS project_21, t3.funding AS funding_22, t3.review AS review_23, t3.swh AS swh_24, t3.on_platform AS on_platform_25, t3.private_demo AS private_demo_26, t3.hosted_demo AS hosted_demo_27, t0.edited_software_id AS edited_software_id_28, t29.id AS id_30, t29.name AS name_31, t29.description AS description_32, t29.version AS version_33, t29.created_at AS created_at_34, t29.translation AS translation_35, t29.slug AS slug_36, t29.status AS status_37, t29.website AS website_38, t29.github AS github_39, t29.gitlab AS gitlab_40, t29.bitbucket AS bitbucket_41, t29.id_hal AS id_hal_42, t29.bibtex AS bibtex_43, t29.logo AS logo_44, t29.developers AS developers_45, t29.os AS os_46, t29.project AS project_47, t29.funding AS funding_48, t29.review AS review_49, t29.swh AS swh_50, t29.on_platform AS on_platform_51, t29.private_demo AS private_demo_52, t29.hosted_demo AS hosted_demo_53 FROM software_copy t0 LEFT JOIN software t3 ON t0.original_software_id = t3.id LEFT JOIN software t29 ON t0.edited_software_id = t29.id WHERE t0.edited_software_id IN (277);
27	0.15 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`184`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 184;
28	0.22 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`184`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 184;
29	0.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`185`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 185;
30	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`185`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 185;
31	0.20 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`185`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 185;
32	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`206`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 206;
33	0.11 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`206`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 206;
34	0.17 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`206`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 206;
35	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`207`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 207;
36	0.11 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`207`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 207;
37	0.12 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`207`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 207;
38	0.11 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`480`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 480;
39	0.10 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`480`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 480;
40	0.11 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`480`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 480;
41	0.16 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? Parameters: [`482`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.version AS version_4, t0.created_at AS created_at_5, t0.translation AS translation_6, t0.slug AS slug_7, t0.status AS status_8, t0.website AS website_9, t0.github AS github_10, t0.gitlab AS gitlab_11, t0.bitbucket AS bitbucket_12, t0.id_hal AS id_hal_13, t0.bibtex AS bibtex_14, t0.logo AS logo_15, t0.developers AS developers_16, t0.os AS os_17, t0.project AS project_18, t0.funding AS funding_19, t0.review AS review_20, t0.swh AS swh_21, t0.on_platform AS on_platform_22, t0.private_demo AS private_demo_23, t0.hosted_demo AS hosted_demo_24 FROM software t0 INNER JOIN software_team ON t0.id = software_team.software_id WHERE software_team.team_id = 482;
42	0.10 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? Parameters: [`482`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.hide_description AS hide_description_3, t0.alt_text AS alt_text_4, t0.media_url AS media_url_5, t0.type AS type_6, t0.extension AS extension_7, t0.dimension AS dimension_8, t0.description AS description_9, t0.size AS size_10, t0.status AS status_11, t0.copyright AS copyright_12, t0.created_at AS created_at_13, t0.path AS path_14 FROM media t0 INNER JOIN media_team ON t0.id = media_team.media_id WHERE media_team.team_id = 482;
43	0.11 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? Parameters: [`482`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.auth_code AS auth_code_3, t0.roles AS roles_4, t0.password AS password_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.full_name AS full_name_8, t0.coder AS coder_9, t0.status AS status_10, t0.level_of_expertise AS level_of_expertise_11, t0.activation_token AS activation_token_12, t0.ai_researcher AS ai_researcher_13, t0.email_institution AS email_institution_14, t0.researcher_status AS researcher_status_15, t0.researcher_title AS researcher_title_16, t0.created_at AS created_at_17, t0.github AS github_18, t0.gitlab AS gitlab_19, t0.bitbucket AS bitbucket_20, t0.linked_in AS linked_in_21, t0.twitter AS twitter_22, t0.hal_author_id AS hal_author_id_23, t0.profile AS profile_24, t0.messaging_option AS messaging_option_25, t0.bio AS bio_26, t0.slug AS slug_27, t0.level_of_coding AS level_of_coding_28, t0.platform_access AS platform_access_29 FROM user t0 INNER JOIN user_team ON t0.id = user_team.user_id WHERE user_team.team_id = 482;
44	0.14 ms	SELECT t0.id AS id_1, t0.domain AS domain_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM domain t0 INNER JOIN lab_domain ON t0.id = lab_domain.domain_id WHERE lab_domain.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.domain AS domain_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM domain t0 INNER JOIN lab_domain ON t0.id = lab_domain.domain_id WHERE lab_domain.lab_id = ? SELECT t0.id AS id_1, t0.domain AS domain_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM domain t0 INNER JOIN lab_domain ON t0.id = lab_domain.domain_id WHERE lab_domain.lab_id = 18;
45	0.13 ms	SELECT t0.id AS id_1, t0.discipline AS discipline_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM discipline t0 INNER JOIN lab_discipline ON t0.id = lab_discipline.discipline_id WHERE lab_discipline.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.discipline AS discipline_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM discipline t0 INNER JOIN lab_discipline ON t0.id = lab_discipline.discipline_id WHERE lab_discipline.lab_id = ? SELECT t0.id AS id_1, t0.discipline AS discipline_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.review AS review_5, t0.slug AS slug_6, t0.parent_id AS parent_id_7, t0.author_id AS author_id_8 FROM discipline t0 INNER JOIN lab_discipline ON t0.id = lab_discipline.discipline_id WHERE lab_discipline.lab_id = 18;
46	0.12 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.review AS review_6, t0.author_id AS author_id_7 FROM keyword t0 INNER JOIN keyword_lab ON t0.id = keyword_lab.keyword_id WHERE keyword_lab.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.review AS review_6, t0.author_id AS author_id_7 FROM keyword t0 INNER JOIN keyword_lab ON t0.id = keyword_lab.keyword_id WHERE keyword_lab.lab_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.review AS review_6, t0.author_id AS author_id_7 FROM keyword t0 INNER JOIN keyword_lab ON t0.id = keyword_lab.keyword_id WHERE keyword_lab.lab_id = 18;
47	0.16 ms	SELECT t0.id AS id_1, t0.continent AS continent_2, t0.country AS country_3, t0.region AS region_4, t0.department AS department_5, t0.city AS city_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.zip_code AS zip_code_9, t0.address AS address_10, t0.department_num AS department_num_11 FROM geolocation t0 INNER JOIN lab_geolocation ON t0.id = lab_geolocation.geolocation_id WHERE lab_geolocation.lab_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.continent AS continent_2, t0.country AS country_3, t0.region AS region_4, t0.department AS department_5, t0.city AS city_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.zip_code AS zip_code_9, t0.address AS address_10, t0.department_num AS department_num_11 FROM geolocation t0 INNER JOIN lab_geolocation ON t0.id = lab_geolocation.geolocation_id WHERE lab_geolocation.lab_id = ? SELECT t0.id AS id_1, t0.continent AS continent_2, t0.country AS country_3, t0.region AS region_4, t0.department AS department_5, t0.city AS city_6, t0.status AS status_7, t0.created_at AS created_at_8, t0.zip_code AS zip_code_9, t0.address AS address_10, t0.department_num AS department_num_11 FROM geolocation t0 INNER JOIN lab_geolocation ON t0.id = lab_geolocation.geolocation_id WHERE lab_geolocation.lab_id = 18;

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\Lab	No errors.
App\Entity\Software	No errors.
App\Entity\Domain	No errors.
App\Entity\Discipline	No errors.
App\Entity\Skill	No errors.
App\Entity\Team	No errors.
App\Entity\Institution	No errors.
App\Entity\Comment	No errors.
App\Entity\Media	No errors.
App\Entity\Article	No errors.
App\Entity\User	The association App\Entity\User#calendars refers to the owning side field App\Entity\Calendar#user which does not exist. The association App\Entity\User#events refers to the owning side field App\Entity\Calendar#users which does not exist. The mappings App\Entity\User#owners and App\Entity\Calendar#owners are inconsistent with each other. The mappings App\Entity\User#participants and App\Entity\Calendar#participants are inconsistent with each other.
App\Entity\License	No errors.
App\Entity\Training	No errors.
App\Entity\Page	No errors.
App\Entity\Keyword	No errors.
App\Entity\Tag	No errors.
App\Entity\LabCopy	No errors.
App\Entity\Geolocation	No errors.
App\Entity\InstitutionCopy	No errors.
App\Entity\Container	No errors.
App\Entity\SoftwareData	No errors.
App\Entity\DemoSoftwareData	No errors.
App\Entity\CollectedData	No errors.
App\Entity\SoftwareCopy	No errors.
App\Entity\ProgrammingLanguage	No errors.
App\Entity\DataType	No errors.
App\Entity\TeamCopy	No errors.

Symfony Profiler

GET https://preprod.postlab.fr/laboratoire/institut-de-recherche-en-informatique-de-toulouse-irit-jhom96aq-2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping