Query Metrics
177
Database Queries
8
Different statements
70.04 ms
Query time
0
Invalid entities
401
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
52.67 ms (75.20%) |
164 |
SELECT t0.id AS id_1, t0.provider AS provider_2, t0.email AS email_3, t0.access_token AS access_token_4, t0.refresh_token AS refresh_token_5, t0.token_expires_at AS token_expires_at_6, t0.company_id AS company_id_7 FROM email_credential t0 WHERE t0.company_id = ?
Parameters:
[
284
]
|
||||||||||||||||||||||||||||||
|
4.51 ms (6.44%) |
1 |
SELECT t0.id AS id_1, t0.siret AS siret_2, t0.name AS name_3, t0.trade_name AS trade_name_4, t0.iban AS iban_5, t0.tva_number AS tva_number_6, t0.created_at AS created_at_7, t0.email AS email_8, t0.logo AS logo_9, t0.phone AS phone_10, t0.bic AS bic_11, t0.price AS price_12, t0.price_no_decla AS price_no_decla_13, t0.stripe_id AS stripe_id_14, t0.jeton AS jeton_15, t0.is_supplier AS is_supplier_16, t0.is_prospect AS is_prospect_17, t0.is_active AS is_active_18, t0.comment AS comment_19, t0.invoice_number_prefix AS invoice_number_prefix_20, t0.invoice_number_start_counter AS invoice_number_start_counter_21, t0.invoice_number_reset_counter AS invoice_number_reset_counter_22, t0.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_23, t0.quotation_number_prefix AS quotation_number_prefix_24, t0.quotation_number_start_counter AS quotation_number_start_counter_25, t0.quotation_number_reset_counter AS quotation_number_reset_counter_26, t0.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_27, t0.is_no_same_number AS is_no_same_number_28, t0.credit_number_prefix AS credit_number_prefix_29, t0.lat AS lat_30, t0.lng AS lng_31, t0.identite_recto AS identite_recto_32, t0.identite_verso AS identite_verso_33, t0.kbis AS kbis_34, t0.rib AS rib_35, t0.unsubmit_tva AS unsubmit_tva_36, t0.supplier_hello_glass AS supplier_hello_glass_37, t0.ape AS ape_38, t0.difficulty AS difficulty_39, t0.stripe_tax_rate_id AS stripe_tax_rate_id_40, t0.tax_rate AS tax_rate_41, t0.clearbus AS clearbus_42, t0.morning_start AS morning_start_43, t0.morning_end AS morning_end_44, t0.afternoon_start AS afternoon_start_45, t0.afternoon_end AS afternoon_end_46, t0.morning_saturday_start AS morning_saturday_start_47, t0.morning_saturday_end AS morning_saturday_end_48, t0.afternoon_saturday_start AS afternoon_saturday_start_49, t0.afternoon_saturday_end AS afternoon_saturday_end_50, t0.prime AS prime_51, t0.verso_invoice AS verso_invoice_52, t0.charge_folder AS charge_folder_53, t0.comment_update AS comment_update_54, t0.known_name AS known_name_55, t0.gifts AS gifts_56, t0.customer_authorisation AS customer_authorisation_57, t0.garage_type AS garage_type_58, t0.contractual_franchise AS contractual_franchise_59, t0.other_authorisation AS other_authorisation_60, t0.other_gifts AS other_gifts_61, t0.blocked AS blocked_62, t0.id_garage AS id_garage_63, t0.email_api AS email_api_64, t0.paid_date_day AS paid_date_day_65, t0.payment_method AS payment_method_66, t0.acquisition_source AS acquisition_source_67, t0.acquisition_source_detail AS acquisition_source_detail_68, t0.is_premium AS is_premium_69, t0.legal_form AS legal_form_70, t0.tax_regime AS tax_regime_71, t0.share_capital AS share_capital_72, t0.rcs AS rcs_73, t0.terms_and_conditions_file AS terms_and_conditions_file_74, t0.apply_terms_for_invoice AS apply_terms_for_invoice_75, t0.apply_terms_for_quote AS apply_terms_for_quote_76, t0.apply_terms_for_repair_order AS apply_terms_for_repair_order_77, t0.hubspot_id AS hubspot_id_78, t0.supplier_id AS supplier_id_79, t0.commercial_id AS commercial_id_80, t0.category_id AS category_id_81, t0.configuration_id AS configuration_id_82, t0.bridge_user_id AS bridge_user_id_83, t0.franchise_id AS franchise_id_84, t0.franchise_supplier_id AS franchise_supplier_id_85, t86.id AS id_87, t86.provider AS provider_88, t86.email AS email_89, t86.access_token AS access_token_90, t86.refresh_token AS refresh_token_91, t86.token_expires_at AS token_expires_at_92, t86.company_id AS company_id_93 FROM companie t0 LEFT JOIN email_credential t86 ON t86.company_id = t0.id WHERE t0.id = ?
Parameters:
[
864
]
|
||||||||||||||||||||||||||||||
|
3.95 ms (5.64%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.firstname AS firstname_6, t0.name AS name_7, t0.is_active AS is_active_8, t0.partenaire AS partenaire_9, t0.last_login AS last_login_10, t0.is_ready AS is_ready_11, t0.referent AS referent_12, t0.difficulty AS difficulty_13, t0.is_premium AS is_premium_14, t0.is_gold AS is_gold_15, t0.tokens_invalidated_at AS tokens_invalidated_at_16, t0.hubspot_id AS hubspot_id_17, t0.service_id AS service_id_18, t0.notif_configuration_id AS notif_configuration_id_19, t0.mail_configuration_id AS mail_configuration_id_20 FROM admin t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"poseuradmin@reseauglass.fr"
]
|
||||||||||||||||||||||||||||||
|
2.79 ms (3.98%) |
2 |
SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.roles AS roles_2, a0_.password AS password_3, a0_.is_verified AS is_verified_4, a0_.firstname AS firstname_5, a0_.name AS name_6, a0_.is_active AS is_active_7, a0_.partenaire AS partenaire_8, a0_.last_login AS last_login_9, a0_.is_ready AS is_ready_10, a0_.referent AS referent_11, a0_.difficulty AS difficulty_12, a0_.is_premium AS is_premium_13, a0_.is_gold AS is_gold_14, a0_.tokens_invalidated_at AS tokens_invalidated_at_15, a0_.hubspot_id AS hubspot_id_16, a0_.service_id AS service_id_17, a0_.notif_configuration_id AS notif_configuration_id_18, a0_.mail_configuration_id AS mail_configuration_id_19 FROM admin a0_ INNER JOIN user_company u1_ ON a0_.id = u1_.user_id WHERE (u1_.roles @> ? = true OR u1_.roles @> ? = true) AND u1_.company_id = ?
Parameters:
[ "["ROLE_SERVICE_CLIENT"]" "["ROLE_SERVICE_CLIENT_LIMIT"]" 864 ]
|
||||||||||||||||||||||||||||||
|
2.06 ms (2.95%) |
1 |
SELECT c0_.id AS id_0, c0_.siret AS siret_1, c0_.name AS name_2, c0_.trade_name AS trade_name_3, c0_.iban AS iban_4, c0_.tva_number AS tva_number_5, c0_.created_at AS created_at_6, c0_.email AS email_7, c0_.logo AS logo_8, c0_.phone AS phone_9, c0_.bic AS bic_10, c0_.price AS price_11, c0_.price_no_decla AS price_no_decla_12, c0_.stripe_id AS stripe_id_13, c0_.jeton AS jeton_14, c0_.is_supplier AS is_supplier_15, c0_.is_prospect AS is_prospect_16, c0_.is_active AS is_active_17, c0_.comment AS comment_18, c0_.invoice_number_prefix AS invoice_number_prefix_19, c0_.invoice_number_start_counter AS invoice_number_start_counter_20, c0_.invoice_number_reset_counter AS invoice_number_reset_counter_21, c0_.number_of_digits_for_invoice_number AS number_of_digits_for_invoice_number_22, c0_.quotation_number_prefix AS quotation_number_prefix_23, c0_.quotation_number_start_counter AS quotation_number_start_counter_24, c0_.quotation_number_reset_counter AS quotation_number_reset_counter_25, c0_.number_of_digits_for_quotation_number AS number_of_digits_for_quotation_number_26, c0_.is_no_same_number AS is_no_same_number_27, c0_.credit_number_prefix AS credit_number_prefix_28, c0_.lat AS lat_29, c0_.lng AS lng_30, c0_.identite_recto AS identite_recto_31, c0_.identite_verso AS identite_verso_32, c0_.kbis AS kbis_33, c0_.rib AS rib_34, c0_.unsubmit_tva AS unsubmit_tva_35, c0_.supplier_hello_glass AS supplier_hello_glass_36, c0_.ape AS ape_37, c0_.difficulty AS difficulty_38, c0_.stripe_tax_rate_id AS stripe_tax_rate_id_39, c0_.tax_rate AS tax_rate_40, c0_.clearbus AS clearbus_41, c0_.morning_start AS morning_start_42, c0_.morning_end AS morning_end_43, c0_.afternoon_start AS afternoon_start_44, c0_.afternoon_end AS afternoon_end_45, c0_.morning_saturday_start AS morning_saturday_start_46, c0_.morning_saturday_end AS morning_saturday_end_47, c0_.afternoon_saturday_start AS afternoon_saturday_start_48, c0_.afternoon_saturday_end AS afternoon_saturday_end_49, c0_.prime AS prime_50, c0_.verso_invoice AS verso_invoice_51, c0_.charge_folder AS charge_folder_52, c0_.comment_update AS comment_update_53, c0_.known_name AS known_name_54, c0_.gifts AS gifts_55, c0_.customer_authorisation AS customer_authorisation_56, c0_.garage_type AS garage_type_57, c0_.contractual_franchise AS contractual_franchise_58, c0_.other_authorisation AS other_authorisation_59, c0_.other_gifts AS other_gifts_60, c0_.blocked AS blocked_61, c0_.id_garage AS id_garage_62, c0_.email_api AS email_api_63, c0_.paid_date_day AS paid_date_day_64, c0_.payment_method AS payment_method_65, c0_.acquisition_source AS acquisition_source_66, c0_.acquisition_source_detail AS acquisition_source_detail_67, c0_.is_premium AS is_premium_68, c0_.legal_form AS legal_form_69, c0_.tax_regime AS tax_regime_70, c0_.share_capital AS share_capital_71, c0_.rcs AS rcs_72, c0_.terms_and_conditions_file AS terms_and_conditions_file_73, c0_.apply_terms_for_invoice AS apply_terms_for_invoice_74, c0_.apply_terms_for_quote AS apply_terms_for_quote_75, c0_.apply_terms_for_repair_order AS apply_terms_for_repair_order_76, c0_.hubspot_id AS hubspot_id_77, c0_.supplier_id AS supplier_id_78, c0_.commercial_id AS commercial_id_79, c0_.category_id AS category_id_80, c0_.configuration_id AS configuration_id_81, c0_.bridge_user_id AS bridge_user_id_82, c0_.franchise_id AS franchise_id_83, c0_.franchise_supplier_id AS franchise_supplier_id_84 FROM companie c0_ INNER JOIN category c1_ ON c0_.category_id = c1_.id WHERE c1_.name = ? AND c0_.supplier_id IS NULL
Parameters:
[
"Assurance"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (2.88%) |
6 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.referent AS referent_3, t0.hubspot_id AS hubspot_id_4, t0.company_id AS company_id_5, t0.user_id AS user_id_6, t0.known_id AS known_id_7 FROM user_company t0 WHERE t0.user_id = ?
Parameters:
[
659
]
|
||||||||||||||||||||||||||||||
|
1.09 ms (1.56%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.name AS name_3, t0.color AS color_4, t0.email AS email_5, t0.phone AS phone_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.is_active AS is_active_9, t0.info AS info_10, t0.department AS department_11, t0.companie_id AS companie_id_12, t0.technician_id AS technician_id_13, t0.address_id AS address_id_14 FROM technician t0 WHERE t0.companie_id = ?
Parameters:
[
864
]
|
||||||||||||||||||||||||||||||
|
0.94 ms (1.35%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.companie_id AS companie_id_5, t0.franchise_id AS franchise_id_6 FROM known t0 WHERE t0.companie_id = ?
Parameters:
[
864
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Company | 165 |
| App\Entity\Configuration | 165 |
| App\Entity\Admin | 22 |
| App\Entity\Known | 21 |
| App\Entity\Technician | 10 |
| App\Entity\Address | 10 |
| App\Entity\UserCompany | 6 |
| App\Entity\BridgeUser | 1 |
| App\Entity\Category | 1 |