Query Metrics
17
Database Queries
11
Different statements
3.54 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
1.15 ms (32.53%) |
6 |
SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.id_entity = ?
Parameters:
[
2
]
|
0.47 ms (13.37%) |
2 |
SELECT t0.id AS id_1, t0.type_reference AS type_reference_2, t0.id_element AS id_element_3, t0.language AS language_4, t0.name AS name_5 FROM reference_list t0
Parameters:
[] |
0.26 ms (7.45%) |
1 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.status AS status_2, g0_.max_winners AS max_winners_3, g0_.reward AS reward_4, g0_.begin_date AS begin_date_5, g0_.end_date AS end_date_6, g0_.created_at AS created_at_7, g0_.teams AS teams_8, g0_.created_by AS created_by_9 FROM gamification_config g0_ WHERE g0_.end_date >= ? AND g0_.status = ? ORDER BY g0_.end_date DESC
Parameters:
[ "2024-09-21 00:00:00" 1 ] |
0.24 ms (6.63%) |
1 |
SELECT t0.id AS id_1, t0.data AS data_2, t0.help AS help_3, t0.id_mail_account AS id_mail_account_4, t0.id_user AS id_user_5 FROM customized_filter t0 WHERE t0.id_mail_account IS NULL
Parameters:
[] |
0.22 ms (6.21%) |
1 |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.type AS type_2, h0_.message AS message_3, h0_.page AS page_4, h0_.modal AS modal_5 FROM help_information h0_ WHERE LOWER(REPLACE(h0_.page, 'https://', '')) = ? AND h0_.type = ? LIMIT 1
Parameters:
[ "dev.myoverview.fr/login" 1 ] |
0.22 ms (6.18%) |
1 |
SELECT t0.id AS id_1, t0.app_key AS app_key_2, t0.value AS value_3, t0.id_entity AS id_entity_4 FROM app_data t0 WHERE t0.app_key = ? LIMIT 1
Parameters:
[
"advice_popin"
]
|
0.21 ms (5.81%) |
1 |
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.status AS status_2, g0_.max_winners AS max_winners_3, g0_.reward AS reward_4, g0_.begin_date AS begin_date_5, g0_.end_date AS end_date_6, g0_.created_at AS created_at_7, g0_.teams AS teams_8, g0_.created_by AS created_by_9 FROM gamification_config g0_ WHERE g0_.status = ? ORDER BY g0_.end_date DESC
Parameters:
[
4
]
|
0.20 ms (5.61%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price_month AS price_month_3, t0.standard_price_month AS standard_price_month_4, t0.price_year AS price_year_5, t0.standard_price_year AS standard_price_year_6, t0.nb_days_trial AS nb_days_trial_7 FROM app_module t0 WHERE t0.id = ?
Parameters:
[
2
]
|
0.19 ms (5.45%) |
1 |
SELECT g0_.id AS id_0, g0_.score_total AS score_total_1, g0_.level AS level_2, g0_.is_rewarded AS is_rewarded_3, g0_.created_at AS created_at_4, g0_.id_gamification_config AS id_gamification_config_5, g0_.id_user AS id_user_6 FROM gamification_user_score g0_ WHERE g0_.id_user = ? AND g0_.id_gamification_config = ?
Parameters:
[ null 10 ] |
0.19 ms (5.42%) |
1 |
SELECT r0_.id_element AS id_element_0, r0_.name AS name_1, r1_.id_element AS id_element_2, r0_.language AS language_3, r0_.type_reference AS type_reference_4 FROM reference_list_relation r1_ INNER JOIN reference_list r0_ ON (r0_.id_element = r1_.reference_list_element)
Parameters:
[] |
0.19 ms (5.33%) |
1 |
SELECT a0_.id AS id_0, a0_.app_key AS app_key_1, a0_.value AS value_2, a0_.id_entity AS id_entity_3 FROM app_data a0_ WHERE a0_.app_key = ? AND a0_.id_entity = ?
Parameters:
[ "advice_popin" 2 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
travel | doctrine.dbal.travel_connection |
billing | doctrine.dbal.billing_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
travel | doctrine.orm.travel_entity_manager |
billing | doctrine.orm.billing_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
Class | Mapping errors |
---|---|
MyOverview\MainBundle\Entity\ReferenceList | No errors. |
MyOverview\MainBundle\Entity\ReferenceListRelation | No errors. |
MyOverview\MessengerBundle\Entity\Company | No errors. |
MyOverview\MessengerBundle\Entity\CustomizedFilter | No errors. |
MyOverview\MessengerBundle\Entity\MailAccount | No errors. |
MyOverview\UserBundle\Entity\User | No errors. |
MyOverview\MainBundle\Entity\GamificationConfig | No errors. |
MyOverview\MainBundle\Entity\GamificationUserScore | No errors. |
MyOverview\MessengerBundle\Entity\Message | No errors. |
MyOverview\MainBundle\Entity\AppData | No errors. |
MyOverview\MainBundle\Entity\AppModule | No errors. |
MyOverview\MainBundle\Entity\AppModuleLog | No errors. |
travel entity manager
No loaded entities.
billing entity manager
No loaded entities.