Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

33 Database Queries

11 Different statements

14.18 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL)
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
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 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 */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bluue4' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'bluue4'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        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_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
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 * FROM doctrine_migration_versions
SELECT DATABASE()

#▲	Time	Info
1	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
2	0.37 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"stocks_bundle__calc_stock_with_product_parent" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'stocks_bundle__calc_stock_with_product_parent' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
3	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 Parameters: [`"stocks_bundle__calc_stock_with_product_parent"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'stocks_bundle__calc_stock_with_product_parent' AND t0.context_id IS NULL LIMIT 1;
4	0.20 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
5	0.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"stocks_bundle__not_shared_stock_product_root_context" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'stocks_bundle__not_shared_stock_product_root_context' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
6	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 Parameters: [`"stocks_bundle__not_shared_stock_product_root_context"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'stocks_bundle__not_shared_stock_product_root_context' AND t0.context_id IS NULL LIMIT 1;
7	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
8	0.26 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"products_bundle__shared_products" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'products_bundle__shared_products' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
9	0.14 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 Parameters: [`"products_bundle__shared_products"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'products_bundle__shared_products' AND t0.context_id IS NULL LIMIT 1;
10	0.14 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
11	0.14 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"stocks_bundle__warehouses_context" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'stocks_bundle__warehouses_context' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
12	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
13	0.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"sales_bundle__shared_sales" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'sales_bundle__shared_sales' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
14	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 Parameters: [`"sales_bundle__shared_sales"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'sales_bundle__shared_sales' AND t0.context_id IS NULL LIMIT 1;
15	0.21 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
16	0.15 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL) Parameters: [] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.reference AS reference_2, e0_.address AS address_3, e0_.address2 AS address2_4, e0_.postcode AS postcode_5, e0_.city AS city_6, e0_.phone AS phone_7, e0_.email AS email_8, e0_.created_at AS created_at_9, e0_.updated_at AS updated_at_10, e0_.deleted_at AS deleted_at_11, e0_.country_id AS country_id_12, e0_.context_id AS context_id_13, e0_.created_by_id AS created_by_id_14, e0_.updated_by_id AS updated_by_id_15, e0_.deleted_by_id AS deleted_by_id_16 FROM establishment e0_ WHERE (e0_.deleted_at IS NULL);
17	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
18	0.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"prestashop_connector_bundle__shop_url" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'prestashop_connector_bundle__shop_url' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
19	0.16 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.address2 AS address2_5, t0.postcode AS postcode_6, t0.city AS city_7, t0.phone AS phone_8, t0.email AS email_9, t0.website AS website_10, t0.vat_number AS vat_number_11, t0.siren AS siren_12, t0.siret AS siret_13, t0.ape AS ape_14, t0.is_franchise AS is_franchise_15, t0.position AS position_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.is_default AS is_default_20, t0.currency_id AS currency_id_21, t0.country_id AS country_id_22, t0.country_state_id AS country_state_id_23, t0.created_by_id AS created_by_id_24, t0.updated_by_id AS updated_by_id_25, t0.deleted_by_id AS deleted_by_id_26 FROM context t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
20	0.17 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 Parameters: [`"prestashop_connector_bundle__api_key" b"\x1E╚5\x1DHÔd\x06ÅÚoµð\e»ã"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = ? AND t0.context_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.context_id AS context_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM configuration t0 WHERE t0.name = 'prestashop_connector_bundle__api_key' AND t0.context_id = 0x1EC8351D48E264068FE96FE6D01BAFC6 LIMIT 1;
21	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
22	1.94 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"bluue4"`] View formatted query View runnable query Explain query 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 = 'bluue4' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
23	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
24	1.77 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"bluue4"`] View formatted query View runnable query Explain query 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 = 'bluue4' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
25	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
26	0.35 ms	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' Parameters: [`"bluue4" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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 = 'bluue4' AND t.TABLE_NAME = 'doctrine_migration_versions' AND t.TABLE_TYPE = 'BASE TABLE';
27	0.11 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
28	2.63 ms	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 / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'bluue4' / ORDER BY k.ORDINAL_POSITION Parameters: [`"bluue4" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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 / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'bluue4' / 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 / WHERE k.TABLE_SCHEMA = 'bluue4' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'bluue4' / ORDER BY k.ORDINAL_POSITION;
29	2.06 ms	SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'bluue4' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', 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_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"bluue4" "bluue4" "doctrine_migration_versions"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'bluue4' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', 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_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * FROM information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'bluue4' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', 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_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'bluue4' AND t.TABLE_SCHEMA = 'bluue4' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;
30	0.07 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
31	0.14 ms	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 Parameters: [`"bluue4" "doctrine_migration_versions"`] View formatted query View runnable query Explain query 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 = 'bluue4' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY SEQ_IN_INDEX;
32	0.21 ms	SELECT * FROM doctrine_migration_versions Parameters: [] View formatted query View runnable query Explain query SELECT * FROM doctrine_migration_versions SELECT * FROM doctrine_migration_versions;
33	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Context	No errors.
App\Entity\Currency	No errors.
App\Entity\Country	No errors.
App\Entity\CountryState	No errors.
App\Entity\User	No errors.
App\Entity\Configuration	No errors.
App\Entity\UserContext	No errors.
App\Entity\MailServer	No errors.
App\Entity\Establishment	No errors.
Bluue\CategoriesBundle\Entity\Category	No errors.
Bluue\SalesBundle\Entity\OrderLine	No errors.
Bluue\SalesBundle\Entity\Quotation	No errors.
Bluue\SalesBundle\Entity\Order	No errors.
Bluue\SalesBundle\Entity\Invoice	No errors.
Bluue\SalesBundle\Entity\CreditNote	No errors.
Bluue\SalesBundle\Entity\DeliveryNote	No errors.
Bluue\SalesBundle\Entity\InvoiceLine	No errors.
Bluue\SalesBundle\Entity\CreditNoteLine	No errors.
Bluue\SalesBundle\Entity\Payment	No errors.
App\Entity\UsersEstablishments	No errors.
App\Entity\CountryZone	No errors.
App\Entity\TaxRuleCountry	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
App\Entity\CountryTranslation	No errors.
App\Entity\Profile	No errors.
App\Entity\UserLoginLog	No errors.
App\Entity\Notification	No errors.
App\Entity\Language	No errors.
App\Entity\TeamUser	No errors.
Bluue\CategoriesBundle\Entity\CategoryTranslation	No errors.
Bluue\CategoriesBundle\Entity\CategoryProduct	No errors.
Bluue\CategoriesBundle\Entity\CategoryContext	No errors.
Bluue\SalesBundle\Entity\LineType	No errors.
App\Entity\TaxRule	No errors.
Bluue\ProductsBundle\Entity\Product	No errors.
Bluue\ProductsBundle\Entity\Declination	No errors.
Bluue\StocksBundle\Entity\StockOrderLine	No errors.
Bluue\CustomersBundle\Entity\Customer	No errors.
Bluue\SalesBundle\Entity\PaymentMethod	No errors.
Bluue\SalesBundle\Entity\QuotationLine	No errors.
Bluue\SalesBundle\Entity\OrderState	No errors.
Bluue\SalesBundle\Entity\OrderHistory	No errors.
Bluue\SalesBundle\Entity\PaymentTerm	No errors.
Bluue\SalesBundle\Entity\DocumentPayment	No errors.
Bluue\RecurringInvoicesBundle\Entity\RecurringInvoice	No errors.
Bluue\SalesBundle\Entity\DeliveryNoteLine	No errors.
Bluue\SalesBundle\Entity\Bank	No errors.

Symfony Profiler

https://caisse.bluue4.demo.scaledev.fr/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping