GET https://preprod.postlab.fr/cartographie/logiciels?page=8

Response
200 OK
IP
18.217.237.169
Profiled on
Token
31a03a

Query Metrics

620 Database Queries
29 Different statements
103.76 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
31.52 ms
(30.38%) 		163 
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: 
[
  48
]
View formatted query    View runnable query    Explain query
27.27 ms
(26.29%) 		165 
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: 
[
  48
]
View formatted query    View runnable query    Explain query
21.41 ms
(20.63%) 		163 
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: 
[
  48
]
View formatted query    View runnable query    Explain query
2.60 ms
(2.51%) 		19 
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: 
[
  33
]
View formatted query    View runnable query    Explain query
2.23 ms
(2.15%) 		13 
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_authorized_users ON t0.id = software_authorized_users.software_id WHERE software_authorized_users.user_id = ?
Parameters: 
[
  72
]
View formatted query    View runnable query    Explain query
2.15 ms
(2.07%) 		13 
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 user_team ON t0.id = user_team.team_id WHERE user_team.user_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
1.87 ms
(1.81%) 		9 
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: 
[
  49
]
View formatted query    View runnable query    Explain query
1.84 ms
(1.77%) 		9 
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_software ON t0.id = media_software.media_id WHERE media_software.software_id = ?
Parameters: 
[
  46
]
View formatted query    View runnable query    Explain query
1.76 ms
(1.70%) 		13 
SELECT t0.id AS id_1, t0.name AS name_2, t0.volume_id AS volume_id_3, t0.path AS path_4, t0.server AS server_5, t0.ssh_key AS ssh_key_6, t0.creator AS creator_7, t0.in_exec_space AS in_exec_space_8, t0.file_system_type AS file_system_type_9, t0.type AS type_10, t0.created_at AS created_at_11 FROM volume t0 INNER JOIN volume_user ON t0.id = volume_user.volume_id WHERE volume_user.user_id = ?
Parameters: 
[
  132
]
View formatted query    View runnable query    Explain query
1.68 ms
(1.61%) 		9 
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: 
[
  49
]
View formatted query    View runnable query    Explain query
1.64 ms
(1.58%) 		9 
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: 
[
  49
]
View formatted query    View runnable query    Explain query
1.49 ms
(1.43%) 		13 
SELECT t0.id AS id_1, t0.title AS title_2, t0.ssh_key AS ssh_key_3, t0.type AS type_4, t0.expiration AS expiration_5, t0.user_id AS user_id_6 FROM user_sshkey t0 WHERE t0.user_id IN (?)
Parameters: 
[
  132
]
View formatted query    View runnable query    Explain query
1.02 ms
(0.98%) 		1 
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.acronym AS acronym_2, l0_.description AS description_3, l0_.address AS address_4, l0_.translation AS translation_5, l0_.slug AS slug_6, l0_.status AS status_7, l0_.created_at AS created_at_8, l0_.website AS website_9, l0_.github AS github_10, l0_.gitlab AS gitlab_11, l0_.bitbucket AS bitbucket_12, l0_.logo AS logo_13, l0_.linked_in AS linked_in_14, l0_.twitter AS twitter_15, l0_.facebook AS facebook_16, l0_.instagram AS instagram_17, l0_.youtube AS youtube_18, l0_.research_gate AS research_gate_19, l0_.academia AS academia_20, l0_.review AS review_21, s1_.id AS id_22, s1_.name AS name_23, s1_.description AS description_24, s1_.version AS version_25, s1_.created_at AS created_at_26, s1_.translation AS translation_27, s1_.slug AS slug_28, s1_.status AS status_29, s1_.website AS website_30, s1_.github AS github_31, s1_.gitlab AS gitlab_32, s1_.bitbucket AS bitbucket_33, s1_.id_hal AS id_hal_34, s1_.bibtex AS bibtex_35, s1_.logo AS logo_36, s1_.developers AS developers_37, s1_.os AS os_38, s1_.project AS project_39, s1_.funding AS funding_40, s1_.review AS review_41, s1_.swh AS swh_42, s1_.on_platform AS on_platform_43, s1_.private_demo AS private_demo_44, s1_.hosted_demo AS hosted_demo_45 FROM lab l0_ INNER JOIN software_lab s2_ ON l0_.id = s2_.lab_id INNER JOIN software s1_ ON s1_.id = s2_.software_id WHERE l0_.status = 'a:1:{s:9:\"published\";i:1;}' AND s1_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY l0_.acronym ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.79 ms
(0.76%) 		1 
SELECT d0_.id AS id_0, d0_.discipline AS discipline_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, s1_.id AS id_6, s1_.name AS name_7, s1_.description AS description_8, s1_.version AS version_9, s1_.created_at AS created_at_10, s1_.translation AS translation_11, s1_.slug AS slug_12, s1_.status AS status_13, s1_.website AS website_14, s1_.github AS github_15, s1_.gitlab AS gitlab_16, s1_.bitbucket AS bitbucket_17, s1_.id_hal AS id_hal_18, s1_.bibtex AS bibtex_19, s1_.logo AS logo_20, s1_.developers AS developers_21, s1_.os AS os_22, s1_.project AS project_23, s1_.funding AS funding_24, s1_.review AS review_25, s1_.swh AS swh_26, s1_.on_platform AS on_platform_27, s1_.private_demo AS private_demo_28, s1_.hosted_demo AS hosted_demo_29, d0_.parent_id AS parent_id_30, d0_.author_id AS author_id_31 FROM discipline d0_ INNER JOIN software_discipline s2_ ON d0_.id = s2_.discipline_id INNER JOIN software s1_ ON s1_.id = s2_.software_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.62 ms
(0.60%) 		1 
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.version AS version_3, s0_.created_at AS created_at_4, s0_.translation AS translation_5, s0_.slug AS slug_6, s0_.status AS status_7, s0_.website AS website_8, s0_.github AS github_9, s0_.gitlab AS gitlab_10, s0_.bitbucket AS bitbucket_11, s0_.id_hal AS id_hal_12, s0_.bibtex AS bibtex_13, s0_.logo AS logo_14, s0_.developers AS developers_15, s0_.os AS os_16, s0_.project AS project_17, s0_.funding AS funding_18, s0_.review AS review_19, s0_.swh AS swh_20, s0_.on_platform AS on_platform_21, s0_.private_demo AS private_demo_22, s0_.hosted_demo AS hosted_demo_23 FROM software s0_ WHERE s0_.status = 'a:1:{s:9:\"published\";i:1;}' ORDER BY s0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.47 ms
(0.45%) 		3 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.display_level AS display_level_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.action AS action_8, t0.result_file_path AS result_file_path_9, t0.result_display_path AS result_display_path_10, t0.container_id AS container_id_11, t0.script_id AS script_id_12, t0.output_type_id AS output_type_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t14.status AS status_18, t14.created_at AS created_at_19 FROM command t0 LEFT JOIN output_type t14 ON t0.output_type_id = t14.id WHERE t0.container_id IN (?)
Parameters: 
[
  7
]
View formatted query    View runnable query    Explain query
0.45 ms
(0.44%) 		2 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.original_license_id IN (?)
Parameters: 
[
  36
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.37%) 		2 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.edited_license_id IN (?)
Parameters: 
[
  37
]
View formatted query    View runnable query    Explain query
0.33 ms
(0.32%) 		2 
SELECT d0_.id AS id_0, d0_.type AS type_1, d0_.description AS description_2, d0_.url AS url_3, d0_.status AS status_4, d0_.created_at AS created_at_5 FROM data_type d0_ WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 ms
(0.32%) 		1 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.status AS status_3, p0_.created_at AS created_at_4, s1_.id AS id_5, s1_.name AS name_6, s1_.description AS description_7, s1_.version AS version_8, s1_.created_at AS created_at_9, s1_.translation AS translation_10, s1_.slug AS slug_11, s1_.status AS status_12, s1_.website AS website_13, s1_.github AS github_14, s1_.gitlab AS gitlab_15, s1_.bitbucket AS bitbucket_16, s1_.id_hal AS id_hal_17, s1_.bibtex AS bibtex_18, s1_.logo AS logo_19, s1_.developers AS developers_20, s1_.os AS os_21, s1_.project AS project_22, s1_.funding AS funding_23, s1_.review AS review_24, s1_.swh AS swh_25, s1_.on_platform AS on_platform_26, s1_.private_demo AS private_demo_27, s1_.hosted_demo AS hosted_demo_28 FROM programming_language p0_ INNER JOIN programming_language_software p2_ ON p0_.id = p2_.programming_language_id INNER JOIN software s1_ ON s1_.id = p2_.software_id WHERE p0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.30 ms
(0.29%) 		1 
SELECT l0_.id AS id_0, l0_.acronym AS acronym_1, l0_.version AS version_2, l0_.name AS name_3, l0_.description AS description_4, l0_.fees AS fees_5, l0_.usage_right AS usage_right_6, l0_.permissions AS permissions_7, l0_.limitations AS limitations_8, l0_.conditions AS conditions_9, l0_.translation AS translation_10, l0_.status AS status_11, l0_.created_at AS created_at_12, l0_.logo AS logo_13, l0_.website AS website_14, l0_.review AS review_15, l0_.slug AS slug_16, s1_.id AS id_17, s1_.name AS name_18, s1_.description AS description_19, s1_.version AS version_20, s1_.created_at AS created_at_21, s1_.translation AS translation_22, s1_.slug AS slug_23, s1_.status AS status_24, s1_.website AS website_25, s1_.github AS github_26, s1_.gitlab AS gitlab_27, s1_.bitbucket AS bitbucket_28, s1_.id_hal AS id_hal_29, s1_.bibtex AS bibtex_30, s1_.logo AS logo_31, s1_.developers AS developers_32, s1_.os AS os_33, s1_.project AS project_34, s1_.funding AS funding_35, s1_.review AS review_36, s1_.swh AS swh_37, s1_.on_platform AS on_platform_38, s1_.private_demo AS private_demo_39, s1_.hosted_demo AS hosted_demo_40 FROM license l0_ INNER JOIN software_license s2_ ON l0_.id = s2_.license_id INNER JOIN software s1_ ON s1_.id = s2_.software_id WHERE l0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.22 ms
(0.21%) 		1 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.edited_license_id IN (?, ?, ?)
Parameters: 
[
  4
  6
  35
]
View formatted query    View runnable query    Explain query
0.22 ms
(0.21%) 		1 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.original_license_id IN (?, ?)
Parameters: 
[
  2
  3
]
View formatted query    View runnable query    Explain query
0.22 ms
(0.21%) 		1 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.edited_license_id IN (?, ?)
Parameters: 
[
  2
  3
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.20%) 		1 
SELECT d0_.id AS id_0, d0_.domain AS domain_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.review AS review_4, d0_.slug AS slug_5, s1_.id AS id_6, s1_.name AS name_7, s1_.description AS description_8, s1_.version AS version_9, s1_.created_at AS created_at_10, s1_.translation AS translation_11, s1_.slug AS slug_12, s1_.status AS status_13, s1_.website AS website_14, s1_.github AS github_15, s1_.gitlab AS gitlab_16, s1_.bitbucket AS bitbucket_17, s1_.id_hal AS id_hal_18, s1_.bibtex AS bibtex_19, s1_.logo AS logo_20, s1_.developers AS developers_21, s1_.os AS os_22, s1_.project AS project_23, s1_.funding AS funding_24, s1_.review AS review_25, s1_.swh AS swh_26, s1_.on_platform AS on_platform_27, s1_.private_demo AS private_demo_28, s1_.hosted_demo AS hosted_demo_29, d0_.parent_id AS parent_id_30, d0_.author_id AS author_id_31 FROM domain d0_ INNER JOIN software_domain s2_ ON d0_.id = s2_.domain_id INNER JOIN software s1_ ON s1_.id = s2_.software_id WHERE d0_.status = 'a:1:{s:9:\"published\";i:1;}'
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.21 ms
(0.20%) 		1 
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: 
[
  529
  130
]
View formatted query    View runnable query    Explain query
0.20 ms
(0.19%) 		1 
SELECT t0.id AS id_1, t0.original_license_id AS original_license_id_2, t3.id AS id_4, t3.acronym AS acronym_5, t3.version AS version_6, t3.name AS name_7, t3.description AS description_8, t3.fees AS fees_9, t3.usage_right AS usage_right_10, t3.permissions AS permissions_11, t3.limitations AS limitations_12, t3.conditions AS conditions_13, t3.translation AS translation_14, t3.status AS status_15, t3.created_at AS created_at_16, t3.logo AS logo_17, t3.website AS website_18, t3.review AS review_19, t3.slug AS slug_20, t0.edited_license_id AS edited_license_id_21, t22.id AS id_23, t22.acronym AS acronym_24, t22.version AS version_25, t22.name AS name_26, t22.description AS description_27, t22.fees AS fees_28, t22.usage_right AS usage_right_29, t22.permissions AS permissions_30, t22.limitations AS limitations_31, t22.conditions AS conditions_32, t22.translation AS translation_33, t22.status AS status_34, t22.created_at AS created_at_35, t22.logo AS logo_36, t22.website AS website_37, t22.review AS review_38, t22.slug AS slug_39 FROM license_copy t0 LEFT JOIN license t3 ON t0.original_license_id = t3.id LEFT JOIN license t22 ON t0.edited_license_id = t22.id WHERE t0.original_license_id IN (?, ?, ?)
Parameters: 
[
  4
  6
  35
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.16%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.display_order AS display_order_4, t0.display_level AS display_level_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.action AS action_8, t0.result_file_path AS result_file_path_9, t0.result_display_path AS result_display_path_10, t0.container_id AS container_id_11, t0.script_id AS script_id_12, t0.output_type_id AS output_type_id_13, t14.id AS id_15, t14.name AS name_16, t14.description AS description_17, t14.status AS status_18, t14.created_at AS created_at_19 FROM command t0 LEFT JOIN output_type t14 ON t0.output_type_id = t14.id WHERE t0.container_id IN (?, ?, ?)
Parameters: 
[
  1
  2
  8
]
View formatted query    View runnable query    Explain query
0.15 ms
(0.15%) 		1 
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: 
[
  529
  130
]
View formatted query    View runnable query    Explain query

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\Keyword No errors.
App\Entity\Tag No errors.
App\Entity\LabCopy 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\Geolocation No errors.
App\Entity\Container No errors.
App\Entity\SoftwareData No errors.
App\Entity\DemoSoftwareData No errors.
App\Entity\CollectedData No errors.
App\Entity\License No errors.
App\Entity\SoftwareCopy No errors.
App\Entity\ProgrammingLanguage No errors.
App\Entity\DataType No errors.
App\Entity\Article No errors.
App\Entity\Training No errors.
App\Entity\Page No errors.
App\Entity\UserSoftware No errors.
App\Entity\Email No errors.
App\Entity\TeamCopy No errors.
App\Entity\Command No errors.
App\Entity\Script No errors.
App\Entity\OutputType No errors.
App\Entity\Parameter No errors.
App\Entity\Category No errors.
App\Entity\Encoding No errors.
App\Entity\Format No errors.
App\Entity\HtmlType No errors.
App\Entity\Notification No errors.
App\Entity\Invitation No errors.
App\Entity\Messages No errors.
App\Entity\Calendar No errors.
App\Entity\UserApiKey No errors.
App\Entity\Volume No errors.
App\Entity\UserSSHKey No errors.
App\Entity\Conversation No errors.
App\Entity\LicenseCopy No errors.