GET https://pms-uat.birlaopenminds.com/draft-school/429/edit

Response
200 OK
Browse referrer URL
IP
34.120.117.174
Profiled on
Token
a60796

Query Metrics

13 Database Queries
13 Different statements
22.96 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
2.47 ms
(10.74%) 		1 
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.category AS category_3, t0.school_name AS school_name_4, t0.partner_name AS partner_name_5, t0.trust_name AS trust_name_6, t0.address AS address_7, t0.location AS location_8, t0.state AS state_9, t0.pin_code AS pin_code_10, t0.phone AS phone_11, t0.radius AS radius_12, t0.operational_year AS operational_year_13, t0.royalty_rate AS royalty_rate_14, t0.royalty_increment_percent AS royalty_increment_percent_15, t0.royalty_increment_type AS royalty_increment_type_16, t0.balance_amount AS balance_amount_17, t0.agreement_date AS agreement_date_18, t0.agreement_tenure AS agreement_tenure_19, t0.agreement_expiry_date AS agreement_expiry_date_20, t0.consultancy_fee_method AS consultancy_fee_method_21, t0.active AS active_22, t0.principal_email AS principal_email_23, t0.partner_email AS partner_email_24, t0.principal_mobile AS principal_mobile_25, t0.partner_mobile AS partner_mobile_26, t0.billing_name AS billing_name_27, t0.billing_address AS billing_address_28, t0.billing_city AS billing_city_29, t0.billing_state AS billing_state_30, t0.school_code AS school_code_31, t0.board AS board_32, t0.capacity_built_up AS capacity_built_up_33, t0.capacity_operational AS capacity_operational_34, t0.occupancy AS occupancy_35, t0.session AS session_36, t0.school_status AS school_status_37, t0.frm_assigned_at AS frm_assigned_at_38, t0.partner_welcome_email_sent_at AS partner_welcome_email_sent_at_39, t0.publish_approval_status AS publish_approval_status_40, t0.created_at AS created_at_41, t0.updated_at AS updated_at_42, t0.brand_id AS brand_id_43, t0.zone_id AS zone_id_44, t0.status_id AS status_id_45, t0.countersigned_id AS countersigned_id_46, t0.assignee_id AS assignee_id_47, t48.id AS id_49, t48.project_status AS project_status_50, t48.infrastructure_type AS infrastructure_type_51, t48.land_type AS land_type_52, t48.project_start_date AS project_start_date_53, t48.estimated_launch_date AS estimated_launch_date_54, t48.actual_launch_date AS actual_launch_date_55, t48.operational_year AS operational_year_56, t48.project_progress AS project_progress_57, t48.last_notification_sent_at AS last_notification_sent_at_58, t48.is_proactive_sent AS is_proactive_sent_59, t48.plan_due_by AS plan_due_by_60, t48.is_sla_warning_sent AS is_sla_warning_sent_61, t48.delay_notification_count AS delay_notification_count_62, t48.delay_days AS delay_days_63, t48.uuid AS uuid_64, t48.school_id AS school_id_65, t0.lead_id AS lead_id_66, t0.created_by AS created_by_67, t0.updated_by AS updated_by_68 FROM school t0 LEFT JOIN rampup_project t48 ON t48.school_id = t0.id WHERE t0.id = ?
Parameters: 
[
  "429"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.09 ms
(9.11%) 		1 
SELECT u0_.id AS id_0, u0_.employee_code AS employee_code_1, u0_.employee_name AS employee_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.mobile AS mobile_8, u0_.avatar AS avatar_9, u0_.token AS token_10, u0_.token_date AS token_date_11, u0_.last_login AS last_login_12, u0_.email_verified AS email_verified_13, u0_.mobile_verified AS mobile_verified_14, u0_.enabled AS enabled_15, u0_.date_of_birth AS date_of_birth_16, u0_.gender AS gender_17, u0_.display_name AS display_name_18, u0_.type AS type_19, u0_.phone AS phone_20, u0_.created_at AS created_at_21, u0_.updated_at AS updated_at_22, u0_.office_location_id AS office_location_id_23, u0_.zone_id AS zone_id_24, u0_.department_id AS department_id_25 FROM user u0_ INNER JOIN department d1_ ON u0_.department_id = d1_.id WHERE (u0_.roles LIKE ? OR u0_.roles LIKE ? OR u0_.roles LIKE ?) AND d1_.name = ? ORDER BY CONCAT(u0_.first_name, CONCAT(' ', u0_.last_name)) ASC
Parameters: 
[
  "%"ROLE_ADMIN"%"
  "%"ROLE_MANAGER"%"
  "%"ROLE_USER"%"
  "Franchise Relations"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.97 ms
(8.56%) 		1 
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.google_analytics_id AS google_analytics_id_18, t0.google_tag_manager_code AS google_tag_manager_code_19, t0.google_site_verification_code AS google_site_verification_code_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.meta_keywords AS meta_keywords_23 FROM setting t0 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.91 ms
(8.31%) 		1 
SELECT z0_.id AS id_0, z0_.name AS name_1, z0_.shortform AS shortform_2 FROM zone z0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.79 ms
(7.80%) 		1 
SELECT s0_.id AS id_0, s0_.name AS name_1 FROM status s0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.72 ms
(7.48%) 		1 
SELECT t0.id AS id_1, t0.project_status AS project_status_2, t0.infrastructure_type AS infrastructure_type_3, t0.land_type AS land_type_4, t0.project_start_date AS project_start_date_5, t0.estimated_launch_date AS estimated_launch_date_6, t0.actual_launch_date AS actual_launch_date_7, t0.operational_year AS operational_year_8, t0.project_progress AS project_progress_9, t0.last_notification_sent_at AS last_notification_sent_at_10, t0.is_proactive_sent AS is_proactive_sent_11, t0.plan_due_by AS plan_due_by_12, t0.is_sla_warning_sent AS is_sla_warning_sent_13, t0.delay_notification_count AS delay_notification_count_14, t0.delay_days AS delay_days_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17 FROM rampup_project t0 WHERE t0.school_id = ? LIMIT 1
Parameters: 
[
  429
]
View formatted query    View runnable query    Explain query    View query backtrace
1.69 ms
(7.37%) 		1 
SELECT b0_.id AS id_0, b0_.brand_name AS brand_name_1, b0_.brand_code AS brand_code_2 FROM brand b0_
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.69 ms
(7.37%) 		1 
SELECT t0.id AS id_1, t0.employee_code AS employee_code_2, t0.employee_name AS employee_name_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.mobile AS mobile_9, t0.avatar AS avatar_10, t0.token AS token_11, t0.token_date AS token_date_12, t0.last_login AS last_login_13, t0.email_verified AS email_verified_14, t0.mobile_verified AS mobile_verified_15, t0.enabled AS enabled_16, t0.date_of_birth AS date_of_birth_17, t0.gender AS gender_18, t0.display_name AS display_name_19, t0.type AS type_20, t0.phone AS phone_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.office_location_id AS office_location_id_24, t0.zone_id AS zone_id_25, t0.department_id AS department_id_26 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.67 ms
(7.28%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM royalty_increment_type t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.61 ms
(7.02%) 		1 
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_code AS brand_code_3 FROM brand t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
1.60 ms
(6.98%) 		1 
SELECT t0.user_id AS user_id_1, t0.module_id AS module_id_2, t0.permission_id AS permission_id_3 FROM user_permission t0 WHERE t0.user_id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query    View query backtrace
1.52 ms
(6.63%) 		1 
SELECT COUNT(a0_.id) AS sclr_0 FROM approval_request a0_ WHERE a0_.status = ?
Parameters: 
[
  "Sent for Approval"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.23 ms
(5.35%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.official_email AS official_email_4 FROM department t0 WHERE t0.id = ?
Parameters: 
[
  13
]
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\User No errors.
App\Entity\OfficeLocation No errors.
App\Entity\EmployeeZone No errors.
App\Entity\Department No errors.
App\Entity\UserReportingManager No errors.
App\Entity\UserPermission No errors.
App\Entity\Module No errors.
App\Entity\Permission No errors.
App\Entity\School No errors.
App\Entity\Brand No errors.
App\Entity\Zone No errors.
App\Entity\Status No errors.
App\Entity\RampupProject No errors.
App\Entity\Lead No errors.
App\Entity\Grade No errors.
App\Entity\RoyaltyIncrementType No errors.
App\Entity\Tasklist No errors.
App\Entity\Setting No errors.
App\Entity\ApprovalRequest No errors.