Query Metrics

90 Database Queries
16 Different statements
44.98 ms Query time
12 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.84 ms
(17.43%)
18
SELECT t0.id AS id_1, t0.name AS name_2, t0.plural_name AS plural_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.parentLevel AS parentLevel_9, t8.peopleToCarry AS peopleToCarry_10, t8.carbon_foot_print AS carbon_foot_print_11, t8.active AS active_12, t8.slug AS slug_13, t8.volume_in_m3 AS volume_in_m3_14, t8.format AS format_15, t8.id AS id_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.parent AS parent_19 FROM stuff_type_translation t0 LEFT JOIN stuff_type t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?
Parameters:
[
  224
]
5.39 ms
(11.97%)
7
SELECT t0.reference AS reference_1, t0.price AS price_2, t0.buy_price AS buy_price_3, t0.price_before_decrease AS price_before_decrease_4, t0.age AS age_5, t0.exact_age AS exact_age_6, t0.state AS state_7, t0.height_in_cm AS height_in_cm_8, t0.width_in_cm AS width_in_cm_9, t0.depth_in_cm AS depth_in_cm_10, t0.description AS description_11, t0.brand_legacy AS brand_legacy_12, t0.model AS model_13, t0.slug AS slug_14, t0.partner_link AS partner_link_15, t0.buy_date AS buy_date_16, t0.soldByIzidore AS soldByIzidore_17, t0.moderation_status AS moderation_status_18, t0.last_moderation_date AS last_moderation_date_19, t0.favorite AS favorite_20, t0.custom_type AS custom_type_21, t0.disabled AS disabled_22, t0.disabled_reason AS disabled_reason_23, t0.disabled_at AS disabled_at_24, t0.completed_at AS completed_at_25, t0.moderation_reason AS moderation_reason_26, t0.creation_state AS creation_state_27, t0.view AS view_28, t0.updated_by_owner_at AS updated_by_owner_at_29, t0.certified_at AS certified_at_30, t0.certified AS certified_31, t0.fixed_rate AS fixed_rate_32, t0.title AS title_33, t0.stuff_source AS stuff_source_34, t0.colors AS colors_35, t0.materials AS materials_36, t0.quantity AS quantity_37, t0.shop_reference AS shop_reference_38, t0.depot_reference AS depot_reference_39, t0.has_invoice AS has_invoice_40, t0.warranty_end_date AS warranty_end_date_41, t0.id AS id_42, t0.uid AS uid_43, t0.deleted_at AS deleted_at_44, t0.created_at AS created_at_45, t0.updated_at AS updated_at_46, t0.room_id AS room_id_47, t0.announce_id AS announce_id_48, t0.type_id AS type_id_49, t50.parentLevel AS parentLevel_51, t50.peopleToCarry AS peopleToCarry_52, t50.carbon_foot_print AS carbon_foot_print_53, t50.active AS active_54, t50.slug AS slug_55, t50.volume_in_m3 AS volume_in_m3_56, t50.format AS format_57, t50.id AS id_58, t50.created_at AS created_at_59, t50.updated_at AS updated_at_60, t50.parent AS parent_61, t0.brand_id AS brand_id_62, t63.name AS name_64, t63.slug AS slug_65, t63.is_main AS is_main_66, t63.menu_rank AS menu_rank_67, t63.default_partner_link AS default_partner_link_68, t63.quality AS quality_69, t63.id AS id_70, t63.created_at AS created_at_71, t63.updated_at AS updated_at_72, t63.business_id AS business_id_73, t63.pro_valuator_id AS pro_valuator_id_74, t63.pro_voucher_id AS pro_voucher_id_75, t0.certified_by_id AS certified_by_id_76, t0.pro_voucher_id AS pro_voucher_id_77 FROM stuff t0 LEFT JOIN stuff_type t50 ON t0.type_id = t50.id LEFT JOIN brand t63 ON t0.brand_id = t63.id WHERE t0.announce_id IN (?)
Parameters:
[
  913
]
4.91 ms
(10.93%)
14
SELECT t0.picture_name AS picture_name_1, t0.number AS number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stuff_id AS stuff_id_6, t0.library_image_id AS library_image_id_7 FROM stuff_picture t0 WHERE t0.stuff_id IN (?)
Parameters:
[
  1572
]
4.66 ms
(10.36%)
11
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo_id AS logo_id_4, t0.user_business_id AS user_business_id_5, t0.brand_id AS brand_id_6, t7.name AS name_8, t7.slug AS slug_9, t7.is_main AS is_main_10, t7.menu_rank AS menu_rank_11, t7.default_partner_link AS default_partner_link_12, t7.quality AS quality_13, t7.id AS id_14, t7.created_at AS created_at_15, t7.updated_at AS updated_at_16, t7.business_id AS business_id_17, t7.pro_valuator_id AS pro_valuator_id_18, t7.pro_voucher_id AS pro_voucher_id_19 FROM pro_certificator t0 LEFT JOIN brand t7 ON t0.brand_id = t7.id WHERE t0.brand_id = ?
Parameters:
[
  12
]
3.69 ms
(8.19%)
7
SELECT t0.reference AS reference_1, t0.state AS state_2, t0.rating AS rating_3, t0.favorite AS favorite_4, t0.lot AS lot_5, t0.discount_percentage AS discount_percentage_6, t0.cgv AS cgv_7, t0.fee_checked AS fee_checked_8, t0.end_date AS end_date_9, t0.live_at AS live_at_10, t0.scheduled_alert AS scheduled_alert_11, t0.alert_order AS alert_order_12, t0.rated_at AS rated_at_13, t0.rated AS rated_14, t0.phone AS phone_15, t0.description AS description_16, t0.has_online_payment AS has_online_payment_17, t0.creation_reminder_email_sent AS creation_reminder_email_sent_18, t0.decreasing_prices AS decreasing_prices_19, t0.decreasing_prices_until AS decreasing_prices_until_20, t0.global_decreasing_percentage AS global_decreasing_percentage_21, t0.ground_floor_option AS ground_floor_option_22, t0.cover_picture_name AS cover_picture_name_23, t0.moderation_status AS moderation_status_24, t0.last_moderation_date AS last_moderation_date_25, t0.products_availability_update_date AS products_availability_update_date_26, t0.first_completed_at AS first_completed_at_27, t0.title AS title_28, t0.is_manual_pickup AS is_manual_pickup_29, t0.schedule AS schedule_30, t0.contact_first_name AS contact_first_name_31, t0.contact_last_name AS contact_last_name_32, t0.contact_email AS contact_email_33, t0.contact_phone_number AS contact_phone_number_34, t0.localisation_type AS localisation_type_35, t0.id AS id_36, t0.uid AS uid_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.seller_id AS seller_id_40, t0.address_id AS address_id_41, t0.room_id AS room_id_42, t0.sponsor_id AS sponsor_id_43, t0.business_shop_id AS business_shop_id_44, t0.created_by_id AS created_by_id_45, t0.updated_by_id AS updated_by_id_46, t0.deleted_by_id AS deleted_by_id_47 FROM announce t0 WHERE t0.id = ?
Parameters:
[
  913
]
2.99 ms
(6.64%)
7
SELECT t0.count AS count_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.subject_id AS subject_id_5, t0.subject_type FROM favorite_anonymous t0 WHERE t0.subject_id = ? AND t0.subject_type IN ('stuff') LIMIT 1
Parameters:
[
  1572
]
2.99 ms
(6.64%)
7
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
  1572
]
2.86 ms
(6.36%)
1
SELECT s0_.reference AS reference_0, s0_.price AS price_1, s0_.buy_price AS buy_price_2, s0_.price_before_decrease AS price_before_decrease_3, s0_.age AS age_4, s0_.exact_age AS exact_age_5, s0_.state AS state_6, s0_.height_in_cm AS height_in_cm_7, s0_.width_in_cm AS width_in_cm_8, s0_.depth_in_cm AS depth_in_cm_9, s0_.description AS description_10, s0_.brand_legacy AS brand_legacy_11, s0_.model AS model_12, s0_.slug AS slug_13, s0_.partner_link AS partner_link_14, s0_.buy_date AS buy_date_15, s0_.soldByIzidore AS soldByIzidore_16, s0_.moderation_status AS moderation_status_17, s0_.last_moderation_date AS last_moderation_date_18, s0_.favorite AS favorite_19, s0_.custom_type AS custom_type_20, s0_.disabled AS disabled_21, s0_.disabled_reason AS disabled_reason_22, s0_.disabled_at AS disabled_at_23, s0_.completed_at AS completed_at_24, s0_.moderation_reason AS moderation_reason_25, s0_.creation_state AS creation_state_26, s0_.view AS view_27, s0_.updated_by_owner_at AS updated_by_owner_at_28, s0_.certified_at AS certified_at_29, s0_.certified AS certified_30, s0_.fixed_rate AS fixed_rate_31, s0_.title AS title_32, s0_.stuff_source AS stuff_source_33, s0_.colors AS colors_34, s0_.materials AS materials_35, s0_.quantity AS quantity_36, s0_.shop_reference AS shop_reference_37, s0_.depot_reference AS depot_reference_38, s0_.has_invoice AS has_invoice_39, s0_.warranty_end_date AS warranty_end_date_40, s0_.id AS id_41, s0_.uid AS uid_42, s0_.deleted_at AS deleted_at_43, s0_.created_at AS created_at_44, s0_.updated_at AS updated_at_45, s1_.parentLevel AS parentLevel_46, s1_.peopleToCarry AS peopleToCarry_47, s1_.carbon_foot_print AS carbon_foot_print_48, s1_.active AS active_49, s1_.slug AS slug_50, s1_.volume_in_m3 AS volume_in_m3_51, s1_.format AS format_52, s1_.id AS id_53, s1_.created_at AS created_at_54, s1_.updated_at AS updated_at_55, s0_.room_id AS room_id_56, s0_.announce_id AS announce_id_57, s0_.type_id AS type_id_58, s0_.brand_id AS brand_id_59, s0_.certified_by_id AS certified_by_id_60, s0_.pro_voucher_id AS pro_voucher_id_61, s1_.parent AS parent_62 FROM stuff s0_ LEFT JOIN stuff_type s1_ ON s0_.type_id = s1_.id LEFT JOIN stuff_type_translation s2_ ON s1_.id = s2_.translatable_id WHERE s0_.favorite = ? AND s0_.disabled = 0 AND s0_.deleted_at IS NULL AND s0_.moderation_status IN (?, ?, ?) ORDER BY s0_.last_moderation_date DESC LIMIT 7
Parameters:
[
  1
  1
  3
  4
]
2.32 ms
(5.15%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "test_izidore_2"
]
1.62 ms
(3.61%)
2
SELECT DATABASE()
Parameters:
[]
1.53 ms
(3.39%)
4
SELECT t0.picture_name AS picture_name_1, t0.number AS number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stuff_id AS stuff_id_6, t0.library_image_id AS library_image_id_7 FROM stuff_picture t0 WHERE t0.stuff_id IN (?, ?, ?)
Parameters:
[
  1486
  1757
  1758
]
1.48 ms
(3.29%)
4
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.is_main AS is_main_3, t0.menu_rank AS menu_rank_4, t0.default_partner_link AS default_partner_link_5, t0.quality AS quality_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.business_id AS business_id_10, t0.pro_valuator_id AS pro_valuator_id_11, t12.id AS id_13, t12.created_at AS created_at_14, t12.updated_at AS updated_at_15, t12.logo_id AS logo_id_16, t12.user_business_id AS user_business_id_17, t12.brand_id AS brand_id_18, t0.pro_voucher_id AS pro_voucher_id_19 FROM brand t0 LEFT JOIN pro_certificator t12 ON t12.brand_id = t0.id WHERE t0.id IN (?)
Parameters:
[
  5
]
1.09 ms
(2.42%)
3
SELECT t0.parentLevel AS parentLevel_1, t0.peopleToCarry AS peopleToCarry_2, t0.carbon_foot_print AS carbon_foot_print_3, t0.active AS active_4, t0.slug AS slug_5, t0.volume_in_m3 AS volume_in_m3_6, t0.format AS format_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent AS parent_11 FROM stuff_type t0 WHERE t0.id = ?
Parameters:
[
  11
]
0.78 ms
(1.74%)
2
SELECT t0.picture_name AS picture_name_1, t0.number AS number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stuff_id AS stuff_id_6, t0.library_image_id AS library_image_id_7 FROM stuff_picture t0 WHERE t0.stuff_id IN (?, ?)
Parameters:
[
  1529
  1530
]
0.44 ms
(0.97%)
1
SELECT t0.picture_name AS picture_name_1, t0.number AS number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stuff_id AS stuff_id_6, t0.library_image_id AS library_image_id_7 FROM stuff_picture t0 WHERE t0.stuff_id IN (?, ?, ?, ?)
Parameters:
[
  1562
  1580
  1581
  1626
]
0.41 ms
(0.92%)
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.is_main AS is_main_3, t0.menu_rank AS menu_rank_4, t0.default_partner_link AS default_partner_link_5, t0.quality AS quality_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.business_id AS business_id_10, t0.pro_valuator_id AS pro_valuator_id_11, t12.id AS id_13, t12.created_at AS created_at_14, t12.updated_at AS updated_at_15, t12.logo_id AS logo_id_16, t12.user_business_id AS user_business_id_17, t12.brand_id AS brand_id_18, t0.pro_voucher_id AS pro_voucher_id_19 FROM brand t0 LEFT JOIN pro_certificator t12 ON t12.brand_id = t0.id WHERE t0.id IN (?, ?, ?)
Parameters:
[
  89
  7
  37
]

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\AbstractEntity No errors.
App\Entity\UtmCampaign No errors.
App\Entity\FavoriteAnonymous No errors.
App\Entity\FavoriteAnonymousAnnounce No errors.
App\Entity\FavoriteAnonymousStuff No errors.
App\Entity\Favorite No errors.
App\Entity\FavoriteAnnounce No errors.
App\Entity\FavoriteStuff No errors.
App\Entity\Announce No errors.
App\Entity\Stuff No errors.
App\Entity\ContactThread No errors.
App\Entity\ContactThreadMessage No errors.
App\Entity\Brand
  • The association App\Entity\Brand#business refers to the inverse side field App\Entity\UserBusiness#brands which does not exist.
  • The association App\Entity\Brand#searches refers to the owning side field App\Entity\Search#brands which does not exist.
App\Entity\Sponsor
  • The association App\Entity\Sponsor#utmCampaigns refers to the owning side field App\Entity\Sponsor#sponsor which does not exist.
App\Entity\StuffType No errors.
App\Entity\AnnounceOrder No errors.
App\Entity\AnnounceOrderWithdrawal No errors.
App\Entity\UserBusiness
  • The field App\Entity\UserBusiness#informations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BusinessInformations#business does not contain the required 'inversedBy="informations"' attribute.
App\Entity\FrenchCity
  • The field 'App\Entity\FrenchCity#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\FrenchCity#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\User No errors.
App\Entity\Address
  • The field 'App\Entity\Address#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Address#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\Room No errors.
App\Entity\PreFilledRoomImage No errors.
App\Entity\AnnounceLibraryImage No errors.
App\Entity\AnnounceOption No errors.
App\Entity\PaymentTransaction No errors.
App\Entity\CalendarAvailability No errors.
App\Entity\BusinessShop No errors.
App\Entity\AnnounceOrderStuff
  • The field App\Entity\AnnounceOrderStuff#negotiation is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Negotiation#stuff does not contain the required 'mappedBy="negotiation"' attribute.
  • If association App\Entity\AnnounceOrderStuff#negotiation is one-to-one, then the inversed side App\Entity\Negotiation#stuff has to be one-to-one as well.
App\Entity\AnnouncePreOrderStuff No errors.
App\Entity\StuffPicture No errors.
App\Entity\StuffTag No errors.
App\Entity\ProCertificator No errors.
App\Entity\ProVoucher No errors.
App\Entity\Negotiation
  • The mappings App\Entity\Negotiation#announceOrderStuff and App\Entity\AnnounceOrderStuff#negotiation are inconsistent with each other.
App\Entity\ContactThreadMessageDocument No errors.
App\Entity\Search
  • The mappings App\Entity\Search#brand and App\Entity\Brand#searches are inconsistent with each other.
App\Entity\ProValuator No errors.
App\Entity\DeliveryProviderStuffTypePolicy No errors.
App\Entity\StuffTypeTranslation No errors.
App\Entity\AnnounceOrderPickupDate No errors.
App\Entity\PaymentAuthorization No errors.
App\Entity\Delivery No errors.
App\Entity\Voucher No errors.
App\Entity\BankAccount No errors.
App\Entity\BusinessAccess No errors.
App\Entity\BusinessInformations No errors.
App\Entity\Picture
  • The field App\Entity\Picture#userBusiness is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserBusiness#logo does not contain the required 'inversedBy="userBusiness"' attribute.
  • The field App\Entity\Picture#proValuator is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProValuator#logo does not contain the required 'inversedBy="proValuator"' attribute.
  • The field App\Entity\Picture#proCertificator is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProCertificator#logo does not contain the required 'inversedBy="proCertificator"' attribute.
App\Entity\ConfigCatalogAlgolia No errors.
App\Entity\KycProcess No errors.
App\Entity\NotificationToken No errors.
App\Entity\Cart No errors.
App\Entity\NotificationPreferences No errors.
App\Entity\Business No errors.
App\Entity\CGUVersion No errors.
App\Entity\SearchUser No errors.
App\Entity\RoomType No errors.
App\Entity\Discount No errors.
App\Entity\AnnouncePreOrder No errors.
App\Entity\Valuation No errors.
App\Entity\DeliveryProvider No errors.
App\Entity\PaymentCard No errors.
App\Entity\DeliveryOption No errors.
App\Entity\BusinessDocument No errors.
App\Entity\AlertNewsletter No errors.
App\Entity\AlertNewsletterCampaign No errors.
App\Entity\RoomTypeTranslation No errors.
App\Entity\ValidationCode No errors.
App\Entity\DeliveryCityGroup
  • The association App\Entity\DeliveryCityGroup#deliveryProvider refers to the inverse side field App\Entity\DeliveryProvider#deliveryCityGroups which does not exist.
App\Entity\SEOText No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\AppVersion No errors.
App\Entity\View No errors.
App\Entity\Contact No errors.
App\Entity\ContactThreadMessageBlocker No errors.
App\Entity\InvoiceItem No errors.
App\Entity\Notification No errors.
App\Entity\SearchAlert No errors.
App\Entity\ServerError No errors.
App\Entity\StuffTypeTag
  • The field App\Entity\StuffTypeTag#stuffType is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\StuffType#tags does not contain the required 'mappedBy="stuffType"' attribute.
  • If association App\Entity\StuffTypeTag#stuffType is many-to-one, then the inversed side App\Entity\StuffType#tags has to be one-to-many.
App\Entity\StuffTypeTagTranslation No errors.
App\Entity\Invoice No errors.
App\Entity\Testimonial No errors.
App\Entity\DeliveryProviderOption No errors.
App\Entity\KycDocument No errors.
App\Entity\Locality
  • The field 'App\Entity\Locality#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Locality#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Vich\UploaderBundle\Entity\File No errors.
Algolia\SearchBundle\Entity\Aggregator No errors.