GET https://innovineschoolshop.com/control/report/weekly-orders

Query Metrics

2 Database Queries
2 Different statements
1.00 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.57 ms
(57.11%)
1
SELECT DATE_FORMAT(DATE_ADD(s.`created_at`, INTERVAL(1-DAYOFWEEK(s.`created_at`))DAY), '%Y-%m-%d')AS M, COUNT(*)AS X 
                FROM `order` s
                WHERE s.`status` IN (1,2,3) AND DATE(s.`created_at`) BETWEEN '2025-03-11' AND '2026-03-11'
                GROUP BY WEEK(s.`created_at`, 1)
                ORDER BY s.`created_at`
Parameters:
[]
0.43 ms
(42.89%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
Parameters:
[
  233
]

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\School No errors.
App\Entity\Address No errors.