Symfony Profiler

Query Metrics

64 Database Queries

14 Different statements

15.64 ms Query time

8 Invalid entities

Queries


SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.sales AS sales_4, t0.expire_date AS expire_date_5, t0.weight AS weight_6, t0.product_code AS product_code_7, t0.dimension AS dimension_8, t0.license AS license_9, t0.package AS package_10, t0.calories AS calories_11, t0.carbs AS carbs_12, t0.fats AS fats_13, t0.protein AS protein_14, t0.net_carbs AS net_carbs_15, t0.fibers AS fibers_16, t0.sodium AS sodium_17, t0.cholesterol AS cholesterol_18, t0.calories_rate AS calories_rate_19, t0.carbs_rate AS carbs_rate_20, t0.fats_rate AS fats_rate_21, t0.protein_rate AS protein_rate_22, t0.net_carbs_rate AS net_carbs_rate_23, t0.fibers_rate AS fibers_rate_24, t0.sodium_rate AS sodium_rate_25, t0.cholesterol_rate AS cholesterol_rate_26, t0.image AS image_27, t0.stock_count AS stock_count_28, t0.is_published AS is_published_29, t0.description AS description_30, t0.description_ar AS description_ar_31, t0.title_ar AS title_ar_32, t0.shipping_weight AS shipping_weight_33, t0.shipping_weight_unit AS shipping_weight_unit_34, t0.dimensions_unit AS dimensions_unit_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.product_category_id AS product_category_id_38 FROM product t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.unit_amount_minor AS unit_amount_minor_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_prices t0 WHERE t0.product_id IN (?)
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.sales AS sales_4, t0.expire_date AS expire_date_5, t0.weight AS weight_6, t0.product_code AS product_code_7, t0.dimension AS dimension_8, t0.license AS license_9, t0.package AS package_10, t0.calories AS calories_11, t0.carbs AS carbs_12, t0.fats AS fats_13, t0.protein AS protein_14, t0.net_carbs AS net_carbs_15, t0.fibers AS fibers_16, t0.sodium AS sodium_17, t0.cholesterol AS cholesterol_18, t0.calories_rate AS calories_rate_19, t0.carbs_rate AS carbs_rate_20, t0.fats_rate AS fats_rate_21, t0.protein_rate AS protein_rate_22, t0.net_carbs_rate AS net_carbs_rate_23, t0.fibers_rate AS fibers_rate_24, t0.sodium_rate AS sodium_rate_25, t0.cholesterol_rate AS cholesterol_rate_26, t0.image AS image_27, t0.stock_count AS stock_count_28, t0.is_published AS is_published_29, t0.description AS description_30, t0.description_ar AS description_ar_31, t0.title_ar AS title_ar_32, t0.shipping_weight AS shipping_weight_33, t0.shipping_weight_unit AS shipping_weight_unit_34, t0.dimensions_unit AS dimensions_unit_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.product_category_id AS product_category_id_38 FROM product t0
SELECT t0.id AS id_1, t0.unit_amount_minor AS unit_amount_minor_2, t0.product_id AS product_id_3, t0.price_list_id AS price_list_id_4 FROM product_prices t0 WHERE t0.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT t0.id AS id_1, t0.email AS email_2, t0.status AS status_3, t0.created_date AS created_date_4, t0.product_id AS product_id_5 FROM product_notification t0 WHERE t0.product_id = ?
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL
SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists t0 WHERE t0.is_default = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0
SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.product_id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.is_published AS is_published_4, t0.created_by_id AS created_by_id_5 FROM product_category t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.product_id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT e0_.id AS id_0, e0_.base_code AS base_code_1, e0_.quote_code AS quote_code_2, e0_.rate_numer AS rate_numer_3, e0_.rate_denom AS rate_denom_4, e0_.provider AS provider_5, e0_.as_of AS as_of_6, e0_.created_at AS created_at_7 FROM exchange_rates e0_ WHERE e0_.base_code = ? AND e0_.quote_code = ? ORDER BY e0_.as_of DESC LIMIT 1
SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.product_id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.product_id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.product_id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT e0_.id AS id_0, e0_.base_code AS base_code_1, e0_.quote_code AS quote_code_2, e0_.rate_numer AS rate_numer_3, e0_.rate_denom AS rate_denom_4, e0_.provider AS provider_5, e0_.as_of AS as_of_6, e0_.created_at AS created_at_7 FROM exchange_rates e0_ WHERE e0_.base_code = ? AND e0_.quote_code = ? ORDER BY e0_.as_of DESC LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.is_published AS is_published_4, t0.created_by_id AS created_by_id_5 FROM product_category t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT e0_.id AS id_0, e0_.base_code AS base_code_1, e0_.quote_code AS quote_code_2, e0_.rate_numer AS rate_numer_3, e0_.rate_denom AS rate_denom_4, e0_.provider AS provider_5, e0_.as_of AS as_of_6, e0_.created_at AS created_at_7 FROM exchange_rates e0_ WHERE e0_.base_code = ? AND e0_.quote_code = ? ORDER BY e0_.as_of DESC LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.is_published AS is_published_4, t0.created_by_id AS created_by_id_5 FROM product_category t0 WHERE t0.id = ?
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1

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\Product	The field App\Entity\Product#productPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductPrice#product does not contain the required 'inversedBy="productPrices"' attribute.
App\Entity\ProductCategory	No errors.
App\Entity\Rate	The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Entity\ProductPrice	The field 'App\Entity\ProductPrice#unitAmountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Favorite	No errors.
App\Entity\Program	The mappings App\Entity\Program#programCategories and App\Entity\ProgramCategory#programs are inconsistent with each other. If association App\Entity\Program#programCategories is many-to-many, then the inversed side App\Entity\ProgramCategory#programs has to be many-to-many as well. The field App\Entity\Program#programPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProgramPrice#program does not contain the required 'inversedBy="programPrices"' attribute. The field App\Entity\Program#restaurantProgramPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RestaurantProgramPrice#program does not contain the required 'inversedBy="restaurantProgramPrices"' attribute. The mappings App\Entity\Program#programDiets and App\Entity\ProgramDiet#programs are inconsistent with each other. If association App\Entity\Program#programDiets is many-to-many, then the inversed side App\Entity\ProgramDiet#programs has to be many-to-many as well.
App\Entity\Flavor	No errors.
App\Entity\ProgramCategory	The association App\Entity\ProgramCategory#programs refers to the owning side field App\Entity\Program#programCategory which does not exist. The mappings App\Entity\ProgramCategory#programsMany and App\Entity\Program#programCategories are inconsistent with each other. The association App\Entity\ProgramCategory#requests refers to the owning side field App\Entity\Request#programCategory which does not exist.
App\Entity\PriceList	No errors.
App\Entity\ProductNotification	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\Currency	No errors.
App\Entity\User	The mappings App\Entity\User#role and App\Entity\Role#users are inconsistent with each other. The field App\Entity\User#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#user does not contain the required 'inversedBy="orders"' attribute. The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which is not defined as association, but as field. The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which does not exist.
App\Embeddable\BankInfo	No errors.
App\Entity\Restaurant	The association App\Entity\Restaurant#programs refers to the owning side field App\Entity\Program#restaurants which does not exist. The field App\Entity\Restaurant#restaurantProgramPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RestaurantProgramPrice#restaurant does not contain the required 'inversedBy="restaurantProgramPrices"' attribute.
App\Entity\ExchangeRate	The field 'App\Entity\ExchangeRate#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\ExchangeRate#rateNumer' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\ExchangeRate#rateDenom' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.

Symfony Profiler

GET https://dev.badnii.com/server.env/product/121

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping