Query Metrics
34
Database Queries
18
Different statements
6.68 ms
Query time
49
Invalid entities
416
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.89 ms (13.26%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.matomo_url AS matomo_url_18, t0.matomo_js AS matomo_js_19, t0.matomo_tracker AS matomo_tracker_20, t0.google_map AS google_map_21, t0.maintenance AS maintenance_22, t0.logo AS logo_23, t0.fav_icon AS fav_icon_24, t0.contact_url AS contact_url_25, t0.contact_background AS contact_background_26, t0.contact_latitude AS contact_latitude_27, t0.contact_longitude AS contact_longitude_28, t0.type_map AS type_map_29, t0.tarte_au_citron_url AS tarte_au_citron_url_30, t0.tarte_au_citron_js AS tarte_au_citron_js_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.default_blog_image AS default_blog_image_34, t0.default_auction_image AS default_auction_image_35 FROM site t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.71 ms (10.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.low_price AS low_price_4, t0.hight_price AS hight_price_5, t0.position AS position_6, t0.highlight AS highlight_7, t0.description AS description_8, t0.slug AS slug_9, t0.interencheres_link AS interencheres_link_10, t0.drouot_link AS drouot_link_11, t0.import_id AS import_id_12, t0.display_auction_detail AS display_auction_detail_13, t0.position_galerie_image AS position_galerie_image_14, t0.numero AS numero_15, t0.numero_bis AS numero_bis_16, t0.adjudication AS adjudication_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.auction_id AS auction_id_20 FROM pack t0 WHERE t0.display = ? AND t0.auction_id = ?
Parameters:
[ 1 85 ] |
||||||||||||||||||||||||||||
|
0.56 ms (8.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.low_price AS low_price_4, t0.hight_price AS hight_price_5, t0.position AS position_6, t0.highlight AS highlight_7, t0.description AS description_8, t0.slug AS slug_9, t0.interencheres_link AS interencheres_link_10, t0.drouot_link AS drouot_link_11, t0.import_id AS import_id_12, t0.display_auction_detail AS display_auction_detail_13, t0.position_galerie_image AS position_galerie_image_14, t0.numero AS numero_15, t0.numero_bis AS numero_bis_16, t0.adjudication AS adjudication_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.auction_id AS auction_id_20 FROM pack t0 WHERE t0.slug = ? AND t0.auction_id = ? AND t0.display = ? LIMIT 1
Parameters:
[ "nantes" 85 1 ] |
||||||||||||||||||||||||||||
|
0.56 ms (8.40%) |
4 |
SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.display = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.45 ms (6.71%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display AS display_2, p0_.low_price AS low_price_3, p0_.hight_price AS hight_price_4, p0_.position AS position_5, p0_.highlight AS highlight_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.interencheres_link AS interencheres_link_9, p0_.drouot_link AS drouot_link_10, p0_.import_id AS import_id_11, p0_.display_auction_detail AS display_auction_detail_12, p0_.position_galerie_image AS position_galerie_image_13, p0_.numero AS numero_14, p0_.numero_bis AS numero_bis_15, p0_.adjudication AS adjudication_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.auction_id AS auction_id_19 FROM pack p0_ WHERE p0_.slug = ? AND p0_.auction_id = ?
Parameters:
[ "nantes" 85 ] |
||||||||||||||||||||||||||||
|
0.44 ms (6.62%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.slug AS slug_5, t0.display AS display_6, t0.description AS description_7, t0.price AS price_8, t0.position_section AS position_section_9, t0.display_section AS display_section_10, t0.position_carrousel AS position_carrousel_11, t0.display_carrousel AS display_carrousel_12, t0.start_date AS start_date_13, t0.end_date AS end_date_14, t0.consultant AS consultant_15, t0.exposition AS exposition_16, t0.interencheres_link AS interencheres_link_17, t0.drouot_link AS drouot_link_18, t0.import_id AS import_id_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_pdf AS image_pdf_22, t23.id AS id_24, t23.street AS street_25, t23.postal_code AS postal_code_26, t23.city AS city_27, t23.created_at AS created_at_28, t23.updated_at AS updated_at_29, t23.auction_id AS auction_id_30 FROM auction t0 LEFT JOIN address_auction t23 ON t23.auction_id = t0.id WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[ "arts-decoratifs-du-xxe-siecle-859" 1 ] |
||||||||||||||||||||||||||||
|
0.42 ms (6.26%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.display AS display_3, t0.low_price AS low_price_4, t0.hight_price AS hight_price_5, t0.position AS position_6, t0.highlight AS highlight_7, t0.description AS description_8, t0.slug AS slug_9, t0.interencheres_link AS interencheres_link_10, t0.drouot_link AS drouot_link_11, t0.import_id AS import_id_12, t0.display_auction_detail AS display_auction_detail_13, t0.position_galerie_image AS position_galerie_image_14, t0.numero AS numero_15, t0.numero_bis AS numero_bis_16, t0.adjudication AS adjudication_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.auction_id AS auction_id_20 FROM pack t0 WHERE t0.display = ? AND t0.display_auction_detail = ? AND t0.auction_id = ? ORDER BY t0.position_galerie_image ASC
Parameters:
[ 1 1 85 ] |
||||||||||||||||||||||||||||
|
0.35 ms (5.26%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter t0 WHERE t0.public = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.33 ms (4.90%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM pack p0_ WHERE p0_.display = ? AND p0_.auction_id = ?
Parameters:
[ 1 85 ] |
||||||||||||||||||||||||||||
|
0.32 ms (4.79%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.libelle AS libelle_4, t0.public AS public_5 FROM parameter_module t0 WHERE t0.public = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
|
0.28 ms (4.25%) |
2 |
SELECT t0.id AS id_1, t0.agence AS agence_2, t0.agence_address AS agence_address_3, t0.agence_zip AS agence_zip_4, t0.agence_city AS agence_city_5, t0.agence_email AS agence_email_6, t0.agence_phone AS agence_phone_7, t0.agence_opening_hours AS agence_opening_hours_8, t0.agence_contact_url AS agence_contact_url_9, t0.agence_contact_latitude AS agence_contact_latitude_10, t0.agence_contact_longitude AS agence_contact_longitude_11, t0.agence_nethelium AS agence_nethelium_12, t0.agence_contact_zoom AS agence_contact_zoom_13, t0.breadcrumb AS breadcrumb_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23, t0.primary_page AS primary_page_24, t0.parent_id AS parent_id_25 FROM page t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[ "ventes-venir" 1 ] |
||||||||||||||||||||||||||||
|
0.26 ms (3.86%) |
1 |
SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.breadcrumb AS breadcrumb_6, t0.sub_title AS sub_title_7, t0.highlighted AS highlighted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.affichage_menu AS affichage_menu_14, t0.slug AS slug_15, t0.display AS display_16, t0.no_index AS no_index_17, t0.primary_page AS primary_page_18 FROM blog_article t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[ "nantes" 1 ] |
||||||||||||||||||||||||||||
|
0.22 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.title AS title_4, t0.btn_color AS btn_color_5, t0.text_color AS text_color_6, t0.type AS type_7, t0.image AS image_8, t0.image2 AS image2_9, t0.image_mobile AS image_mobile_10, t0.image_position_horizontal AS image_position_horizontal_11, t0.image_position_vertical AS image_position_vertical_12, t0.video AS video_13, t0.position AS position_14, t0.carrousel AS carrousel_15, t0.button AS button_16, t0.map_latitude AS map_latitude_17, t0.map_longitude AS map_longitude_18, t0.map_zoom AS map_zoom_19, t0.section_nethelium_affichage AS section_nethelium_affichage_20, t0.link AS link_21, t0.link_target AS link_target_22, t0.btn_text AS btn_text_23, t0.min_height AS min_height_24, t0.text_position AS text_position_25, t0.text_position_vertical AS text_position_vertical_26, t0.btn_display AS btn_display_27, t0.background_type AS background_type_28, t0.primary_color AS primary_color_29, t0.carrousel_thumb AS carrousel_thumb_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.blog_choice AS blog_choice_33, t0.blog_count_article AS blog_count_article_34, t0.number_product AS number_product_35, t0.display_date AS display_date_36, t0.display_place AS display_place_37, t0.type_auction AS type_auction_38, t0.page_id AS page_id_39, t0.iframe_nethelium_id AS iframe_nethelium_id_40, t0.custom_form_id AS custom_form_id_41, t42.id AS id_43, t42.title AS title_44, t42.fields AS fields_45, t42.name AS name_46, t42.description AS description_47, t42.btn_text AS btn_text_48, t42.newsletter AS newsletter_49, t42.created_at AS created_at_50, t42.updated_at AS updated_at_51, t42.mail_id AS mail_id_52 FROM page_section t0 LEFT JOIN custom_form t42 ON t0.custom_form_id = t42.id WHERE t0.page_id = ? AND t0.type = ? AND t0.type_auction IN (?, ?, ?) LIMIT 1
Parameters:
[ 12 "auction" "auction_soon" "auction_finish" "pack_finish" ] |
||||||||||||||||||||||||||||
|
0.22 ms (3.26%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.title AS title_4, t0.btn_color AS btn_color_5, t0.text_color AS text_color_6, t0.type AS type_7, t0.image AS image_8, t0.image2 AS image2_9, t0.image_mobile AS image_mobile_10, t0.image_position_horizontal AS image_position_horizontal_11, t0.image_position_vertical AS image_position_vertical_12, t0.video AS video_13, t0.position AS position_14, t0.carrousel AS carrousel_15, t0.button AS button_16, t0.map_latitude AS map_latitude_17, t0.map_longitude AS map_longitude_18, t0.map_zoom AS map_zoom_19, t0.section_nethelium_affichage AS section_nethelium_affichage_20, t0.link AS link_21, t0.link_target AS link_target_22, t0.btn_text AS btn_text_23, t0.min_height AS min_height_24, t0.text_position AS text_position_25, t0.text_position_vertical AS text_position_vertical_26, t0.btn_display AS btn_display_27, t0.background_type AS background_type_28, t0.primary_color AS primary_color_29, t0.carrousel_thumb AS carrousel_thumb_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.blog_choice AS blog_choice_33, t0.blog_count_article AS blog_count_article_34, t0.number_product AS number_product_35, t0.display_date AS display_date_36, t0.display_place AS display_place_37, t0.type_auction AS type_auction_38, t0.page_id AS page_id_39, t0.iframe_nethelium_id AS iframe_nethelium_id_40, t0.custom_form_id AS custom_form_id_41, t42.id AS id_43, t42.title AS title_44, t42.fields AS fields_45, t42.name AS name_46, t42.description AS description_47, t42.btn_text AS btn_text_48, t42.newsletter AS newsletter_49, t42.created_at AS created_at_50, t42.updated_at AS updated_at_51, t42.mail_id AS mail_id_52 FROM page_section t0 LEFT JOIN custom_form t42 ON t0.custom_form_id = t42.id WHERE t0.page_id = ? AND t0.type = ? LIMIT 1
Parameters:
[ 12 "bandeau_newsletter" ] |
||||||||||||||||||||||||||||
|
0.20 ms (2.98%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.display AS display_2, p0_.low_price AS low_price_3, p0_.hight_price AS hight_price_4, p0_.position AS position_5, p0_.highlight AS highlight_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.interencheres_link AS interencheres_link_9, p0_.drouot_link AS drouot_link_10, p0_.import_id AS import_id_11, p0_.display_auction_detail AS display_auction_detail_12, p0_.position_galerie_image AS position_galerie_image_13, p0_.numero AS numero_14, p0_.numero_bis AS numero_bis_15, p0_.adjudication AS adjudication_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.auction_id AS auction_id_19 FROM pack p0_ WHERE p0_.display = ? AND p0_.auction_id = ? ORDER BY p0_.id DESC LIMIT 36
Parameters:
[ 1 85 ] |
||||||||||||||||||||||||||||
|
0.18 ms (2.67%) |
1 |
SELECT p0_.id AS id_0, p0_.agence AS agence_1, p0_.agence_address AS agence_address_2, p0_.agence_zip AS agence_zip_3, p0_.agence_city AS agence_city_4, p0_.agence_email AS agence_email_5, p0_.agence_phone AS agence_phone_6, p0_.agence_opening_hours AS agence_opening_hours_7, p0_.agence_contact_url AS agence_contact_url_8, p0_.agence_contact_latitude AS agence_contact_latitude_9, p0_.agence_contact_longitude AS agence_contact_longitude_10, p0_.agence_nethelium AS agence_nethelium_11, p0_.agence_contact_zoom AS agence_contact_zoom_12, p0_.breadcrumb AS breadcrumb_13, p0_.created_at AS created_at_14, p0_.updated_at AS updated_at_15, p0_.title AS title_16, p0_.meta_title AS meta_title_17, p0_.meta_description AS meta_description_18, p0_.affichage_menu AS affichage_menu_19, p0_.slug AS slug_20, p0_.display AS display_21, p0_.no_index AS no_index_22, p0_.primary_page AS primary_page_23, p0_.parent_id AS parent_id_24 FROM page p0_ LEFT JOIN page p1_ ON p0_.parent_id = p1_.id LEFT JOIN page p2_ ON p1_.parent_id = p2_.id WHERE p0_.slug = ? AND p0_.display = 1 AND p1_.slug = ? AND p2_.slug = ? AND p2_.parent_id IS NULL
Parameters:
[ "nantes" "arts-decoratifs-du-xxe-siecle-859" "ventes-venir" ]
|
||||||||||||||||||||||||||||
|
0.15 ms (2.26%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.vignette_text AS vignette_text_3, t0.vignette_image AS vignette_image_4, t0.breadcrumb AS breadcrumb_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.title AS title_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.affichage_menu AS affichage_menu_11, t0.display AS display_12, t0.no_index AS no_index_13, t0.primary_page AS primary_page_14, t0.parent_id AS parent_id_15 FROM blog_category t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[ "nantes" 1 ] |
||||||||||||||||||||||||||||
|
0.15 ms (2.22%) |
1 |
SELECT r0_.id AS id_0, r0_.old_url AS old_url_1, r0_.type AS type_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r0_.page_id AS page_id_5 FROM redirection r0_ WHERE r0_.old_url = ? OR r0_.old_url = ? OR r0_.old_url = ?
Parameters:
[ "ventes-venir/arts-decoratifs-du-xxe-siecle-859/nantes" "ventes-venir/arts-decoratifs-du-xxe-siecle-859/nantes/" "ventes-venir/arts-decoratifs-du-xxe-siecle-859/nantes" ]
|
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\Pack | 385 |
| App\Entity\Page | 20 |
| App\Entity\Parameter | 4 |
| App\Entity\PageSection | 2 |
| App\Entity\Site | 1 |
| App\Entity\Auction | 1 |
| Clockbox\Auction\Entity\AddressAuction | 1 |
| App\Entity\CustomForm | 1 |
| Clockbox\Core\Entity\Mail | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Clockbox\Core\Entity\Site | No errors. |
| App\Entity\Site | No errors. |
| Clockbox\Core\Entity\Page | No errors. |
| App\Entity\Page | No errors. |
| Clockbox\Core\Entity\PageSection | No errors. |
| App\Entity\PageSection |
|
| Clockbox\Core\Entity\Parameter | No errors. |
| App\Entity\Parameter | No errors. |
| Clockbox\Core\Entity\ParameterModule | No errors. |
| App\Entity\ParameterModule | No errors. |
| Clockbox\Core\Entity\Redirection |
|
| App\Entity\Redirection |
|
| Clockbox\Auction\Entity\Auction |
|
| App\Entity\Auction |
|
| Clockbox\Auction\Entity\AddressAuction | No errors. |
| Clockbox\Auction\Entity\Pack |
|
| Clockbox\Auction\Entity\CategoryAuction |
|
| App\Entity\Pack |
|
| Clockbox\Auction\Entity\PackImage |
|
| App\Entity\PackImage |
|
| Clockbox\Core\Entity\IframeNethelium |
|
| App\Entity\IframeNethelium |
|
| Clockbox\Core\Entity\CustomForm |
|
| App\Entity\CustomForm |
|
| Clockbox\Core\Entity\Mail |
|
| Clockbox\Core\Entity\Norme |
|
| App\Entity\Norme |
|
| Clockbox\Core\Entity\Marker |
|
| App\Entity\Marker |
|
| Clockbox\Core\Entity\Carrousel |
|
| App\Entity\Carrousel |
|
| Clockbox\Core\Entity\SocialNetwork |
|
| App\Entity\SocialNetwork |
|
| Clockbox\Core\Entity\Faq |
|
| App\Entity\Faq |
|
| Clockbox\Blog\Entity\BlogCategory |
|
| Clockbox\Auction\Entity\SlideAuction | No errors. |
| App\Entity\SlideAuction | No errors. |
| Clockbox\Core\Entity\Question |
|
| App\Entity\Question |
|
| Clockbox\Core\Entity\FooterLink |
|
| App\Entity\FooterLink |
|
| Clockbox\Core\Entity\MailUser |
|
| Clockbox\Core\Entity\Choice |
|
| App\Entity\Choice |
|
| Clockbox\Core\Entity\Partner | No errors. |
| App\Entity\Expert | No errors. |
| App\Entity\AddressAuction | No errors. |
| App\Entity\CategoryAuction |
|
| Clockbox\Core\Entity\Newsletter | No errors. |
| App\Entity\Newsletter | No errors. |
| Clockbox\Core\Entity\MenuGroup |
|
| App\Entity\MenuGroup |
|
| Clockbox\Core\Entity\Media | No errors. |
| App\Entity\Media | No errors. |
| Clockbox\Blog\Entity\BlogCategorySection |
|
| App\Entity\BlogCategorySection |
|
| Clockbox\Core\Entity\Menu |
|
| App\Entity\Menu |
|
| Clockbox\Core\Entity\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Mail |
|
| Clockbox\Blog\Entity\BlogArticle |
|
| App\Entity\BlogArticle |
|
| Clockbox\Core\Entity\Footer | No errors. |
| App\Entity\Footer | No errors. |
| App\Entity\Partner | No errors. |
| Clockbox\Core\Entity\MenuItem |
|
| App\Entity\MenuItem |
|
| Clockbox\Core\Entity\Bandeau | No errors. |
| App\Entity\Bandeau | No errors. |
| Clockbox\Blog\Entity\BlogArticleSection |
|
| App\Entity\BlogArticleSection |
|
| App\Entity\BlogCategory |
|
| App\Entity\MailUser |
|
| Vich\UploaderBundle\Entity\File | No errors. |