Query Metrics

8 Database Queries
7 Different statements
7.41 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.76 ms
(23.72%)
1
"COMMIT"
Parameters:
[]
1.53 ms
(20.63%)
2
SELECT p0_.id AS id_0, p0_.from_date AS from_date_1, p0_.to_date AS to_date_2, p0_.active AS active_3, p0_.is_in_modal AS is_in_modal_4, p0_.product_id AS product_id_5, p0_.custom_image_id AS custom_image_id_6 FROM product_sponsored p0_ WHERE p0_.active = 1 AND p0_.from_date <= ? AND p0_.to_date >= ? AND p0_.is_in_modal = 1 ORDER BY RAND() ASC LIMIT 15
Parameters:
[
  "2025-10-04 12:20:09"
  "2025-10-04 12:20:09"
]
1.43 ms
(19.33%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.resume AS resume_3, t0.text AS text_4, t0.lang AS lang_5, t0.creation_date AS creation_date_6, t0.publication_date AS publication_date_7, t0.active AS active_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.author AS author_11, t0.image_id AS image_id_12 FROM omelo_post t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
0.99 ms
(13.30%)
1
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.date_created AS date_created_13, t0.first_name AS first_name_14, t0.display_name AS display_name_15, t0.last_name AS last_name_16, t0.phone AS phone_17, t0.lang AS lang_18, t0.settings_receive_message_notification AS settings_receive_message_notification_19, t0.facebook_id AS facebook_id_20, t0.google_id AS google_id_21, t0.linkedin_id AS linkedin_id_22, t0.terms_acceptance_date AS terms_acceptance_date_23, t0.terms_acceptance_ip AS terms_acceptance_ip_24, t0.stripe_account_id AS stripe_account_id_25, t0.is_beta_tester AS is_beta_tester_26, t0.payment_last4digits AS payment_last4digits_27, t0.is_arecruiter AS is_arecruiter_28, t0.is_hri AS is_hri_29, t0.is_allowed_to_make_groups AS is_allowed_to_make_groups_30, t0.make_group_name AS make_group_name_31, t0.is_allowed_to_make_company_for_association AS is_allowed_to_make_company_for_association_32, t0.has_reusable_box AS has_reusable_box_33, t0.reminder_coupon_sent AS reminder_coupon_sent_34, t0.next_user_survey_time AS next_user_survey_time_35, t0.dont_show_survey AS dont_show_survey_36, t0.user_subscription_maturin AS user_subscription_maturin_37, t0.date_log_subscription_maturin AS date_log_subscription_maturin_38, t0.subscription_stripe_id AS subscription_stripe_id_39, t0.profile_image_id AS profile_image_id_40, t0.referred_by_id AS referred_by_id_41, t0.make_company_for_association_id AS make_company_for_association_id_42, t43.id AS id_44, t43.diets AS diets_45, t43.allergy AS allergy_46, t43.nb_personnes AS nb_personnes_47, t43.grocery_budget AS grocery_budget_48, t43.handicap AS handicap_49, t43.age_category AS age_category_50, t43.user_id AS user_id_51 FROM app_users t0 LEFT JOIN user_survey t43 ON t43.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  3
]
0.85 ms
(11.43%)
1
INSERT INTO cart (date_created, stripe_token, stripe_response, is_paid, solex_order_id, date_payment, shipping_estimation_raw, shipping_maturin_cost, shipping_maturin_carrier_name, shipping_maturin_service_name, shipping_maturin_estimated_date, picking_and_packing_fee, payment_fee, maturin_fee, taxes_products, taxes_maturin, taxes_shipping_maturin, taxes_shipping_company, taxes_packing, shipping_maturin_service_id, solex_order_raw, maturin_tracking_info, order_no, is_on_hold, just_in_time_email_sent, reminder_sent, raw_distributor_billing, taxes_products_calculations, taxes_shipping_maturin_calculations, taxes_shipping_company_calculations, taxes_packing_calculations, amount_saved_by_coupon, shipping_signature_required, signature_mandatory, extra_priority_points, warehouse_group_id, is_refunded, refund_stripe_response, note_from_buyer, is_bulk_order, track_link, track_pod_status_id, delivery_choice_date, pre_order, pre_order_now, shipping_address_id, user_id, used_coupon_id, logistic_invoice_id, send_with_subscription_id, from_subscription_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1 => "2025-10-04 12:20:09"
  2 => null
  3 => null
  4 => 0
  5 => null
  6 => null
  7 => null
  8 => null
  9 => null
  10 => null
  11 => null
  12 => 0
  13 => 0
  14 => 0
  15 => 0
  16 => 0
  17 => 0
  18 => 0
  19 => 0
  20 => null
  21 => null
  22 => "a:0:{}"
  23 => null
  24 => 0
  25 => 0
  26 => 0
  27 => "N;"
  28 => "a:0:{}"
  29 => "a:0:{}"
  30 => "a:0:{}"
  31 => "a:0:{}"
  32 => 0
  33 => 0
  34 => 0
  35 => 0
  36 => null
  37 => 0
  38 => "N;"
  39 => null
  40 => 0
  41 => null
  42 => null
  43 => null
  44 => null
  45 => null
  46 => null
  47 => null
  48 => null
  49 => null
  50 => null
  51 => null
]
0.70 ms
(9.43%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.display_order AS display_order_3, t0.image AS image_4, t0.category AS category_5, t0.filename AS filename_6, t0.mime AS mime_7, t0.weight AS weight_8, t0.height AS height_9, t0.width AS width_10, t0.folder AS folder_11, t0.creation_date AS creation_date_12, t0.last_updated AS last_updated_13, t0.user_id AS user_id_14 FROM image t0 WHERE t0.id = ?
Parameters:
[
  275
]
0.16 ms
(2.16%)
1
"START TRANSACTION"
Parameters:
[]

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\User No errors.
App\Entity\Notification No errors.
App\Entity\Message No errors.
App\Entity\Product No errors.
App\Entity\Cart No errors.
App\Entity\OmeloPost No errors.
App\Entity\Image No errors.
App\Entity\CartProduct No errors.
App\Entity\FinancialLog No errors.
App\Entity\CustomOrder No errors.
App\Entity\MaturinOrder No errors.
App\Entity\RecurringOrder No errors.
App\Entity\Subscription No errors.
App\Entity\UserShippingLocation No errors.
App\Entity\CartCoupon No errors.
App\Entity\Invoice No errors.
App\Entity\Category No errors.
App\Entity\Conservation No errors.
App\Entity\Company No errors.
App\Entity\Region No errors.
App\Entity\Corporative No errors.
App\Entity\CompanyLocation No errors.
App\Entity\CompanyAssociation No errors.
App\Entity\UserSurvey No errors.
App\Entity\UserVariables No errors.
App\Entity\UserSearch No errors.
App\Entity\UserViewedProduct No errors.
App\Entity\UserFavorite No errors.
App\Entity\EmailSent No errors.
App\Entity\ProductSponsored No errors.