Symfony Profiler

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 = 'staff_volkswagen'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

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
  AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
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
AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = 'staff_volkswagen' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;

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 = 'staff_volkswagen' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.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,
  COLUMN_COMMENT AS comment,
  CHARACTER_SET_NAME AS characterset,
  COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       COLUMN_NAME        AS field,
       COLUMN_TYPE        AS type,
       IS_NULLABLE        AS `null`,
       COLUMN_KEY         AS `key`,
       COLUMN_DEFAULT     AS `default`,
       EXTRA,
       COLUMN_COMMENT     AS comment,
       CHARACTER_SET_NAME AS characterset,
       COLLATION_NAME     AS collation
FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'staff_volkswagen' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

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

SELECT
  t0.address AS address_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.shop_active AS shop_active_4,
  t0.shop_button_text AS shop_button_text_5,
  t0.shop_link AS shop_link_6,
  t0.shop_target AS shop_target_7,
  t0.roulette_active AS roulette_active_8,
  t0.roulette_link AS roulette_link_9,
  t0.roulette_text AS roulette_text_10,
  t0.roulette_image AS roulette_image_11,
  t0.roulette_banner_home AS roulette_banner_home_12,
  t0.roulette_target AS roulette_target_13,
  t0.header_logo_color AS header_logo_color_14,
  t0.header_logo_white AS header_logo_white_15,
  t0.footer_logo AS footer_logo_16,
  t0.link_buses AS link_buses_17,
  t0.link_services AS link_services_18,
  t0.link_spare_parts AS link_spare_parts_19,
  t0.link_spare_parts_warranty AS link_spare_parts_warranty_20,
  t0.link_online_store AS link_online_store_21,
  t0.link_technical_assistance AS link_technical_assistance_22,
  t0.link_after_sales_trucks AS link_after_sales_trucks_23,
  t0.link_after_sales_buses AS link_after_sales_buses_24,
  t0.link_claim_trucks AS link_claim_trucks_25,
  t0.link_claim_buses AS link_claim_buses_26,
  t0.sent_title AS sent_title_27,
  t0.sent_text AS sent_text_28,
  t0.sent_button_home_text AS sent_button_home_text_29,
  t0.sent_button_models_text AS sent_button_models_text_30,
  t0.error_title AS error_title_31,
  t0.error_text AS error_text_32,
  t0.error_button_home_text AS error_button_home_text_33,
  t0.error_button_models_text AS error_button_models_text_34,
  t0.error_404_title AS error_404_title_35,
  t0.error_404_text AS error_404_text_36,
  t0.error_404_button_home_text AS error_404_button_home_text_37,
  t0.error_404_button_models_text AS error_404_button_models_text_38,
  t0.social_whatsapp_show AS social_whatsapp_show_39,
  t0.social_whatsapp_number AS social_whatsapp_number_40,
  t0.social_whatsapp_message AS social_whatsapp_message_41,
  t0.social_facebook_show AS social_facebook_show_42,
  t0.social_facebook_link AS social_facebook_link_43,
  t0.social_linkedin_show AS social_linkedin_show_44,
  t0.social_linkedin_link AS social_linkedin_link_45,
  t0.social_youtube_show AS social_youtube_show_46,
  t0.social_youtube_link AS social_youtube_link_47,
  t0.social_blog_show AS social_blog_show_48,
  t0.social_blog_link AS social_blog_link_49,
  t0.social_blog_categories AS social_blog_categories_50,
  t0.social_blog_posts AS social_blog_posts_51,
  t0.seo_indexing AS seo_indexing_52,
  t0.seo_favicon AS seo_favicon_53,
  t0.seo_title AS seo_title_54,
  t0.seo_description AS seo_description_55,
  t0.scripts_meta AS scripts_meta_56,
  t0.scripts_header AS scripts_header_57,
  t0.scripts_body AS scripts_body_58,
  t0.scripts_footer AS scripts_footer_59,
  t0.captcha_show AS captcha_show_60,
  t0.captcha_site AS captcha_site_61,
  t0.captcha_secret AS captcha_secret_62,
  t0.id AS id_63,
  t0.created_at AS created_at_64,
  t0.modified_at AS modified_at_65,
  t0.created_user AS created_user_66,
  t0.modified_user AS modified_user_67
FROM
  info t0
WHERE
  t0.id = ?

SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.shop_active AS shop_active_4, t0.shop_button_text AS shop_button_text_5, t0.shop_link AS shop_link_6, t0.shop_target AS shop_target_7, t0.roulette_active AS roulette_active_8, t0.roulette_link AS roulette_link_9, t0.roulette_text AS roulette_text_10, t0.roulette_image AS roulette_image_11, t0.roulette_banner_home AS roulette_banner_home_12, t0.roulette_target AS roulette_target_13, t0.header_logo_color AS header_logo_color_14, t0.header_logo_white AS header_logo_white_15, t0.footer_logo AS footer_logo_16, t0.link_buses AS link_buses_17, t0.link_services AS link_services_18, t0.link_spare_parts AS link_spare_parts_19, t0.link_spare_parts_warranty AS link_spare_parts_warranty_20, t0.link_online_store AS link_online_store_21, t0.link_technical_assistance AS link_technical_assistance_22, t0.link_after_sales_trucks AS link_after_sales_trucks_23, t0.link_after_sales_buses AS link_after_sales_buses_24, t0.link_claim_trucks AS link_claim_trucks_25, t0.link_claim_buses AS link_claim_buses_26, t0.sent_title AS sent_title_27, t0.sent_text AS sent_text_28, t0.sent_button_home_text AS sent_button_home_text_29, t0.sent_button_models_text AS sent_button_models_text_30, t0.error_title AS error_title_31, t0.error_text AS error_text_32, t0.error_button_home_text AS error_button_home_text_33, t0.error_button_models_text AS error_button_models_text_34, t0.error_404_title AS error_404_title_35, t0.error_404_text AS error_404_text_36, t0.error_404_button_home_text AS error_404_button_home_text_37, t0.error_404_button_models_text AS error_404_button_models_text_38, t0.social_whatsapp_show AS social_whatsapp_show_39, t0.social_whatsapp_number AS social_whatsapp_number_40, t0.social_whatsapp_message AS social_whatsapp_message_41, t0.social_facebook_show AS social_facebook_show_42, t0.social_facebook_link AS social_facebook_link_43, t0.social_linkedin_show AS social_linkedin_show_44, t0.social_linkedin_link AS social_linkedin_link_45, t0.social_youtube_show AS social_youtube_show_46, t0.social_youtube_link AS social_youtube_link_47, t0.social_blog_show AS social_blog_show_48, t0.social_blog_link AS social_blog_link_49, t0.social_blog_categories AS social_blog_categories_50, t0.social_blog_posts AS social_blog_posts_51, t0.seo_indexing AS seo_indexing_52, t0.seo_favicon AS seo_favicon_53, t0.seo_title AS seo_title_54, t0.seo_description AS seo_description_55, t0.scripts_meta AS scripts_meta_56, t0.scripts_header AS scripts_header_57, t0.scripts_body AS scripts_body_58, t0.scripts_footer AS scripts_footer_59, t0.captcha_show AS captcha_show_60, t0.captcha_site AS captcha_site_61, t0.captcha_secret AS captcha_secret_62, t0.id AS id_63, t0.created_at AS created_at_64, t0.modified_at AS modified_at_65, t0.created_user AS created_user_66, t0.modified_user AS modified_user_67 FROM info t0 WHERE t0.id = 1;

SELECT
  t0.source AS source_1,
  t0.destination AS destination_2,
  t0.permanent AS permanent_3,
  t0.count AS count_4,
  t0.last_accessed AS last_accessed_5,
  t0.id AS id_6
FROM
  redirects t0
WHERE
  t0.source = ?
LIMIT
  1

SELECT t0.source AS source_1, t0.destination AS destination_2, t0.permanent AS permanent_3, t0.count AS count_4, t0.last_accessed AS last_accessed_5, t0.id AS id_6 FROM redirects t0 WHERE t0.source = '/robots.txt' LIMIT 1;

SELECT
  t0.document_types AS document_types_1,
  t0.contact_title AS contact_title_2,
  t0.contact_text AS contact_text_3,
  t0.contact_types AS contact_types_4,
  t0.contact_receiver AS contact_receiver_5,
  t0.promotion_receiver AS promotion_receiver_6,
  t0.application_receiver AS application_receiver_7,
  t0.truck_quotation_receiver AS truck_quotation_receiver_8,
  t0.bus_quotation_receiver AS bus_quotation_receiver_9,
  t0.service_quotation_title AS service_quotation_title_10,
  t0.service_quotation_receiver AS service_quotation_receiver_11,
  t0.id AS id_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.created_user AS created_user_15,
  t0.modified_user AS modified_user_16
FROM
  forms t0
WHERE
  t0.id = ?

SELECT t0.document_types AS document_types_1, t0.contact_title AS contact_title_2, t0.contact_text AS contact_text_3, t0.contact_types AS contact_types_4, t0.contact_receiver AS contact_receiver_5, t0.promotion_receiver AS promotion_receiver_6, t0.application_receiver AS application_receiver_7, t0.truck_quotation_receiver AS truck_quotation_receiver_8, t0.bus_quotation_receiver AS bus_quotation_receiver_9, t0.service_quotation_title AS service_quotation_title_10, t0.service_quotation_receiver AS service_quotation_receiver_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM forms t0 WHERE t0.id = 1;

SELECT
  t0.banner_desktop AS banner_desktop_1,
  t0.banner_tablet AS banner_tablet_2,
  t0.banner_mobile AS banner_mobile_3,
  t0.return_link AS return_link_4,
  t0.return_target AS return_target_5,
  t0.both_title AS both_title_6,
  t0.both_image AS both_image_7,
  t0.both_image_hover AS both_image_hover_8,
  t0.both_description AS both_description_9,
  t0.trucks_title AS trucks_title_10,
  t0.trucks_image AS trucks_image_11,
  t0.trucks_image_hover AS trucks_image_hover_12,
  t0.trucks_description AS trucks_description_13,
  t0.buses_title AS buses_title_14,
  t0.buses_image AS buses_image_15,
  t0.buses_image_hover AS buses_image_hover_16,
  t0.buses_description AS buses_description_17,
  t0.advertising_show AS advertising_show_18,
  t0.advertising_image AS advertising_image_19,
  t0.advertising_link AS advertising_link_20,
  t0.advertising_target AS advertising_target_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.modified_at AS modified_at_24,
  t0.created_user AS created_user_25,
  t0.modified_user AS modified_user_26
FROM
  models t0
WHERE
  t0.id = ?

SELECT t0.banner_desktop AS banner_desktop_1, t0.banner_tablet AS banner_tablet_2, t0.banner_mobile AS banner_mobile_3, t0.return_link AS return_link_4, t0.return_target AS return_target_5, t0.both_title AS both_title_6, t0.both_image AS both_image_7, t0.both_image_hover AS both_image_hover_8, t0.both_description AS both_description_9, t0.trucks_title AS trucks_title_10, t0.trucks_image AS trucks_image_11, t0.trucks_image_hover AS trucks_image_hover_12, t0.trucks_description AS trucks_description_13, t0.buses_title AS buses_title_14, t0.buses_image AS buses_image_15, t0.buses_image_hover AS buses_image_hover_16, t0.buses_description AS buses_description_17, t0.advertising_show AS advertising_show_18, t0.advertising_image AS advertising_image_19, t0.advertising_link AS advertising_link_20, t0.advertising_target AS advertising_target_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.modified_at AS modified_at_24, t0.created_user AS created_user_25, t0.modified_user AS modified_user_26 FROM models t0 WHERE t0.id = 1;

SELECT
  s0_.title AS title_0,
  s0_.link AS link_1,
  s0_.active AS active_2,
  s0_.position AS position_3,
  s0_.id AS id_4,
  s0_.created_at AS created_at_5,
  s0_.modified_at AS modified_at_6,
  s0_.created_user AS created_user_7,
  s0_.modified_user AS modified_user_8
FROM
  service s0_
WHERE
  s0_.active = 1
ORDER BY
  s0_.position ASC

SELECT s0_.title AS title_0, s0_.link AS link_1, s0_.active AS active_2, s0_.position AS position_3, s0_.id AS id_4, s0_.created_at AS created_at_5, s0_.modified_at AS modified_at_6, s0_.created_user AS created_user_7, s0_.modified_user AS modified_user_8 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;