Query Metrics
9
Database Queries
7
Different statements
5.05 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.87 ms |
SELECT t0.name AS name_1, t0.meta_title AS meta_title_2, t0.html_content AS html_content_3, t0.phone_number_label AS phone_number_label_4, t0.pin_label AS pin_label_5, t0.phone_number_button AS phone_number_button_6, t0.sms_button AS sms_button_7, t0.enabled AS enabled_8, t0.unique_key AS unique_key_9, t0.body_background AS body_background_10, t0.head_html AS head_html_11, t0.conversion_tag AS conversion_tag_12, t0.has_shared_portal AS has_shared_portal_13, t0.host AS host_14, t0.pin_button AS pin_button_15, t0.before_button_content AS before_button_content_16, t0.after_button_content AS after_button_content_17, t0.success_content AS success_content_18, t0.css AS css_19, t0.js AS js_20, t0.use_default_browser_language AS use_default_browser_language_21, t0.exit_url AS exit_url_22, t0.unique_name AS unique_name_23, t0.redirect_to_portal_if_subscribed AS redirect_to_portal_if_subscribed_24, t0.default_value AS default_value_25, t0.google_sheet_id AS google_sheet_id_26, t0.google_sheet_conversion_name AS google_sheet_conversion_name_27, t0.exit_url_type AS exit_url_type_28, t0.has_cookies_consent AS has_cookies_consent_29, t0.has_live_check_phone_number AS has_live_check_phone_number_30, t0.google_conversion_action_id AS google_conversion_action_id_31, t0.google_account_id AS google_account_id_32, t0.id AS id_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.favicon_id AS favicon_id_36, t0.default_language_id AS default_language_id_37, t0.product_id AS product_id_38, t0.header_enrichment_id AS header_enrichment_id_39, t0.default_source_id AS default_source_id_40, t0.exit_landing_page_id AS exit_landing_page_id_41 FROM landing_page t0 WHERE t0.unique_key = ? LIMIT 1
Parameters:
[
"KtVPc6nf"
]
|
2 | 0.43 ms |
SELECT t0.name AS name_1, t0.iso AS iso_2, t0.id AS id_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
1
]
|
3 | 0.51 ms |
SELECT t0.content AS content_1, t0.phone_number_label AS phone_number_label_2, t0.pin_label AS pin_label_3, t0.phone_number_button AS phone_number_button_4, t0.sms_button AS sms_button_5, t0.pin_button AS pin_button_6, t0.before_button_content AS before_button_content_7, t0.after_button_content AS after_button_content_8, t0.success_content AS success_content_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.language_id AS language_id_13, t0.landing_page_id AS landing_page_id_14 FROM html_content t0 WHERE t0.landing_page_id = ?
Parameters:
[
93
]
|
4 | 0.18 ms |
SELECT t0.name AS name_1, t0.iso AS iso_2, t0.id AS id_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
3
]
|
5 | 0.18 ms |
SELECT t0.name AS name_1, t0.iso AS iso_2, t0.id AS id_3 FROM language t0 WHERE t0.id = ?
Parameters:
[
2
]
|
6 | 0.18 ms |
SELECT t0.name AS name_1, t0.iso AS iso_2, t0.id AS id_3 FROM language t0 WHERE t0.iso = ? LIMIT 1
Parameters:
[
"en"
]
|
7 | 0.39 ms |
SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.unique_key AS unique_key_3, t0.unique_name AS unique_name_4, t0.visitor_tag_length AS visitor_tag_length_5, t0.input_key_length AS input_key_length_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.portal_id AS portal_id_10, t0.payment_type_id AS payment_type_id_11 FROM product t0 WHERE t0.id = ?
Parameters:
[
12
]
|
8 | 0.91 ms |
SELECT t0.manager_class_name AS manager_class_name_1, t0.external_service_id AS external_service_id_2, t0.unique_key AS unique_key_3, t0.name AS name_4, t0.manage_subscriptions_ourselves AS manage_subscriptions_ourselves_5, t0.amount AS amount_6, t0.notifs_with_fake_phone_number AS notifs_with_fake_phone_number_7, t0.nb_digits_pin AS nb_digits_pin_8, t0.subscription_sms_code AS subscription_sms_code_9, t0.subscription_sms_phone_number AS subscription_sms_phone_number_10, t0.unsubscribe_sms_code AS unsubscribe_sms_code_11, t0.unsubscribe_sms_phone_number AS unsubscribe_sms_phone_number_12, t0.has_success_page AS has_success_page_13, t0.confirmed_with_notification AS confirmed_with_notification_14, t0.new_subscription_parameter AS new_subscription_parameter_15, t0.renew_subscription_parameter AS renew_subscription_parameter_16, t0.stop_subscription_parameter AS stop_subscription_parameter_17, t0.charge_parameter AS charge_parameter_18, t0.sms_sent_parameter AS sms_sent_parameter_19, t0.sms_received_parameter AS sms_received_parameter_20, t0.notification_type_key_parameter AS notification_type_key_parameter_21, t0.has_initialize AS has_initialize_22, t0.we_can_refund AS we_can_refund_23, t0.nb_days_withou_charge_before_unsubscribe AS nb_days_withou_charge_before_unsubscribe_24, t0.unique_name AS unique_name_25, t0.subscription_sms_content AS subscription_sms_content_26, t0.unsubscribe_sms_content AS unsubscribe_sms_content_27, t0.final_step_page_content AS final_step_page_content_28, t0.dynamic_callback_option AS dynamic_callback_option_29, t0.enabled AS enabled_30, t0.welcome_sms_content AS welcome_sms_content_31, t0.id AS id_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.payment_type_id AS payment_type_id_35, t0.country_id AS country_id_36, t0.aggregator_id AS aggregator_id_37, t0.currency_id AS currency_id_38, t0.default_language_id AS default_language_id_39 FROM payment_connector t0 INNER JOIN product_payment_connector ON t0.id = product_payment_connector.payment_connector_id WHERE product_payment_connector.product_id = ?
Parameters:
[
12
]
|
9 | 0.40 ms |
SELECT t0.name AS name_1, t0.people_name AS people_name_2, t0.iso AS iso_3, t0.code AS code_4, t0.need_iban AS need_iban_5, t0.need_ifsc_code AS need_ifsc_code_6, t0.need_routing_code AS need_routing_code_7, t0.need_aba_number AS need_aba_number_8, t0.mobile_number_prefix AS mobile_number_prefix_9, t0.iso3 AS iso3_10, t0.unique_name AS unique_name_11, t0.id AS id_12 FROM country t0 WHERE t0.id = ?
Parameters:
[
206
]
|
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\LandingPage |
|
App\Entity\Image | No errors. |
App\Entity\Language | No errors. |
App\Entity\Product | No errors. |
App\Entity\HeaderEnrichment | No errors. |
App\Entity\Source | No errors. |
App\Entity\Input | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\HtmlContent | No errors. |
App\Entity\StatsInput | No errors. |
App\Entity\StatsData | No errors. |
App\Entity\LogVisit | No errors. |
App\Entity\SmsContent | No errors. |
App\Entity\PaymentConnector | No errors. |
App\Entity\Portal | No errors. |
App\Entity\PaymentType | No errors. |
App\Entity\SourceApiCall | No errors. |
App\Entity\Country | No errors. |
App\Entity\Aggregator | No errors. |
App\Entity\Currency | No errors. |
App\Entity\Carrier | No errors. |
App\Entity\EventNotif | No errors. |
App\Entity\Charge | No errors. |
App\Entity\Refund | No errors. |
App\Entity\SentSms | No errors. |
App\Entity\LogRequest | No errors. |
App\Entity\FakePhoneNumber | No errors. |
App\Entity\ReceivedSms | No errors. |
App\Entity\MccMnc | No errors. |