GET https://dev.badnii.com/sitemap.xml

Query Metrics

37 Database Queries
15 Different statements
13.05 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 1.52 ms
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.content_ar AS content_ar_7, t0.image AS image_8, t0.published AS published_9, t0.meta_tags AS meta_tags_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.blog_category_id AS blog_category_id_13 FROM blog t0 ORDER BY t0.created_at DESC LIMIT 3
Parameters:
[]
2 0.91 ms
SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.google_id AS google_id_3, u0_.first_name_ar AS first_name_ar_4, u0_.last_name_ar AS last_name_ar_5, u0_.address AS address_6, u0_.is_active AS is_active_7, u0_.email AS email_8, u0_.mobile AS mobile_9, u0_.phone_verified AS phone_verified_10, u0_.otp_code AS otp_code_11, u0_.otp_expires_at AS otp_expires_at_12, u0_.otp_attempts AS otp_attempts_13, u0_.gender AS gender_14, u0_.preferred_unit AS preferred_unit_15, u0_.current_weight AS current_weight_16, u0_.target_weight AS target_weight_17, u0_.height AS height_18, u0_.password AS password_19, u0_.last_seen AS last_seen_20, u0_.country AS country_21, u0_.city AS city_22, u0_.date_of_birth AS date_of_birth_23, u0_.avatar AS avatar_24, u0_.description AS description_25, u0_.description_ar AS description_ar_26, u0_.is_approved AS is_approved_27, u0_.is_available_for_request AS is_available_for_request_28, u0_.accepted_terms AS accepted_terms_29, u0_.reset_token AS reset_token_30, u0_.reset_token_expires_at AS reset_token_expires_at_31, u0_.facebook_id AS facebook_id_32, u0_.created_at AS created_at_33, u0_.updated_at AS updated_at_34, u0_.role_id AS role_id_35, u0_.physical_activity_id AS physical_activity_id_36, u0_.diet_goal_id AS diet_goal_id_37, u0_.custom_role_id AS custom_role_id_38 FROM user u0_ LEFT JOIN role r1_ ON u0_.role_id = r1_.id INNER JOIN program p2_ ON u0_.id = p2_.created_by_id WHERE r1_.type = ? AND u0_.id <> ? AND u0_.is_active = ? LIMIT 3
Parameters:
[
  "ROLE_EXPERT"
  3
  1
]
3 0.38 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.phone_verified AS phone_verified_11, t0.otp_code AS otp_code_12, t0.otp_expires_at AS otp_expires_at_13, t0.otp_attempts AS otp_attempts_14, t0.gender AS gender_15, t0.preferred_unit AS preferred_unit_16, t0.current_weight AS current_weight_17, t0.target_weight AS target_weight_18, t0.height AS height_19, t0.password AS password_20, t0.last_seen AS last_seen_21, t0.country AS country_22, t0.city AS city_23, t0.date_of_birth AS date_of_birth_24, t0.avatar AS avatar_25, t0.description AS description_26, t0.description_ar AS description_ar_27, t0.is_approved AS is_approved_28, t0.is_available_for_request AS is_available_for_request_29, t0.accepted_terms AS accepted_terms_30, t0.reset_token AS reset_token_31, t0.reset_token_expires_at AS reset_token_expires_at_32, t0.facebook_id AS facebook_id_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.role_id AS role_id_36, t0.physical_activity_id AS physical_activity_id_37, t0.diet_goal_id AS diet_goal_id_38, t0.custom_role_id AS custom_role_id_39 FROM user t0 WHERE t0.role_id = ? LIMIT 1
Parameters:
[
  "ROLE_ADMIN"
]
4 0.33 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.question_ar AS question_ar_3, t0.answer AS answer_4, t0.answer_ar AS answer_ar_5, t0.published AS published_6, t0.created_by_id AS created_by_id_7, t0.program_id AS program_id_8 FROM faq t0 WHERE t0.created_by_id IS NULL AND t0.published = ? LIMIT 3
Parameters:
[
  1
]
5 0.24 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM diet_goal t0
Parameters:
[]
6 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM how_know_diet t0
Parameters:
[]
7 0.72 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_ar AS title_ar_2, p0_.short_description AS short_description_3, p0_.short_description_ar AS short_description_ar_4, p0_.description AS description_5, p0_.description_ar AS description_ar_6, p0_.meta_description AS meta_description_7, p0_.meta_description_ar AS meta_description_ar_8, p0_.age_from AS age_from_9, p0_.age_to AS age_to_10, p0_.ideal_gender AS ideal_gender_11, p0_.period_months AS period_months_12, p0_.image AS image_13, p0_.status AS status_14, p0_.daily_target_calories AS daily_target_calories_15, p0_.daily_target_carbs AS daily_target_carbs_16, p0_.daily_target_fat AS daily_target_fat_17, p0_.daily_target_protein AS daily_target_protein_18, p0_.is_featured AS is_featured_19, p0_.published_at AS published_at_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, AVG(r1_.rate) AS sclr_23, COUNT(r1_.id) AS sclr_24, p0_.created_by_id AS created_by_id_25 FROM program p0_ LEFT JOIN rate r1_ ON p0_.id = r1_.program_id LEFT JOIN restaurant_program_prices r2_ ON (r2_.program_id = p0_.id) WHERE r2_.id IS NOT NULL GROUP BY p0_.id ORDER BY sclr_23 DESC, sclr_24 DESC LIMIT 3
Parameters:
[]
8 0.33 ms
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
Parameters:
[]
9 0.25 ms
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
Parameters:
[]
10 0.27 ms
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
Parameters:
[]
11 0.24 ms
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
Parameters:
[]
12 0.28 ms
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
Parameters:
[]
13 0.48 ms
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
Parameters:
[]
14 0.38 ms
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 = ?
Parameters:
[
  "USD"
]
15 0.23 ms
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
Parameters:
[]
16 0.40 ms
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
Parameters:
[]
17 0.29 ms
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
Parameters:
[]
18 0.25 ms
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
Parameters:
[]
19 0.34 ms
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.type = ? LIMIT 1
Parameters:
[
  "about"
]
20 0.24 ms
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.type = ? LIMIT 1
Parameters:
[
  "about"
]
21 0.25 ms
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.type = ? LIMIT 1
Parameters:
[
  "about"
]
22 0.23 ms
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.type = ? LIMIT 1
Parameters:
[
  "about"
]
23 0.22 ms
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.type = ? LIMIT 1
Parameters:
[
  "chooseProgram"
]
24 0.32 ms
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.type = ? LIMIT 1
Parameters:
[
  "chooseProgram"
]
25 0.25 ms
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.type = ? LIMIT 1
Parameters:
[
  "chooseProgram"
]
26 0.29 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.image AS image_4 FROM program_category t0
Parameters:
[]
27 0.31 ms
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.type = ? LIMIT 1
Parameters:
[
  "nutritionTips"
]
28 0.23 ms
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.type = ? LIMIT 1
Parameters:
[
  "nutritionTips"
]
29 0.23 ms
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.type = ? LIMIT 1
Parameters:
[
  "nutritionTips"
]
30 0.44 ms
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.user AS user_3, t0.comment_ar AS comment_ar_4, t0.user_ar AS user_ar_5 FROM testimonial t0
Parameters:
[]
31 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0 WHERE t0.id = ?
Parameters:
[
  5
]
32 0.25 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0 WHERE t0.id = ?
Parameters:
[
  4
]
33 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0 WHERE t0.id = ?
Parameters:
[
  7
]
34 0.29 ms
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
Parameters:
[]
35 0.24 ms
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
Parameters:
[]
36 0.41 ms
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
Parameters:
[]
37 0.31 ms
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
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\Blog No errors.
App\Entity\BlogCategory No errors.
App\Entity\Tag 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\Entity\Role
  • The association App\Entity\Role#users refers to the owning side field App\Entity\User#Role which does not exist.
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\PhysicalActivity No errors.
App\Entity\dietGoal No errors.
App\Entity\CustomRole No errors.
App\Entity\Faq No errors.
App\Entity\Request No errors.
App\Entity\HowKnowDiet No errors.
App\Entity\Rate
  • The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Entity\RestaurantProgramPrice
  • The field 'App\Entity\RestaurantProgramPrice#unitAmountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Setting No errors.
App\Entity\Page No errors.
App\Entity\Currency 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\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\Testimonial No errors.