Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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 = 'staff_eurocamiones'
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'staff_eurocamiones' */
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 = 'staff_eurocamiones' /*!50116 AND c.CONSTRAINT_SCHEMA = 'staff_eurocamiones' */ORDER BY k.ORDINAL_POSITION;

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

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

SELECT
  t0.address AS address_1,
  t0.phone AS phone_2,
  t0.email AS email_3,
  t0.service_address AS service_address_4,
  t0.service_phone AS service_phone_5,
  t0.service_email AS service_email_6,
  t0.technical_assistance_address AS technical_assistance_address_7,
  t0.technical_assistance_phone AS technical_assistance_phone_8,
  t0.technical_assistance_email AS technical_assistance_email_9,
  t0.shop_active AS shop_active_10,
  t0.shop_button_text AS shop_button_text_11,
  t0.shop_link AS shop_link_12,
  t0.shop_target AS shop_target_13,
  t0.roulette_active AS roulette_active_14,
  t0.roulette_text AS roulette_text_15,
  t0.roulette_image AS roulette_image_16,
  t0.roulette_banner_home AS roulette_banner_home_17,
  t0.header_logo_color AS header_logo_color_18,
  t0.header_logo_white AS header_logo_white_19,
  t0.footer_logo AS footer_logo_20,
  t0.sent_image AS sent_image_21,
  t0.sent_title AS sent_title_22,
  t0.sent_text AS sent_text_23,
  t0.sent_button_home_text AS sent_button_home_text_24,
  t0.error_image AS error_image_25,
  t0.error_title AS error_title_26,
  t0.error_text AS error_text_27,
  t0.error_button_home_text AS error_button_home_text_28,
  t0.error_404_image AS error_404_image_29,
  t0.error_404_title AS error_404_title_30,
  t0.error_404_text AS error_404_text_31,
  t0.error_404_button_home_text AS error_404_button_home_text_32,
  t0.social_whatsapp_show AS social_whatsapp_show_33,
  t0.social_whatsapp_number AS social_whatsapp_number_34,
  t0.social_whatsapp_message AS social_whatsapp_message_35,
  t0.social_facebook_show AS social_facebook_show_36,
  t0.social_facebook_link AS social_facebook_link_37,
  t0.social_linkedin_show AS social_linkedin_show_38,
  t0.social_linkedin_link AS social_linkedin_link_39,
  t0.social_youtube_show AS social_youtube_show_40,
  t0.social_youtube_link AS social_youtube_link_41,
  t0.social_blog_show AS social_blog_show_42,
  t0.social_blog_link AS social_blog_link_43,
  t0.social_blog_categories AS social_blog_categories_44,
  t0.social_blog_posts AS social_blog_posts_45,
  t0.seo_indexing AS seo_indexing_46,
  t0.seo_favicon AS seo_favicon_47,
  t0.seo_title AS seo_title_48,
  t0.seo_description AS seo_description_49,
  t0.scripts_meta AS scripts_meta_50,
  t0.scripts_header AS scripts_header_51,
  t0.scripts_body AS scripts_body_52,
  t0.scripts_footer AS scripts_footer_53,
  t0.captcha_show AS captcha_show_54,
  t0.captcha_site AS captcha_site_55,
  t0.captcha_secret AS captcha_secret_56,
  t0.id AS id_57,
  t0.created_at AS created_at_58,
  t0.modified_at AS modified_at_59,
  t0.created_user AS created_user_60,
  t0.modified_user AS modified_user_61
FROM
  info t0
WHERE
  t0.id = ?

SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.service_address AS service_address_4, t0.service_phone AS service_phone_5, t0.service_email AS service_email_6, t0.technical_assistance_address AS technical_assistance_address_7, t0.technical_assistance_phone AS technical_assistance_phone_8, t0.technical_assistance_email AS technical_assistance_email_9, t0.shop_active AS shop_active_10, t0.shop_button_text AS shop_button_text_11, t0.shop_link AS shop_link_12, t0.shop_target AS shop_target_13, t0.roulette_active AS roulette_active_14, t0.roulette_text AS roulette_text_15, t0.roulette_image AS roulette_image_16, t0.roulette_banner_home AS roulette_banner_home_17, t0.header_logo_color AS header_logo_color_18, t0.header_logo_white AS header_logo_white_19, t0.footer_logo AS footer_logo_20, t0.sent_image AS sent_image_21, t0.sent_title AS sent_title_22, t0.sent_text AS sent_text_23, t0.sent_button_home_text AS sent_button_home_text_24, t0.error_image AS error_image_25, t0.error_title AS error_title_26, t0.error_text AS error_text_27, t0.error_button_home_text AS error_button_home_text_28, t0.error_404_image AS error_404_image_29, t0.error_404_title AS error_404_title_30, t0.error_404_text AS error_404_text_31, t0.error_404_button_home_text AS error_404_button_home_text_32, t0.social_whatsapp_show AS social_whatsapp_show_33, t0.social_whatsapp_number AS social_whatsapp_number_34, t0.social_whatsapp_message AS social_whatsapp_message_35, t0.social_facebook_show AS social_facebook_show_36, t0.social_facebook_link AS social_facebook_link_37, t0.social_linkedin_show AS social_linkedin_show_38, t0.social_linkedin_link AS social_linkedin_link_39, t0.social_youtube_show AS social_youtube_show_40, t0.social_youtube_link AS social_youtube_link_41, t0.social_blog_show AS social_blog_show_42, t0.social_blog_link AS social_blog_link_43, t0.social_blog_categories AS social_blog_categories_44, t0.social_blog_posts AS social_blog_posts_45, t0.seo_indexing AS seo_indexing_46, t0.seo_favicon AS seo_favicon_47, t0.seo_title AS seo_title_48, t0.seo_description AS seo_description_49, t0.scripts_meta AS scripts_meta_50, t0.scripts_header AS scripts_header_51, t0.scripts_body AS scripts_body_52, t0.scripts_footer AS scripts_footer_53, t0.captcha_show AS captcha_show_54, t0.captcha_site AS captcha_site_55, t0.captcha_secret AS captcha_secret_56, t0.id AS id_57, t0.created_at AS created_at_58, t0.modified_at AS modified_at_59, t0.created_user AS created_user_60, t0.modified_user AS modified_user_61 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.technical_assistance_title AS technical_assistance_title_6,
  t0.technical_assistance_receiver AS technical_assistance_receiver_7,
  t0.promotion_receiver AS promotion_receiver_8,
  t0.application_receiver AS application_receiver_9,
  t0.truck_quotation_receiver AS truck_quotation_receiver_10,
  t0.service_quotation_title AS service_quotation_title_11,
  t0.service_quotation_receiver AS service_quotation_receiver_12,
  t0.claim_p1_title AS claim_p1_title_13,
  t0.claim_p2_title AS claim_p2_title_14,
  t0.claim_goods AS claim_goods_15,
  t0.claim_p3_title AS claim_p3_title_16,
  t0.claim_types AS claim_types_17,
  t0.claim_p4_title AS claim_p4_title_18,
  t0.claim_response_days AS claim_response_days_19,
  t0.claim_description AS claim_description_20,
  t0.claim_notes AS claim_notes_21,
  t0.claim_receiver AS claim_receiver_22,
  t0.id AS id_23,
  t0.created_at AS created_at_24,
  t0.modified_at AS modified_at_25,
  t0.created_user AS created_user_26,
  t0.modified_user AS modified_user_27
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.technical_assistance_title AS technical_assistance_title_6, t0.technical_assistance_receiver AS technical_assistance_receiver_7, t0.promotion_receiver AS promotion_receiver_8, t0.application_receiver AS application_receiver_9, t0.truck_quotation_receiver AS truck_quotation_receiver_10, t0.service_quotation_title AS service_quotation_title_11, t0.service_quotation_receiver AS service_quotation_receiver_12, t0.claim_p1_title AS claim_p1_title_13, t0.claim_p2_title AS claim_p2_title_14, t0.claim_goods AS claim_goods_15, t0.claim_p3_title AS claim_p3_title_16, t0.claim_types AS claim_types_17, t0.claim_p4_title AS claim_p4_title_18, t0.claim_response_days AS claim_response_days_19, t0.claim_description AS claim_description_20, t0.claim_notes AS claim_notes_21, t0.claim_receiver AS claim_receiver_22, t0.id AS id_23, t0.created_at AS created_at_24, t0.modified_at AS modified_at_25, t0.created_user AS created_user_26, t0.modified_user AS modified_user_27 FROM forms t0 WHERE t0.id = 1;

SELECT
  b0_.title AS title_0,
  b0_.open_external_link AS open_external_link_1,
  b0_.external_link AS external_link_2,
  b0_.banner_text AS banner_text_3,
  b0_.banner_image AS banner_image_4,
  b0_.banner_button_show AS banner_button_show_5,
  b0_.banner_button_text AS banner_button_text_6,
  b0_.banner_button_link AS banner_button_link_7,
  b0_.banner_button_target AS banner_button_target_8,
  b0_.detail_show AS detail_show_9,
  b0_.detail_title AS detail_title_10,
  b0_.detail_text AS detail_text_11,
  b0_.features_show AS features_show_12,
  b0_.features_items AS features_items_13,
  b0_.active AS active_14,
  b0_.position AS position_15,
  b0_.slug AS slug_16,
  b0_.id AS id_17,
  b0_.created_at AS created_at_18,
  b0_.modified_at AS modified_at_19,
  b0_.created_user AS created_user_20,
  b0_.modified_user AS modified_user_21
FROM
  brand b0_
WHERE
  b0_.active = 1
ORDER BY
  b0_.position ASC

SELECT b0_.title AS title_0, b0_.open_external_link AS open_external_link_1, b0_.external_link AS external_link_2, b0_.banner_text AS banner_text_3, b0_.banner_image AS banner_image_4, b0_.banner_button_show AS banner_button_show_5, b0_.banner_button_text AS banner_button_text_6, b0_.banner_button_link AS banner_button_link_7, b0_.banner_button_target AS banner_button_target_8, b0_.detail_show AS detail_show_9, b0_.detail_title AS detail_title_10, b0_.detail_text AS detail_text_11, b0_.features_show AS features_show_12, b0_.features_items AS features_items_13, b0_.active AS active_14, b0_.position AS position_15, b0_.slug AS slug_16, b0_.id AS id_17, b0_.created_at AS created_at_18, b0_.modified_at AS modified_at_19, b0_.created_user AS created_user_20, b0_.modified_user AS modified_user_21 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.position ASC;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  s0_.title AS title_0,
  s0_.image AS image_1,
  s0_.banner_image AS banner_image_2,
  s0_.banner_title AS banner_title_3,
  s0_.banner_text AS banner_text_4,
  s0_.detail_show AS detail_show_5,
  s0_.detail_title AS detail_title_6,
  s0_.detail_text AS detail_text_7,
  s0_.benefits_show AS benefits_show_8,
  s0_.benefits_title AS benefits_title_9,
  s0_.benefits_text AS benefits_text_10,
  s0_.benefits_image AS benefits_image_11,
  s0_.active AS active_12,
  s0_.in_header AS in_header_13,
  s0_.position AS position_14,
  s0_.slug AS slug_15,
  s0_.id AS id_16,
  s0_.created_at AS created_at_17,
  s0_.modified_at AS modified_at_18,
  s0_.created_user AS created_user_19,
  s0_.modified_user AS modified_user_20
FROM
  service s0_
WHERE
  s0_.active = 1
ORDER BY
  s0_.position ASC

SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.banner_image AS banner_image_2, s0_.banner_title AS banner_title_3, s0_.banner_text AS banner_text_4, s0_.detail_show AS detail_show_5, s0_.detail_title AS detail_title_6, s0_.detail_text AS detail_text_7, s0_.benefits_show AS benefits_show_8, s0_.benefits_title AS benefits_title_9, s0_.benefits_text AS benefits_text_10, s0_.benefits_image AS benefits_image_11, s0_.active AS active_12, s0_.in_header AS in_header_13, s0_.position AS position_14, s0_.slug AS slug_15, s0_.id AS id_16, s0_.created_at AS created_at_17, s0_.modified_at AS modified_at_18, s0_.created_user AS created_user_19, s0_.modified_user AS modified_user_20 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC;