Query Metrics
18
Database Queries
7
Different statements
28.24 ms
Query time
7
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.68 ms |
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:
[
"/"
]
|
2 | 3.79 ms |
SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.status AS status_2, o0_.org_id AS org_id_3, o0_.offer_id AS offer_id_4 FROM offer_org o0_ INNER JOIN offer o1_ ON o0_.offer_id = o1_.id INNER JOIN organization o2_ ON o0_.org_id = o2_.id LEFT JOIN organization o3_ ON o1_.from_org_id = o3_.id LEFT JOIN tag_offer t5_ ON o1_.id = t5_.offer_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id WHERE o1_.validity_date > ? ORDER BY o1_.creation_date DESC LIMIT 10
Parameters:
[
"2024-09-28 05:09:47"
]
|
3 | 7.91 ms |
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_ WHERE o0_.is_enabled = 1 ORDER BY o0_.created_at DESC LIMIT 10
Parameters:
[] |
4 | 3.01 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
5 | 0.75 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
6 | 0.90 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (parent_id = ?) AND (rg.status = ?) ORDER BY rgd.priority DESC
Parameters:
[ 1 1 ] |
7 | 0.47 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
8 | 2.40 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "request_uri" 1 "/?phpinfo=1" ] |
9 | 0.61 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
10 | 0.76 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "request_uri_prefix" 1 "/?phpinfo=1" ] |
11 | 0.83 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
12 | 1.71 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "path_info" 1 "/" ] |
13 | 0.47 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
14 | 0.60 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "path_info_prefix" 1 "/" ] |
15 | 0.33 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
16 | 0.60 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND (rt.value = ?) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "route" 1 "public_home" ] |
17 | 0.39 ms |
SELECT DISTINCT rg.*, rgd.* FROM nglayouts_rule_group rg INNER JOIN nglayouts_rule_group_data rgd ON rgd.rule_group_id = rg.id WHERE (rg.uuid = ?) AND (rg.status = ?)
Parameters:
[ "00000000-0000-0000-0000-000000000000" 1 ] |
18 | 1.03 ms |
SELECT DISTINCT r.*, rd.*, l.uuid AS layout_uuid FROM nglayouts_rule r INNER JOIN nglayouts_rule_data rd ON rd.rule_id = r.id LEFT JOIN nglayouts_layout l ON (r.layout_uuid = l.uuid) AND (l.status = 1) INNER JOIN nglayouts_rule_target rt ON (r.id = rt.rule_id) AND (r.status = rt.status) WHERE (r.rule_group_id = ?) AND (rd.enabled = ?) AND (rt.type = ?) AND (r.status = ?) AND ((CHAR_LENGTH(TRIM(rt.value)) > 0) AND (? LIKE CONCAT(TRIM(rt.value), '%'))) ORDER BY rd.priority DESC
Parameters:
[ 1 1 "route_prefix" 1 "public_home" ] |
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\OfferOrg | No errors. |
App\Entity\Offer |
|
App\Entity\Organization | No errors. |
App\Entity\Tag | No errors. |
App\Entity\Sector |
|
App\Entity\City |
|
App\Entity\Subscription |
|
App\Entity\UserOrganization | No errors. |
App\Entity\Payment | No errors. |
App\Entity\Model | No errors. |
App\Entity\User |
|
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. |