Query Metrics
6
Database Queries
6
Different statements
7.26 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.08 ms (42.44%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1 ORDER BY o0_.id DESC) dctrn_result) dctrn_table
Parameters:
[] |
1.60 ms (22.00%) |
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15 OFFSET 105
Parameters:
[] |
1.11 ms (15.25%) |
1 |
SELECT o0_.id AS id_0, o0_.logo AS logo_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.refrer_code AS refrer_code_4, o0_.facebook_link AS facebook_link_5, o0_.youtube_link AS youtube_link_6, o0_.instagram_link AS instagram_link_7, o0_.linkedin_link AS linkedin_link_8, o0_.visits_count AS visits_count_9, o0_.latitude AS latitude_10, o0_.longitude AS longitude_11, o0_.subscription_status AS subscription_status_12, o0_.email AS email_13, o0_.gain AS gain_14, o0_.total_members AS total_members_15, o0_.monetizing_enabled AS monetizing_enabled_16, o0_.auto_link_clients_enabled AS auto_link_clients_enabled_17, o0_.description AS description_18, o0_.password AS password_19, o0_.subscribers_count AS subscribers_count_20, o0_.type AS type_21, o0_.address AS address_22, o0_.phone AS phone_23, o0_.whatsapp_phone AS whatsapp_phone_24, o0_.is_enabled AS is_enabled_25, o0_.can_create_coupon AS can_create_coupon_26, o0_.can_receive_partnership_request AS can_receive_partnership_request_27, o0_.website_link AS website_link_28, o0_.can_receive_agreements AS can_receive_agreements_29, o0_.can_send_agreements AS can_send_agreements_30, o0_.slug AS slug_31, o0_.devis_enabled AS devis_enabled_32, o0_.is_managed_in_house AS is_managed_in_house_33, o0_.is_slug_manuel AS is_slug_manuel_34, o0_.use_calendar AS use_calendar_35, o0_.params AS params_36, o0_.sector_id AS sector_id_37, o0_.city_id AS city_id_38, o0_.subscription_id AS subscription_id_39 FROM organization o0_ LEFT JOIN city c1_ ON o0_.city_id = c1_.id LEFT JOIN sector s2_ ON o0_.sector_id = s2_.id WHERE o0_.is_enabled = 1 AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.id DESC
Parameters:
[ 125 124 121 120 119 118 115 113 110 108 107 106 105 104 103 ] |
0.72 ms (9.92%) |
1 |
SELECT t0.id AS id_1, t0.source_route AS source_route_2, t0.target_route AS target_route_3, t0.creation_date AS creation_date_4 FROM redirections t0 WHERE t0.source_route = ? LIMIT 1
Parameters:
[
"/nos-partenaires"
]
|
0.39 ms (5.33%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM sector t0
Parameters:
[] |
0.37 ms (5.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM city t0
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\Redirection | No errors. |
App\Entity\Organization | No errors. |
App\Entity\City |
|
App\Entity\Sector |
|
App\Entity\User |
|
App\Entity\Offer |
|
App\Entity\Subscription |
|
App\Entity\UserOrganization | No errors. |
App\Entity\Payment | No errors. |
App\Entity\Model | No errors. |
App\Entity\Notification | No errors. |
App\Entity\Blocking | No errors. |
App\Entity\Post | No errors. |
App\Entity\Devis |
|
App\Entity\Media |
|
App\Entity\ConParticipant | No errors. |
App\Entity\AgOption | No errors. |
App\Entity\AgEvent | No errors. |
App\Entity\MClient | No errors. |