GET https://www.badnii.com/index.php/en/programs/123

Response
200 OK
IP
216.73.216.103
Profiled on
Token
5041de

Query Metrics

18 Database Queries
7 Different statements
6.45 ms Query time
10 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.62 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.50 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: 
[
  "123"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.58 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: 
[
  123
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.98 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: 
[
  123
]
View formatted query    View runnable query    Explain query    View query backtrace
5 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
6 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
7 0.23 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.18 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.21 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.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
11 0.19 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.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
13 0.17 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.17 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.75 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
16 0.18 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
17 0.33 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
18 0.23 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.