Symfony Profiler

SELECT
  t0_.title AS title_0
FROM
  type t0_
ORDER BY
  t0_.periorite ASC

SELECT t0_.title AS title_0 FROM type t0_ ORDER BY t0_.periorite ASC;

SELECT
  DATABASE()

SELECT DATABASE();

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

SELECT
  DATABASE()

SELECT DATABASE();

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

SELECT
  DATABASE()

SELECT DATABASE();

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 = 'rm9b6_bn_invest' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';

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 = 'rm9b6_bn_invest' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_SCHEMA = c.TABLE_SCHEMA
  AND t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE        AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_SCHEMA = c.TABLE_SCHEMA
        AND t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'rm9b6_bn_invest' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

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

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  p0_.id AS id_0,
  p0_.api_id AS api_id_1,
  p0_.agency_name AS agency_name_2,
  p0_.agency_reference AS agency_reference_3,
  p0_.lastupdate AS lastupdate_4,
  p0_.status_id AS status_id_5,
  p0_.reference AS reference_6,
  p0_.name AS name_7,
  p0_.adresse AS adresse_8,
  p0_.price AS price_9,
  p0_.surface AS surface_10,
  p0_.rooms AS rooms_11,
  p0_.bathrooms AS bathrooms_12,
  p0_.showerrooms AS showerrooms_13,
  p0_.bedrooms AS bedrooms_14,
  p0_.floor AS floor_15,
  p0_.description AS description_16,
  p0_.promotion_id AS promotion_id_17,
  p0_.transaction_type AS transaction_type_18,
  p0_.enabled AS enabled_19,
  p0_.featured AS featured_20,
  p0_.type_property AS type_property_21,
  p0_.longitude AS longitude_22,
  p0_.latitude AS latitude_23,
  p0_.zip AS zip_24,
  p0_.videos_object AS videos_object_25,
  p0_.visit3ds_object AS visit3ds_object_26,
  p0_.disponibilite_date AS disponibilite_date_27,
  p0_.status AS status_28,
  p0_.country_fr AS country_fr_29,
  p0_.district_fr AS district_fr_30,
  p0_.canton_fr AS canton_fr_31,
  p0_.quarter_fr AS quarter_fr_32,
  p0_.zone_fr AS zone_fr_33,
  p0_.city_fr AS city_fr_34,
  p0_.disponible_fr AS disponible_fr_35,
  p0_.broker_id AS broker_id_36,
  p0_.country_id AS country_id_37,
  p0_.canton_id AS canton_id_38,
  p0_.district_id AS district_id_39,
  p0_.quarter_id AS quarter_id_40,
  p0_.zone_id AS zone_id_41,
  p0_.city_id AS city_id_42,
  p0_.type_id AS type_id_43,
  p0_.disponible_id AS disponible_id_44
FROM
  property p0_
  INNER JOIN type t1_ ON p0_.type_id = t1_.id
WHERE
  p0_.transaction_type = ?
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.api_id AS api_id_1, p0_.agency_name AS agency_name_2, p0_.agency_reference AS agency_reference_3, p0_.lastupdate AS lastupdate_4, p0_.status_id AS status_id_5, p0_.reference AS reference_6, p0_.name AS name_7, p0_.adresse AS adresse_8, p0_.price AS price_9, p0_.surface AS surface_10, p0_.rooms AS rooms_11, p0_.bathrooms AS bathrooms_12, p0_.showerrooms AS showerrooms_13, p0_.bedrooms AS bedrooms_14, p0_.floor AS floor_15, p0_.description AS description_16, p0_.promotion_id AS promotion_id_17, p0_.transaction_type AS transaction_type_18, p0_.enabled AS enabled_19, p0_.featured AS featured_20, p0_.type_property AS type_property_21, p0_.longitude AS longitude_22, p0_.latitude AS latitude_23, p0_.zip AS zip_24, p0_.videos_object AS videos_object_25, p0_.visit3ds_object AS visit3ds_object_26, p0_.disponibilite_date AS disponibilite_date_27, p0_.status AS status_28, p0_.country_fr AS country_fr_29, p0_.district_fr AS district_fr_30, p0_.canton_fr AS canton_fr_31, p0_.quarter_fr AS quarter_fr_32, p0_.zone_fr AS zone_fr_33, p0_.city_fr AS city_fr_34, p0_.disponible_fr AS disponible_fr_35, p0_.broker_id AS broker_id_36, p0_.country_id AS country_id_37, p0_.canton_id AS canton_id_38, p0_.district_id AS district_id_39, p0_.quarter_id AS quarter_id_40, p0_.zone_id AS zone_id_41, p0_.city_id AS city_id_42, p0_.type_id AS type_id_43, p0_.disponible_id AS disponible_id_44 FROM property p0_ INNER JOIN type t1_ ON p0_.type_id = t1_.id WHERE p0_.transaction_type = 2 ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.periorite AS periorite_4
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.ref AS ref_4,
  t0.ordre AS ordre_5,
  t0.property_id AS property_id_6,
  t0.broker_id AS broker_id_7
FROM
  photo t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = 137;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.periorite AS periorite_4
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.ref AS ref_4,
  t0.ordre AS ordre_5,
  t0.property_id AS property_id_6,
  t0.broker_id AS broker_id_7
FROM
  photo t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = 135;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.periorite AS periorite_4
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.periorite AS periorite_4 FROM type t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.path AS path_3,
  t0.ref AS ref_4,
  t0.ordre AS ordre_5,
  t0.property_id AS property_id_6,
  t0.broker_id AS broker_id_7
FROM
  photo t0
WHERE
  t0.property_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.path AS path_3, t0.ref AS ref_4, t0.ordre AS ordre_5, t0.property_id AS property_id_6, t0.broker_id AS broker_id_7 FROM photo t0 WHERE t0.property_id = 126;

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/bernard_nicod_commercial'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/bernard_nicod_commercial') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('93d0d8f6-d6ce-41fb-a61c-0dd11212e858');

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/offres/envoyer-un-message') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/snippets/offres'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/offres') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  w0_.title AS title_0,
  w0_.webspace_key AS webspace_key_1,
  w0_.all_domains AS all_domains_2,
  w0_.content AS content_3,
  w0_.type AS type_4,
  w0_.id AS id_5,
  w1_.url AS url_6,
  w1_.environment AS environment_7,
  w1_.id AS id_8
FROM
  we_analytics w0_
  LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics
  LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain
WHERE
  (
    w0_.all_domains = 1
    OR (
      w1_.url = ?
      AND w1_.environment = ?
    )
  )
  AND w0_.webspace_key = ?
ORDER BY
  w0_.id ASC,
  w1_.id ASC

SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = 'bn-invest-com.ewm.dev' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'bernard_nicod_commercial' ORDER BY w0_.id ASC, w1_.id ASC;