27.16 ms
(65.91%)
|
1 |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY RAND() ASC LIMIT 3
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.publish_at AS publish_at_4, p0_.type AS type_5, p0_.display AS display_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.image_id AS image_id_9, p0_.area_id AS area_id_10 FROM publication p0_ LEFT JOIN area a1_ ON p0_.area_id = a1_.id AND (a1_.region_id = '1') WHERE p0_.type = 'promotion' AND p0_.display = 1 AND (a1_.id IS NULL OR (a1_.paid = 1 AND a1_.display = 1)) ORDER BY RAND() ASC LIMIT 3;
|
11.43 ms
(27.74%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.publish_at AS publish_at_5, t0.type AS type_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image_id AS image_id_10, t0.area_id AS area_id_11 FROM publication t0 WHERE t0.slug = ? AND t0.type = ? AND t0.display = ? LIMIT 1
Parameters: [
"voskresnye-master-klassy-v-casa-agave-2"
"promotion"
1
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.publish_at AS publish_at_5, t0.type AS type_6, t0.display AS display_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.image_id AS image_id_10, t0.area_id AS area_id_11 FROM publication t0 WHERE t0.slug = 'voskresnye-master-klassy-v-casa-agave-2' AND t0.type = 'promotion' AND t0.display = 1 LIMIT 1;
|
0.64 ms
(1.55%)
|
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1') ORDER BY RAND() ASC) dctrn_result) dctrn_table
SELECT
COUNT(*) AS dctrn_count
FROM
(
SELECT
DISTINCT id_0
FROM
(
SELECT
a0_.id AS id_0,
a0_.enabled_at AS enabled_at_1,
a0_.disabled_at AS disabled_at_2,
a0_.recommended AS recommended_3,
a0_.best_for_wedding AS best_for_wedding_4,
a0_.best_for_corporate AS best_for_corporate_5,
a0_.created_at AS created_at_6,
a0_.updated_at AS updated_at_7,
a1_.id AS id_8,
a1_.name AS name_9,
a1_.slug AS slug_10,
a1_.email AS email_11,
a1_.site AS site_12,
a1_.you_tube_movie AS you_tube_movie_13,
a1_.description AS description_14,
a1_.manager_info AS manager_info_15,
a1_.contact_info AS contact_info_16,
a1_.closing_condition AS closing_condition_17,
a1_.closing_condition_comment AS closing_condition_comment_18,
a1_.address AS address_19,
a1_.latitude AS latitude_20,
a1_.longitude AS longitude_21,
a1_.expired_at AS expired_at_22,
a1_.placement_period AS placement_period_23,
a1_.placement_date AS placement_date_24,
a1_.min_price AS min_price_25,
a1_.min_capacity AS min_capacity_26,
a1_.max_capacity AS max_capacity_27,
a1_.view AS view_28,
a1_.phone_view AS phone_view_29,
a1_.site_view AS site_view_30,
a1_.address_view AS address_view_31,
a1_.booking_count AS booking_count_32,
a1_.award_participating AS award_participating_33,
a1_.paid AS paid_34,
a1_.display AS display_35,
a1_.created_at AS created_at_36,
a1_.updated_at AS updated_at_37,
f2_.id AS id_38,
f2_.title AS title_39,
f2_.slug AS slug_40,
f2_.genitive_title AS genitive_title_41,
f2_.dative_title AS dative_title_42,
f2_.accusative_title AS accusative_title_43,
f2_.instrumental_title AS instrumental_title_44,
f2_.prepositional_title AS prepositional_title_45,
f2_.created_at AS created_at_46,
f2_.updated_at AS updated_at_47
FROM
advertising_top a0_
INNER JOIN area a1_ ON a0_.area_id = a1_.id
AND (a1_.region_id = '1')
INNER JOIN region r3_ ON a0_.region_id = r3_.id
LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id
LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id
LEFT JOIN file f5_ ON a1_.image_id = f5_.id
LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id
LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id
WHERE
(
a0_.enabled_at < NOW()
AND a0_.disabled_at > NOW()
AND a0_.recommended = 1
)
AND (a0_.region_id = '1')
ORDER BY
RAND() ASC
) dctrn_result
) dctrn_table
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1') ORDER BY RAND() ASC) dctrn_result) dctrn_table;
|
0.40 ms
(0.98%)
|
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0 WHERE t0.slug = 'msk' LIMIT 1;
|
0.40 ms
(0.97%)
|
1 |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1')) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 8
SELECT
DISTINCT id_0
FROM
(
SELECT
DISTINCT id_0,
RAND()
FROM
(
SELECT
a0_.id AS id_0,
a0_.enabled_at AS enabled_at_1,
a0_.disabled_at AS disabled_at_2,
a0_.recommended AS recommended_3,
a0_.best_for_wedding AS best_for_wedding_4,
a0_.best_for_corporate AS best_for_corporate_5,
a0_.created_at AS created_at_6,
a0_.updated_at AS updated_at_7,
a1_.id AS id_8,
a1_.name AS name_9,
a1_.slug AS slug_10,
a1_.email AS email_11,
a1_.site AS site_12,
a1_.you_tube_movie AS you_tube_movie_13,
a1_.description AS description_14,
a1_.manager_info AS manager_info_15,
a1_.contact_info AS contact_info_16,
a1_.closing_condition AS closing_condition_17,
a1_.closing_condition_comment AS closing_condition_comment_18,
a1_.address AS address_19,
a1_.latitude AS latitude_20,
a1_.longitude AS longitude_21,
a1_.expired_at AS expired_at_22,
a1_.placement_period AS placement_period_23,
a1_.placement_date AS placement_date_24,
a1_.min_price AS min_price_25,
a1_.min_capacity AS min_capacity_26,
a1_.max_capacity AS max_capacity_27,
a1_.view AS view_28,
a1_.phone_view AS phone_view_29,
a1_.site_view AS site_view_30,
a1_.address_view AS address_view_31,
a1_.booking_count AS booking_count_32,
a1_.award_participating AS award_participating_33,
a1_.paid AS paid_34,
a1_.display AS display_35,
a1_.created_at AS created_at_36,
a1_.updated_at AS updated_at_37,
f2_.id AS id_38,
f2_.title AS title_39,
f2_.slug AS slug_40,
f2_.genitive_title AS genitive_title_41,
f2_.dative_title AS dative_title_42,
f2_.accusative_title AS accusative_title_43,
f2_.instrumental_title AS instrumental_title_44,
f2_.prepositional_title AS prepositional_title_45,
f2_.created_at AS created_at_46,
f2_.updated_at AS updated_at_47
FROM
advertising_top a0_
INNER JOIN area a1_ ON a0_.area_id = a1_.id
AND (a1_.region_id = '1')
INNER JOIN region r3_ ON a0_.region_id = r3_.id
LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id
LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id
LEFT JOIN file f5_ ON a1_.image_id = f5_.id
LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id
LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id
WHERE
(
a0_.enabled_at < NOW()
AND a0_.disabled_at > NOW()
AND a0_.recommended = 1
)
AND (a0_.region_id = '1')
) dctrn_result_inner
ORDER BY
RAND() ASC
) dctrn_result
LIMIT
8
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, RAND() FROM (SELECT a0_.id AS id_0, a0_.enabled_at AS enabled_at_1, a0_.disabled_at AS disabled_at_2, a0_.recommended AS recommended_3, a0_.best_for_wedding AS best_for_wedding_4, a0_.best_for_corporate AS best_for_corporate_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.name AS name_9, a1_.slug AS slug_10, a1_.email AS email_11, a1_.site AS site_12, a1_.you_tube_movie AS you_tube_movie_13, a1_.description AS description_14, a1_.manager_info AS manager_info_15, a1_.contact_info AS contact_info_16, a1_.closing_condition AS closing_condition_17, a1_.closing_condition_comment AS closing_condition_comment_18, a1_.address AS address_19, a1_.latitude AS latitude_20, a1_.longitude AS longitude_21, a1_.expired_at AS expired_at_22, a1_.placement_period AS placement_period_23, a1_.placement_date AS placement_date_24, a1_.min_price AS min_price_25, a1_.min_capacity AS min_capacity_26, a1_.max_capacity AS max_capacity_27, a1_.view AS view_28, a1_.phone_view AS phone_view_29, a1_.site_view AS site_view_30, a1_.address_view AS address_view_31, a1_.booking_count AS booking_count_32, a1_.award_participating AS award_participating_33, a1_.paid AS paid_34, a1_.display AS display_35, a1_.created_at AS created_at_36, a1_.updated_at AS updated_at_37, f2_.id AS id_38, f2_.title AS title_39, f2_.slug AS slug_40, f2_.genitive_title AS genitive_title_41, f2_.dative_title AS dative_title_42, f2_.accusative_title AS accusative_title_43, f2_.instrumental_title AS instrumental_title_44, f2_.prepositional_title AS prepositional_title_45, f2_.created_at AS created_at_46, f2_.updated_at AS updated_at_47 FROM advertising_top a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id AND (a1_.region_id = '1') INNER JOIN region r3_ ON a0_.region_id = r3_.id LEFT JOIN filter_metro_area f4_ ON a1_.id = f4_.area_id LEFT JOIN filter_metro f2_ ON f2_.id = f4_.filter_metro_id LEFT JOIN file f5_ ON a1_.image_id = f5_.id LEFT JOIN file f6_ ON a1_.appearance_image_id = f6_.id LEFT JOIN file f7_ ON a1_.interior_image_id = f7_.id WHERE (a0_.enabled_at < NOW() AND a0_.disabled_at > NOW() AND a0_.recommended = 1) AND (a0_.region_id = '1')) dctrn_result_inner ORDER BY RAND() ASC) dctrn_result LIMIT 8;
|
0.35 ms
(0.84%)
|
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.link AS link_2, a0_.display AS display_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, f1_.id AS id_6, f1_.hash AS hash_7, f1_.path AS path_8, f1_.link AS link_9, f1_.name AS name_10, f1_.file_name AS file_name_11, f1_.mime_type AS mime_type_12, f1_.size AS size_13, f1_.created_at AS created_at_14, f1_.updated_at AS updated_at_15, a0_.image_id AS image_id_16 FROM advertising_homepage_tag a0_ LEFT JOIN file f1_ ON a0_.image_id = f1_.id WHERE a0_.display = 1 ORDER BY RAND() ASC LIMIT 14;
|
0.28 ms
(0.67%)
|
1 |
SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = ? LIMIT 1
Parameters: [
"/msk/publication/promotion/voskresnye-master-klassy-v-casa-agave-2"
]
SELECT t0.id AS id_1, t0.link AS link_2, t0.title AS title_3, t0.h1 AS h1_4, t0.keywords AS keywords_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM seo_static_meta t0 WHERE t0.link = '/msk/publication/promotion/voskresnye-master-klassy-v-casa-agave-2' LIMIT 1;
|
0.19 ms
(0.45%)
|
1 |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.path AS path_3, t0.link AS link_4, t0.name AS name_5, t0.file_name AS file_name_6, t0.mime_type AS mime_type_7, t0.size AS size_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM file t0 WHERE t0.id = 25241;
|
0.13 ms
(0.30%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = ? LIMIT 1
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.archive AS archive_4, t0.about AS about_5, t0.destinations AS destinations_6, t0.start AS start_7, t0.end AS end_8, t0.application_end AS application_end_9, t0.voting_start AS voting_start_10, t0.voting_end AS voting_end_11, t0.create_short_list_start AS create_short_list_start_12, t0.create_short_list_end AS create_short_list_end_13, t0.adjudicator_voting_start AS adjudicator_voting_start_14, t0.adjudicator_voting_end AS adjudicator_voting_end_15, t0.rewarding AS rewarding_16, t0.phone AS phone_17, t0.email AS email_18, t0.whats_app AS whats_app_19, t0.website AS website_20, t0.position AS position_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.about_image_id AS about_image_id_24, t0.destinations_image_id AS destinations_image_id_25, t0.stages_image_id AS stages_image_id_26, t0.banner_image_id AS banner_image_id_27, t0.presentation_id AS presentation_id_28, t0.regulations_id AS regulations_id_29 FROM award t0 WHERE t0.active = 1 LIMIT 1;
|
0.12 ms
(0.30%)
|
1 |
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_
SELECT a0_.id AS id_0, a0_.code AS code_1, a0_.name AS name_2, a0_.description AS description_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.event_id AS event_id_6 FROM area_event_selection a0_;
|
0.12 ms
(0.28%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.genitive_title AS genitive_title_4, t0.dative_title AS dative_title_5, t0.accusative_title AS accusative_title_6, t0.instrumental_title AS instrumental_title_7, t0.prepositional_title AS prepositional_title_8, t0.default AS default_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM region t0;
|