Query Metrics
8
Database Queries
7
Different statements
15.41 ms
Query time
0
Invalid entities
16
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.60 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.22 ms |
SELECT t0.id AS id_1, t0.ip AS ip_2 FROM aws_ip t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 3 | 8.92 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:
[
"qa-with-ifsf-more-standards-fewer-payment-headaches"
]
|
||||||||||||||||||||||||||||||||
| 4 | 3.52 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:
[ 42611 1 2 4 1 1773230969 1773230969 "en" ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.48 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:
[
42611
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.30 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_div = ? ORDER BY t0.pos ASC
Parameters:
[
51137
]
|
||||||||||||||||||||||||||||||||
| 7 | 0.27 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_div = ? ORDER BY t0.pos ASC
Parameters:
[
51138
]
|
||||||||||||||||||||||||||||||||
| 8 | 1.10 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:
[
42611
]
|
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\ContentDiv | 7 |
| App\Entity\Content | 6 |
| App\Entity\ContentMedia | 2 |
| 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. |