Symfony Profiler

SELECT
  t0_.param_nom AS param_nom_0,
  t0_.param_etat AS param_etat_1,
  t0_.param_value AS param_value_2
FROM
  tbl_param t0_

SELECT t0_.param_nom AS param_nom_0, t0_.param_etat AS param_etat_1, t0_.param_value AS param_value_2 FROM tbl_param t0_;

SELECT
  t0_.param_nom AS param_nom_0,
  t0_.param_etat AS param_etat_1,
  t0_.param_value AS param_value_2
FROM
  tbl_param t0_

SELECT t0_.param_nom AS param_nom_0, t0_.param_etat AS param_etat_1, t0_.param_value AS param_value_2 FROM tbl_param t0_;

SELECT
  t0.id AS id_1,
  t0.raison_social AS raison_social_2,
  t0.adresse AS adresse_3,
  t0.code_postal AS code_postal_4,
  t0.pays AS pays_5,
  t0.departement AS departement_6,
  t0.devise_principale AS devise_principale_7,
  t0.telephone AS telephone_8,
  t0.fax AS fax_9,
  t0.email AS email_10,
  t0.web AS web_11,
  t0.note AS note_12,
  t0.nom_contact AS nom_contact_13,
  t0.prenom_contact AS prenom_contact_14,
  t0.phone_contact AS phone_contact_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.deleted_at AS deleted_at_18,
  t0.ice AS ice_19,
  t0.cnss AS cnss_20,
  t0.patente AS patente_21,
  t0.identifiant_fiscale AS identifiant_fiscale_22,
  t0.registre_commerce AS registre_commerce_23,
  t0.ville AS ville_24,
  t0.logo_societe_id AS logo_societe_id_25,
  t0.image_header_id AS image_header_id_26,
  t0.image_footer_id AS image_footer_id_27,
  t0.created_by AS created_by_28,
  t0.updated_by AS updated_by_29,
  t0.deleted_by AS deleted_by_30,
  t0.banque_id AS banque_id_31
FROM
  tbl_societe t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.departement AS departement_6, t0.devise_principale AS devise_principale_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.email AS email_10, t0.web AS web_11, t0.note AS note_12, t0.nom_contact AS nom_contact_13, t0.prenom_contact AS prenom_contact_14, t0.phone_contact AS phone_contact_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.ice AS ice_19, t0.cnss AS cnss_20, t0.patente AS patente_21, t0.identifiant_fiscale AS identifiant_fiscale_22, t0.registre_commerce AS registre_commerce_23, t0.ville AS ville_24, t0.logo_societe_id AS logo_societe_id_25, t0.image_header_id AS image_header_id_26, t0.image_footer_id AS image_footer_id_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.deleted_by AS deleted_by_30, t0.banque_id AS banque_id_31 FROM tbl_societe t0 WHERE t0.id = 1;

SELECT
  t0.file_id AS file_id_1,
  t0.file_name AS file_name_2,
  t0.file_ext AS file_ext_3,
  t0.file_size AS file_size_4,
  t0.origin_name AS origin_name_5,
  t0.file_path AS file_path_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.is_upload_graph AS is_upload_graph_10,
  t0.is_secured AS is_secured_11,
  t0.is_optimized AS is_optimized_12,
  t0.prelevement_id AS prelevement_id_13,
  t0.updated_by AS updated_by_14,
  t0.created_by AS created_by_15,
  t0.deleted_by AS deleted_by_16,
  t0.identification_materiaux_id AS identification_materiaux_id_17,
  t0.pieces_identification_id AS pieces_identification_id_18,
  t0.essais_speciaux_id AS essais_speciaux_id_19,
  t0.pieces_essais_speciaux_id AS pieces_essais_speciaux_id_20,
  t0.rapport_final_prelevement_id AS rapport_final_prelevement_id_21,
  t0.rapport_final_compactage_id AS rapport_final_compactage_id_22,
  t0.reglement_id AS reglement_id_23,
  t0.tbl_compactge_id AS tbl_compactge_id_24,
  t0.pieces_compactage_id AS pieces_compactage_id_25,
  t0.tbl_dossier_id AS tbl_dossier_id_26,
  t27.id AS id_28,
  t27.raison_social AS raison_social_29,
  t27.adresse AS adresse_30,
  t27.code_postal AS code_postal_31,
  t27.pays AS pays_32,
  t27.departement AS departement_33,
  t27.devise_principale AS devise_principale_34,
  t27.telephone AS telephone_35,
  t27.fax AS fax_36,
  t27.email AS email_37,
  t27.web AS web_38,
  t27.note AS note_39,
  t27.nom_contact AS nom_contact_40,
  t27.prenom_contact AS prenom_contact_41,
  t27.phone_contact AS phone_contact_42,
  t27.created_at AS created_at_43,
  t27.updated_at AS updated_at_44,
  t27.deleted_at AS deleted_at_45,
  t27.ice AS ice_46,
  t27.cnss AS cnss_47,
  t27.patente AS patente_48,
  t27.identifiant_fiscale AS identifiant_fiscale_49,
  t27.registre_commerce AS registre_commerce_50,
  t27.ville AS ville_51,
  t27.logo_societe_id AS logo_societe_id_52,
  t27.image_header_id AS image_header_id_53,
  t27.image_footer_id AS image_footer_id_54,
  t27.created_by AS created_by_55,
  t27.updated_by AS updated_by_56,
  t27.deleted_by AS deleted_by_57,
  t27.banque_id AS banque_id_58,
  t59.id AS id_60,
  t59.raison_social AS raison_social_61,
  t59.adresse AS adresse_62,
  t59.code_postal AS code_postal_63,
  t59.pays AS pays_64,
  t59.departement AS departement_65,
  t59.devise_principale AS devise_principale_66,
  t59.telephone AS telephone_67,
  t59.fax AS fax_68,
  t59.email AS email_69,
  t59.web AS web_70,
  t59.note AS note_71,
  t59.nom_contact AS nom_contact_72,
  t59.prenom_contact AS prenom_contact_73,
  t59.phone_contact AS phone_contact_74,
  t59.created_at AS created_at_75,
  t59.updated_at AS updated_at_76,
  t59.deleted_at AS deleted_at_77,
  t59.ice AS ice_78,
  t59.cnss AS cnss_79,
  t59.patente AS patente_80,
  t59.identifiant_fiscale AS identifiant_fiscale_81,
  t59.registre_commerce AS registre_commerce_82,
  t59.ville AS ville_83,
  t59.logo_societe_id AS logo_societe_id_84,
  t59.image_header_id AS image_header_id_85,
  t59.image_footer_id AS image_footer_id_86,
  t59.created_by AS created_by_87,
  t59.updated_by AS updated_by_88,
  t59.deleted_by AS deleted_by_89,
  t59.banque_id AS banque_id_90,
  t91.id AS id_92,
  t91.raison_social AS raison_social_93,
  t91.adresse AS adresse_94,
  t91.code_postal AS code_postal_95,
  t91.pays AS pays_96,
  t91.departement AS departement_97,
  t91.devise_principale AS devise_principale_98,
  t91.telephone AS telephone_99,
  t91.fax AS fax_100,
  t91.email AS email_101,
  t91.web AS web_102,
  t91.note AS note_103,
  t91.nom_contact AS nom_contact_104,
  t91.prenom_contact AS prenom_contact_105,
  t91.phone_contact AS phone_contact_106,
  t91.created_at AS created_at_107,
  t91.updated_at AS updated_at_108,
  t91.deleted_at AS deleted_at_109,
  t91.ice AS ice_110,
  t91.cnss AS cnss_111,
  t91.patente AS patente_112,
  t91.identifiant_fiscale AS identifiant_fiscale_113,
  t91.registre_commerce AS registre_commerce_114,
  t91.ville AS ville_115,
  t91.logo_societe_id AS logo_societe_id_116,
  t91.image_header_id AS image_header_id_117,
  t91.image_footer_id AS image_footer_id_118,
  t91.created_by AS created_by_119,
  t91.updated_by AS updated_by_120,
  t91.deleted_by AS deleted_by_121,
  t91.banque_id AS banque_id_122,
  t123.formation_id AS formation_id_124,
  t123.formation_lib AS formation_lib_125,
  t123.formation_lib_court AS formation_lib_court_126,
  t123.created_at AS created_at_127,
  t123.updated_at AS updated_at_128,
  t123.deleted_at AS deleted_at_129,
  t123.formation_file_id AS formation_file_id_130,
  t123.created_by AS created_by_131,
  t123.updated_by AS updated_by_132,
  t123.deleted_by AS deleted_by_133,
  t134.user_id AS user_id_135,
  t134.username AS username_136,
  t134.password AS password_137,
  t134.email AS email_138,
  t134.tel AS tel_139,
  t134.date_naissance AS date_naissance_140,
  t134.first_name AS first_name_141,
  t134.last_name AS last_name_142,
  t134.is_associe AS is_associe_143,
  t134.username_court AS username_court_144,
  t134.nbr_conncetion AS nbr_conncetion_145,
  t134.last_connection AS last_connection_146,
  t134.current_session_token AS current_session_token_147,
  t134.cin AS cin_148,
  t134.actif AS actif_149,
  t134.code_user AS code_user_150,
  t134.roles AS roles_151,
  t134.action_permission AS action_permission_152,
  t134.action_permission_technique AS action_permission_technique_153,
  t134.action_permission_excluded AS action_permission_excluded_154,
  t134.is_admin_permissions_technique AS is_admin_permissions_technique_155,
  t134.is_admin_editique AS is_admin_editique_156,
  t134.is_admin_session AS is_admin_session_157,
  t134.is_reviseur AS is_reviseur_158,
  t134.is_qualite AS is_qualite_159,
  t134.is_gestionnaire_equipement AS is_gestionnaire_equipement_160,
  t134.signature_user_id AS signature_user_id_161,
  t134.cachet_image_id AS cachet_image_id_162,
  t134.photo_id AS photo_id_163,
  t164.user_id AS user_id_165,
  t164.username AS username_166,
  t164.password AS password_167,
  t164.email AS email_168,
  t164.tel AS tel_169,
  t164.date_naissance AS date_naissance_170,
  t164.first_name AS first_name_171,
  t164.last_name AS last_name_172,
  t164.is_associe AS is_associe_173,
  t164.username_court AS username_court_174,
  t164.nbr_conncetion AS nbr_conncetion_175,
  t164.last_connection AS last_connection_176,
  t164.current_session_token AS current_session_token_177,
  t164.cin AS cin_178,
  t164.actif AS actif_179,
  t164.code_user AS code_user_180,
  t164.roles AS roles_181,
  t164.action_permission AS action_permission_182,
  t164.action_permission_technique AS action_permission_technique_183,
  t164.action_permission_excluded AS action_permission_excluded_184,
  t164.is_admin_permissions_technique AS is_admin_permissions_technique_185,
  t164.is_admin_editique AS is_admin_editique_186,
  t164.is_admin_session AS is_admin_session_187,
  t164.is_reviseur AS is_reviseur_188,
  t164.is_qualite AS is_qualite_189,
  t164.is_gestionnaire_equipement AS is_gestionnaire_equipement_190,
  t164.signature_user_id AS signature_user_id_191,
  t164.cachet_image_id AS cachet_image_id_192,
  t164.photo_id AS photo_id_193,
  t0.lnk_dossier_files_id AS lnk_dossier_files_id_194
FROM
  tbl_file t0
  LEFT JOIN tbl_societe t27 ON t27.logo_societe_id = t0.file_id
  LEFT JOIN tbl_societe t59 ON t59.image_header_id = t0.file_id
  LEFT JOIN tbl_societe t91 ON t91.image_footer_id = t0.file_id
  LEFT JOIN ref_formation t123 ON t123.formation_file_id = t0.file_id
  LEFT JOIN user t134 ON t134.signature_user_id = t0.file_id
  LEFT JOIN user t164 ON t164.cachet_image_id = t0.file_id
WHERE
  t0.file_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.file_id AS file_id_1, t0.file_name AS file_name_2, t0.file_ext AS file_ext_3, t0.file_size AS file_size_4, t0.origin_name AS origin_name_5, t0.file_path AS file_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.is_upload_graph AS is_upload_graph_10, t0.is_secured AS is_secured_11, t0.is_optimized AS is_optimized_12, t0.prelevement_id AS prelevement_id_13, t0.updated_by AS updated_by_14, t0.created_by AS created_by_15, t0.deleted_by AS deleted_by_16, t0.identification_materiaux_id AS identification_materiaux_id_17, t0.pieces_identification_id AS pieces_identification_id_18, t0.essais_speciaux_id AS essais_speciaux_id_19, t0.pieces_essais_speciaux_id AS pieces_essais_speciaux_id_20, t0.rapport_final_prelevement_id AS rapport_final_prelevement_id_21, t0.rapport_final_compactage_id AS rapport_final_compactage_id_22, t0.reglement_id AS reglement_id_23, t0.tbl_compactge_id AS tbl_compactge_id_24, t0.pieces_compactage_id AS pieces_compactage_id_25, t0.tbl_dossier_id AS tbl_dossier_id_26, t27.id AS id_28, t27.raison_social AS raison_social_29, t27.adresse AS adresse_30, t27.code_postal AS code_postal_31, t27.pays AS pays_32, t27.departement AS departement_33, t27.devise_principale AS devise_principale_34, t27.telephone AS telephone_35, t27.fax AS fax_36, t27.email AS email_37, t27.web AS web_38, t27.note AS note_39, t27.nom_contact AS nom_contact_40, t27.prenom_contact AS prenom_contact_41, t27.phone_contact AS phone_contact_42, t27.created_at AS created_at_43, t27.updated_at AS updated_at_44, t27.deleted_at AS deleted_at_45, t27.ice AS ice_46, t27.cnss AS cnss_47, t27.patente AS patente_48, t27.identifiant_fiscale AS identifiant_fiscale_49, t27.registre_commerce AS registre_commerce_50, t27.ville AS ville_51, t27.logo_societe_id AS logo_societe_id_52, t27.image_header_id AS image_header_id_53, t27.image_footer_id AS image_footer_id_54, t27.created_by AS created_by_55, t27.updated_by AS updated_by_56, t27.deleted_by AS deleted_by_57, t27.banque_id AS banque_id_58, t59.id AS id_60, t59.raison_social AS raison_social_61, t59.adresse AS adresse_62, t59.code_postal AS code_postal_63, t59.pays AS pays_64, t59.departement AS departement_65, t59.devise_principale AS devise_principale_66, t59.telephone AS telephone_67, t59.fax AS fax_68, t59.email AS email_69, t59.web AS web_70, t59.note AS note_71, t59.nom_contact AS nom_contact_72, t59.prenom_contact AS prenom_contact_73, t59.phone_contact AS phone_contact_74, t59.created_at AS created_at_75, t59.updated_at AS updated_at_76, t59.deleted_at AS deleted_at_77, t59.ice AS ice_78, t59.cnss AS cnss_79, t59.patente AS patente_80, t59.identifiant_fiscale AS identifiant_fiscale_81, t59.registre_commerce AS registre_commerce_82, t59.ville AS ville_83, t59.logo_societe_id AS logo_societe_id_84, t59.image_header_id AS image_header_id_85, t59.image_footer_id AS image_footer_id_86, t59.created_by AS created_by_87, t59.updated_by AS updated_by_88, t59.deleted_by AS deleted_by_89, t59.banque_id AS banque_id_90, t91.id AS id_92, t91.raison_social AS raison_social_93, t91.adresse AS adresse_94, t91.code_postal AS code_postal_95, t91.pays AS pays_96, t91.departement AS departement_97, t91.devise_principale AS devise_principale_98, t91.telephone AS telephone_99, t91.fax AS fax_100, t91.email AS email_101, t91.web AS web_102, t91.note AS note_103, t91.nom_contact AS nom_contact_104, t91.prenom_contact AS prenom_contact_105, t91.phone_contact AS phone_contact_106, t91.created_at AS created_at_107, t91.updated_at AS updated_at_108, t91.deleted_at AS deleted_at_109, t91.ice AS ice_110, t91.cnss AS cnss_111, t91.patente AS patente_112, t91.identifiant_fiscale AS identifiant_fiscale_113, t91.registre_commerce AS registre_commerce_114, t91.ville AS ville_115, t91.logo_societe_id AS logo_societe_id_116, t91.image_header_id AS image_header_id_117, t91.image_footer_id AS image_footer_id_118, t91.created_by AS created_by_119, t91.updated_by AS updated_by_120, t91.deleted_by AS deleted_by_121, t91.banque_id AS banque_id_122, t123.formation_id AS formation_id_124, t123.formation_lib AS formation_lib_125, t123.formation_lib_court AS formation_lib_court_126, t123.created_at AS created_at_127, t123.updated_at AS updated_at_128, t123.deleted_at AS deleted_at_129, t123.formation_file_id AS formation_file_id_130, t123.created_by AS created_by_131, t123.updated_by AS updated_by_132, t123.deleted_by AS deleted_by_133, t134.user_id AS user_id_135, t134.username AS username_136, t134.password AS password_137, t134.email AS email_138, t134.tel AS tel_139, t134.date_naissance AS date_naissance_140, t134.first_name AS first_name_141, t134.last_name AS last_name_142, t134.is_associe AS is_associe_143, t134.username_court AS username_court_144, t134.nbr_conncetion AS nbr_conncetion_145, t134.last_connection AS last_connection_146, t134.current_session_token AS current_session_token_147, t134.cin AS cin_148, t134.actif AS actif_149, t134.code_user AS code_user_150, t134.roles AS roles_151, t134.action_permission AS action_permission_152, t134.action_permission_technique AS action_permission_technique_153, t134.action_permission_excluded AS action_permission_excluded_154, t134.is_admin_permissions_technique AS is_admin_permissions_technique_155, t134.is_admin_editique AS is_admin_editique_156, t134.is_admin_session AS is_admin_session_157, t134.is_reviseur AS is_reviseur_158, t134.is_qualite AS is_qualite_159, t134.is_gestionnaire_equipement AS is_gestionnaire_equipement_160, t134.signature_user_id AS signature_user_id_161, t134.cachet_image_id AS cachet_image_id_162, t134.photo_id AS photo_id_163, t164.user_id AS user_id_165, t164.username AS username_166, t164.password AS password_167, t164.email AS email_168, t164.tel AS tel_169, t164.date_naissance AS date_naissance_170, t164.first_name AS first_name_171, t164.last_name AS last_name_172, t164.is_associe AS is_associe_173, t164.username_court AS username_court_174, t164.nbr_conncetion AS nbr_conncetion_175, t164.last_connection AS last_connection_176, t164.current_session_token AS current_session_token_177, t164.cin AS cin_178, t164.actif AS actif_179, t164.code_user AS code_user_180, t164.roles AS roles_181, t164.action_permission AS action_permission_182, t164.action_permission_technique AS action_permission_technique_183, t164.action_permission_excluded AS action_permission_excluded_184, t164.is_admin_permissions_technique AS is_admin_permissions_technique_185, t164.is_admin_editique AS is_admin_editique_186, t164.is_admin_session AS is_admin_session_187, t164.is_reviseur AS is_reviseur_188, t164.is_qualite AS is_qualite_189, t164.is_gestionnaire_equipement AS is_gestionnaire_equipement_190, t164.signature_user_id AS signature_user_id_191, t164.cachet_image_id AS cachet_image_id_192, t164.photo_id AS photo_id_193, t0.lnk_dossier_files_id AS lnk_dossier_files_id_194 FROM tbl_file t0 LEFT JOIN tbl_societe t27 ON t27.logo_societe_id = t0.file_id LEFT JOIN tbl_societe t59 ON t59.image_header_id = t0.file_id LEFT JOIN tbl_societe t91 ON t91.image_footer_id = t0.file_id LEFT JOIN ref_formation t123 ON t123.formation_file_id = t0.file_id LEFT JOIN user t134 ON t134.signature_user_id = t0.file_id LEFT JOIN user t164 ON t164.cachet_image_id = t0.file_id WHERE t0.file_id = 1192 AND ((t0.deleted_at IS NULL));

SELECT
  t0_.param_nom AS param_nom_0,
  t0_.param_etat AS param_etat_1,
  t0_.param_value AS param_value_2
FROM
  tbl_param t0_

SELECT t0_.param_nom AS param_nom_0, t0_.param_etat AS param_etat_1, t0_.param_value AS param_value_2 FROM tbl_param t0_;

SELECT
  t0_.param_nom AS param_nom_0,
  t0_.param_etat AS param_etat_1,
  t0_.param_value AS param_value_2
FROM
  tbl_param t0_

SELECT t0_.param_nom AS param_nom_0, t0_.param_etat AS param_etat_1, t0_.param_value AS param_value_2 FROM tbl_param t0_;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'labcorp_laboest_bd'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'labcorp_laboest_bd'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_NAME = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'labcorp_laboest_bd' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'labcorp_laboest_bd' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'labcorp_laboest_bd' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'labcorp_laboest_bd' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'labcorp_laboest_bd'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.COLUMN_TYPE
  ) AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'labcorp_laboest_bd'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'labcorp_laboest_bd' AND t.TABLE_SCHEMA = 'labcorp_laboest_bd' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  SEQ_IN_INDEX

SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'labcorp_laboest_bd' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();