Query Metrics
30
Database Queries
6
Different statements
23.23 ms
Query time
10
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.79 ms |
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.deleted_at AS deleted_at_3, m0_.file_path AS file_path_4, m0_.discr AS discr_5, m0_.object_id AS object_id_6, m0_.object_id AS object_id_7, m0_.object_id AS object_id_8, m0_.object_id AS object_id_9, m0_.object_id AS object_id_10, m0_.object_id AS object_id_11, m0_.object_id AS object_id_12, m0_.object_id AS object_id_13, m0_.object_id AS object_id_14, m0_.object_id AS object_id_15, m0_.object_id AS object_id_16, m0_.object_id AS object_id_17, m0_.object_id AS object_id_18, m0_.object_id AS object_id_19, m0_.object_id AS object_id_20, m0_.object_id AS object_id_21, m0_.object_id AS object_id_22, m0_.object_id AS object_id_23, m0_.object_id AS object_id_24, m0_.object_id AS object_id_25, m0_.object_id AS object_id_26, m0_.object_id AS object_id_27, m0_.object_id AS object_id_28, m0_.object_id AS object_id_29 FROM media_object m0_ WHERE (m0_.file_path LIKE ?) AND m0_.discr IN ('media_coupon', 'media_participation', 'media_blog', 'media_thumbnail_blog', 'media_product', 'media_gift', 'media_thumbnail_gift', 'media_code_gift', 'media_thumbnail_draw', 'media_desktop_draw', 'media_mobile_draw', 'media_pdf_draw', 'media_code_draw', 'media_code_odr', 'media_promotion', 'media_image', 'media_pdf', 'media_game', 'media_mobile_game', 'media_slider', 'media_mobile_slider', 'media_game_params', 'media_thumbnail_odr', 'media_desktop_odr', 'media_mobile_odr', 'media_pdf_odr', 'media_multi_offer', 'media_recipe', 'media_pdf_documentation', 'media_knowledge_response')
Parameters:
[
"%%"
]
|
| 2 | 1.17 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"2b771af2-eb1f-490d-b55d-862ef581a31d"
]
|
| 3 | 2.45 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"9bbfd09f-9ade-45a5-86cf-d4dfd12ef05d"
]
|
| 4 | 1.11 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"2b771af2-eb1f-490d-b55d-862ef581a31d"
]
|
| 5 | 0.79 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
"02651ed6-dae5-4415-bea7-caa2dc949605"
]
|
| 6 | 0.73 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"c697ec7a-de6d-48fa-b533-ab479bbc8fd3"
]
|
| 7 | 0.57 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"031f679f-9736-41f2-95a6-89e5c8f4e4cf"
]
|
| 8 | 0.51 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_multi_odr')
Parameters:
[
"c697ec7a-de6d-48fa-b533-ab479bbc8fd3"
]
|
| 9 | 0.75 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"5bd39bf8-592a-43b8-a1c6-3a6eebac6995"
]
|
| 10 | 0.51 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"f53377fe-eacb-4610-a14f-3390461920dc"
]
|
| 11 | 0.42 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"5bd39bf8-592a-43b8-a1c6-3a6eebac6995"
]
|
| 12 | 0.82 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"233f4f5b-993b-44c4-ba9e-97a1f40650d9"
]
|
| 13 | 0.46 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"233f4f5b-993b-44c4-ba9e-97a1f40650d9"
]
|
| 14 | 0.55 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"c7422474-6125-4ed5-865e-7b51325e155a"
]
|
| 15 | 0.52 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"153b3b63-2513-4511-a91e-1963ed6909bd"
]
|
| 16 | 0.45 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"c7422474-6125-4ed5-865e-7b51325e155a"
]
|
| 17 | 0.81 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"fa39e199-8a13-48b0-ae49-7affa7ead402"
]
|
| 18 | 0.61 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"cdde3bab-6adf-422c-9ff6-9838e34768b0"
]
|
| 19 | 0.54 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_multi_odr')
Parameters:
[
"fa39e199-8a13-48b0-ae49-7affa7ead402"
]
|
| 20 | 0.55 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
"82c01ed8-5f9f-41ea-8103-f539f7fc6b48"
]
|
| 21 | 0.38 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
"8bf15e0b-8f8e-4e73-a4c1-9633258bfef1"
]
|
| 22 | 0.58 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"ce82c2c3-5b21-4b42-a193-a9b5905ae00a"
]
|
| 23 | 1.11 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.optin_brand AS optin_brand_5, t0.optin_customer AS optin_customer_6, t0.optin_process AS optin_process_7, t0.optin_phone AS optin_phone_8, t0.optin_sales AS optin_sales_9, t0.optin_whats_app AS optin_whats_app_10, t0.optin_mobile_carriers AS optin_mobile_carriers_11, t0.optin_whats_app_carriers AS optin_whats_app_carriers_12, t0.extra_data AS extra_data_13, t0.deleted_at AS deleted_at_14, t0.referral_code AS referral_code_15, t0.company_name AS company_name_16, t0.siret AS siret_17, t0.active AS active_18, t0.last_login AS last_login_19, t0.additional_information AS additional_information_20, t0.phone_number AS phone_number_21, t0.other AS other_22, t0.knowledge_responses AS knowledge_responses_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.identity_id AS identity_id_26, t0.company_id AS company_id_27, t0.referent_id AS referent_id_28, t0.strate_id AS strate_id_29, t0.profile_id AS profile_id_30, t0.discr FROM user t0 WHERE t0.id = ? AND t0.discr IN ('user', 'consumer', 'admin')
Parameters:
[
"c0813da9-296b-467e-a952-c3357753f28e"
]
|
| 24 | 0.37 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_multi_odr')
Parameters:
[
"ce82c2c3-5b21-4b42-a193-a9b5905ae00a"
]
|
| 25 | 0.36 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
"b0eb38dd-3cea-4f9c-aba8-62d5c312d957"
]
|
| 26 | 0.34 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position AS position_3, t0.image_id AS image_id_4, t0.knowledge_id AS knowledge_id_5 FROM knowledge_response t0 WHERE t0.image_id = ?
Parameters:
[
"c64cffde-6b06-406f-83a3-664e7fe24009"
]
|
| 27 | 0.54 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"a91b3279-e0b3-4b85-b84c-1c800c9e22f0"
]
|
| 28 | 0.42 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"a91b3279-e0b3-4b85-b84c-1c800c9e22f0"
]
|
| 29 | 0.60 ms |
SELECT t0.id AS id_1, t0.edited_id AS edited_id_2, t0.token AS token_3, t0.update_conformity_at AS update_conformity_at_4, t0.restatement_participation AS restatement_participation_5, t0.financial_status AS financial_status_6, t0.financial_date AS financial_date_7, t0.financial_amount AS financial_amount_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.state_id AS state_id_11, t0.user_id AS user_id_12, t0.company_id AS company_id_13, t0.validation_export_id AS validation_export_id_14, t0.discr, t0.print_url AS print_url_15, t0.emitter_code AS emitter_code_16, t0.channel AS channel_17, t0.status AS status_18, t0.code AS code_19, t0.amount AS amount_20, t0.mail_success AS mail_success_21, t0.amount AS amount_22, t0.iban AS iban_23, t0.bic AS bic_24, t0.code AS code_25, t0.amount AS amount_26, t0.mail_success AS mail_success_27, t0.code AS code_28, t0.amount AS amount_29, t0.date_of_purchase AS date_of_purchase_30, t0.iban AS iban_31, t0.bic AS bic_32, t0.paypal AS paypal_33, t0.id_billy AS id_billy_34, t0.mail_success AS mail_success_35, t0.code AS code_36, t0.print_url AS print_url_37, t0.emitter_code AS emitter_code_38, t0.channel AS channel_39, t0.status AS status_40, t0.amount AS amount_41, t0.iban AS iban_42, t0.bic AS bic_43, t0.paypal AS paypal_44, t0.id_billy AS id_billy_45, t0.mail_success AS mail_success_46 FROM participation t0 WHERE t0.id = ? AND t0.discr IN ('coupon', 'step', 'refund', 'puntos', 'draw', 'odr', 'multi')
Parameters:
[
"9c7639a0-c40f-4a1e-a184-d3ca802c8ca0"
]
|
| 30 | 0.44 ms |
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.participation_id AS participation_id_5, t0.discr FROM details_participation t0 WHERE t0.participation_id = ? AND t0.discr IN ('details_step')
Parameters:
[
"9c7639a0-c40f-4a1e-a184-d3ca802c8ca0"
]
|
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\MediaObject\MediaObject | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\MediaObject\MediaCoupon | No errors. |
| App\Entity\MediaObject\MediaParticipation | No errors. |
| App\Entity\MediaObject\MediaBlog | No errors. |
| App\Entity\MediaObject\MediaThumbnailBlog | No errors. |
| App\Entity\MediaObject\MediaProduct | No errors. |
| App\Entity\MediaObject\MediaGift | No errors. |
| App\Entity\MediaObject\MediaThumbnailGift | No errors. |
| App\Entity\MediaObject\MediaCodeGift | No errors. |
| App\Entity\MediaObject\MediaThumbnailDraw | No errors. |
| App\Entity\MediaObject\MediaDesktopDraw | No errors. |
| App\Entity\MediaObject\MediaMobileDraw | No errors. |
| App\Entity\MediaObject\MediaPdfDraw | No errors. |
| App\Entity\MediaObject\MediaCodeDraw | No errors. |
| App\Entity\MediaObject\MediaCodeOdr | No errors. |
| App\Entity\MediaObject\MediaPromotion | No errors. |
| App\Entity\MediaObject\MediaImage | No errors. |
| App\Entity\MediaObject\MediaPdf | No errors. |
| App\Entity\MediaObject\MediaGame | No errors. |
| App\Entity\MediaObject\MediaMobileGame | No errors. |
| App\Entity\MediaObject\MediaSlider | No errors. |
| App\Entity\MediaObject\MediaMobileSlider | No errors. |
| App\Entity\MediaObject\MediaGameParams | No errors. |
| App\Entity\MediaObject\MediaThumbnailOdr | No errors. |
| App\Entity\MediaObject\MediaDesktopOdr | No errors. |
| App\Entity\MediaObject\MediaMobileOdr | No errors. |
| App\Entity\MediaObject\MediaPdfOdr | No errors. |
| App\Entity\MediaObject\MediaMultiOffer | No errors. |
| App\Entity\MediaObject\MediaRecipe | No errors. |
| App\Entity\MediaObject\MediaPdfDocumentation | No errors. |
| App\Entity\MediaObject\MediaKnowledgeResponse | No errors. |
| App\Entity\Details\Operation\DetailsCoupon | No errors. |
| App\Entity\Participation\Participation | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\Participation\Puntos |
|
| App\Entity\Catalog\Gift | No errors. |
| App\Entity\Operation\Operation | No errors. |
| App\Entity\Operation\Draw | No errors. |
| App\Entity\Operation\Odr | No errors. |
| App\Entity\Sogec\Promotion | No errors. |
| App\Entity\Operation\Game | No errors. |
| App\Entity\Slider | No errors. |
| App\Entity\WebsiteParams\WebsiteParams | No errors. |
| App\Entity\WebsiteParams\GameParams | No errors. |
| App\Entity\State | No errors. |
| App\Entity\User\User |
|
| App\Entity\Company\Company | No errors. |
| App\Entity\Participation\ValidationExport | No errors. |
| App\Entity\Participation\Coupon | No errors. |
| App\Entity\Participation\Step |
|
| App\Entity\Participation\Refund | No errors. |
| App\Entity\Participation\Draw | No errors. |
| App\Entity\Participation\Odr |
|
| App\Entity\Participation\Multi |
|
| App\Entity\User\Identity | No errors. |
| App\Entity\User\Referent | No errors. |
| App\Entity\User\Strate | No errors. |
| App\Entity\Security\Profile | No errors. |
| App\Entity\User\Consumer |
|
| App\Entity\User\Admin |
|
| App\Entity\User\Address\Address | No errors. |
| App\Entity\User\Address\Home | No errors. |
| App\Entity\User\Address\Delivery | No errors. |
| App\Entity\Catalog\Order | No errors. |
| App\Entity\Token | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\User\Payment\Iban | No errors. |
| App\Entity\Sponsorship\SponsorshipRequest | No errors. |
| App\Entity\User\Carrier | No errors. |
| App\Entity\Cart\Cart | No errors. |
| App\Entity\Cart\OperationCart | No errors. |
| App\Entity\Cart\GiftCart | No errors. |
| App\Entity\Purse\Purse | No errors. |
| App\Entity\Tas\Tas | No errors. |
| App\Entity\Tas\TasDraw | No errors. |
| App\Entity\Ean\Participation\EanParticipation |
|
| App\Entity\Ean\Participation\EanStep |
|
| App\Entity\Details\Participation\DetailsParticipation | No errors. |
| App\Entity\Details\Participation\DetailsParticipationStep | No errors. |
| App\Entity\Knowledge\KnowledgeResponse | No errors. |
| App\Entity\Knowledge\Knowledge | No errors. |
| App\Entity\Ean\Participation\EanOdr |
|
| App\Entity\Details\Participation\DetailsParticipationMultiOdr | No errors. |