GET https://portal-dev.mobilityplaza.org/suppliers/switchio-by-monet-1

Query Metrics

9 Database Queries
9 Different statements
8.69 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.ip AS ip_2 FROM check_ip_request t0 WHERE t0.ip = ? LIMIT 1
Parameters:
[
  "216.73.216.185"
]
2 0.26 ms
SELECT t0.id AS id_1, t0.ip AS ip_2 FROM aws_ip t0
Parameters:
[]
3 1.11 ms
SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "switchio-by-monet-1"
]
4 3.50 ms
SELECT c0_.id AS id_0, c0_.fi_original_content AS fi_original_content_1, c0_.special_type AS special_type_2, c0_.homepage_type AS homepage_type_3, c0_.main_category AS main_category_4, c0_.main_region AS main_region_5, c0_.homepage_image AS homepage_image_6, c0_.homepage_image_mime AS homepage_image_mime_7, c0_.listing_image AS listing_image_8, c0_.listing_image_mime AS listing_image_mime_9, c0_.top_story AS top_story_10, c0_.headline AS headline_11, c0_.publication_start_date AS publication_start_date_12, c0_.publication_stop_date AS publication_stop_date_13, c0_.advertising_stop_date AS advertising_stop_date_14, c0_.payed_start_date AS payed_start_date_15, c0_.payed_stop_date AS payed_stop_date_16, c0_.validation_status AS validation_status_17, c0_.payed_status AS payed_status_18, c0_.adserver_stock AS adserver_stock_19, c0_.adserver_stock_date AS adserver_stock_date_20, c0_.adserver_stock_advertiser AS adserver_stock_advertiser_21, c0_.adserver_stock_location AS adserver_stock_location_22, c0_.modified_date AS modified_date_23, c0_.create_date AS create_date_24, c0_.homepage_start_date AS homepage_start_date_25, c0_.special_stop_date AS special_stop_date_26, c0_.fi_advertiser AS fi_advertiser_27, c0_.fi_company AS fi_company_28, c0_.clicks AS clicks_29, c0_.clicks_total AS clicks_total_30, c0_.fi_reference AS fi_reference_31, c0_.fi_language AS fi_language_32, c0_.fi_object AS fi_object_33, c0_.author AS author_34, c0_.file AS file_35, c0_.file_url AS file_url_36, c0_.file_name AS file_name_37, c0_.contact_name AS contact_name_38, c0_.contact_company AS contact_company_39, c0_.contact_street AS contact_street_40, c0_.contact_street2 AS contact_street2_41, c0_.contact_zip_city AS contact_zip_city_42, c0_.contact_fi_country AS contact_fi_country_43, c0_.contact_phone AS contact_phone_44, c0_.contact_fax AS contact_fax_45, c0_.contact_email AS contact_email_46, c0_.contact_website AS contact_website_47, c0_.contact_twitter AS contact_twitter_48, c0_.contact_linkedin AS contact_linkedin_49, c0_.contact_xing AS contact_xing_50, c0_.contact_facebook AS contact_facebook_51, c0_.contact_youtube AS contact_youtube_52, c0_.contact_instagram AS contact_instagram_53, c0_.content_fi_category AS content_fi_category_54, c0_.events_venue AS events_venue_55, c0_.events_venue_map AS events_venue_map_56, c0_.events_street AS events_street_57, c0_.events_zip_city AS events_zip_city_58, c0_.events_fi_country AS events_fi_country_59, c0_.events_from_date AS events_from_date_60, c0_.events_to_date AS events_to_date_61, c0_.events_website AS events_website_62, c0_.suppliers_content_fi_category AS suppliers_content_fi_category_63, c0_.external_link AS external_link_64, c0_.image_handling AS image_handling_65, c0_.homepage AS homepage_66, c0_.homepage_position AS homepage_position_67, c0_.article_type AS article_type_68, c0_.events_type AS events_type_69, c0_.short_description AS short_description_70, c0_.slug AS slug_71, c0_.fi_reference AS fi_reference_72, c0_.fi_language AS fi_language_73 FROM content c0_ INNER JOIN language l1_ ON c0_.fi_language = l1_.id WHERE c0_.id <> ? AND c0_.fi_object IN (?) AND c0_.validation_status = ? AND c0_.publication_start_date < ? AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > ?) AND l1_.lg_iso2 = ? ORDER BY c0_.modified_date DESC LIMIT 5
Parameters:
[
  32183
  5
  1
  1773224683
  1773224683
  "en"
]
5 0.54 ms
SELECT t0.id AS id_1, t0.fi_content AS fi_content_2, t0.type AS type_3, t0.subheadline AS subheadline_4, t0.text AS text_5, t0.pos AS pos_6, t0.hidden AS hidden_7, t0.fi_content AS fi_content_8 FROM content_div t0 WHERE t0.fi_content = ? ORDER BY t0.pos ASC
Parameters:
[
  32183
]
6 0.38 ms
SELECT t0.id AS id_1, t0.fi_content AS fi_content_2, t0.fi_content_div AS fi_content_div_3, t0.type AS type_4, t0.data AS data_5, t0.mime AS mime_6, t0.copyright AS copyright_7, t0.description AS description_8, t0.pos AS pos_9, t0.fi_content AS fi_content_10, t0.fi_content_div AS fi_content_div_11 FROM content_media t0 WHERE t0.fi_content = ?
Parameters:
[
  32183
]
7 0.70 ms
SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 INNER JOIN content_ref ON t0.id = content_ref.fi_content WHERE content_ref.fi_reference = ?
Parameters:
[
  32183
]
8 0.32 ms
SELECT t0.id AS id_1, t0.cn_iso2 AS cn_iso2_2, t0.cn_iso3 AS cn_iso3_3, t0.code AS code_4, t0.cn_phone AS cn_phone_5, t0.cn_short_en AS cn_short_en_6, t0.cn_short_de AS cn_short_de_7, t0.cn_short_fr AS cn_short_fr_8, t0.cn_short_es AS cn_short_es_9 FROM country t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  53
]
9 1.36 ms
SELECT t0.id AS id_1, t0.fi_original_content AS fi_original_content_2, t0.special_type AS special_type_3, t0.homepage_type AS homepage_type_4, t0.main_category AS main_category_5, t0.main_region AS main_region_6, t0.homepage_image AS homepage_image_7, t0.homepage_image_mime AS homepage_image_mime_8, t0.listing_image AS listing_image_9, t0.listing_image_mime AS listing_image_mime_10, t0.top_story AS top_story_11, t0.headline AS headline_12, t0.publication_start_date AS publication_start_date_13, t0.publication_stop_date AS publication_stop_date_14, t0.advertising_stop_date AS advertising_stop_date_15, t0.payed_start_date AS payed_start_date_16, t0.payed_stop_date AS payed_stop_date_17, t0.validation_status AS validation_status_18, t0.payed_status AS payed_status_19, t0.adserver_stock AS adserver_stock_20, t0.adserver_stock_date AS adserver_stock_date_21, t0.adserver_stock_advertiser AS adserver_stock_advertiser_22, t0.adserver_stock_location AS adserver_stock_location_23, t0.modified_date AS modified_date_24, t0.create_date AS create_date_25, t0.homepage_start_date AS homepage_start_date_26, t0.special_stop_date AS special_stop_date_27, t0.fi_advertiser AS fi_advertiser_28, t0.fi_company AS fi_company_29, t0.clicks AS clicks_30, t0.clicks_total AS clicks_total_31, t0.fi_reference AS fi_reference_32, t0.fi_language AS fi_language_33, t0.fi_object AS fi_object_34, t0.author AS author_35, t0.file AS file_36, t0.file_url AS file_url_37, t0.file_name AS file_name_38, t0.contact_name AS contact_name_39, t0.contact_company AS contact_company_40, t0.contact_street AS contact_street_41, t0.contact_street2 AS contact_street2_42, t0.contact_zip_city AS contact_zip_city_43, t0.contact_fi_country AS contact_fi_country_44, t0.contact_phone AS contact_phone_45, t0.contact_fax AS contact_fax_46, t0.contact_email AS contact_email_47, t0.contact_website AS contact_website_48, t0.contact_twitter AS contact_twitter_49, t0.contact_linkedin AS contact_linkedin_50, t0.contact_xing AS contact_xing_51, t0.contact_facebook AS contact_facebook_52, t0.contact_youtube AS contact_youtube_53, t0.contact_instagram AS contact_instagram_54, t0.content_fi_category AS content_fi_category_55, t0.events_venue AS events_venue_56, t0.events_venue_map AS events_venue_map_57, t0.events_street AS events_street_58, t0.events_zip_city AS events_zip_city_59, t0.events_fi_country AS events_fi_country_60, t0.events_from_date AS events_from_date_61, t0.events_to_date AS events_to_date_62, t0.events_website AS events_website_63, t0.suppliers_content_fi_category AS suppliers_content_fi_category_64, t0.external_link AS external_link_65, t0.image_handling AS image_handling_66, t0.homepage AS homepage_67, t0.homepage_position AS homepage_position_68, t0.article_type AS article_type_69, t0.events_type AS events_type_70, t0.short_description AS short_description_71, t0.slug AS slug_72, t0.fi_reference AS fi_reference_73, t0.fi_language AS fi_language_74 FROM content t0 INNER JOIN content_rel ON t0.id = content_rel.fi_content_t WHERE content_rel.fi_content_s = ? ORDER BY t0.modified_date DESC
Parameters:
[
  32183
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Content 11
App\Entity\Language 1
App\Entity\ContentDiv 1
App\Entity\ContentMedia 1
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\CheckIpRequest No errors.
App\Entity\AwsIp No errors.
App\Entity\Content No errors.
App\Entity\Language No errors.
App\Entity\ContentDiv No errors.
App\Entity\ContentMedia No errors.
App\Entity\Country No errors.