GET https://portal-dev.mobilityplaza.org/news

Response
200 OK
IP
216.73.216.185
Profiled on
Token
e3e2c7

Query Metrics

7 Database Queries
7 Different statements
14.76 ms Query time
0 Invalid entities
35 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.55 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"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.21 ms 
SELECT t0.id AS id_1, t0.ip AS ip_2 FROM aws_ip t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
3 3.14 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_.fi_object IN (?, ?) AND c0_.validation_status = ? AND c0_.top_story = ? AND c0_.publication_start_date < ? AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > ?) AND l1_.lg_iso2 = ? ORDER BY c0_.publication_start_date DESC, c0_.modified_date DESC LIMIT 1
Parameters: 
[
  1
  4
  1
  1
  1773224594
  1773224594
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 2.53 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_.validation_status = ? AND l1_.lg_iso2 = ? AND c0_.article_type = ? AND c0_.publication_start_date < ? AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > ?) ORDER BY c0_.modified_date DESC LIMIT 4
Parameters: 
[
  1
  "en"
  "V"
  1773224594
  1773224594
]
View formatted query    View runnable query    Explain query    View query backtrace
5 2.45 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_.validation_status = ? AND l1_.lg_iso2 = ? AND c0_.article_type = ? AND c0_.publication_start_date < ? AND (c0_.publication_stop_date = 0 OR c0_.publication_stop_date > ?) ORDER BY c0_.modified_date DESC LIMIT 2
Parameters: 
[
  1
  "en"
  "P"
  1773224594
  1773224594
]
View formatted query    View runnable query    Explain query    View query backtrace
6 2.45 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_.fi_object IN (2, 3) AND c0_.publication_start_date > ?) OR (c0_.fi_object IN (11) AND c0_.publication_start_date > ?)) AND c0_.validation_status = ? AND c0_.payed_status = ? AND c0_.publication_start_date < ?) AND l1_.lg_iso2 = ? ORDER BY c0_.modified_date DESC LIMIT 30
Parameters: 
[
  1768386194
  1772014994
  1
  1
  1773224594
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 3.43 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_.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 32
Parameters: 
[
  1
  4
  1
  1773224594
  1773224594
  "en"
]
View formatted query    View runnable query    Explain query    View query backtrace

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 34
App\Entity\Language 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.