Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.source AS source_5,
  t0.target AS target_6,
  t0.comment AS comment_7,
  t0.identifier AS identifier_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.deleted_by_id AS deleted_by_id_11
FROM
  redirect t0
WHERE
  t0.source = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.source AS source_5, t0.target AS target_6, t0.comment AS comment_7, t0.identifier AS identifier_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.deleted_by_id AS deleted_by_id_11 FROM redirect t0 WHERE t0.source = 'kurzy/3601/pridat-hodnoceni' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.is_created_by_admin AS is_created_by_admin_5,
  t0.name AS name_6,
  t0.price AS price_7,
  t0.price_description AS price_description_8,
  t0.short_description AS short_description_9,
  t0.description AS description_10,
  t0.requirements AS requirements_11,
  t0.published_at AS published_at_12,
  t0.end_at AS end_at_13,
  t0.length AS length_14,
  t0.can_customize AS can_customize_15,
  t0.is_preparation_for_certification AS is_preparation_for_certification_16,
  t0.is_with_certificate AS is_with_certificate_17,
  t0.can_buy AS can_buy_18,
  t0.can_register AS can_register_19,
  t0.email AS email_20,
  t0.can_paid AS can_paid_21,
  t0.frequency_text AS frequency_text_22,
  t0.lesson_start AS lesson_start_23,
  t0.lesson_end AS lesson_end_24,
  t0.is_confirmation_of_participation AS is_confirmation_of_participation_25,
  t0.certification_price_not_included AS certification_price_not_included_26,
  t0.certification_price AS certification_price_27,
  t0.confirmation_name AS confirmation_name_28,
  t0.url AS url_29,
  t0.code AS code_30,
  t0.is_recommended AS is_recommended_31,
  t0.rating AS rating_32,
  t0.is_native_speaker AS is_native_speaker_33,
  t0.is_customized AS is_customized_34,
  t0.only_for_adults AS only_for_adults_35,
  t0.last_step AS last_step_36,
  t0.place_description AS place_description_37,
  t0.latitude AS latitude_38,
  t0.longitude AS longitude_39,
  t0.identifier AS identifier_40,
  t0.created_by_id AS created_by_id_41,
  t0.updated_by_id AS updated_by_id_42,
  t0.deleted_by_id AS deleted_by_id_43,
  t0.organizer_id AS organizer_id_44,
  t0.place_id AS place_id_45,
  t0.state_id AS state_id_46,
  t0.type_id AS type_id_47,
  t0.certificate_id AS certificate_id_48,
  t0.frequency_id AS frequency_id_49,
  t0.place_type_id AS place_type_id_50,
  t0.topic_id AS topic_id_51,
  t0.length_type_id AS length_type_id_52,
  t0.progress_level_id AS progress_level_id_53,
  t0.language_level_input_id AS language_level_input_id_54,
  t0.language_level_output_id AS language_level_output_id_55,
  t0.city_id AS city_id_56,
  t0.teaching_type_id AS teaching_type_id_57,
  t0.retraining_type_id AS retraining_type_id_58,
  t0.target_group_id AS target_group_id_59
FROM
  course t0
WHERE
  t0.id = ?
  AND (
    (
      t0.organizer_id IN (
        SELECT
          o.id
        FROM
          organizer o
          JOIN fos_user__user u ON o.user_account_id = u.id
          JOIN account_state s ON u.account_state_id = s.id
        WHERE
          s.identifier = 'active'
          AND u.deleted_at IS NULL
      )
    )
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.is_created_by_admin AS is_created_by_admin_5, t0.name AS name_6, t0.price AS price_7, t0.price_description AS price_description_8, t0.short_description AS short_description_9, t0.description AS description_10, t0.requirements AS requirements_11, t0.published_at AS published_at_12, t0.end_at AS end_at_13, t0.length AS length_14, t0.can_customize AS can_customize_15, t0.is_preparation_for_certification AS is_preparation_for_certification_16, t0.is_with_certificate AS is_with_certificate_17, t0.can_buy AS can_buy_18, t0.can_register AS can_register_19, t0.email AS email_20, t0.can_paid AS can_paid_21, t0.frequency_text AS frequency_text_22, t0.lesson_start AS lesson_start_23, t0.lesson_end AS lesson_end_24, t0.is_confirmation_of_participation AS is_confirmation_of_participation_25, t0.certification_price_not_included AS certification_price_not_included_26, t0.certification_price AS certification_price_27, t0.confirmation_name AS confirmation_name_28, t0.url AS url_29, t0.code AS code_30, t0.is_recommended AS is_recommended_31, t0.rating AS rating_32, t0.is_native_speaker AS is_native_speaker_33, t0.is_customized AS is_customized_34, t0.only_for_adults AS only_for_adults_35, t0.last_step AS last_step_36, t0.place_description AS place_description_37, t0.latitude AS latitude_38, t0.longitude AS longitude_39, t0.identifier AS identifier_40, t0.created_by_id AS created_by_id_41, t0.updated_by_id AS updated_by_id_42, t0.deleted_by_id AS deleted_by_id_43, t0.organizer_id AS organizer_id_44, t0.place_id AS place_id_45, t0.state_id AS state_id_46, t0.type_id AS type_id_47, t0.certificate_id AS certificate_id_48, t0.frequency_id AS frequency_id_49, t0.place_type_id AS place_type_id_50, t0.topic_id AS topic_id_51, t0.length_type_id AS length_type_id_52, t0.progress_level_id AS progress_level_id_53, t0.language_level_input_id AS language_level_input_id_54, t0.language_level_output_id AS language_level_output_id_55, t0.city_id AS city_id_56, t0.teaching_type_id AS teaching_type_id_57, t0.retraining_type_id AS retraining_type_id_58, t0.target_group_id AS target_group_id_59 FROM course t0 WHERE t0.id = '3601' AND ((t0.organizer_id IN (
                SELECT o.id
                FROM organizer o
                JOIN fos_user__user u ON o.user_account_id = u.id
                JOIN account_state s ON u.account_state_id = s.id
                WHERE s.identifier = 'active' AND u.deleted_at IS NULL
            )));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.deleted_at AS deleted_at_4,
  t0.name AS name_5,
  t0.identifier AS identifier_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8,
  t0.deleted_by_id AS deleted_by_id_9,
  t0.user_account_id AS user_account_id_10,
  t0.company_id AS company_id_11
FROM
  applicant t0
WHERE
  t0.user_account_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deleted_at AS deleted_at_4, t0.name AS name_5, t0.identifier AS identifier_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.deleted_by_id AS deleted_by_id_9, t0.user_account_id AS user_account_id_10, t0.company_id AS company_id_11 FROM applicant t0 WHERE t0.user_account_id IS NULL LIMIT 1;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  COLUMN_NAME AS Field,
  COLUMN_TYPE AS Type,
  IS_NULLABLE AS `Null`,
  COLUMN_KEY AS `Key`,
  COLUMN_DEFAULT AS `Default`,
  EXTRA AS Extra,
  COLUMN_COMMENT AS Comment,
  CHARACTER_SET_NAME AS CharacterSet,
  COLLATION_NAME AS Collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = 'vsechnykurzy'
  AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'vsechnykurzy' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  DISTINCT k.`CONSTRAINT_NAME`,
  k.`COLUMN_NAME`,
  k.`REFERENCED_TABLE_NAME`,
  k.`REFERENCED_COLUMN_NAME`
  /*!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 = 'doctrine_migration_versions' */
WHERE
  k.table_name = 'doctrine_migration_versions'
  AND k.table_schema = 'vsechnykurzy'
  /*!50116 AND c.constraint_schema = 'vsechnykurzy' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!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 = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'vsechnykurzy' /*!50116 AND c.constraint_schema = 'vsechnykurzy' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

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_NAME = 'doctrine_migration_versions'
  AND TABLE_SCHEMA = 'vsechnykurzy'
ORDER BY
  SEQ_IN_INDEX ASC

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_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'vsechnykurzy' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  ENGINE,
  AUTO_INCREMENT,
  TABLE_COLLATION,
  TABLE_COMMENT,
  CREATE_OPTIONS
FROM
  information_schema.TABLES
WHERE
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;