| 1 |
0.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"CodeIgniterFetch"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = 'CodeIgniterFetch' LIMIT 1;
|
| 2 |
0.44 ms |
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1;
|
| 3 |
0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = 'Stripe' LIMIT 1;
|
| 4 |
0.41 ms |
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1
SELECT t0.encryption AS encryption_1, t0.id AS id_2, t0.name AS name_3, t0.maintenance AS maintenance_4, t0.address AS address_5, t0.office_ip_address AS office_ip_address_6, t0.postal_code AS postal_code_7, t0.city AS city_8, t0.email AS email_9, t0.email_password AS email_password_10, t0.email_port AS email_port_11, t0.email_smtp AS email_smtp_12, t0.password_reset_days AS password_reset_days_13, t0.has_password_reset AS has_password_reset_14, t0.phone AS phone_15, t0.helpdesk AS helpdesk_16, t0.meta_keywords AS meta_keywords_17, t0.meta_description AS meta_description_18, t0.fiscal_number AS fiscal_number_19, t0.domain AS domain_20, t0.file AS file_21, t0.coords_google_maps AS coords_google_maps_22, t0.profit_margin AS profit_margin_23, t0.first_tag_head AS first_tag_head_24, t0.first_tag_body AS first_tag_body_25, t0.last_tag_head AS last_tag_head_26, t0.license AS license_27, t0.booking_hours_advance AS booking_hours_advance_28, t0.commercial_registry_office AS commercial_registry_office_29, t0.expire_payment AS expire_payment_30 FROM company t0 LIMIT 1;
|
| 5 |
0.30 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.url AS url_4, t0.icon AS icon_5 FROM social_network t0 WHERE t0.is_active = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.url AS url_4, t0.icon AS icon_5 FROM social_network t0 WHERE t0.is_active = 1;
|
| 6 |
0.54 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = ? OR w2_.id IS NULL) AND l1_.name = ? AND w2_.is_public = ? LIMIT 1
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = 1 OR w2_.id IS NULL) AND l1_.name = 'en' AND w2_.is_public = 1 LIMIT 1;
|
| 7 |
0.41 ms |
SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.is_main_operator = ? LIMIT 1
SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.is_main_operator = 1 LIMIT 1;
|
| 8 |
0.54 ms |
SELECT l0_.id AS id_0, l0_.min AS min_1, l0_.max AS max_2, l0_.is_active AS is_active_3, l0_.is_required AS is_required_4, l0_.max_allowed AS max_allowed_5, l0_.luggage_id AS luggage_id_6, l0_.cargo_builder_id AS cargo_builder_id_7 FROM luggage_configuration l0_ INNER JOIN luggage l1_ ON l0_.luggage_id = l1_.id WHERE l0_.is_active = 1 ORDER BY l1_.position ASC
SELECT l0_.id AS id_0, l0_.min AS min_1, l0_.max AS max_2, l0_.is_active AS is_active_3, l0_.is_required AS is_required_4, l0_.max_allowed AS max_allowed_5, l0_.luggage_id AS luggage_id_6, l0_.cargo_builder_id AS cargo_builder_id_7 FROM luggage_configuration l0_ INNER JOIN luggage l1_ ON l0_.luggage_id = l1_.id WHERE l0_.is_active = 1 ORDER BY l1_.position ASC;
|
| 9 |
0.47 ms |
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.is_active AS is_active_3, p0_.is_required AS is_required_4, p0_.passenger_id AS passenger_id_5, p0_.pax_builder_id AS pax_builder_id_6 FROM passenger_configuration p0_ INNER JOIN passenger p1_ ON p0_.passenger_id = p1_.id WHERE p0_.is_active = 1 ORDER BY p1_.position ASC
SELECT p0_.id AS id_0, p0_.min AS min_1, p0_.max AS max_2, p0_.is_active AS is_active_3, p0_.is_required AS is_required_4, p0_.passenger_id AS passenger_id_5, p0_.pax_builder_id AS pax_builder_id_6 FROM passenger_configuration p0_ INNER JOIN passenger p1_ ON p0_.passenger_id = p1_.id WHERE p0_.is_active = 1 ORDER BY p1_.position ASC;
|
| 10 |
0.50 ms |
SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.is_required AS is_required_2, b0_.box_id AS box_id_3, b0_.cargo_builder_id AS cargo_builder_id_4 FROM box_configuration b0_ INNER JOIN box b1_ ON b0_.box_id = b1_.id WHERE b0_.is_active = 1 ORDER BY b1_.position ASC
SELECT b0_.id AS id_0, b0_.is_active AS is_active_1, b0_.is_required AS is_required_2, b0_.box_id AS box_id_3, b0_.cargo_builder_id AS cargo_builder_id_4 FROM box_configuration b0_ INNER JOIN box b1_ ON b0_.box_id = b1_.id WHERE b0_.is_active = 1 ORDER BY b1_.position ASC;
|
| 11 |
0.39 ms |
SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.id = ? LIMIT 1
SELECT t0.id AS id_1, t0.file AS file_2, t0.name AS name_3, t0.email_booking AS email_booking_4, t0.email_financial AS email_financial_5, t0.phone_booking AS phone_booking_6, t0.phone_financial AS phone_financial_7, t0.domain AS domain_8, t0.markup AS markup_9, t0.percentage AS percentage_10, t0.is_yft_money_collect AS is_yft_money_collect_11, t0.invoicing AS invoicing_12, t0.is_client_account AS is_client_account_13, t0.comment AS comment_14, t0.is_voucher_operator_required AS is_voucher_operator_required_15, t0.is_main_operator AS is_main_operator_16, t0.code_igniter_id AS code_igniter_id_17, t0.pickup_time_slot AS pickup_time_slot_18, t0.has_main_season AS has_main_season_19, t0.user_id AS user_id_20 FROM operator t0 WHERE t0.id = 1 LIMIT 1;
|
| 12 |
0.24 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = 2;
|
| 13 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = 2;
|
| 14 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.id = 1;
|
| 15 |
0.24 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = 1;
|
| 16 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = 1;
|
| 17 |
0.24 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4, t0.configuration_id AS configuration_id_5 FROM passenger t0 WHERE t0.id = 3;
|
| 18 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale_id AS locale_id_4, t0.passenger_id AS passenger_id_5 FROM passenger_translation t0 WHERE t0.passenger_id = 3;
|
| 19 |
0.23 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 2;
|
| 20 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 2;
|
| 21 |
0.25 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 3;
|
| 22 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 3;
|
| 23 |
0.24 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 11;
|
| 24 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 11;
|
| 25 |
0.21 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 5;
|
| 26 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 5;
|
| 27 |
0.23 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 6;
|
| 28 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 6;
|
| 29 |
0.24 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 7;
|
| 30 |
0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 7;
|
| 31 |
0.25 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 8;
|
| 32 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 8;
|
| 33 |
0.23 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 9;
|
| 34 |
0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 9;
|
| 35 |
0.23 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.reference AS reference_3, t0.position AS position_4 FROM luggage t0 WHERE t0.id = 10;
|
| 36 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.luggage_id AS luggage_id_4 FROM luggage_translation t0 WHERE t0.luggage_id = 10;
|
| 37 |
0.26 ms |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4 FROM box t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.position AS position_3, t0.reference AS reference_4 FROM box t0 WHERE t0.id = 1;
|
| 38 |
0.36 ms |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.box_id AS box_id_3 FROM box_option t0 WHERE t0.box_id = ?
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.box_id AS box_id_3 FROM box_option t0 WHERE t0.box_id = 1;
|
| 39 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_id AS box_id_4 FROM box_translation t0 WHERE t0.box_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_id AS box_id_4 FROM box_translation t0 WHERE t0.box_id = 1;
|
| 40 |
0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 1;
|
| 41 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 2;
|
| 42 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 3;
|
| 43 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 4;
|
| 44 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 5;
|
| 45 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale_id AS locale_id_3, t0.box_option_id AS box_option_id_4 FROM box_option_translation t0 WHERE t0.box_option_id = 6;
|
| 46 |
0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.is_frontend_active = ? ORDER BY t0.is_favorite DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_backend_active AS is_backend_active_3, t0.is_frontend_active AS is_frontend_active_4, t0.is_favorite AS is_favorite_5, t0.alias AS alias_6, t0.moloni_language_id AS moloni_language_id_7 FROM locale t0 WHERE t0.is_frontend_active = 1 ORDER BY t0.is_favorite DESC;
|
| 47 |
0.44 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.reference = ? AND p1_.is_active = ? AND p0_.is_active = ? ORDER BY p0_.position ASC
Parameters: [
"home"
1
1
]
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.reference = 'home' AND p1_.is_active = 1 AND p0_.is_active = 1 ORDER BY p0_.position ASC;
|
| 48 |
0.39 ms |
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.reference = ? AND p1_.is_active = ? AND p0_.is_active = ? ORDER BY p0_.position ASC
Parameters: [
"footer"
1
1
]
SELECT p0_.id AS id_0, p0_.is_active AS is_active_1, p0_.is_mobile_active AS is_mobile_active_2, p0_.file AS file_3, p0_.position AS position_4, p0_.file_in_banner AS file_in_banner_5, p0_.page_id AS page_id_6 FROM page_template p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p1_.reference = 'footer' AND p1_.is_active = 1 AND p0_.is_active = 1 ORDER BY p0_.position ASC;
|
| 49 |
8.85 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_ INNER JOIN course c1_ ON (c1_.from_id = l0_.id OR c1_.to_id = l0_.id) WHERE l0_.is_active = 1 AND l0_.is_online = 1 AND c1_.is_active = 1 AND c1_.is_online = 1 ORDER BY l0_.is_favorite DESC, l0_.position ASC, l0_.name ASC
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_ INNER JOIN course c1_ ON (c1_.from_id = l0_.id OR c1_.to_id = l0_.id) WHERE l0_.is_active = 1 AND l0_.is_online = 1 AND c1_.is_active = 1 AND c1_.is_online = 1 ORDER BY l0_.is_favorite DESC, l0_.position ASC, l0_.name ASC;
|
| 50 |
0.50 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.zone AS zone_2, l0_.coordinates AS coordinates_3, l0_.is_airport AS is_airport_4, l0_.is_online AS is_online_5, l0_.is_active AS is_active_6, l0_.check_in_time AS check_in_time_7, l0_.is_favorite AS is_favorite_8, l0_.position AS position_9, l0_.type AS type_10, l0_.iso AS iso_11 FROM location l0_;
|
| 51 |
0.34 ms |
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.percentage AS percentage_2, t0_.position AS position_3, t0_.is_active AS is_active_4 FROM trip_option t0_ WHERE t0_.is_active = 1 ORDER BY t0_.position ASC
SELECT t0_.id AS id_0, t0_.reference AS reference_1, t0_.percentage AS percentage_2, t0_.position AS position_3, t0_.is_active AS is_active_4 FROM trip_option t0_ WHERE t0_.is_active = 1 ORDER BY t0_.position ASC;
|
| 52 |
0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.trip_option_id AS trip_option_id_4, t0.locale_id AS locale_id_5 FROM trip_option_translation t0 WHERE t0.trip_option_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.trip_option_id AS trip_option_id_4, t0.locale_id AS locale_id_5 FROM trip_option_translation t0 WHERE t0.trip_option_id = 1;
|
| 53 |
3.11 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = 3;
|
| 54 |
2.06 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = 4;
|
| 55 |
0.34 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = 6;
|
| 56 |
0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.locale_id AS locale_id_4, t0.page_template_id AS page_template_id_5 FROM page_template_translation t0 WHERE t0.page_template_id = 5;
|