GET https://centre-rac.com/subscribe/1

Query Metrics

38 Database Queries
13 Different statements
7.40 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 0.38 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.subscription_class_id AS subscription_class_id_11, f0_.product_type_id AS product_type_id_12 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.id = ?
Parameters:
[
  "1"
]
2 0.21 ms
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5 FROM widget w0_
Parameters:
[]
3 0.25 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "name"
]
4 0.25 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "slogan"
]
5 0.27 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "keyword"
]
6 0.22 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "description"
]
7 0.17 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "favicon"
]
8 0.17 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo"
]
9 0.19 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo_s"
]
10 0.20 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "principalColor"
]
11 0.16 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "secondaryColor"
]
12 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "algoliaIndex"
]
13 0.22 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "name"
]
14 0.21 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "logo_s"
]
15 0.12 ms
SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0
Parameters:
[]
16 0.22 ms
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.options AS options_3, f0_.price AS price_4, f0_.is_subscription_open AS is_subscription_open_5, f0_.payment_configuration AS payment_configuration_6, f0_.price_ht AS price_ht_7, f0_.is_in_top_bar AS is_in_top_bar_8, f0_.top_bar_message AS top_bar_message_9, f0_.is_deleted AS is_deleted_10, f0_.subscription_class_id AS subscription_class_id_11, f0_.product_type_id AS product_type_id_12 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?
Parameters:
[
  1
]
17 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  2
]
18 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  4
]
19 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_bkg AS image_bkg_4, t0.header_image AS header_image_5, t0.subtitle AS subtitle_6, t0.is_home AS is_home_7, t0.header_type AS header_type_8, t0.header_detail AS header_detail_9, t0.keywords AS keywords_10, t0.content AS content_11, t0.is_deleted AS is_deleted_12 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  3
]
20 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.description AS description_4, t0.slug AS slug_5, t0.principal_image AS principal_image_6, t0.is_sold AS is_sold_7, t0.top_position AS top_position_8, t0.is_enabled AS is_enabled_9, t0.keywords AS keywords_10, t0.price AS price_11, t0.price_ht AS price_ht_12, t0.properties AS properties_13, t0.max_cart_quantity AS max_cart_quantity_14, t0.weight AS weight_15, t0.variations AS variations_16, t0.is_deleted AS is_deleted_17, t0.product_type_id AS product_type_id_18 FROM product t0 INNER JOIN formation_product ON t0.id = formation_product.product_id WHERE formation_product.formation_id = ?
Parameters:
[
  1
]
21 0.21 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?)
Parameters:
[
  4
  5
  6
  7
]
22 0.17 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?)
Parameters:
[
  8
  9
  11
  12
]
23 0.19 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  13
  14
  15
  48
  49
  50
  51
  52
]
24 0.19 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  60
  59
  55
  56
  57
  58
]
25 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?)
Parameters:
[
  21
  18
  16
  19
]
26 0.13 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?)
Parameters:
[
  20
  17
  4
]
27 0.16 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  70
  26
  27
  67
  68
  69
]
28 0.18 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  29
  30
  31
  32
  33
  34
]
29 0.15 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  35
  36
  45
  42
  43
  37
]
30 0.16 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  38
  53
  40
  39
  41
]
31 0.14 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  61
  63
  64
  65
  66
]
32 0.16 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.description AS description_2, l0_.video_link AS video_link_3, l0_.content AS content_4, l0_.duration AS duration_5, l0_.is_deleted AS is_deleted_6 FROM lesson l0_ WHERE COALESCE(l0_.is_deleted, 0) = 0 AND l0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  46
  71
  72
  73
  74
]
33 0.19 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "facebook"
]
34 0.19 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "twitter"
]
35 0.24 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "instagram"
]
36 0.18 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "linkedin"
]
37 0.21 ms
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
  "youtube"
]
38 0.16 ms
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.name AS name_2, p0_.footer_name AS footer_name_3, p0_.content AS content_4, p0_.is_deleted AS is_deleted_5 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0
Parameters:
[]

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\Document No errors.
App\Entity\Event No errors.
App\Entity\Formation No errors.
App\Entity\Lesson No errors.
App\Entity\LiveSession No errors.
App\Entity\QuestionFAQ No errors.
App\Entity\StudentClass No errors.
App\Entity\Test
  • The association App\Entity\Test#account refers to the inverse side field Graphlife\CMSBundle\Entity\User#tests which does not exist.
  • The association App\Entity\Test#course refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Product#tests which does not exist.
App\Entity\UserCourse No errors.
App\Entity\Question No errors.
Graphlife\CMSBundle\Entity\Banner No errors.
Graphlife\CMSBundle\Entity\Country No errors.
Graphlife\CMSBundle\Entity\Email No errors.
Graphlife\CMSBundle\Entity\Menu No errors.
Graphlife\CMSBundle\Entity\NewsletterEmail No errors.
Graphlife\CMSBundle\Entity\Notification
  • The association Graphlife\CMSBundle\Entity\Notification#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#notifications which does not exist.
Graphlife\CMSBundle\Entity\Page No errors.
Graphlife\CMSBundle\Entity\Parameter No errors.
Graphlife\CMSBundle\Entity\ParameterCategory No errors.
Graphlife\CMSBundle\Entity\PolicyTerm No errors.
Graphlife\CMSBundle\Entity\Post No errors.
Graphlife\CMSBundle\Entity\PostCategory No errors.
Graphlife\CMSBundle\Entity\User No errors.
Graphlife\CMSBundle\Entity\Widget No errors.
Graphlife\CMSPaymentBundle\Entity\CodePromo No errors.
Graphlife\CMSPaymentBundle\Entity\Product No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentMethod No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax No errors.
Graphlife\CMSPaymentBundle\Entity\ProductType No errors.
Graphlife\CMSPaymentBundle\Entity\ShippmentStatus No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter No errors.
Graphlife\CMSPaymentBundle\Entity\Transaction No errors.
Graphlife\CMSPaymentBundle\Entity\Currency No errors.
Graphlife\CMSPaymentBundle\Entity\Payment
  • The mappings Graphlife\CMSPaymentBundle\Entity\Payment#shippments and Graphlife\CMSPaymentBundle\Entity\Shippment#payment are inconsistent with each other.
  • The association Graphlife\CMSPaymentBundle\Entity\Payment#user refers to the inverse side field Graphlife\CMSBundle\Entity\User#payments which does not exist.
Graphlife\CMSPaymentBundle\Entity\Category No errors.
Graphlife\CMSPaymentBundle\Entity\Promotion No errors.
Graphlife\CMSPaymentBundle\Entity\ShippingMethod
  • The association Graphlife\CMSPaymentBundle\Entity\ShippingMethod#countries refers to the inverse side field Graphlife\CMSBundle\Entity\Country#shippingMethods which does not exist.
Graphlife\CMSPaymentBundle\Entity\Shippment
  • The association Graphlife\CMSPaymentBundle\Entity\Shippment#payment refers to the inverse side field Graphlife\CMSPaymentBundle\Entity\Payment#shippment which does not exist.
Graphlife\CMSPaymentBundle\Entity\Stock No errors.