GET https://dev.badnii.com/robots.txt/programs/57

Response
200 OK
IP
216.73.216.87
Profiled on
Token
86f4dd

Query Metrics

33 Database Queries
17 Different statements
10.02 ms Query time
20 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.09 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: 
[
  "OMR"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.41 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.short_description AS short_description_4, t0.short_description_ar AS short_description_ar_5, t0.description AS description_6, t0.description_ar AS description_ar_7, t0.meta_description AS meta_description_8, t0.meta_description_ar AS meta_description_ar_9, t0.age_from AS age_from_10, t0.age_to AS age_to_11, t0.ideal_gender AS ideal_gender_12, t0.period_months AS period_months_13, t0.image AS image_14, t0.status AS status_15, t0.daily_target_calories AS daily_target_calories_16, t0.daily_target_carbs AS daily_target_carbs_17, t0.daily_target_fat AS daily_target_fat_18, t0.daily_target_protein AS daily_target_protein_19, t0.is_featured AS is_featured_20, t0.published_at AS published_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24 FROM program t0 WHERE t0.id = ?
Parameters: 
[
  "57"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.39 ms 
SELECT t0.id AS id_1, t0.interval_name AS interval_name_2, t0.unit_amount_minor AS unit_amount_minor_3, t0.program_id AS program_id_4, t0.price_list_id AS price_list_id_5 FROM program_prices t0 WHERE t0.program_id IN (?)
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.27 ms 
SELECT t0.id AS id_1, t0.slot_number AS slot_number_2, t0.notes AS notes_3, t0.average_calories AS average_calories_4, t0.average_protein AS average_protein_5, t0.average_carbs AS average_carbs_6, t0.average_fat AS average_fat_7, t0.program_id AS program_id_8, t0.meal_category_id AS meal_category_id_9 FROM program_daily_meals t0 WHERE t0.program_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.37 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.22 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
8 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.37 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.35 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.22 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.19 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.15 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
15 0.23 ms 
SELECT t0.id AS id_1, t0.interval AS interval_2, t0.unit_amount_minor AS unit_amount_minor_3, t0.restaurant_id AS restaurant_id_4, t0.program_id AS program_id_5, t0.price_list_id AS price_list_id_6 FROM restaurant_program_prices t0 WHERE t0.program_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.47 ms 
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.program_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.25 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.program_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
18 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 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "OMR"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 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 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "OMR"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.21 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 = ? LIMIT 1
Parameters: 
[
  "OMR"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.16 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 = ? LIMIT 1
Parameters: 
[
  "OMR"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.23 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 INNER JOIN program_program_category ON t0.id = program_program_category.program_category_id WHERE program_program_category.program_id = ?
Parameters: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.31 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.gender AS gender_11, t0.preferred_unit AS preferred_unit_12, t0.current_weight AS current_weight_13, t0.target_weight AS target_weight_14, t0.height AS height_15, t0.password AS password_16, t0.last_seen AS last_seen_17, t0.country AS country_18, t0.city AS city_19, t0.date_of_birth AS date_of_birth_20, t0.avatar AS avatar_21, t0.description AS description_22, t0.description_ar AS description_ar_23, t0.is_approved AS is_approved_24, t0.is_available_for_request AS is_available_for_request_25, t0.accepted_terms AS accepted_terms_26, t0.reset_token AS reset_token_27, t0.facebook_id AS facebook_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.role_id AS role_id_31, t0.physical_activity_id AS physical_activity_id_32, t0.diet_goal_id AS diet_goal_id_33, t0.custom_role_id AS custom_role_id_34 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.48 ms 
SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (?)
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.28 ms 
SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (?)
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.31 ms 
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.short_description AS short_description_4, t0.short_description_ar AS short_description_ar_5, t0.description AS description_6, t0.description_ar AS description_ar_7, t0.meta_description AS meta_description_8, t0.meta_description_ar AS meta_description_ar_9, t0.age_from AS age_from_10, t0.age_to AS age_to_11, t0.ideal_gender AS ideal_gender_12, t0.period_months AS period_months_13, t0.image AS image_14, t0.status AS status_15, t0.daily_target_calories AS daily_target_calories_16, t0.daily_target_carbs AS daily_target_carbs_17, t0.daily_target_fat AS daily_target_fat_18, t0.daily_target_protein AS daily_target_protein_19, t0.is_featured AS is_featured_20, t0.published_at AS published_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24 FROM program t0 WHERE t0.created_by_id = ?
Parameters: 
[
  108
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.28 ms 
SELECT t0.id AS id_1, t0.interval_name AS interval_name_2, t0.unit_amount_minor AS unit_amount_minor_3, t0.program_id AS program_id_4, t0.price_list_id AS price_list_id_5 FROM program_prices t0 WHERE t0.program_id IN (?, ?)
Parameters: 
[
  54
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.20 ms 
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.program_id = ?
Parameters: 
[
  54
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.18 ms 
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.program_id = ?
Parameters: 
[
  55
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.30 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.22 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
32 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.for_role IS NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
33 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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\Currency 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\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\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\ProgramPrice
  • The field 'App\Entity\ProgramPrice#unitAmountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Request No 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\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\Faq No errors.
App\Entity\ProgramDiet
  • The association App\Entity\ProgramDiet#programs refers to the owning side field App\Entity\Program#programDiet which does not exist.
  • The mappings App\Entity\ProgramDiet#programsMany and App\Entity\Program#programDiets are inconsistent with each other.
App\Entity\Disease No errors.
App\Entity\ProgramDailyMeal
  • The field 'App\Entity\ProgramDailyMeal#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Rate
  • The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Entity\ProgramField No errors.
App\Entity\PriceList No errors.
App\Entity\MealCategory
  • The association App\Entity\MealCategory#requests refers to the owning side field App\Entity\Request#mealCategories which does not exist.
App\Entity\Setting No errors.
App\Entity\Page No errors.
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\Role
  • The association App\Entity\Role#users refers to the owning side field App\Entity\User#Role which does not exist.
App\Entity\PhysicalActivity No errors.
App\Entity\dietGoal No errors.
App\Entity\CustomRole No errors.
App\Entity\MasterMenuItem No errors.
App\Entity\ProductCategory No errors.
App\Embeddable\AddressSnapshot No errors.
App\Entity\Order
  • The field 'App\Entity\Order#subtotalProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#subtotalProgramRestaurantMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#adminFeeExclusiveMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#discountProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#deliveryFeeProgramRestMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Order#grandTotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Subscription
  • The association App\Entity\Subscription#program refers to the inverse side field App\Entity\Program#subscriptions which does not exist.
App\Entity\MealMaker
  • The association App\Entity\MealMaker#program refers to the inverse side field App\Entity\Program#mealMakers which does not exist.
App\Entity\MealMakerDay
  • The association App\Entity\MealMakerDay#program refers to the inverse side field App\Entity\Program#mealMakerDays which does not exist.
App\Entity\Message
  • The mappings App\Entity\Message#sentBy and App\Entity\User#messages are inconsistent with each other.
App\Entity\ProfileSetting No errors.
App\Entity\RateFood No errors.
App\Entity\Cart
  • The field 'App\Entity\Cart#productsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#subscriptionsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#discountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#deliveryFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
  • The field 'App\Entity\Cart#totalMinor' 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\CollectionList No errors.
App\Entity\RecuringFood No errors.
App\Entity\Chat No errors.
App\Entity\Adresse No errors.
App\Entity\Coupon
  • The field 'App\Entity\Coupon#discountValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Coupon#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#coupon does not contain the required 'inversedBy="carts"' attribute.
  • The association App\Entity\Coupon#orders refers to the owning side field App\Entity\Order#coupon which does not exist.
App\Entity\Notification No errors.
App\Entity\UserDocument No errors.
App\Entity\Testimonial No errors.
App\Entity\IndividualTransactions
  • The association App\Entity\IndividualTransactions#currency refers to the inverse side field App\Entity\Currency#individualTransactions which does not exist.