Symfony Profiler

Query Metrics

73 Database Queries

12 Different statements

40.38 ms Query time

17 Invalid entities

200 Managed entities

Queries


SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1
SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = ? AND m2_.route_name = ?
SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = ? AND s0_.type_thumb = ?
SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = ?
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = ? ORDER BY m0_.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = ? LIMIT 1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ?
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ?
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, favoris_14, publish_date_5 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ?) dctrn_result_inner ORDER BY favoris_14 DESC, publish_date_5 DESC) dctrn_result LIMIT 20
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ? ORDER BY s0_.favoris DESC, s0_.publish_date DESC) dctrn_result) dctrn_table

#▲	Time	Info
1	0.66 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1 Parameters: [`"jean-sebastien.leleu@epicture.fr"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = ? LIMIT 1 SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.new_email AS new_email_5, t0.roles AS roles_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.newsletter_accepted AS newsletter_accepted_9, t0.terms_accepted AS terms_accepted_10, t0.is_valid AS is_valid_11, t0.confirmation_token AS confirmation_token_12, t0.shortcuts AS shortcuts_13, t0.lastlogin AS lastlogin_14, t0.locale AS locale_15, t0.birthday AS birthday_16, t0.description AS description_17, t0.gender_id AS gender_id_18, t0.picture_name AS picture_name_19, t0.password_request_at AS password_request_at_20, t0.enabled AS enabled_21, t0.come_from AS come_from_22, t0.display_scenario AS display_scenario_23, t0.phone AS phone_24, t0.info_shared_neopse AS info_shared_neopse_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.city_id AS city_id_28, t0.admin_group_id AS admin_group_id_29 FROM users t0 WHERE t0.email = 'jean-sebastien.leleu@epicture.fr' LIMIT 1;
2	0.78 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1 Parameters: [`"1445"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.address AS address_4, t0.additional_address AS additional_address_5, t0.postcode AS postcode_6, t0.identify_number AS identify_number_7, t0.website AS website_8, t0.prepaid_amount AS prepaid_amount_9, t0.sponsor_code AS sponsor_code_10, t0.sponsor_points AS sponsor_points_11, t0.reference AS reference_12, t0.sepa_name AS sepa_name_13, t0.population AS population_14, t0.typology AS typology_15, t0.is_rdc AS is_rdc_16, t0.is_contract_historic AS is_contract_historic_17, t0.collectivity_service_code AS collectivity_service_code_18, t0.is_number_ej AS is_number_ej_19, t0.demo AS demo_20, t0.vat AS vat_21, t0.logo AS logo_22, t0.is_data_different_invoice AS is_data_different_invoice_23, t0.other_name AS other_name_24, t0.other_address AS other_address_25, t0.other_identify_number AS other_identify_number_26, t0.manual_renewal AS manual_renewal_27, t0.testimony_answered AS testimony_answered_28, t0.is_cmd AS is_cmd_29, t0.notes AS notes_30, t0.date_invitation_ceo_interview AS date_invitation_ceo_interview_31, t0.date_ceo_interview AS date_ceo_interview_32, t0.top_ranking AS top_ranking_33, t0.rdc_feeling AS rdc_feeling_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.deleted_at AS deleted_at_37, t0.lat AS lat_38, t0.lng AS lng_39, t0.type_id AS type_id_40, t0.category_id AS category_id_41, t0.city_id AS city_id_42, t0.user_id AS user_id_43, t0.othet_city_id AS othet_city_id_44, t0.intercommunality_id AS intercommunality_id_45, t0.attachments AS attachments_46 FROM projects t0 WHERE t0.id = '1445' AND t0.deleted_at IS NULL LIMIT 1;
3	1.35 ms	SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = ? AND m2_.route_name = ? Parameters: [`1445 "news"`] View formatted query View runnable query Explain query SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = ? AND m2_.route_name = ? SELECT p0_.date_end AS date_end_0, p0_.status AS status_1, p0_.pending_order AS pending_order_2, p1_.id AS id_3, p1_.name AS name_4, p1_.description AS description_5, p1_.address AS address_6, p1_.additional_address AS additional_address_7, p1_.postcode AS postcode_8, p1_.identify_number AS identify_number_9, p1_.website AS website_10, p1_.prepaid_amount AS prepaid_amount_11, p1_.sponsor_code AS sponsor_code_12, p1_.sponsor_points AS sponsor_points_13, p1_.reference AS reference_14, p1_.sepa_name AS sepa_name_15, p1_.population AS population_16, p1_.typology AS typology_17, p1_.is_rdc AS is_rdc_18, p1_.is_contract_historic AS is_contract_historic_19, p1_.collectivity_service_code AS collectivity_service_code_20, p1_.is_number_ej AS is_number_ej_21, p1_.demo AS demo_22, p1_.vat AS vat_23, p1_.logo AS logo_24, p1_.is_data_different_invoice AS is_data_different_invoice_25, p1_.other_name AS other_name_26, p1_.other_address AS other_address_27, p1_.other_identify_number AS other_identify_number_28, p1_.manual_renewal AS manual_renewal_29, p1_.testimony_answered AS testimony_answered_30, p1_.is_cmd AS is_cmd_31, p1_.notes AS notes_32, p1_.date_invitation_ceo_interview AS date_invitation_ceo_interview_33, p1_.date_ceo_interview AS date_ceo_interview_34, p1_.top_ranking AS top_ranking_35, p1_.rdc_feeling AS rdc_feeling_36, p1_.created_at AS created_at_37, p1_.updated_at AS updated_at_38, p1_.deleted_at AS deleted_at_39, p1_.lat AS lat_40, p1_.lng AS lng_41, m2_.id AS id_42, m2_.name AS name_43, m2_.status AS status_44, m2_.menu_key AS menu_key_45, m2_.route_name AS route_name_46, m2_.is_front_page AS is_front_page_47, m2_.is_widget AS is_widget_48, m2_.is_feed AS is_feed_49, p0_.projecttool_id AS projecttool_id_50, p0_.mod_id AS mod_id_51, p0_.project_id AS project_id_52, p1_.type_id AS type_id_53, p1_.category_id AS category_id_54, p1_.city_id AS city_id_55, p1_.user_id AS user_id_56, p1_.othet_city_id AS othet_city_id_57, p1_.intercommunality_id AS intercommunality_id_58, p1_.attachments AS attachments_59, m2_.projecttool_id AS projecttool_id_60, m2_.prod_id AS prod_id_61 FROM projects_mods p0_ INNER JOIN projects p1_ ON p0_.project_id = p1_.id INNER JOIN mods m2_ ON p0_.mod_id = m2_.id WHERE p0_.project_id = 1445 AND m2_.route_name = 'news';
4	0.63 ms	SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = ? AND s0_.type_thumb = ? Parameters: [`1445 0`] View formatted query View runnable query Explain query SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = ? AND s0_.type_thumb = ? SELECT s0_.url_thumb AS url_thumb_0, s0_.type_thumb AS type_thumb_1, s0_.cropped_data AS cropped_data_2, s0_.id AS id_3, s0_.name AS name_4, s0_.size AS size_5, s0_.mime_type AS mime_type_6, s0_.original_name AS original_name_7, s0_.uploaded_at AS uploaded_at_8, s0_.preview AS preview_9, s0_.preview_mime_type AS preview_mime_type_10, s0_.preview_size AS preview_size_11, s0_.deleted_at AS deleted_at_12, s0_.project_id AS project_id_13, s0_.original_file_id AS original_file_id_14 FROM site_thumbnails_files s0_ WHERE s0_.project_id = 1445 AND s0_.type_thumb = 0;
5	0.55 ms	SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = ? Parameters: [`1445`] View formatted query View runnable query Explain query SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = ? SELECT t0.date_end AS date_end_1, t0.status AS status_2, t0.additional_size AS additional_size_3, t0.free AS free_4, t0.next_data AS next_data_5, t0.pending_order AS pending_order_6, t0.size_platform AS size_platform_7, t0.pack AS pack_8, t0.reminded_at AS reminded_at_9, t0.delete_at AS delete_at_10, t0.locked AS locked_11, t0.renewal_refused AS renewal_refused_12, t0.renewal_refused_reason AS renewal_refused_reason_13, t0.renewal_refused_filename AS renewal_refused_filename_14, t0.projecttool_id AS projecttool_id_15, t0.project_id AS project_id_16 FROM projects_projecttools t0 WHERE t0.project_id = 1445;
6	1.09 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = ? ORDER BY m0_.name ASC Parameters: [`3`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = ? ORDER BY m0_.name ASC SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.status AS status_2, m0_.menu_key AS menu_key_3, m0_.route_name AS route_name_4, m0_.is_front_page AS is_front_page_5, m0_.is_widget AS is_widget_6, m0_.is_feed AS is_feed_7, p1_.ht AS ht_8, p1_.prod_type AS prod_type_9, p1_.enabled AS enabled_10, p1_.id AS id_11, p2_.id AS id_12, p2_.name AS name_13, p2_.always_checked AS always_checked_14, p2_.projecttool_key AS projecttool_key_15, p2_.max_size AS max_size_16, p2_.index_route AS index_route_17, p2_.enabled AS enabled_18, m0_.projecttool_id AS projecttool_id_19, m0_.prod_id AS prod_id_20, p1_.projecttool_id AS projecttool_id_21 FROM mods m0_ LEFT JOIN products p1_ ON m0_.prod_id = p1_.id INNER JOIN projecttools p2_ ON m0_.projecttool_id = p2_.id WHERE m0_.projecttool_id = 3 ORDER BY m0_.name ASC;
7	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`26`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 26;
8	0.67 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 12;
9	0.74 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 13;
10	0.58 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`141`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 141;
11	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`39`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 39;
12	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`40`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 40;
13	0.61 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`41`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 41;
14	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`42`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 42;
15	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`43`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 43;
16	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`44`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 44;
17	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 10;
18	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 14;
19	0.62 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 30;
20	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 3;
21	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`25`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 25;
22	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`46`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 46;
23	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 24;
24	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`147`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 147;
25	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`23`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 23;
26	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 28;
27	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 29;
28	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 48;
29	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 18;
30	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`19`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 19;
31	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 8;
32	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`35`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 35;
33	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`49`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 49;
34	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`50`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 50;
35	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`15`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 15;
36	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`34`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 34;
37	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 9;
38	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 51;
39	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 38;
40	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 11;
41	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 5;
42	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 7;
43	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`20`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 20;
44	0.43 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 4;
45	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 59;
46	0.65 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 60;
47	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`61`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 61;
48	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`37`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 37;
49	0.56 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 31;
50	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`52`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 52;
51	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 53;
52	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 54;
53	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 45;
54	0.56 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 55;
55	0.52 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 32;
56	0.59 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`62`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 62;
57	0.62 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`63`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 63;
58	0.60 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`64`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 64;
59	0.60 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 16;
60	0.69 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 36;
61	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`56`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 56;
62	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`21`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 21;
63	0.51 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`57`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 57;
64	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`58`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 58;
65	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 17;
66	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 6;
67	0.49 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? Parameters: [`22`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5, t6.ht AS ht_7, t6.prod_type AS prod_type_8, t6.enabled AS enabled_9, t6.id AS id_10, t6.projecttool_id AS projecttool_id_11 FROM products_translation t0 LEFT JOIN products t6 ON t0.translatable_id = t6.id WHERE t0.translatable_id = 22;
68	0.50 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = ? LIMIT 1 Parameters: [`1445`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.url_prefix AS url_prefix_3, t0.url_domain AS url_domain_4, t0.template AS template_5, t0.template_favourites AS template_favourites_6, t0.template_widgets AS template_widgets_7, t0.template_settings AS template_settings_8, t0.template_updated_at AS template_updated_at_9, t0.template_custom_css AS template_custom_css_10, t0.search_enabled AS search_enabled_11, t0.feed_api_key AS feed_api_key_12, t0.project_id AS project_id_13 FROM site t0 WHERE t0.project_id = 1445 LIMIT 1;
69	0.65 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ? Parameters: [`1445 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = 1445 AND p1_.status = 1;
70	0.62 ms	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ? Parameters: [`1445 1`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = ? AND p1_.status = ? SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.always_checked AS always_checked_2, p0_.projecttool_key AS projecttool_key_3, p0_.max_size AS max_size_4, p0_.index_route AS index_route_5, p0_.enabled AS enabled_6 FROM projecttools p0_ INNER JOIN projects_projecttools p1_ ON (p0_.id = p1_.projecttool_id) INNER JOIN projects p2_ ON (p2_.id = p1_.project_id) WHERE p2_.id = 1445 AND p1_.status = 1;
71	0.95 ms	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_;
72	0.68 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, favoris_14, publish_date_5 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ?) dctrn_result_inner ORDER BY favoris_14 DESC, publish_date_5 DESC) dctrn_result LIMIT 20 Parameters: [`1445`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, favoris_14, publish_date_5 FROM ( SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ? ) dctrn_result_inner ORDER BY favoris_14 DESC, publish_date_5 DESC ) dctrn_result LIMIT 20 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, favoris_14, publish_date_5 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = 1445) dctrn_result_inner ORDER BY favoris_14 DESC, publish_date_5 DESC) dctrn_result LIMIT 20;
73	0.42 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ? ORDER BY s0_.favoris DESC, s0_.publish_date DESC) dctrn_result) dctrn_table Parameters: [`1445`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = ? ORDER BY s0_.favoris DESC, s0_.publish_date DESC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.header AS header_2, s0_.vignette AS vignette_3, s0_.contents AS contents_4, s0_.publish_date AS publish_date_5, s0_.de_publish_date AS de_publish_date_6, s0_.status AS status_7, s0_.is_temporary AS is_temporary_8, s0_.is_draft AS is_draft_9, s0_.contents_front AS contents_front_10, s0_.id_front AS id_front_11, s0_.url_vignette AS url_vignette_12, s0_.slug AS slug_13, s0_.favoris AS favoris_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16 FROM site_news s0_ WHERE s0_.project_id = 1445 ORDER BY s0_.favoris DESC, s0_.publish_date DESC) dctrn_result) dctrn_table;

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Mod	65
App\Entity\Product	61
App\Entity\ProductTranslation	61
App\Entity\Location\City	2
App\Entity\Project\Projecttool	2
App\Entity\Project\ProjectProjecttool	2
App\Entity\User	1
App\Entity\AdministratorGroup	1
App\Entity\Project\Project	1
App\Entity\Project\ProjectType	1
App\Entity\Project\Category	1
App\Entity\Project\ProjectMod	1
App\Entity\ToolSite\Site	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Location\City	No errors.
App\Entity\AdministratorGroup	No errors.
App\Entity\Project\Project	No errors.
App\Entity\UserAccess	No errors.
App\Entity\Project\ProjectType	No errors.
App\Entity\Project\Category	No errors.
App\Entity\Intercommunality	No errors.
App\Entity\Project\ProjectRefuseAttachment	No errors.
App\Entity\Project\ProjectProjecttool	No errors.
App\Entity\ToolSite\SiteModule	No errors.
App\Entity\Project\ProjectMod	No errors.
App\Entity\Project\ProjectRelation	No errors.
App\Entity\Project\ProjectContact	The field 'App\Entity\Project\ProjectContact#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type.
App\Entity\Order	No errors.
App\Entity\Historic\Contract	No errors.
App\Entity\Mod	No errors.
App\Entity\Project\Projecttool	No errors.
App\Entity\Product	No errors.
App\Entity\AbstractFile	No errors.
App\Entity\ToolSite\SiteThumbnails	No errors.
App\Entity\ToolSite\SiteFile	The field App\Entity\ToolSite\SiteFile#thumbnails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\SiteThumbnails#originalFile does not contain the required 'inversedBy="thumbnails"' attribute. The field App\Entity\ToolSite\SiteFile#attachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\Files\SiteAttachments#files does not contain the required 'inversedBy="attachments"' attribute. The field App\Entity\ToolSite\SiteFile#appFiles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\App\AppFile#originalFile does not contain the required 'inversedBy="appFiles"' attribute.
App\Entity\ToolSite\SiteNews	No errors.
App\Entity\ToolSite\Site	No errors.
App\Entity\ProductTranslation	No errors.
App\Entity\Location\Country	No errors.
App\Entity\Location\ZoneArea	No errors.
App\Entity\Location\CityTranslation	No errors.
App\Entity\AdministratorRight	No errors.
App\Entity\UserRight	No errors.
App\Entity\User\UserProfile	No errors.
App\Entity\Label	No errors.
App\Entity\Project\ProjectTypeTranslation	No errors.
App\Entity\Project\CategoryTranslation	No errors.
App\Entity\Project\ProjectFile	No errors.
App\Entity\ToolSite\SiteTab	No errors.
App\Entity\ToolSite\SiteRubric	The mappings App\Entity\ToolSite\SiteRubric#usersModulesRights and App\Entity\User\UserProfileRightRubric#rubric are inconsistent with each other.
App\Entity\ToolSite\SiteTree	The field App\Entity\ToolSite\SiteTree#section is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ToolSite\SiteTreeSection#tree does not contain the required 'inversedBy="section"' attribute.
App\Entity\OrderLine	No errors.
App\Entity\TermsOfSales	No errors.
App\Entity\OrderAttachment	No errors.
App\Entity\Quote	No errors.
App\Entity\Historic\ContractAttachment	No errors.
App\Entity\Historic\Profile	No errors.
App\Entity\ToolSite\SiteCarpooling	No errors.
App\Entity\ToolSite\SiteCarpoolingWaiting	No errors.
App\Entity\ToolSite\SiteDiary	No errors.
App\Entity\ToolSite\SiteEditorials	No errors.
App\Entity\ToolSite\SiteEventWaiting	No errors.
App\Entity\ToolSite\SiteMarket	No errors.
App\Entity\ToolSite\SiteMeta	No errors.
App\Entity\ToolSite\SiteQuestionAnswer	No errors.
App\Entity\ToolSite\SiteRentRoom	No errors.
App\Entity\ToolSite\SiteTrombi	No errors.
App\Entity\ToolSite\SiteUnes	No errors.
App\Entity\ToolSite\SiteVideo	No errors.
App\Entity\ToolSite\RestrictedArea\SitePrivateNews	No errors.
App\Entity\ToolSite\SiteAssociationBook	No errors.
App\Entity\AbstractFolder	No errors.
App\Entity\ToolSite\SiteFolderFile	No errors.
App\Entity\ToolSite\Files\SiteAttachments	No errors.
App\Entity\ToolSite\App\AppFile	No errors.
App\Entity\ToolSite\SiteJobAds	No errors.
App\Entity\Location\Zone	No errors.
App\Entity\Currency	No errors.
App\Entity\Vat	The field 'App\Entity\Vat#value' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Location\CountryTranslation	No errors.
App\Entity\Location\ZoneAreaType	No errors.
App\Entity\LabelRank	No errors.
App\Entity\LabelTranslation	No errors.
App\Entity\User\UserProfileRightRubric	The association App\Entity\User\UserProfileRightRubric#rubric refers to the inverse side field App\Entity\ToolSite\SiteRubric#usersProdulesRights which does not exist.
App\Entity\ToolSite\Content	No errors.
App\Entity\ToolSite\Shortcut	No errors.
App\Entity\ToolSite\SiteTreeSection	No errors.
App\Entity\TextData	No errors.
App\Entity\Commercial\Prospect	No errors.
App\Entity\QuoteLine	No errors.
App\Entity\Historic\ContractFile	No errors.
App\Entity\ToolSite\SiteDiaryCategory	No errors.
App\Entity\ToolSite\SiteDiaryCoordinates	No errors.
App\Entity\Location\Place	No errors.
App\Entity\ToolSite\SiteHealthBook	No errors.
App\Entity\ToolSite\SiteProfessionalBook	No errors.
App\Entity\ToolSite\SiteTerritory	No errors.
App\Entity\ToolSite\SiteTouristBook	No errors.
App\Entity\ToolSite\SiteEventCoordinates	No errors.
App\Entity\ToolSite\SiteQuestionAnswerCategory	No errors.
App\Entity\ToolSite\SiteFormManager	No errors.
App\Entity\ToolSite\SiteTrombiCategory	No errors.
App\Entity\ToolSite\RestrictedArea\SitePrivateGroup	No errors.
App\Entity\ToolSite\SiteTouristBookCategory	No errors.
App\Entity\ToolSite\SiteHealthBookCategory	No errors.
App\Entity\DomainExtension	No errors.
App\Entity\CommercialNotification	No errors.
App\Entity\MajorAccountClient	No errors.
App\Entity\CommercialNotificationAttachment	No errors.
App\Entity\AdminFile	No errors.
App\Entity\AdministratorSignature	No errors.
App\Entity\User\UserProfileRightContent	No errors.
App\Entity\User\PendingAction	No errors.
App\Entity\User\UserProfileRight	No errors.
App\Entity\Documentation	No errors.
App\Entity\AdministratorActivity	No errors.
App\Entity\Commercial\ProspectNote	No errors.
App\Entity\Commercial\OpeningSurveyResponse	No errors.
App\Entity\Commercial\ProspectToolStatus	No errors.
App\Entity\Commercial\ProspectRelation	No errors.
App\Entity\Commercial\ProspectContact	The field 'App\Entity\Commercial\ProspectContact#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type.
App\Entity\Commercial\Agenda	No errors.
App\Entity\Commercial\ProspectTool	The field 'App\Entity\Commercial\ProspectTool#type' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type. The field 'App\Entity\Commercial\ProspectTool#tool' has the property type 'string' that differs from the metadata field type 'int' returned by the 'smallint' DBAL type.
App\Entity\AdminPage	No errors.
App\Entity\PerformanceReviewPresentation	No errors.
App\Entity\DomainName	No errors.
App\Entity\Sponsorship\Affiliate	No errors.
App\Entity\Sponsorship\Invitation	No errors.
App\Entity\Sponsorship\Sponsor	No errors.
App\Entity\Sponsorship\Transfer	No errors.
App\Entity\ToolSite\SiteMarketHebdo	No errors.
App\Entity\ToolSite\SiteProfessionalBookUserSendAccount	No errors.
App\Entity\ToolSite\SiteAdvertisementsWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteOneClick	No errors.
App\Entity\ToolSite\SiteAdvertisementsUserSend	No errors.
App\Entity\ToolSite\SiteCarpoolingUserSend	No errors.
App\Entity\ToolSite\SiteOnlinePayment	No errors.
App\Entity\ToolSite\SitePublicMarkets	No errors.
App\Entity\ToolSite\SiteAdvertisementsUserSendAccount	No errors.
App\Entity\ToolSite\SiteAccessPlan	No errors.
App\Entity\ToolSite\SiteTwinning	No errors.
App\Entity\ToolSite\SiteCarpoolAdsInfo	No errors.
App\Entity\ToolSite\SiteAccessibility	No errors.
App\Entity\ToolSite\SiteTerritoryUserSend	No errors.
App\Entity\ToolSite\SiteJobAdsWaitingSend	No errors.
App\Entity\ToolSite\SiteJobAdsWaitingSendAccount	No errors.
App\Entity\ToolSite\SitePublicMarketsParameters	No errors.
App\Entity\ToolSite\SiteTerritoryWaitingSend	No errors.
App\Entity\ToolSite\SiteGeolocalizationCategory	No errors.
App\Entity\ToolSite\SiteTouristBookWaitingSend	No errors.
App\Entity\ToolSite\SiteExternalLink	No errors.
App\Entity\ToolSite\SiteAssociationBookUserSendAccount	No errors.
App\Entity\ToolSite\TemplateThemePreset	No errors.
App\Entity\ToolSite\SiteAdvertisements	The association App\Entity\ToolSite\SiteAdvertisements#backgroundImage refers to the inverse side field App\Entity\ToolSite\SiteFile#advertisements which does not exist.
App\Entity\ToolSite\SitePictureGallery	No errors.
App\Entity\ToolSite\SiteProfessionalBookWaitingSend	No errors.
App\Entity\ToolSite\SiteHealthBookWaitingSend	No errors.
App\Entity\ToolSite\SiteEventUserSendAccount	No errors.
App\Entity\ToolSite\SiteContactParameter	No errors.
App\Entity\ToolSite\SiteSocialNetwork	No errors.
App\Entity\ToolSite\SiteEventWaitingSend	No errors.
App\Entity\ToolSite\SiteProcessGuide	No errors.
App\Entity\ToolSite\SiteTerritoryUserSendAccount	No errors.
App\Entity\ToolSite\SiteHealthBookWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteAssociationBookWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteGuestBook	No errors.
App\Entity\ToolSite\SitePublicationCategory	No errors.
App\Entity\ToolSite\SiteCarpoolAds	No errors.
App\Entity\ToolSite\SiteGuestBookParameter	No errors.
App\Entity\ToolSite\SiteGuestBookUserSendAccount	No errors.
App\Entity\ToolSite\SiteShortcut	No errors.
App\Entity\ToolSite\SiteSurveyVote	No errors.
App\Entity\ToolSite\SiteMarketPunctual	No errors.
App\Entity\ToolSite\SiteLabel	No errors.
App\Entity\ToolSite\SiteAssociationBookWaitingAttachment	No errors.
App\Entity\ToolSite\SiteJobAdsUserSendAccount	No errors.
App\Entity\ToolSite\SiteRentRoomBooking	No errors.
App\Entity\ToolSite\SiteLegalNotice	No errors.
App\Entity\ToolSite\SiteForumAnswers	No errors.
App\Entity\ToolSite\SitePartnerCategory	No errors.
App\Entity\ToolSite\SiteGeolocalization	No errors.
App\Entity\ToolSite\SiteSurvey	No errors.
App\Entity\ToolSite\SiteCarpoolingUserSendAccount	No errors.
App\Entity\ToolSite\SiteReport	No errors.
App\Entity\ToolSite\SitePressClippings	No errors.
App\Entity\ToolSite\SiteAdvertisementsWaitingSend	No errors.
App\Entity\ToolSite\SiteProfessionalBookWaiting	No errors.
App\Entity\ToolSite\SiteCarpoolingWaitingSend	No errors.
App\Entity\ToolSite\SiteProfessionalBookUserSend	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetter	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetterUserAccessPending	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetterUsersSend	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetterGroup	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetterUserAccess	No errors.
App\Entity\ToolSite\NewsLetters\SiteNewsLetterParameter	No errors.
App\Entity\ToolSite\SiteShortcutType	No errors.
App\Entity\ToolSite\SitePublication	No errors.
App\Entity\ToolSite\SiteQuestionAnswerParameter	No errors.
App\Entity\ToolSite\SiteEventWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteNewsBuilderTemplate	No errors.
App\Entity\ToolSite\SiteAssociationBookEvent	No errors.
App\Entity\ToolSite\SiteJobAdsWaiting	No errors.
App\Entity\ToolSite\SiteEventUserSend	No errors.
App\Entity\ToolSite\Saisine\SiteSaisineParameter	No errors.
App\Entity\ToolSite\Saisine\SiteSaisineCategory	No errors.
App\Entity\ToolSite\Saisine\SiteSaisineRequest	No errors.
App\Entity\ToolSite\SiteTouristBookUserSendAccount	No errors.
App\Entity\ToolSite\SiteAssociationBookWaiting	No errors.
App\Entity\ToolSite\SiteAdvertisementsCategory	No errors.
App\Entity\ToolSite\SiteMessageContact	No errors.
App\Entity\ToolSite\SiteContact	No errors.
App\Entity\ToolSite\SiteBreakingNews	No errors.
App\Entity\ToolSite\SiteJobAdsUserSend	No errors.
App\Entity\ToolSite\SiteCustomWidget	No errors.
App\Entity\ToolSite\SiteGuestBookWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteSurveyAnswer	No errors.
App\Entity\ToolSite\SiteHealthBookUserSendAccount	No errors.
App\Entity\ToolSite\SiteAdvertisementsWaiting	No errors.
App\Entity\ToolSite\SiteTouristBookUserSend	No errors.
App\Entity\ToolSite\RestrictedArea\SitePrivateUserAccess	No errors.
App\Entity\ToolSite\RestrictedArea\SitePrivateParameter	No errors.
App\Entity\ToolSite\RestrictedArea\SitePrivateUserAccessPending	No errors.
App\Entity\ToolSite\SiteAssociationBookContact	No errors.
App\Entity\ToolSite\SiteHealthBookWaiting	No errors.
App\Entity\ToolSite\SiteSurveyQuestion	No errors.
App\Entity\ToolSite\SiteTouristBookWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteAssociationBookUserSend	No errors.
App\Entity\ToolSite\SiteCarpoolingWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteProfessionalBookWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteExternalLinkCategory	No errors.
App\Entity\ToolSite\SiteAssociationBookWaitingSend	No errors.
App\Entity\ToolSite\SitePartner	No errors.
App\Entity\ToolSite\SiteAlerts	No errors.
App\Entity\ToolSite\SiteTouristBookWaiting	No errors.
App\Entity\ToolSite\SiteMarketProducts	No errors.
App\Entity\ToolSite\SitePublicMarketsAwarded	No errors.
App\Entity\ToolSite\SiteTerritoryWaitingSendAccount	No errors.
App\Entity\ToolSite\SiteReportCategory	No errors.
App\Entity\ToolSite\App\AppReport	No errors.
App\Entity\ToolSite\App\AppFavorite	No errors.
App\Entity\ToolSite\App\AppPushNotificationToken	No errors.
App\Entity\ToolSite\App\AppNotification	No errors.
App\Entity\ToolSite\App\AppReportParameter	No errors.
App\Entity\ToolSite\App\AppSetting	No errors.
App\Entity\ToolSite\App\AppReportCategory	No errors.
App\Entity\ToolSite\SiteHealthBookUserSend	No errors.
App\Entity\ToolSite\SiteTerritoryWaiting	No errors.
App\Entity\ToolSite\SiteContribution	No errors.
App\Entity\ToolSite\SiteForum	No errors.
App\Entity\ToolSite\SiteTemplate	No errors.
App\Entity\Message	No errors.
App\Entity\Language	No errors.
App\Entity\OrderInstallment	No errors.
App\Entity\NotificationUser	No errors.
App\Entity\Transaction	No errors.
App\Entity\Historic\ContractRenewalNotification	No errors.
App\Entity\Historic\ContractRenewalCondition	No errors.
App\Entity\BadWord	No errors.
App\Entity\Ticketing\Order	No errors.
App\Entity\Ticketing\PlanZone	No errors.
App\Entity\Ticketing\Promoter	No errors.
App\Entity\Ticketing\Media\Folder	No errors.
App\Entity\Ticketing\Media\File	No errors.
App\Entity\Ticketing\Media\Thumbnail	No errors.
App\Entity\Ticketing\SeancePrice	The field 'App\Entity\Ticketing\SeancePrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Ticketing\Structure	No errors.
App\Entity\Ticketing\Transaction	No errors.
App\Entity\Ticketing\Cart	No errors.
App\Entity\Ticketing\ContactMessage	No errors.
App\Entity\Ticketing\PlanBuilder	No errors.
App\Entity\Ticketing\EventCategory	No errors.
App\Entity\Ticketing\CartItem	No errors.
App\Entity\Ticketing\PaymentMethod	No errors.
App\Entity\Ticketing\Ticket	No errors.
App\Entity\Ticketing\BreakingNews	No errors.
App\Entity\Ticketing\PackPriceZone	The association App\Entity\Ticketing\PackPriceZone#packPrice refers to the inverse side field App\Entity\Ticketing\PackPrice#zones which does not exist.
App\Entity\Ticketing\PackPrice	The field 'App\Entity\Ticketing\PackPrice#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\Ticketing\PackPrice#packPriceZone and App\Entity\Ticketing\PackPriceZone#packPrice are inconsistent with each other.
App\Entity\Ticketing\Outflow	The field 'App\Entity\Ticketing\Outflow#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Ticketing\Outflow#neopseFees' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Ticketing\Outflow#fixedFees' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Ticketing\Outflow#variableFees' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Ticketing\Outflow#totalFees' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Ticketing\Outflow#vat' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Ticketing\Plan	No errors.
App\Entity\Ticketing\Pack	No errors.
App\Entity\Ticketing\Seance	The field 'App\Entity\Ticketing\Seance#vat' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Ticketing\Event	No errors.
App\Entity\Ticketing\OrderItem	No errors.
App\Entity\AdminProfileRight	No errors.
App\Entity\MajorAccount	No errors.
App\Entity\OrderQuoteLine	No errors.
App\Entity\MajorAccountGain	No errors.
App\Entity\UserAccessPending	No errors.
App\Entity\RenewalRefusalSnapshot	No errors.
App\Entity\Sponsorship	The association App\Entity\Sponsorship#order refers to the inverse side field App\Entity\Order#sponsorships which does not exist.
App\Entity\MessageTranslation	No errors.
App\Entity\MajorAccountRepayment	No errors.
App\Entity\Notification	No errors.
App\Entity\Support\TicketFile	No errors.
App\Entity\Support\TicketCategory	No errors.
App\Entity\Support\TicketPredefined	No errors.
App\Entity\Support\Call	No errors.
App\Entity\Support\TicketMessage	No errors.
App\Entity\Support\TicketAttachment	No errors.
App\Entity\Support\Ticket	No errors.
App\Entity\Support\TicketMessageDraft	No errors.
App\Entity\Support\SuggestionClient	No errors.
App\Entity\Support\SuggestionClientCategory	No errors.
App\Entity\OrderType	No errors.
App\Entity\Intranet\IntranetAttachments	No errors.
App\Entity\Intranet\TopicUsersSend	No errors.
App\Entity\Intranet\IntranetThumbnails	No errors.
App\Entity\Intranet\Workgroup	No errors.
App\Entity\Intranet\Topic	No errors.
App\Entity\Intranet\WaitingTopicPost	No errors.
App\Entity\Intranet\Post	No errors.
App\Entity\Intranet\WorkgroupUser	No errors.
App\Entity\Intranet\IntranetFile	No errors.
App\Entity\Intranet\News	No errors.
App\Entity\Intranet\WaitingEvent	No errors.
App\Entity\Intranet\WaitingNews	No errors.
App\Entity\Intranet\Event	No errors.
App\Entity\Intranet\FolderFile	No errors.
App\Entity\DocumentationTranslation	The association App\Entity\DocumentationTranslation#translatable refers to the inverse side field App\Entity\Documentation#translations which does not exist.
App\Entity\DomainExtensionTranslation	No errors.
App\Entity\OrderQuote	No errors.
App\Entity\CommercialNotificationUser	No errors.
App\Entity\NotificationPreference	No errors.
App\Entity\Tag	No errors.
App\Entity\Configuration	No errors.
App\Entity\Barometer	No errors.
App\Entity\WrongEmail	No errors.
App\Entity\Administrator	No errors.
App\Entity\AdminProfile	The field App\Entity\AdminProfile#rights is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AdminProfileRight#profile does not contain the required 'inversedBy="rights"' attribute.
App\Entity\CommercialNotificationUserSend	No errors.
App\Entity\Administration\Admin\ChorusLogs	No errors.
App\Entity\Administration\Admin\Chorus	No errors.
App\Entity\Administration\Corporate\BlogPost	No errors.
App\Entity\Administration\Corporate\BlogPostAttachment	No errors.
App\Entity\Administration\Corporate\Alert	No errors.
App\Entity\Administration\Corporate\Newsletter\NewsletterUserAccessPending	No errors.
App\Entity\Administration\Corporate\Newsletter\Newsletter	No errors.
App\Entity\Administration\Corporate\Newsletter\NewsletterUserSend	No errors.
App\Entity\Administration\Corporate\Newsletter\NewsletterUserAccess	No errors.
App\Entity\Administration\Corporate\SitePlan	No errors.
App\Entity\Administration\Corporate\File	No errors.
App\Entity\Administration\Corporate\BlogPostCategory	No errors.
App\Entity\Administration\Corporate\BlogPostLink	No errors.
App\Entity\Administration\Corporate\Contact	No errors.
App\Entity\Administration\Corporate\ClientReferencePhoto	No errors.
App\Entity\Administration\Corporate\ClientReference	No errors.
App\Entity\Administration\Corporate\Template	No errors.
App\Entity\Administration\AdminNotification	No errors.
App\Entity\Communication\JournalDeBord	No errors.
App\Entity\Communication\ClientMarketingTemplate	No errors.
App\Entity\Communication\ClientMarketing	No errors.
App\Entity\Communication\FlashMessage	No errors.
App\Entity\AdministratorLoginHistory	No errors.
App\Entity\OrderInstallmentLine	No errors.
App\Entity\Location\ZoneAreaTypeTranslation	No errors.
App\Entity\WrongMailDomain	No errors.
App\Entity\Project\ProjectInterviewCeo	No errors.
App\Entity\Project\ProjectNote	No errors.
App\Entity\Project\ProjectStorage	No errors.
App\Entity\Project\CreditTemp	No errors.
App\Entity\Project\Storage	No errors.
App\Entity\Project\ProjectPoints	No errors.
App\Entity\Project\ProjectMatomo	No errors.
App\Entity\DocumentationFile	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation	No errors.
Gedmo\Translatable\Entity\Translation	No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://site.staging.neopse.com/project/1445/news

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping