Symfony Profiler

Query Metrics

58 Database Queries

15 Different statements

14.49 ms Query time

5 Invalid entities

47 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements


SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.code AS code_2, p0_.slug AS slug_3, p0_.image_bkg AS image_bkg_4, p0_.header_image AS header_image_5, p0_.subtitle AS subtitle_6, p0_.is_home AS is_home_7, p0_.header_type AS header_type_8, p0_.header_detail AS header_detail_9, p0_.keywords AS keywords_10, p0_.content AS content_11, p0_.is_deleted AS is_deleted_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14 FROM page p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.is_home = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT m0_.id AS id_0, m0_.link_name AS link_name_1, m0_.link AS link_2, m0_.on_top AS on_top_3, m0_.ordre AS ordre_4, m0_.visibility AS visibility_5, m0_.link_type AS link_type_6, m0_.only_footer AS only_footer_7, m0_.is_deleted AS is_deleted_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10 FROM menu m0_ WHERE COALESCE(m0_.is_deleted, 0) = 0 ORDER BY m0_.ordre ASC
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_.created_at AS created_at_11, f0_.updated_at AS updated_at_12, f0_.subscription_class_id AS subscription_class_id_13, f0_.product_type_id AS product_type_id_14 FROM formation f0_ WHERE COALESCE(f0_.is_deleted, 0) = 0 AND f0_.is_in_top_bar = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.title AS title_2, b0_.image AS image_3, b0_.bkg AS bkg_4, b0_.is_visible AS is_visible_5, b0_.full_content AS full_content_6, b0_.with_text AS with_text_7, b0_.type AS type_8, b0_.overlay_background AS overlay_background_9, b0_.text AS text_10, b0_.link_type AS link_type_11, b0_.link_text AS link_text_12, b0_.bkg_color AS bkg_color_13, b0_.bkg_video AS bkg_video_14, b0_.link AS link_15, b0_.is_deleted AS is_deleted_16, b0_.created_at AS created_at_17, b0_.updated_at AS updated_at_18 FROM banner b0_ WHERE COALESCE(b0_.is_deleted, 0) = 0 AND b0_.id IN (?)
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.thumb AS thumb_2, p0_.description AS description_3, p0_.slug AS slug_4, p0_.principal_image AS principal_image_5, p0_.is_sold AS is_sold_6, p0_.top_position AS top_position_7, p0_.is_enabled AS is_enabled_8, p0_.keywords AS keywords_9, p0_.price AS price_10, p0_.price_ht AS price_ht_11, p0_.properties AS properties_12, p0_.max_cart_quantity AS max_cart_quantity_13, p0_.weight AS weight_14, p0_.variations AS variations_15, p0_.is_deleted AS is_deleted_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.product_type_id AS product_type_id_19, p0_.author_id AS author_id_20 FROM product p0_ WHERE COALESCE(p0_.is_enabled, 1) = 1 ORDER BY RAND() ASC LIMIT 3
SELECT pt.id, pt.name, pt.data, pt.type, 
                   CASE WHEN pt.type = 'PromotionProduct' THEN 999 ELSE 1 END AS priority,
                   pt.date_end AS dateEnd
            FROM promotion pt
            WHERE pt.date_end > ?
              AND (
                (
                  pt.type = 'PromotionProduct'
                  AND CAST(JSON_UNQUOTE(JSON_EXTRACT(pt.data, '$.product')) AS UNSIGNED) IN (?,?,?)
                )
                OR pt.type IN ('PromotionProductType', 'PromotionCategory', 'PromotionProductGroup')
              )
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.data AS data_2, p0_.type AS type_3, CASE WHEN p0_.type = 'PromotionProduct' THEN 999 ELSE 1 END AS sclr_4, p0_.date_end AS date_end_5 FROM promotion p0_ WHERE (p0_.type = 'PromotionProductType' AND p0_.date_end >= ?) OR (p0_.type = 'PromotionProductGroup' AND p0_.date_end >= ?) OR (p0_.type = 'PromotionCategory' AND p0_.date_end >= ?)
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.country AS country_8, t0.username AS username_9, t0.last_login AS last_login_10, t0.properties AS properties_11, t0.is_active AS is_active_12, t0.verified_token AS verified_token_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9, t0.product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.slug AS slug_2, c0_.color AS color_3, c0_.is_enabled AS is_enabled_4, c0_.is_deleted AS is_deleted_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.parent_id AS parent_id_8, c0_.product_link_id AS product_link_id_9 FROM category c0_ WHERE COALESCE(c0_.is_deleted, 0) = 0 AND c0_.id IN (?, ?)
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.country AS country_8, t0.username AS username_9, t0.last_login AS last_login_10, t0.properties AS properties_11, t0.is_active AS is_active_12, t0.verified_token AS verified_token_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9, t0.product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.slug AS slug_2, c0_.color AS color_3, c0_.is_enabled AS is_enabled_4, c0_.is_deleted AS is_deleted_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.parent_id AS parent_id_8, c0_.product_link_id AS product_link_id_9 FROM category c0_ WHERE COALESCE(c0_.is_deleted, 0) = 0 AND c0_.id IN (?)
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.country AS country_8, t0.username AS username_9, t0.last_login AS last_login_10, t0.properties AS properties_11, t0.is_active AS is_active_12, t0.verified_token AS verified_token_13, t0.is_deleted AS is_deleted_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16 FROM `user` t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.is_deleted AS is_deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9, t0.product_link_id AS product_link_id_10 FROM category t0 INNER JOIN product_category ON t0.id = product_category.category_id WHERE product_category.product_id = ?
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.slug AS slug_2, c0_.color AS color_3, c0_.is_enabled AS is_enabled_4, c0_.is_deleted AS is_deleted_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.parent_id AS parent_id_8, c0_.product_link_id AS product_link_id_9 FROM category c0_ WHERE COALESCE(c0_.is_deleted, 0) = 0 AND c0_.id IN (?)
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_ WHERE COALESCE(w0_.is_deleted, 0) = 0 AND w0_.code = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
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, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7 FROM policy_term p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
Graphlife\CMSBundle\Entity\Parameter	17
Graphlife\CMSBundle\Entity\Widget	8
Graphlife\CMSBundle\Entity\Menu	6
Graphlife\CMSBundle\Entity\PolicyTerm	4
Graphlife\CMSPaymentBundle\Entity\Product	3
Graphlife\CMSBundle\Entity\User	3
Graphlife\CMSPaymentBundle\Entity\Category	3
Graphlife\CMSBundle\Entity\Page	1
Graphlife\CMSBundle\Entity\Banner	1
Graphlife\CMSPaymentBundle\Entity\ProductType	1

Entities Mapping

Class	Mapping errors
Graphlife\CMSPaymentBundle\Entity\CodePromo	No errors.
Graphlife\CMSPaymentBundle\Entity\Currency	No errors.
Graphlife\CMSPaymentBundle\Entity\Product	No errors.
Graphlife\CMSPaymentBundle\Entity\Package	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\PaymentMethod	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentPlan	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductImage	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductTax	No errors.
Graphlife\CMSPaymentBundle\Entity\ProductType	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\ShippmentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Stock	No errors.
Graphlife\CMSPaymentBundle\Entity\Transporter	No errors.
Graphlife\CMSPaymentBundle\Entity\Category	No errors.
Graphlife\CMSPaymentBundle\Entity\PaymentStatus	No errors.
Graphlife\CMSPaymentBundle\Entity\Transaction	No errors.
Graphlife\CMSBundle\Entity\Country	No errors.
Graphlife\CMSBundle\Entity\Email	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\ParameterCategory	No errors.
Graphlife\CMSBundle\Entity\Widget	No errors.
Graphlife\CMSBundle\Entity\Banner	No errors.
Graphlife\CMSBundle\Entity\EntityTranslation	No errors.
Graphlife\CMSBundle\Entity\Language	No errors.
Graphlife\CMSBundle\Entity\Menu	No errors.
Graphlife\CMSBundle\Entity\Page	No errors.
Graphlife\CMSBundle\Entity\Parameter	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.
App\Entity\BankTransfer	No errors.
App\Entity\CommissionFormateur	No errors.
App\Entity\CompanyCourse	No errors.
App\Entity\DemandeFormateur	No errors.
App\Entity\Document	No errors.
App\Entity\Event	No errors.
App\Entity\LessonStatus	No errors.
App\Entity\LiveSession	No errors.
App\Entity\Question	No errors.
App\Entity\QuestionFAQ	No errors.
App\Entity\QuestionFAQCategory	No errors.
App\Entity\ServiceCompany	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\UserCompany	No errors.
App\Entity\UserCourse	No errors.
App\Entity\VideoUploading	No errors.
App\Entity\Formation	No errors.
App\Entity\Lesson	No errors.
App\Entity\Company	No errors.

Symfony Profiler

GET https://africafirst.graph-life.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping