GET https://dev-sub.phonismart.com/KtVPc6nf/check-phone-number?phone=564987

Query Metrics

9 Database Queries
7 Different statements
5.05 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • The field App\Entity\LandingPage#statsInputs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StatsInput#landingPage does not contain the required 'inversedBy="statsInputs"' attribute.
  • The field App\Entity\LandingPage#statsDatas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StatsData#landingPage does not contain the required 'inversedBy="statsDatas"' attribute.
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.