| 1 |
2.22 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = 1;
|
| 2 |
1.23 ms |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.is_enabled AS is_enabled_4, t0.register_url AS register_url_5, t0.crm_api_key AS crm_api_key_6, t0.webhook_url AS webhook_url_7, t0.olead_api_key AS olead_api_key_8, t0.footer_content AS footer_content_9, t0.utm_variables AS utm_variables_10, t0.cgu_url AS cgu_url_11, t0.privacy_url AS privacy_url_12, t0.site_name AS site_name_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.uuid AS uuid_17, t0.company_id AS company_id_18 FROM app_campaign t0 WHERE t0.uuid = ? LIMIT 1
Parameters: [
"e4fd65f7-72a6-4d6a-a135-fb02c3137d3d"
]
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.is_enabled AS is_enabled_4, t0.register_url AS register_url_5, t0.crm_api_key AS crm_api_key_6, t0.webhook_url AS webhook_url_7, t0.olead_api_key AS olead_api_key_8, t0.footer_content AS footer_content_9, t0.utm_variables AS utm_variables_10, t0.cgu_url AS cgu_url_11, t0.privacy_url AS privacy_url_12, t0.site_name AS site_name_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.uuid AS uuid_17, t0.company_id AS company_id_18 FROM app_campaign t0 WHERE t0.uuid = 'e4fd65f7-72a6-4d6a-a135-fb02c3137d3d' LIMIT 1;
|
| 3 |
1.00 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.domain AS domain_2, a0_.modules AS modules_3, a0_.is_enabled AS is_enabled_4, a0_.is_check_valid_email AS is_check_valid_email_5, a0_.gtm_id AS gtm_id_6, a0_.identifier AS identifier_7, a0_.deleted_at AS deleted_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.uuid AS uuid_11 FROM app_company a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.name ASC
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.domain AS domain_2, a0_.modules AS modules_3, a0_.is_enabled AS is_enabled_4, a0_.is_check_valid_email AS is_check_valid_email_5, a0_.gtm_id AS gtm_id_6, a0_.identifier AS identifier_7, a0_.deleted_at AS deleted_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.uuid AS uuid_11 FROM app_company a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.name ASC;
|
| 4 |
0.81 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.is_public AS is_public_4, t0.is_enabled AS is_enabled_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uuid AS uuid_9 FROM app_media t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.is_public AS is_public_4, t0.is_enabled AS is_enabled_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uuid AS uuid_9 FROM app_media t0 WHERE t0.id = 25;
|
| 5 |
0.86 ms |
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8 FROM app_taxonomy a0_ WHERE a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8 FROM app_taxonomy a0_ WHERE a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;
|
| 6 |
1.37 ms |
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_."rank" AS rank_4, a0_.short_name AS short_name_5, a0_.is_enabled AS is_enabled_6, a0_.is_check_compliance AS is_check_compliance_7, a0_.icon AS icon_8, a0_.allowed_countries AS allowed_countries_9, a0_.deleted_at AS deleted_at_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.uuid AS uuid_13, a1_.id AS id_14, a1_.identifier AS identifier_15, a1_.name AS name_16, a1_.description AS description_17, a1_.is_enabled AS is_enabled_18, a1_.deleted_at AS deleted_at_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.uuid AS uuid_22, a0_.company_id AS company_id_23, a0_.taxonomy_id AS taxonomy_id_24, a0_.parent_id AS parent_id_25 FROM app_term a0_ LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id WHERE a1_.identifier = ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC
Parameters: [
"partner_type"
true
]
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_."rank" AS rank_4, a0_.short_name AS short_name_5, a0_.is_enabled AS is_enabled_6, a0_.is_check_compliance AS is_check_compliance_7, a0_.icon AS icon_8, a0_.allowed_countries AS allowed_countries_9, a0_.deleted_at AS deleted_at_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.uuid AS uuid_13, a1_.id AS id_14, a1_.identifier AS identifier_15, a1_.name AS name_16, a1_.description AS description_17, a1_.is_enabled AS is_enabled_18, a1_.deleted_at AS deleted_at_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.uuid AS uuid_22, a0_.company_id AS company_id_23, a0_.taxonomy_id AS taxonomy_id_24, a0_.parent_id AS parent_id_25 FROM app_term a0_ LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id WHERE a1_.identifier = 'partner_type' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;
|
| 7 |
1.07 ms |
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.url AS url_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8, a0_.company_id AS company_id_9, a0_.campaign_id AS campaign_id_10, a0_.type_id AS type_id_11 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC
Parameters: [
"module"
true
]
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.url AS url_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8, a0_.company_id AS company_id_9, a0_.campaign_id AS campaign_id_10, a0_.type_id AS type_id_11 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = 'module' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;
|