Query Metrics
45
Database Queries
16
Different statements
19.95 ms
Query time
12
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.98 ms (14.92%) |
8 |
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:
[
19
]
|
|
2.91 ms (14.57%) |
10 |
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:
[
5
]
|
|
2.00 ms (10.04%) |
8 |
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:
[
22
]
|
|
1.88 ms (9.40%) |
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.71 ms (8.56%) |
1 |
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:
[
"9"
]
|
|
1.65 ms (8.26%) |
2 |
SELECT t0.type AS type_1, t0.address_full AS address_full_2, t0.street_number AS street_number_3, t0.route AS route_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.administrative_area_level1 AS administrative_area_level1_7, t0.administrative_area_level2 AS administrative_area_level2_8, t0.other AS other_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.country AS country_12, t0.complement AS complement_13, t0.floor AS floor_14, t0.district AS district_15, t0.elevator AS elevator_16, t0.elevator_size AS elevator_size_17, t0.id AS id_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20 FROM address t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
1.11 ms (5.54%) |
2 |
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
1727
]
|
|
1.09 ms (5.48%) |
1 |
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:
[
9
]
|
|
1.00 ms (5.04%) |
1 |
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:
[ 885 888 890 1662 ] |
|
0.84 ms (4.20%) |
3 |
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.78 ms (3.91%) |
2 |
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:
[
1727
]
|
|
0.63 ms (3.16%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.51 ms (2.56%) |
1 |
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.business_shop_id IN (?)
Parameters:
[
9
]
|
|
0.37 ms (1.86%) |
1 |
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.25 ms (1.27%) |
1 |
SELECT t0.logo_name AS logo_name_1, t0.description AS description_2, t0.commercial_name AS commercial_name_3, t0.slug AS slug_4, t0.cgv AS cgv_5, t0.mango_pay_wallet_id AS mango_pay_wallet_id_6, t0.negotiation_allowed AS negotiation_allowed_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.enabled AS enabled_11, t0.user_business_id AS user_business_id_12, t0.bank_account_id AS bank_account_id_13 FROM business_shop t0 WHERE t0.id = ?
Parameters:
[
"9"
]
|
|
0.25 ms (1.24%) |
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:
[ 1633 1634 1499 ] |
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\User | No errors. |
| App\Entity\Address |
|
| App\Entity\Room | No errors. |
| App\Entity\Sponsor |
|
| App\Entity\BusinessShop | No errors. |
| App\Entity\PreFilledRoomImage | No errors. |
| App\Entity\AnnounceLibraryImage | No errors. |
| App\Entity\AnnounceOption | No errors. |
| App\Entity\PaymentTransaction | No errors. |
| App\Entity\AnnounceOrder | No errors. |
| App\Entity\CalendarAvailability | No errors. |
| App\Entity\StuffType | No errors. |
| App\Entity\Brand |
|
| App\Entity\UserBusiness |
|
| App\Entity\ProValuator | No errors. |
| App\Entity\ProVoucher | No errors. |
| App\Entity\ProCertificator | No errors. |
| App\Entity\AnnounceOrderStuff |
|
| App\Entity\AnnouncePreOrderStuff | No errors. |
| App\Entity\StuffPicture | No errors. |
| App\Entity\StuffTag | No errors. |
| App\Entity\Negotiation |
|
| App\Entity\DeliveryProviderStuffTypePolicy | No errors. |
| App\Entity\Search |
|
| App\Entity\StuffTypeTranslation | No errors. |
| App\Entity\Picture |
|
| App\Entity\BankAccount | No errors. |
| App\Entity\AnnounceOrderWithdrawal | No errors. |
| App\Entity\FrenchCity |
|
| App\Entity\ContactThreadMessageDocument | 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\BusinessAccess | No errors. |
| App\Entity\RoomType | No errors. |
| App\Entity\Delivery | No errors. |
| App\Entity\AnnounceOrderPickupDate | No errors. |
| App\Entity\PaymentAuthorization | No errors. |
| App\Entity\Voucher | No errors. |
| App\Entity\BusinessInformations | No errors. |
| App\Entity\ConfigCatalogAlgolia | No errors. |
| App\Entity\Valuation | No errors. |
| App\Entity\Discount | No errors. |
| App\Entity\AnnouncePreOrder | No errors. |
| App\Entity\DeliveryProvider | No errors. |
| App\Entity\KycDocument | No errors. |
| App\Entity\SearchAlert | No errors. |
| App\Entity\RoomTypeTranslation | No errors. |
| App\Entity\DeliveryOption | No errors. |
| App\Entity\PaymentCard | No errors. |
| App\Entity\BusinessDocument | No errors. |
| App\Entity\DeliveryProviderOption | No errors. |
| App\Entity\AlertNewsletter | No errors. |
| App\Entity\AlertNewsletterCampaign | No errors. |
| App\Entity\ValidationCode | No errors. |
| App\Entity\DeliveryCityGroup |
|
| 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\ServerError | No errors. |
| App\Entity\StuffTypeTag |
|
| App\Entity\StuffTypeTagTranslation | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\Testimonial | No errors. |
| App\Entity\Locality |
|
| 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. |