Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  t0.is_editable AS is_editable_1,
  t0.is_main_page AS is_main_page_2,
  t0.is_blog_page AS is_blog_page_3,
  t0.template_path AS template_path_4,
  t0.is_published AS is_published_5,
  t0.should_be_followed AS should_be_followed_6,
  t0.type AS type_7,
  t0.id AS id_8,
  t0.internal_name AS internal_name_9,
  t0.migration_id AS migration_id_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t13.is_news AS is_news_14,
  t13.sort_order AS sort_order_15,
  t13.reading_time AS reading_time_16,
  t13.previous_post AS previous_post_17,
  t13.next_post AS next_post_18,
  t13.id AS id_19,
  t13.page_id AS page_id_20,
  t13.post_preview_id AS post_preview_id_21,
  t13.category_id AS category_id_22,
  t23.name AS name_24,
  t23.street AS street_25,
  t23.apartment_number AS apartment_number_26,
  t23.postal_code AS postal_code_27,
  t23.city AS city_28,
  t23.lat AS lat_29,
  t23.lng AS lng_30,
  t23.email AS email_31,
  t23.phone_number AS phone_number_32,
  t23.sort_order AS sort_order_33,
  t23.population AS population_34,
  t23.opening_date AS opening_date_35,
  t23.parking_spaces_number AS parking_spaces_number_36,
  t23.store_usable_floor_area AS store_usable_floor_area_37,
  t23.commercial_space AS commercial_space_38,
  t23.has_petrol_station AS has_petrol_station_39,
  t23.has_car_wash AS has_car_wash_40,
  t23.has_shopping_delivery AS has_shopping_delivery_41,
  t23.region AS region_42,
  t23.id AS id_43,
  t23.created_at AS created_at_44,
  t23.updated_at AS updated_at_45,
  t23.page_id AS page_id_46,
  t47.sort_order AS sort_order_48,
  t47.id AS id_49,
  t47.page_id AS page_id_50,
  t47.category_preview_id AS category_preview_id_51
FROM
  page t0
  LEFT JOIN post t13 ON t13.page_id = t0.id
  LEFT JOIN shop t23 ON t23.page_id = t0.id
  LEFT JOIN category t47 ON t47.page_id = t0.id
WHERE
  t0.id = ?

SELECT t0.is_editable AS is_editable_1, t0.is_main_page AS is_main_page_2, t0.is_blog_page AS is_blog_page_3, t0.template_path AS template_path_4, t0.is_published AS is_published_5, t0.should_be_followed AS should_be_followed_6, t0.type AS type_7, t0.id AS id_8, t0.internal_name AS internal_name_9, t0.migration_id AS migration_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t13.is_news AS is_news_14, t13.sort_order AS sort_order_15, t13.reading_time AS reading_time_16, t13.previous_post AS previous_post_17, t13.next_post AS next_post_18, t13.id AS id_19, t13.page_id AS page_id_20, t13.post_preview_id AS post_preview_id_21, t13.category_id AS category_id_22, t23.name AS name_24, t23.street AS street_25, t23.apartment_number AS apartment_number_26, t23.postal_code AS postal_code_27, t23.city AS city_28, t23.lat AS lat_29, t23.lng AS lng_30, t23.email AS email_31, t23.phone_number AS phone_number_32, t23.sort_order AS sort_order_33, t23.population AS population_34, t23.opening_date AS opening_date_35, t23.parking_spaces_number AS parking_spaces_number_36, t23.store_usable_floor_area AS store_usable_floor_area_37, t23.commercial_space AS commercial_space_38, t23.has_petrol_station AS has_petrol_station_39, t23.has_car_wash AS has_car_wash_40, t23.has_shopping_delivery AS has_shopping_delivery_41, t23.region AS region_42, t23.id AS id_43, t23.created_at AS created_at_44, t23.updated_at AS updated_at_45, t23.page_id AS page_id_46, t47.sort_order AS sort_order_48, t47.id AS id_49, t47.page_id AS page_id_50, t47.category_preview_id AS category_preview_id_51 FROM page t0 LEFT JOIN post t13 ON t13.page_id = t0.id LEFT JOIN shop t23 ON t23.page_id = t0.id LEFT JOIN category t47 ON t47.page_id = t0.id WHERE t0.id = 101;

SELECT
  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 = k.TABLE_NAME */
WHERE
  k.TABLE_NAME = 'doctrine_migration_versions'
  AND k.TABLE_SCHEMA = 'm1091_hfood'
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'm1091_hfood' */
ORDER BY
  k.ORDINAL_POSITION

SELECT 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 = k.TABLE_NAME */ WHERE k.TABLE_NAME = 'doctrine_migration_versions' AND k.TABLE_SCHEMA = 'm1091_hfood' /*!50116 AND c.CONSTRAINT_SCHEMA = 'm1091_hfood' */ORDER BY k.ORDINAL_POSITION;

SELECT
  t0.old_url AS old_url_1,
  t0.new_url AS new_url_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.is_create_by_user AS is_create_by_user_5,
  t0.id AS id_6
FROM
  redirects t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.old_url AS old_url_1, t0.new_url AS new_url_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_create_by_user AS is_create_by_user_5, t0.id AS id_6 FROM redirects t0 WHERE t0.old_url = '/Nowy-wpis' LIMIT 1;

SELECT
  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
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT 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 TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

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 = 'm1091_hfood'
  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 = 'm1091_hfood' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION 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 = 'm1091_hfood'
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 = 'm1091_hfood' ORDER BY SEQ_IN_INDEX ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.url AS url_1,
  t0.displayed_title AS displayed_title_2,
  t0.meta_tags AS meta_tags_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  page_translation t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.url AS url_1, t0.displayed_title AS displayed_title_2, t0.meta_tags AS meta_tags_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.url = 'Nowy-wpis' LIMIT 1;