GET https://frosty-hoover.45-155-169-10.plesk.page/js/routing

Response
200 OK
IP
216.73.216.149
Profiled on
Token
612f1e

Query Metrics

22 Database Queries
10 Different statements
18.59 ms Query time
9 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 4.86 ms 
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, a1_.reference AS reference_46, a1_.state AS state_47, a1_.rating AS rating_48, a1_.favorite AS favorite_49, a1_.lot AS lot_50, a1_.discount_percentage AS discount_percentage_51, a1_.cgv AS cgv_52, a1_.fee_checked AS fee_checked_53, a1_.end_date AS end_date_54, a1_.live_at AS live_at_55, a1_.scheduled_alert AS scheduled_alert_56, a1_.alert_order AS alert_order_57, a1_.rated_at AS rated_at_58, a1_.rated AS rated_59, a1_.phone AS phone_60, a1_.description AS description_61, a1_.has_online_payment AS has_online_payment_62, a1_.creation_reminder_email_sent AS creation_reminder_email_sent_63, a1_.decreasing_prices AS decreasing_prices_64, a1_.decreasing_prices_until AS decreasing_prices_until_65, a1_.global_decreasing_percentage AS global_decreasing_percentage_66, a1_.ground_floor_option AS ground_floor_option_67, a1_.cover_picture_name AS cover_picture_name_68, a1_.moderation_status AS moderation_status_69, a1_.last_moderation_date AS last_moderation_date_70, a1_.products_availability_update_date AS products_availability_update_date_71, a1_.first_completed_at AS first_completed_at_72, a1_.title AS title_73, a1_.is_manual_pickup AS is_manual_pickup_74, a1_.schedule AS schedule_75, a1_.contact_first_name AS contact_first_name_76, a1_.contact_last_name AS contact_last_name_77, a1_.contact_email AS contact_email_78, a1_.contact_phone_number AS contact_phone_number_79, a1_.localisation_type AS localisation_type_80, a1_.id AS id_81, a1_.uid AS uid_82, a1_.created_at AS created_at_83, a1_.updated_at AS updated_at_84, a2_.type AS type_85, a2_.address_full AS address_full_86, a2_.street_number AS street_number_87, a2_.route AS route_88, a2_.zip_code AS zip_code_89, a2_.city AS city_90, a2_.administrative_area_level1 AS administrative_area_level1_91, a2_.administrative_area_level2 AS administrative_area_level2_92, a2_.other AS other_93, a2_.lat AS lat_94, a2_.lng AS lng_95, a2_.country AS country_96, a2_.complement AS complement_97, a2_.floor AS floor_98, a2_.district AS district_99, a2_.elevator AS elevator_100, a2_.elevator_size AS elevator_size_101, a2_.id AS id_102, a2_.created_at AS created_at_103, a2_.updated_at AS updated_at_104, s3_.parentLevel AS parentLevel_105, s3_.peopleToCarry AS peopleToCarry_106, s3_.carbon_foot_print AS carbon_foot_print_107, s3_.active AS active_108, s3_.slug AS slug_109, s3_.volume_in_m3 AS volume_in_m3_110, s3_.format AS format_111, s3_.id AS id_112, s3_.created_at AS created_at_113, s3_.updated_at AS updated_at_114, s4_.id AS id_115, s4_.name AS name_116, s4_.plural_name AS plural_name_117, s4_.created_at AS created_at_118, s4_.updated_at AS updated_at_119, s4_.locale AS locale_120, b5_.name AS name_121, b5_.slug AS slug_122, b5_.is_main AS is_main_123, b5_.menu_rank AS menu_rank_124, b5_.default_partner_link AS default_partner_link_125, b5_.quality AS quality_126, b5_.id AS id_127, b5_.created_at AS created_at_128, b5_.updated_at AS updated_at_129, s6_.picture_name AS picture_name_130, s6_.number AS number_131, s6_.id AS id_132, s6_.created_at AS created_at_133, s6_.updated_at AS updated_at_134, s7_.id AS id_135, s7_.label AS label_136, s7_.name AS name_137, s7_.created_at AS created_at_138, s7_.updated_at AS updated_at_139, s8_.parentLevel AS parentLevel_140, s8_.peopleToCarry AS peopleToCarry_141, s8_.carbon_foot_print AS carbon_foot_print_142, s8_.active AS active_143, s8_.slug AS slug_144, s8_.volume_in_m3 AS volume_in_m3_145, s8_.format AS format_146, s8_.id AS id_147, s8_.created_at AS created_at_148, s8_.updated_at AS updated_at_149, s9_.parentLevel AS parentLevel_150, s9_.peopleToCarry AS peopleToCarry_151, s9_.carbon_foot_print AS carbon_foot_print_152, s9_.active AS active_153, s9_.slug AS slug_154, s9_.volume_in_m3 AS volume_in_m3_155, s9_.format AS format_156, s9_.id AS id_157, s9_.created_at AS created_at_158, s9_.updated_at AS updated_at_159, s0_.room_id AS room_id_160, s0_.announce_id AS announce_id_161, s0_.type_id AS type_id_162, s0_.brand_id AS brand_id_163, s0_.certified_by_id AS certified_by_id_164, s0_.pro_voucher_id AS pro_voucher_id_165, a1_.seller_id AS seller_id_166, a1_.address_id AS address_id_167, a1_.room_id AS room_id_168, a1_.sponsor_id AS sponsor_id_169, a1_.business_shop_id AS business_shop_id_170, a1_.created_by_id AS created_by_id_171, a1_.updated_by_id AS updated_by_id_172, a1_.deleted_by_id AS deleted_by_id_173, s3_.parent AS parent_174, s4_.translatable_id AS translatable_id_175, b5_.business_id AS business_id_176, b5_.pro_valuator_id AS pro_valuator_id_177, b5_.pro_voucher_id AS pro_voucher_id_178, s6_.stuff_id AS stuff_id_179, s6_.library_image_id AS library_image_id_180, s8_.parent AS parent_181, s9_.parent AS parent_182 FROM stuff s0_ INNER JOIN announce a1_ ON s0_.announce_id = a1_.id INNER JOIN address a2_ ON a1_.address_id = a2_.id INNER JOIN stuff_type s3_ ON s0_.type_id = s3_.id LEFT JOIN stuff_type_translation s4_ ON s3_.id = s4_.translatable_id INNER JOIN brand b5_ ON s0_.brand_id = b5_.id LEFT JOIN stuff_picture s6_ ON s0_.id = s6_.stuff_id LEFT JOIN stuff__stuff_tag s10_ ON s0_.id = s10_.stuff_id LEFT JOIN stuff_tag s7_ ON s7_.id = s10_.tag_id LEFT JOIN stuff_type s8_ ON s3_.parent = s8_.id LEFT JOIN stuff_type s9_ ON s3_.id = s9_.parent WHERE s0_.reference = ?
Parameters: 
[
  "249DF"
]
View formatted query    View runnable query    Explain query
2 0.79 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
]
View formatted query    View runnable query    Explain query
3 1.21 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: 
[
  1692
]
View formatted query    View runnable query    Explain query
4 0.45 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: 
[
  1593
]
View formatted query    View runnable query    Explain query
5 0.65 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
]
View formatted query    View runnable query    Explain query
6 0.69 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
]
View formatted query    View runnable query    Explain query
7 0.59 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: 
[
  223
]
View formatted query    View runnable query    Explain query
8 0.64 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
]
View formatted query    View runnable query    Explain query
9 0.62 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: 
[
  225
]
View formatted query    View runnable query    Explain query
10 0.51 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: 
[
  226
]
View formatted query    View runnable query    Explain query
11 0.45 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: 
[
  227
]
View formatted query    View runnable query    Explain query
12 0.54 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: 
[
  228
]
View formatted query    View runnable query    Explain query
13 0.45 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: 
[
  229
]
View formatted query    View runnable query    Explain query
14 0.78 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: 
[
  372
]
View formatted query    View runnable query    Explain query
15 0.17 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 0.51 ms 
INSERT INTO view (stuff) VALUES (?)
Parameters: 
[
  1592
]
View formatted query    View runnable query    Explain query
17 2.17 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.59 ms 
SELECT t0.price AS price_1, t0.price_min AS price_min_2, t0.price_max AS price_max_3, t0.delivery_accepted AS delivery_accepted_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.stuff_type_id AS stuff_type_id_8, t0.provider_id AS provider_id_9 FROM delivery_provider_stuff_type_policy t0 WHERE t0.stuff_type_id = ?
Parameters: 
[
  64
]
View formatted query    View runnable query    Explain query
19 0.57 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.paris_area AS paris_area_3, t0.provinces_area AS provinces_area_4, t0.fixed_price AS fixed_price_5, t0.has_reduce_price AS has_reduce_price_6, t0.has_reduce_price_cond AS has_reduce_price_cond_7, t0.min_price_for_reduce_price AS min_price_for_reduce_price_8, t0.reduce_price AS reduce_price_9, t0.mango_pay_id AS mango_pay_id_10, t0.mango_pay_wallet_id AS mango_pay_wallet_id_11, t0.free AS free_12, t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13, t0.disabled AS disabled_14, t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15, t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16, t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17, t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18, t0.description AS description_19, t0.label AS label_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bank_account_id AS bank_account_id_24 FROM delivery_provider t0 WHERE t0.id = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query
20 0.52 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.paris_area AS paris_area_3, t0.provinces_area AS provinces_area_4, t0.fixed_price AS fixed_price_5, t0.has_reduce_price AS has_reduce_price_6, t0.has_reduce_price_cond AS has_reduce_price_cond_7, t0.min_price_for_reduce_price AS min_price_for_reduce_price_8, t0.reduce_price AS reduce_price_9, t0.mango_pay_id AS mango_pay_id_10, t0.mango_pay_wallet_id AS mango_pay_wallet_id_11, t0.free AS free_12, t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13, t0.disabled AS disabled_14, t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15, t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16, t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17, t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18, t0.description AS description_19, t0.label AS label_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bank_account_id AS bank_account_id_24 FROM delivery_provider t0 WHERE t0.id = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
21 0.33 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.paris_area AS paris_area_3, t0.provinces_area AS provinces_area_4, t0.fixed_price AS fixed_price_5, t0.has_reduce_price AS has_reduce_price_6, t0.has_reduce_price_cond AS has_reduce_price_cond_7, t0.min_price_for_reduce_price AS min_price_for_reduce_price_8, t0.reduce_price AS reduce_price_9, t0.mango_pay_id AS mango_pay_id_10, t0.mango_pay_wallet_id AS mango_pay_wallet_id_11, t0.free AS free_12, t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13, t0.disabled AS disabled_14, t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15, t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16, t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17, t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18, t0.description AS description_19, t0.label AS label_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bank_account_id AS bank_account_id_24 FROM delivery_provider t0 WHERE t0.id = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query
22 0.50 ms 
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.paris_area AS paris_area_3, t0.provinces_area AS provinces_area_4, t0.fixed_price AS fixed_price_5, t0.has_reduce_price AS has_reduce_price_6, t0.has_reduce_price_cond AS has_reduce_price_cond_7, t0.min_price_for_reduce_price AS min_price_for_reduce_price_8, t0.reduce_price AS reduce_price_9, t0.mango_pay_id AS mango_pay_id_10, t0.mango_pay_wallet_id AS mango_pay_wallet_id_11, t0.free AS free_12, t0.require_stuff_type_acceptation AS require_stuff_type_acceptation_13, t0.disabled AS disabled_14, t0.after_order_buyer_sendinblue_template_id AS after_order_buyer_sendinblue_template_id_15, t0.after_order_confirmation_buyer_sendinblue_template_id AS after_order_confirmation_buyer_sendinblue_template_id_16, t0.after_order_seller_sendinblue_template_id AS after_order_seller_sendinblue_template_id_17, t0.after_order_confirmation_seller_sendinblue_template_id AS after_order_confirmation_seller_sendinblue_template_id_18, t0.description AS description_19, t0.label AS label_20, t0.id AS id_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.bank_account_id AS bank_account_id_24 FROM delivery_provider t0 WHERE t0.id = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query

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\StuffType 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\StuffTypeTranslation 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\StuffPicture No errors.
App\Entity\StuffTag No errors.
App\Entity\Room No errors.
App\Entity\ProCertificator No errors.
App\Entity\ProVoucher No errors.
App\Entity\User 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\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\AnnounceLibraryImage 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\Negotiation
  • The mappings App\Entity\Negotiation#announceOrderStuff and App\Entity\AnnounceOrderStuff#negotiation are inconsistent with each other.
App\Entity\PreFilledRoomImage No errors.
App\Entity\AnnounceOption No errors.
App\Entity\PaymentTransaction No errors.
App\Entity\AnnounceOrder No errors.
App\Entity\CalendarAvailability No errors.
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\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\View No errors.
App\Entity\DeliveryProvider No errors.
App\Entity\BankAccount No errors.
App\Entity\Delivery No errors.
App\Entity\DeliveryProviderOption 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.