Query Metrics
9
Database Queries
9
Different statements
11.37 ms
Query time
8
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
4.52 ms (39.75%) |
1 |
"COMMIT"
Parameters:
[] |
2.61 ms (22.97%) |
1 |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.refrer_code AS refrer_code_5, t0.facebook_link AS facebook_link_6, t0.youtube_link AS youtube_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.visits_count AS visits_count_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.subscription_status AS subscription_status_13, t0.email AS email_14, t0.gain AS gain_15, t0.total_members AS total_members_16, t0.monetizing_enabled AS monetizing_enabled_17, t0.auto_link_clients_enabled AS auto_link_clients_enabled_18, t0.description AS description_19, t0.password AS password_20, t0.subscribers_count AS subscribers_count_21, t0.type AS type_22, t0.address AS address_23, t0.phone AS phone_24, t0.whatsapp_phone AS whatsapp_phone_25, t0.is_enabled AS is_enabled_26, t0.can_create_coupon AS can_create_coupon_27, t0.can_receive_partnership_request AS can_receive_partnership_request_28, t0.website_link AS website_link_29, t0.can_receive_agreements AS can_receive_agreements_30, t0.can_send_agreements AS can_send_agreements_31, t0.slug AS slug_32, t0.devis_enabled AS devis_enabled_33, t0.is_managed_in_house AS is_managed_in_house_34, t0.is_slug_manuel AS is_slug_manuel_35, t0.use_calendar AS use_calendar_36, t0.params AS params_37, t0.sector_id AS sector_id_38, t0.city_id AS city_id_39, t0.subscription_id AS subscription_id_40 FROM organization t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"interbuildingandmanufacturing"
]
|
0.97 ms (8.50%) |
1 |
UPDATE organization SET visits_count = ? WHERE id = ?
Parameters:
[ 151 180 ] |
0.93 ms (8.19%) |
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:
[
"/org/interbuildingandmanufacturing"
]
|
0.64 ms (5.62%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM sector t0 WHERE t0.id = ?
Parameters:
[
9
]
|
0.63 ms (5.51%) |
1 |
SELECT t0.id AS id_1, t0.picture AS picture_2, t0.title AS title_3, t0.creation_date AS creation_date_4, t0.status AS status_5, t0.description AS description_6, t0.price AS price_7, t0.promo_price AS promo_price_8, t0.video_url AS video_url_9, t0.youtube_id AS youtube_id_10, t0.is_video AS is_video_11, t0.org_id AS org_id_12 FROM post t0 WHERE t0.org_id = ?
Parameters:
[
180
]
|
0.40 ms (3.53%) |
1 |
SELECT t0.id AS id_1, t0.path AS path_2, t0.creation_date AS creation_date_3, t0.name AS name_4, t0.devis_message_id AS devis_message_id_5, t0.org_id AS org_id_6 FROM media t0 WHERE t0.org_id = ?
Parameters:
[
180
]
|
0.37 ms (3.22%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.31 ms (2.71%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\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. |
App\Entity\Offer |
|
App\Entity\DevisMessage |
|