Query Metrics
4
Database Queries
4
Different statements
4.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.30 ms (46.72%) |
1 |
SELECT t0.slug AS slug_1, t0.dispatch_priority AS dispatch_priority_2, t0.payment_control AS payment_control_3, t0.marker_installation_payment_control AS marker_installation_payment_control_4, t0.aggregate_values AS aggregate_values_5, t0.email_timing_setup AS email_timing_setup_6, t0.customer_renewal_configuration AS customer_renewal_configuration_7, t0.payment_config AS payment_config_8, t0.payment_service AS payment_service_9, t0.snow_overage_limit_reached AS snow_overage_limit_reached_10, t0.id AS id_11, t0.import_id AS import_id_12, t0.name AS name_13, t0.phone AS phone_14, t0.fax AS fax_15, t0.address AS address_16, t0.url AS url_17, t0.tax_number AS tax_number_18, t0.tos AS tos_19, t0.tos_eco AS tos_eco_20, t0.tos_french AS tos_french_21, t0.tos_eco_french AS tos_eco_french_22, t0.smtp AS smtp_23, t0.email_from AS email_from_24, t0.email_from_name AS email_from_name_25, t0.business_email AS business_email_26, t0.scalar_config AS scalar_config_27, t0.commercial_settings AS commercial_settings_28, t0.subscription_id AS subscription_id_29, t0.owner_id AS owner_id_30, t0.default_tax_id AS default_tax_id_31, t0.favorite_status_id AS favorite_status_id_32, t0.favorite_season_id AS favorite_season_id_33, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34, t0.parent_company_id AS parent_company_id_35, t36.slug AS slug_37, t36.dispatch_priority AS dispatch_priority_38, t36.payment_control AS payment_control_39, t36.marker_installation_payment_control AS marker_installation_payment_control_40, t36.aggregate_values AS aggregate_values_41, t36.email_timing_setup AS email_timing_setup_42, t36.customer_renewal_configuration AS customer_renewal_configuration_43, t36.payment_config AS payment_config_44, t36.payment_service AS payment_service_45, t36.snow_overage_limit_reached AS snow_overage_limit_reached_46, t36.id AS id_47, t36.import_id AS import_id_48, t36.name AS name_49, t36.phone AS phone_50, t36.fax AS fax_51, t36.address AS address_52, t36.url AS url_53, t36.tax_number AS tax_number_54, t36.tos AS tos_55, t36.tos_eco AS tos_eco_56, t36.tos_french AS tos_french_57, t36.tos_eco_french AS tos_eco_french_58, t36.smtp AS smtp_59, t36.email_from AS email_from_60, t36.email_from_name AS email_from_name_61, t36.business_email AS business_email_62, t36.scalar_config AS scalar_config_63, t36.commercial_settings AS commercial_settings_64, t36.subscription_id AS subscription_id_65, t36.owner_id AS owner_id_66, t36.default_tax_id AS default_tax_id_67, t36.favorite_status_id AS favorite_status_id_68, t36.favorite_season_id AS favorite_season_id_69, t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70, t36.parent_company_id AS parent_company_id_71, t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72, t36.twili_config_id AS twili_config_id_73, t36.file_collection_id AS file_collection_id_74, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75, t0.twili_config_id AS twili_config_id_76, t77.sid AS sid_78, t77.token AS token_79, t77.phone_number AS phone_number_80, t77.send_batches AS send_batches_81, t77.send_for_completed_address AS send_for_completed_address_82, t77.send_for_obstructed_address AS send_for_obstructed_address_83, t77.batches_text AS batches_text_84, t77.completed_address_text AS completed_address_text_85, t77.obstructed_address_text AS obstructed_address_text_86, t77.id AS id_87, t0.file_collection_id AS file_collection_id_88 FROM company t0 LEFT JOIN company t36 ON t0.parent_company_id = t36.id LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id WHERE t0.id IN (?)
Parameters:
[
[
Ramsey\Uuid\Lazy\LazyUuidFromString {#1315
: "fec5fd77-f624-47f9-baa4-14eaa335ab87"
}
]
]
|
|
1.95 ms (39.54%) |
1 |
SELECT c0_.slug AS slug_0, c0_.dispatch_priority AS dispatch_priority_1, c0_.payment_control AS payment_control_2, c0_.marker_installation_payment_control AS marker_installation_payment_control_3, c0_.aggregate_values AS aggregate_values_4, c0_.email_timing_setup AS email_timing_setup_5, c0_.customer_renewal_configuration AS customer_renewal_configuration_6, c0_.payment_config AS payment_config_7, c0_.payment_service AS payment_service_8, c0_.snow_overage_limit_reached AS snow_overage_limit_reached_9, c0_.id AS id_10, c0_.import_id AS import_id_11, c0_.name AS name_12, c0_.phone AS phone_13, c0_.fax AS fax_14, c0_.address AS address_15, c0_.url AS url_16, c0_.tax_number AS tax_number_17, c0_.tos AS tos_18, c0_.tos_eco AS tos_eco_19, c0_.tos_french AS tos_french_20, c0_.tos_eco_french AS tos_eco_french_21, c0_.smtp AS smtp_22, c0_.email_from AS email_from_23, c0_.email_from_name AS email_from_name_24, c0_.business_email AS business_email_25, c0_.scalar_config AS scalar_config_26, c0_.commercial_settings AS commercial_settings_27, c0_.subscription_id AS subscription_id_28, c0_.owner_id AS owner_id_29, c0_.default_tax_id AS default_tax_id_30, c0_.favorite_status_id AS favorite_status_id_31, c0_.favorite_season_id AS favorite_season_id_32, c0_.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_33, c0_.parent_company_id AS parent_company_id_34, c0_.snow_overage_charge_category_id AS snow_overage_charge_category_id_35, c0_.twili_config_id AS twili_config_id_36, c0_.file_collection_id AS file_collection_id_37 FROM company c0_ WHERE c0_.slug = ? LIMIT 1
Parameters:
[
"ksr"
]
|
|
0.39 ms (7.88%) |
1 |
SELECT t0.sid AS sid_1, t0.token AS token_2, t0.phone_number AS phone_number_3, t0.send_batches AS send_batches_4, t0.send_for_completed_address AS send_for_completed_address_5, t0.send_for_obstructed_address AS send_for_obstructed_address_6, t0.batches_text AS batches_text_7, t0.completed_address_text AS completed_address_text_8, t0.obstructed_address_text AS obstructed_address_text_9, t0.id AS id_10 FROM twilio_config t0 WHERE t0.id IN (?)
Parameters:
[
[
Ramsey\Uuid\Lazy\LazyUuidFromString {#609
: "70f72994-58c1-4825-8e95-9cae9eaf5547"
}
]
]
|
|
0.29 ms (5.86%) |
1 |
SELECT t0.slug AS slug_1, t0.dispatch_priority AS dispatch_priority_2, t0.payment_control AS payment_control_3, t0.marker_installation_payment_control AS marker_installation_payment_control_4, t0.aggregate_values AS aggregate_values_5, t0.email_timing_setup AS email_timing_setup_6, t0.customer_renewal_configuration AS customer_renewal_configuration_7, t0.payment_config AS payment_config_8, t0.payment_service AS payment_service_9, t0.snow_overage_limit_reached AS snow_overage_limit_reached_10, t0.id AS id_11, t0.import_id AS import_id_12, t0.name AS name_13, t0.phone AS phone_14, t0.fax AS fax_15, t0.address AS address_16, t0.url AS url_17, t0.tax_number AS tax_number_18, t0.tos AS tos_19, t0.tos_eco AS tos_eco_20, t0.tos_french AS tos_french_21, t0.tos_eco_french AS tos_eco_french_22, t0.smtp AS smtp_23, t0.email_from AS email_from_24, t0.email_from_name AS email_from_name_25, t0.business_email AS business_email_26, t0.scalar_config AS scalar_config_27, t0.commercial_settings AS commercial_settings_28, t0.subscription_id AS subscription_id_29, t0.owner_id AS owner_id_30, t0.default_tax_id AS default_tax_id_31, t0.favorite_status_id AS favorite_status_id_32, t0.favorite_season_id AS favorite_season_id_33, t0.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_34, t0.parent_company_id AS parent_company_id_35, t36.slug AS slug_37, t36.dispatch_priority AS dispatch_priority_38, t36.payment_control AS payment_control_39, t36.marker_installation_payment_control AS marker_installation_payment_control_40, t36.aggregate_values AS aggregate_values_41, t36.email_timing_setup AS email_timing_setup_42, t36.customer_renewal_configuration AS customer_renewal_configuration_43, t36.payment_config AS payment_config_44, t36.payment_service AS payment_service_45, t36.snow_overage_limit_reached AS snow_overage_limit_reached_46, t36.id AS id_47, t36.import_id AS import_id_48, t36.name AS name_49, t36.phone AS phone_50, t36.fax AS fax_51, t36.address AS address_52, t36.url AS url_53, t36.tax_number AS tax_number_54, t36.tos AS tos_55, t36.tos_eco AS tos_eco_56, t36.tos_french AS tos_french_57, t36.tos_eco_french AS tos_eco_french_58, t36.smtp AS smtp_59, t36.email_from AS email_from_60, t36.email_from_name AS email_from_name_61, t36.business_email AS business_email_62, t36.scalar_config AS scalar_config_63, t36.commercial_settings AS commercial_settings_64, t36.subscription_id AS subscription_id_65, t36.owner_id AS owner_id_66, t36.default_tax_id AS default_tax_id_67, t36.favorite_status_id AS favorite_status_id_68, t36.favorite_season_id AS favorite_season_id_69, t36.favorite_obstruction_reason_id AS favorite_obstruction_reason_id_70, t36.parent_company_id AS parent_company_id_71, t36.snow_overage_charge_category_id AS snow_overage_charge_category_id_72, t36.twili_config_id AS twili_config_id_73, t36.file_collection_id AS file_collection_id_74, t0.snow_overage_charge_category_id AS snow_overage_charge_category_id_75, t0.twili_config_id AS twili_config_id_76, t77.sid AS sid_78, t77.token AS token_79, t77.phone_number AS phone_number_80, t77.send_batches AS send_batches_81, t77.send_for_completed_address AS send_for_completed_address_82, t77.send_for_obstructed_address AS send_for_obstructed_address_83, t77.batches_text AS batches_text_84, t77.completed_address_text AS completed_address_text_85, t77.obstructed_address_text AS obstructed_address_text_86, t77.id AS id_87, t0.file_collection_id AS file_collection_id_88 FROM company t0 LEFT JOIN company t36 ON t0.parent_company_id = t36.id LEFT JOIN twilio_config t77 ON t0.twili_config_id = t77.id WHERE t0.parent_company_id = ?
Parameters:
[
"8438b66a-48ec-423d-9eeb-dde42bb256af"
]
|
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\Company\Company | No errors. |
| App\Entity\Subscription\Subscription | No errors. |
| App\Entity\User\User | No errors. |
| App\Entity\Tax\Tax | No errors. |
| App\Entity\Status\Status | No errors. |
| App\Entity\Season\Season | No errors. |
| App\Entity\ServiceEvent\ObstructionReason | No errors. |
| App\Entity\Category\AbstractCategory | No errors. |
| App\Entity\Category\SpecialServiceRequestCategory | No errors. |
| App\Entity\Company\TwilioConfig | No errors. |
| App\Entity\File\FileCollection | No errors. |
| App\Entity\PaymentSchedule\PaymentSchedule | No errors. |
| App\Entity\Service\ServicePrice | No errors. |
| App\Entity\Contract\ContractAggregates | No errors. |
| App\Entity\Contract\Contract | No errors. |
| App\Entity\User\Group | No errors. |
| App\Entity\Address\Zone | No errors. |
| App\Entity\Tax\TaxRate | No errors. |
| App\Entity\File\File | No errors. |
| App\Entity\PaymentSchedule\PaymentScheduleTimeTable | No errors. |
| App\Entity\Service\Service | No errors. |
| App\Entity\Customer\Customer | No errors. |
| App\Entity\System\Address\Address | No errors. |
| App\Entity\Address\Address | No errors. |
| App\Entity\Contract\ContractService | No errors. |
| App\Entity\Contract\ContractDiscount | No errors. |
| App\Entity\Contract\ContractReferralContractReference | No errors. |
| App\Entity\Contract\ContractPaymentTimeTable | No errors. |