Redirect 302 redirect from GET @announce_show (ed0807)

GET https://frosty-hoover.45-155-169-10.plesk.page/boutique/jeanette-store/127/magasin-toulouse/1705

Query Metrics

51 Database Queries
13 Different statements
20.95 ms Query time
12 Invalid entities

Queries

Group similar statements

# Time Info
1 1.62 ms
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:
[
  "1705"
]
2 1.08 ms
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:
[
  1705
]
3 0.37 ms
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:
[
  66
]
4 0.27 ms
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:
[
  1611
]
5 0.33 ms
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:
[
  9
]
6 0.34 ms
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:
[
  222
]
7 0.25 ms
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:
[
  1615
]
8 0.27 ms
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:
[
  130
]
9 0.34 ms
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:
[
  83
]
10 0.25 ms
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:
[
  1616
]
11 0.28 ms
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:
[
  89
]
12 0.33 ms
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:
[
  102
]
13 0.25 ms
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:
[
  1617
]
14 0.27 ms
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:
[
  111
]
15 0.33 ms
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:
[
  100
]
16 0.31 ms
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:
[
  1618
]
17 0.31 ms
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:
[
  42
]
18 0.29 ms
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:
[
  122
]
19 0.26 ms
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:
[
  1619
]
20 0.33 ms
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:
[
  280
]
21 0.25 ms
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:
[
  1620
]
22 0.28 ms
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:
[
  71
]
23 0.27 ms
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:
[
  127
]
24 0.44 ms
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:
[
  127
]
25 1.56 ms
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:
[
  1706
]
26 0.33 ms
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:
[
  120
]
27 0.25 ms
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:
[
  1614
]
28 0.34 ms
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:
[
  1
]
29 0.42 ms
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
]
30 0.26 ms
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:
[
  1629
]
31 0.26 ms
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:
[
  1630
]
32 0.62 ms
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:
[
  1251
]
33 0.29 ms
SELECT DATABASE()
Parameters:
[]
34 1.77 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "test_izidore_2"
]
35 0.17 ms
SELECT DATABASE()
Parameters:
[]
36 0.69 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
  1616
]
37 0.51 ms
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:
[
  1616
]
38 0.33 ms
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:
[
  13
]
39 0.38 ms
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:
[
  13
]
40 0.29 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
  1615
]
41 0.30 ms
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:
[
  1615
]
42 0.24 ms
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:
[
  64
]
43 0.38 ms
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:
[
  64
]
44 0.27 ms
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
]
45 0.32 ms
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:
[
  11
]
46 0.28 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
  1617
]
47 0.27 ms
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:
[
  1617
]
48 0.23 ms
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:
[
  14
]
49 0.36 ms
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:
[
  14
]
50 0.26 ms
SELECT COUNT(f0_.id) AS sclr_0 FROM favorite f0_ WHERE (f0_.subject_id = ?) AND f0_.subject_type IN ('stuff')
Parameters:
[
  1619
]
51 0.26 ms
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:
[
  1619
]

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
  • 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\Sponsor
  • The association App\Entity\Sponsor#utmCampaigns refers to the owning side field App\Entity\Sponsor#sponsor which does not exist.
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
  • 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\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\ProValuator No errors.
App\Entity\ProVoucher No errors.
App\Entity\ProCertificator 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\Negotiation
  • The mappings App\Entity\Negotiation#announceOrderStuff and App\Entity\AnnounceOrderStuff#negotiation are inconsistent with each other.
App\Entity\DeliveryProviderStuffTypePolicy No errors.
App\Entity\Search
  • The mappings App\Entity\Search#brand and App\Entity\Brand#searches are inconsistent with each other.
App\Entity\StuffTypeTranslation 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\BankAccount No errors.
App\Entity\AnnounceOrderWithdrawal No errors.
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\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
  • 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\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\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.