Query Metrics
16
Database Queries
9
Different statements
1.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.18 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.footer_invoice AS footer_invoice_17, t0.invoice_index AS invoice_index_18, t0.invoice_prefix AS invoice_prefix_19, t0.enableClickNCollect AS enableClickNCollect_20, t0.newsletterformcode AS newsletterformcode_21, t0.mailchimpApiKey AS mailchimpApiKey_22, t0.mailchimpServer AS mailchimpServer_23, t0.mailchimpListId AS mailchimpListId_24, t0.default_locale_id AS default_locale_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.base_currency_id AS base_currency_id_31, t32.code AS code_33, t32.created_at AS created_at_34, t32.updated_at AS updated_at_35, t32.id AS id_36, t0.default_tax_zone_id AS default_tax_zone_id_37, t0.menu_taxon_id AS menu_taxon_id_38, t0.shop_billing_data_id AS shop_billing_data_id_39 FROM sylius_channel t0 INNER JOIN sylius_locale t26 ON t0.default_locale_id = t26.id INNER JOIN sylius_currency t32 ON t0.base_currency_id = t32.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"mons"
]
|
| 2 | 0.12 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
2
]
|
| 3 | 0.12 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
2
]
|
| 4 | 0.11 ms |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
2
]
|
| 5 | 0.13 ms |
SELECT o0_.id AS id_0, o0_.code AS code_1, o0_.enabled AS enabled_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.archived_at AS archived_at_5, o1_.id AS id_6, o1_.slug AS slug_7, o1_.title AS title_8, o1_.content AS content_9, o1_.metaKeywords AS metaKeywords_10, o1_.metaDescription AS metaDescription_11, o1_.locale AS locale_12, o0_.author_id AS author_id_13, o1_.translatable_id AS translatable_id_14 FROM odiseo_blog_article o0_ INNER JOIN odiseo_blog_articles_channels o3_ ON o0_.id = o3_.article_id INNER JOIN sylius_channel s2_ ON s2_.id = o3_.channel_id INNER JOIN odiseo_blog_article_translation o1_ ON o0_.id = o1_.translatable_id AND (o1_.locale = ?) WHERE o0_.enabled = 1 AND s2_.code = ? ORDER BY o0_.created_at DESC, o0_.created_at DESC LIMIT 3
Parameters:
[ "fr" "Mons" ] |
| 6 | 0.10 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.owner_id AS owner_id_4 FROM odiseo_blog_article_image t0 WHERE t0.owner_id = ?
Parameters:
[
72
]
|
| 7 | 0.07 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM odiseo_blog_article_category t0 INNER JOIN odiseo_blog_articles_categories ON t0.id = odiseo_blog_articles_categories.category_id WHERE odiseo_blog_articles_categories.article_id = ?
Parameters:
[
72
]
|
| 8 | 0.07 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM odiseo_blog_article_category_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1
Parameters:
[ 1 "fr" ] |
| 9 | 0.07 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.owner_id AS owner_id_4 FROM odiseo_blog_article_image t0 WHERE t0.owner_id = ?
Parameters:
[
71
]
|
| 10 | 0.06 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM odiseo_blog_article_category t0 INNER JOIN odiseo_blog_articles_categories ON t0.id = odiseo_blog_articles_categories.category_id WHERE odiseo_blog_articles_categories.article_id = ?
Parameters:
[
71
]
|
| 11 | 0.07 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.path AS path_3, t0.owner_id AS owner_id_4 FROM odiseo_blog_article_image t0 WHERE t0.owner_id = ?
Parameters:
[
70
]
|
| 12 | 0.06 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM odiseo_blog_article_category t0 INNER JOIN odiseo_blog_articles_categories ON t0.id = odiseo_blog_articles_categories.category_id WHERE odiseo_blog_articles_categories.article_id = ?
Parameters:
[
70
]
|
| 13 | 0.08 ms |
SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.footer_invoice AS footer_invoice_17, t0.invoice_index AS invoice_index_18, t0.invoice_prefix AS invoice_prefix_19, t0.enableClickNCollect AS enableClickNCollect_20, t0.newsletterformcode AS newsletterformcode_21, t0.mailchimpApiKey AS mailchimpApiKey_22, t0.mailchimpServer AS mailchimpServer_23, t0.mailchimpListId AS mailchimpListId_24, t0.default_locale_id AS default_locale_id_25, t26.code AS code_27, t26.created_at AS created_at_28, t26.updated_at AS updated_at_29, t26.id AS id_30, t0.base_currency_id AS base_currency_id_31, t32.code AS code_33, t32.created_at AS created_at_34, t32.updated_at AS updated_at_35, t32.id AS id_36, t0.default_tax_zone_id AS default_tax_zone_id_37, t0.menu_taxon_id AS menu_taxon_id_38, t0.shop_billing_data_id AS shop_billing_data_id_39 FROM sylius_channel t0 INNER JOIN sylius_locale t26 ON t0.default_locale_id = t26.id INNER JOIN sylius_currency t32 ON t0.base_currency_id = t32.id
Parameters:
[] |
| 14 | 0.07 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_currency t0 INNER JOIN sylius_channel_currencies ON t0.id = sylius_channel_currencies.currency_id WHERE sylius_channel_currencies.channel_id = ?
Parameters:
[
3
]
|
| 15 | 0.07 ms |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = ?
Parameters:
[
3
]
|
| 16 | 0.06 ms |
SELECT t0.code AS code_1, t0.enabled AS enabled_2, t0.id AS id_3 FROM sylius_country t0 INNER JOIN sylius_channel_countries ON t0.id = sylius_channel_countries.country_id WHERE sylius_channel_countries.channel_id = ?
Parameters:
[
3
]
|
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 |
|---|---|
| Sylius\Component\Order\Model\Order | No errors. |
| Sylius\Component\Core\Model\Order | No errors. |
| App\Entity\Order\Order | No errors. |
| Sylius\Component\Channel\Model\Channel | No errors. |
| Sylius\Component\Core\Model\Channel | No errors. |
| App\Entity\Channel\Channel | No errors. |
| Sylius\Component\Locale\Model\Locale | No errors. |
| App\Entity\Locale\Locale | No errors. |
| Sylius\Component\Currency\Model\Currency | No errors. |
| App\Entity\Currency\Currency | No errors. |
| Sylius\Component\Addressing\Model\Zone | No errors. |
| App\Entity\Addressing\Zone | No errors. |
| Sylius\Component\Taxonomy\Model\Taxon | No errors. |
| Sylius\Component\Core\Model\Taxon | No errors. |
| App\Entity\Taxonomy\Taxon | No errors. |
| Sylius\Component\Core\Model\ShopBillingData | No errors. |
| App\Entity\ShopBillingData | No errors. |
| Sylius\Component\Addressing\Model\Country | No errors. |
| App\Entity\Addressing\Country | No errors. |
| Odiseo\BlogBundle\Model\Article | No errors. |
| Odiseo\SyliusBlogPlugin\Entity\Article | No errors. |
| Sylius\Component\Payment\Model\PaymentMethod | No errors. |
| Sylius\Component\Core\Model\PaymentMethod | No errors. |
| App\Entity\Payment\PaymentMethod | No errors. |
| Odiseo\BlogBundle\Model\ArticleTranslation | No errors. |
| Sylius\Component\User\Model\User | No errors. |
| Sylius\Component\Core\Model\AdminUser | No errors. |
| App\Entity\User\AdminUser | No errors. |
| Odiseo\BlogBundle\Model\Image | No errors. |
| Odiseo\BlogBundle\Model\ArticleImage | No errors. |
| Odiseo\BlogBundle\Model\ArticleComment | No errors. |
| Odiseo\SyliusBlogPlugin\Entity\ArticleComment | No errors. |
| Odiseo\BlogBundle\Model\ArticleCategory | No errors. |
| BitBag\SyliusCmsPlugin\Entity\Block | No errors. |
| BitBag\SyliusCmsPlugin\Entity\Media | No errors. |
| App\Entity\BitBagCms\Media | No errors. |
| BitBag\SyliusCmsPlugin\Entity\Page | No errors. |
| App\Entity\BitBagCms\Page | No errors. |
| Odiseo\BlogBundle\Model\ArticleCategoryTranslation | No errors. |
| Sylius\Component\Addressing\Model\Province | No errors. |
| App\Entity\Addressing\Province | No errors. |