Symfony Profiler

SELECT
  'main'

SELECT 'main';

SELECT
  name AS table_name
FROM
  sqlite_master
WHERE
  type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT
  name
FROM
  sqlite_temp_master
WHERE
  type = 'table'
ORDER BY
  name

SELECT name AS table_name
FROM sqlite_master
WHERE type = 'table'
  AND name != 'sqlite_sequence'
  AND name != 'geometry_columns'
  AND name != 'spatial_ref_sys'
UNION ALL
SELECT name
FROM sqlite_temp_master
WHERE type = 'table'
ORDER BY name;

SELECT
  t.name AS table_name,
  c.*
FROM
  sqlite_master t
  JOIN pragma_table_info(t.name) c
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  c.cid

SELECT t.name AS table_name,
                   c.*
              FROM sqlite_master t
              JOIN pragma_table_info(t.name) c WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, c.cid;

SELECT
  sql
FROM
  (
    SELECT
      *
    FROM
      sqlite_master
    UNION ALL
    SELECT
      *
    FROM
      sqlite_temp_master
  )
WHERE
  type = 'table'
  AND name = ?

SELECT sql
  FROM (
      SELECT *
        FROM sqlite_master
   UNION ALL
      SELECT *
        FROM sqlite_temp_master
  )
WHERE type = 'table'
AND name = 'doctrine_migration_versions';

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.corps AS corps_3,
  t0.ordre AS ordre_4,
  t0.autre_image AS autre_image_5,
  t0.legende_image AS legende_image_6,
  t0.chapo AS chapo_7,
  t0.position_image AS position_image_8,
  t0.lien_photo AS lien_photo_9,
  t0.nom_action AS nom_action_10,
  t0.lien_action AS lien_action_11,
  t0.credits_image AS credits_image_12,
  t0.photo_spectacle_id AS photo_spectacle_id_13,
  t0.spectacle_id AS spectacle_id_14,
  t0.article_id AS article_id_15,
  t0.presse_id AS presse_id_16,
  t0.image_id AS image_id_17,
  t0.index_structure_id AS index_structure_id_18,
  t0.spectacle_blocs_id AS spectacle_blocs_id_19,
  t0.page_id AS page_id_20,
  t0.communique_presse_id AS communique_presse_id_21,
  t0.lettre_diffusion_id AS lettre_diffusion_id_22
FROM
  bloc t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.corps AS corps_3, t0.ordre AS ordre_4, t0.autre_image AS autre_image_5, t0.legende_image AS legende_image_6, t0.chapo AS chapo_7, t0.position_image AS position_image_8, t0.lien_photo AS lien_photo_9, t0.nom_action AS nom_action_10, t0.lien_action AS lien_action_11, t0.credits_image AS credits_image_12, t0.photo_spectacle_id AS photo_spectacle_id_13, t0.spectacle_id AS spectacle_id_14, t0.article_id AS article_id_15, t0.presse_id AS presse_id_16, t0.image_id AS image_id_17, t0.index_structure_id AS index_structure_id_18, t0.spectacle_blocs_id AS spectacle_blocs_id_19, t0.page_id AS page_id_20, t0.communique_presse_id AS communique_presse_id_21, t0.lettre_diffusion_id AS lettre_diffusion_id_22 FROM bloc t0 WHERE t0.article_id = 15;

SELECT
  t.name AS table_name,
  p.*
FROM
  sqlite_master t
  JOIN pragma_foreign_key_list(t.name) p ON p."seq" != '-1'
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  p.id DESC,
  p.seq

SELECT t.name AS table_name,
                   p.*
              FROM sqlite_master t
              JOIN pragma_foreign_key_list(t.name) p
                ON p."seq" != '-1' WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, p.id DESC, p.seq;

SELECT
  t.name AS table_name,
  i.*
FROM
  sqlite_master t
  JOIN pragma_index_list(t.name) i
WHERE
  t.type = 'table'
  AND t.name NOT IN (
    'geometry_columns', 'spatial_ref_sys',
    'sqlite_sequence'
  )
  AND t.name = ?
ORDER BY
  t.name,
  i.seq

SELECT t.name AS table_name,
                   i.*
              FROM sqlite_master t
              JOIN pragma_index_list(t.name) i WHERE t.type = 'table' AND t.name NOT IN ('geometry_columns', 'spatial_ref_sys', 'sqlite_sequence') AND t.name = 'doctrine_migration_versions' ORDER BY t.name, i.seq;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.resume AS resume_4,
  t0.meta_description AS meta_description_5,
  t0.meta_title AS meta_title_6,
  t0.corps AS corps_7,
  t0.slug AS slug_8,
  t0.date AS date_9,
  t0.date_revision AS date_revision_10,
  t0.en_avant AS en_avant_11,
  t0.en_ligne AS en_ligne_12,
  t0.image_article AS image_article_13,
  t0.credit_image AS credit_image_14,
  t0.lettre_diffusion AS lettre_diffusion_15,
  t0.legende_image AS legende_image_16,
  t0.source_fichier AS source_fichier_17,
  t0.structure_principale_id AS structure_principale_id_18,
  t0.rubrique_id AS rubrique_id_19,
  t0.image_entete_id AS image_entete_id_20,
  t0.photo_spectacle_id AS photo_spectacle_id_21,
  t0.spectacle_id AS spectacle_id_22,
  t0.gallerie_id AS gallerie_id_23,
  t0.dossier_gallerie_id AS dossier_gallerie_id_24
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.resume AS resume_4, t0.meta_description AS meta_description_5, t0.meta_title AS meta_title_6, t0.corps AS corps_7, t0.slug AS slug_8, t0.date AS date_9, t0.date_revision AS date_revision_10, t0.en_avant AS en_avant_11, t0.en_ligne AS en_ligne_12, t0.image_article AS image_article_13, t0.credit_image AS credit_image_14, t0.lettre_diffusion AS lettre_diffusion_15, t0.legende_image AS legende_image_16, t0.source_fichier AS source_fichier_17, t0.structure_principale_id AS structure_principale_id_18, t0.rubrique_id AS rubrique_id_19, t0.image_entete_id AS image_entete_id_20, t0.photo_spectacle_id AS photo_spectacle_id_21, t0.spectacle_id AS spectacle_id_22, t0.gallerie_id AS gallerie_id_23, t0.dossier_gallerie_id AS dossier_gallerie_id_24 FROM article t0 WHERE t0.slug = 'fight-impro-bjorn-cote-dalu-a-terre' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.meta_title AS meta_title_3,
  t0.description AS description_4,
  t0.meta_description AS meta_description_5,
  t0.image_entete AS image_entete_6,
  t0.slug AS slug_7,
  t0.titre_court AS titre_court_8
FROM
  rubrique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.meta_title AS meta_title_3, t0.description AS description_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.slug AS slug_7, t0.titre_court AS titre_court_8 FROM rubrique t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.url AS url_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.image_entete AS image_entete_6,
  t0.logo AS logo_7,
  t0.adresse AS adresse_8,
  t0.ville AS ville_9,
  t0.code_postal AS code_postal_10,
  t0.telephone AS telephone_11,
  t0.titre AS titre_12,
  t0.a_propos AS a_propos_13,
  t0.nom_contact_presse AS nom_contact_presse_14,
  t0.email_contact_presse AS email_contact_presse_15,
  t0.tel_contact_presse AS tel_contact_presse_16
FROM
  structure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.url AS url_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.image_entete AS image_entete_6, t0.logo AS logo_7, t0.adresse AS adresse_8, t0.ville AS ville_9, t0.code_postal AS code_postal_10, t0.telephone AS telephone_11, t0.titre AS titre_12, t0.a_propos AS a_propos_13, t0.nom_contact_presse AS nom_contact_presse_14, t0.email_contact_presse AS email_contact_presse_15, t0.tel_contact_presse AS tel_contact_presse_16 FROM structure t0 WHERE t0.id = 1;

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  *
FROM
  PRAGMA_TABLE_INFO (?)

SELECT * FROM PRAGMA_TABLE_INFO ('doctrine_migration_versions');