Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Location`.`id`, `Location`.`legacy_id`, `Location`.`status`, `Location`.`name`, `Location`.`address`, `Location`.`address_2`, `Location`.`city`, `Location`.`state_code`, `Location`.`postal_code`, `Location`.`country_code`, `Location`.`timezone`, `Location`.`phone`, `Location`.`contact_franchisees`, `Location`.`contact_emails`, `Location`.`latitude`, `Location`.`longitude`, `Location`.`instagram_location_id`, `Location`.`paytronix_id`, `Location`.`catering`, `Location`.`purees`, `Location`.`sauces`, `Location`.`hours_json`, `Location`.`handles`, `Location`.`flavors`, `Location`.`previous_flavors`, `Location`.`did_set_flavors`, `Location`.`flavors_last_updated`, `Location`.`legacy_hours`, `Location`.`formatted_hours`, `Location`.`hours_status`, `Location`.`hours_message`, `Location`.`promo`, `Location`.`blendable_creations`, `Location`.`drinkable_creations`, `Location`.`smoothies`, `Location`.`ice_cream_cones`, `Location`.`baked_goods`, `Location`.`olo_identifier`, `Location`.`uber_eats_delivery`, `Location`.`doordash_identifier`, `Location`.`postmates_identifier`, `Location`.`uber_eats_identifier`, `Location`.`grubhub_identifier`, `Location`.`ezcater_identifier`, `Location`.`postmates_curbside_pickup`, `Location`.`fundraisers`, `Location`.`unavailable_fundraiser_dates`, `Location`.`bulk_unavailable_dates`, `Location`.`created`, `Location`.`modified`, `Location`.`holiday_message`, `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified`, `ModeratedImage`.`id`, `ModeratedImage`.`parent_id`, `ModeratedImage`.`model`, `ModeratedImage`.`model_id`, `ModeratedImage`.`extension`, `ModeratedImage`.`tag`, `ModeratedImage`.`caption_1`, `ModeratedImage`.`name`, `ModeratedImage`.`size`, `ModeratedImage`.`type`, `ModeratedImage`.`uri`, `ModeratedImage`.`order`, `ModeratedImage`.`created`, `ModeratedImage`.`modified` FROM `yogurtlandstage`.`locations` AS `Location` LEFT JOIN `yogurtlandstage`.`assets` AS `Image` ON (`Image`.`model_id` = `Location`.`id` AND `Image`.`model` = 'Location' AND `Image`.`tag` = 'Image') LEFT JOIN `yogurtlandstage`.`assets` AS `ModeratedImage` ON (`ModeratedImage`.`model_id` = `Location`.`id` AND `ModeratedImage`.`model` = 'Location' AND `ModeratedImage`.`tag` = 'ModeratedImage') WHERE `Location`.`id` = 1376 LIMIT 1 | 1 | 1 | 1 | |
SELECT `Fundraiser`.`id`, `Fundraiser`.`location_paytronix_id`, `Fundraiser`.`location_id`, `Fundraiser`.`status`, `Fundraiser`.`org_name`, `Fundraiser`.`tax_id_number`, `Fundraiser`.`file_tax_id_uri`, `Fundraiser`.`org_details`, `Fundraiser`.`first_name`, `Fundraiser`.`last_name`, `Fundraiser`.`email`, `Fundraiser`.`phone`, `Fundraiser`.`address_street`, `Fundraiser`.`address_city`, `Fundraiser`.`address_state`, `Fundraiser`.`address_zip`, `Fundraiser`.`event_date`, `Fundraiser`.`start_time`, `Fundraiser`.`end_time`, `Fundraiser`.`donation_percentage`, `Fundraiser`.`total_sales`, `Fundraiser`.`denied_reason`, `Fundraiser`.`last_reminded_date`, `Fundraiser`.`est_attendance`, `Fundraiser`.`created`, `Fundraiser`.`modified` FROM `yogurtlandstage`.`fundraisers` AS `Fundraiser` WHERE `Fundraiser`.`location_id` = (1376) | 0 | 0 | 3 | maybe slow |
SELECT `Flavor`.`id`, `Flavor`.`archived`, `Flavor`.`featured`, `Flavor`.`category_id`, `Flavor`.`on_promotion`, `Flavor`.`favorite_count`, `Flavor`.`name`, `Flavor`.`description`, `Flavor`.`calories`, `Flavor`.`carbohydrates`, `Flavor`.`protein`, `Flavor`.`fat_calories`, `Flavor`.`fat_grams`, `Flavor`.`saturated_fat_grams`, `Flavor`.`trans_fat_grams`, `Flavor`.`cholesterol_milligrams`, `Flavor`.`fiber_grams`, `Flavor`.`sugar_grams`, `Flavor`.`vitamin_a_percent_dv`, `Flavor`.`vitamin_c_percent_dv`, `Flavor`.`calcium_percent_dv`, `Flavor`.`iron_percent_dv`, `Flavor`.`real_content`, `Flavor`.`legacy_real_content`, `Flavor`.`ingredients`, `Flavor`.`live_and_active_cultures`, `Flavor`.`cultures`, `Flavor`.`contains`, `Flavor`.`phenylketonurics`, `Flavor`.`paytronix_id`, `Flavor`.`new_expiration`, `Flavor`.`promo_color`, `Flavor`.`promo_treatment`, `Flavor`.`promo_background_type`, `Flavor`.`created`, `Flavor`.`modified`, `FlavorsLocation`.`id`, `FlavorsLocation`.`flavor_id`, `FlavorsLocation`.`location_id` FROM `yogurtlandstage`.`flavors` AS `Flavor` JOIN `yogurtlandstage`.`flavors_locations` AS `FlavorsLocation` ON (`FlavorsLocation`.`location_id` = 1376 AND `FlavorsLocation`.`flavor_id` = `Flavor`.`id`) WHERE `Flavor`.`archived` = '0' ORDER BY (`Flavor`.`featured` = 1 AND `Flavor`.`on_promotion` = 1) DESC, (`Flavor`.`featured` = 0 AND `Flavor`.`on_promotion` = 1) DESC, (`Flavor`.`featured` = 1 AND `Flavor`.`on_promotion` = 0) DESC, `Flavor`.`favorite_count` DESC | 14 | 14 | 1 | maybe slow |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`name`, `Category`.`nutrition_info`, `Category`.`created`, `Category`.`modified` FROM `yogurtlandstage`.`categories` AS `Category` WHERE `Category`.`id` = 1 | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 125 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 139 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 1006 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 137 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 146 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 106 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 144 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 1504 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 129 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 110 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 1050 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 123 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 4840 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `Image`.`id`, `Image`.`parent_id`, `Image`.`model`, `Image`.`model_id`, `Image`.`extension`, `Image`.`tag`, `Image`.`caption_1`, `Image`.`name`, `Image`.`size`, `Image`.`type`, `Image`.`uri`, `Image`.`order`, `Image`.`created`, `Image`.`modified` FROM `yogurtlandstage`.`assets` AS `Image` WHERE `Image`.`model_id` = 2820 AND `Image`.`model` = 'Flavor' AND `Image`.`tag` = 'Image' | 1 | 1 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 125 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 139 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 1006 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 137 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 146 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 106 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 144 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 1504 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 129 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 110 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 1050 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 123 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 4840 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoImage`.`id`, `PromoImage`.`parent_id`, `PromoImage`.`model`, `PromoImage`.`model_id`, `PromoImage`.`extension`, `PromoImage`.`tag`, `PromoImage`.`caption_1`, `PromoImage`.`name`, `PromoImage`.`size`, `PromoImage`.`type`, `PromoImage`.`uri`, `PromoImage`.`order`, `PromoImage`.`created`, `PromoImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoImage` WHERE `PromoImage`.`model_id` = 2820 AND `PromoImage`.`model` = 'Flavor' AND `PromoImage`.`tag` = 'PromoImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 125 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 139 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 1006 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 137 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 146 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 106 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 144 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 1504 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 129 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 110 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 1050 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 123 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 4840 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `PromoBackgroundImage`.`id`, `PromoBackgroundImage`.`parent_id`, `PromoBackgroundImage`.`model`, `PromoBackgroundImage`.`model_id`, `PromoBackgroundImage`.`extension`, `PromoBackgroundImage`.`tag`, `PromoBackgroundImage`.`caption_1`, `PromoBackgroundImage`.`name`, `PromoBackgroundImage`.`size`, `PromoBackgroundImage`.`type`, `PromoBackgroundImage`.`uri`, `PromoBackgroundImage`.`order`, `PromoBackgroundImage`.`created`, `PromoBackgroundImage`.`modified` FROM `yogurtlandstage`.`assets` AS `PromoBackgroundImage` WHERE `PromoBackgroundImage`.`model_id` = 2820 AND `PromoBackgroundImage`.`model` = 'Flavor' AND `PromoBackgroundImage`.`tag` = 'PromoBackgroundImage' | 0 | 0 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 125 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 139 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 1006 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 137 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 146 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 106 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 144 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 1504 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 129 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 110 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 1050 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 123 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 4840 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `LegacyNutrition`.`id`, `LegacyNutrition`.`parent_id`, `LegacyNutrition`.`model`, `LegacyNutrition`.`model_id`, `LegacyNutrition`.`extension`, `LegacyNutrition`.`tag`, `LegacyNutrition`.`caption_1`, `LegacyNutrition`.`name`, `LegacyNutrition`.`size`, `LegacyNutrition`.`type`, `LegacyNutrition`.`uri`, `LegacyNutrition`.`order`, `LegacyNutrition`.`created`, `LegacyNutrition`.`modified` FROM `yogurtlandstage`.`assets` AS `LegacyNutrition` WHERE `LegacyNutrition`.`model_id` = 2820 AND `LegacyNutrition`.`model` = 'Flavor' AND `LegacyNutrition`.`tag` = 'LegacyNutrition' | 1 | 1 | 0 | |
SELECT `Ingredient`.`id`, `Ingredient`.`archived`, `Ingredient`.`name`, `Ingredient`.`created`, `Ingredient`.`modified`, `FlavorsIngredient`.`id`, `FlavorsIngredient`.`flavor_id`, `FlavorsIngredient`.`ingredient_id`, `FlavorsIngredient`.`order` FROM `yogurtlandstage`.`ingredients` AS `Ingredient` JOIN `yogurtlandstage`.`flavors_ingredients` AS `FlavorsIngredient` ON (`FlavorsIngredient`.`flavor_id` IN (125, 139, 1006, 137, 146, 106, 144, 1504, 129, 110, 1050, 123, 4840, 2820) AND `FlavorsIngredient`.`ingredient_id` = `Ingredient`.`id`) WHERE `Ingredient`.`archived` = '0' | 13 | 13 | 0 | |
SELECT `PrimaryAttribute`.`id`, `PrimaryAttribute`.`archived`, `PrimaryAttribute`.`name`, `PrimaryAttribute`.`type`, `PrimaryAttribute`.`searchable`, `PrimaryAttribute`.`inverted_searchable`, `PrimaryAttribute`.`inverted_name`, `PrimaryAttribute`.`locked`, `PrimaryAttribute`.`created`, `PrimaryAttribute`.`modified`, `FlavorsAttribute`.`id`, `FlavorsAttribute`.`flavor_id`, `FlavorsAttribute`.`attribute_id` FROM `yogurtlandstage`.`attributes` AS `PrimaryAttribute` JOIN `yogurtlandstage`.`flavors_attributes` AS `FlavorsAttribute` ON (`FlavorsAttribute`.`flavor_id` IN (125, 139, 1006, 137, 146, 106, 144, 1504, 129, 110, 1050, 123, 4840, 2820) AND `FlavorsAttribute`.`attribute_id` = `PrimaryAttribute`.`id`) WHERE `PrimaryAttribute`.`archived` = '0' AND `PrimaryAttribute`.`type` = 'Primary' | 15 | 15 | 1 | maybe slow |
SELECT `SecondaryAttribute`.`id`, `SecondaryAttribute`.`archived`, `SecondaryAttribute`.`name`, `SecondaryAttribute`.`type`, `SecondaryAttribute`.`searchable`, `SecondaryAttribute`.`inverted_searchable`, `SecondaryAttribute`.`inverted_name`, `SecondaryAttribute`.`locked`, `SecondaryAttribute`.`created`, `SecondaryAttribute`.`modified`, `FlavorsAttribute`.`id`, `FlavorsAttribute`.`flavor_id`, `FlavorsAttribute`.`attribute_id` FROM `yogurtlandstage`.`attributes` AS `SecondaryAttribute` JOIN `yogurtlandstage`.`flavors_attributes` AS `FlavorsAttribute` ON (`FlavorsAttribute`.`flavor_id` IN (125, 139, 1006, 137, 146, 106, 144, 1504, 129, 110, 1050, 123, 4840, 2820) AND `FlavorsAttribute`.`attribute_id` = `SecondaryAttribute`.`id`) WHERE `SecondaryAttribute`.`archived` = '0' AND `SecondaryAttribute`.`type` = 'Secondary' | 67 | 67 | 1 | |
SELECT `OtherAttribute`.`id`, `OtherAttribute`.`archived`, `OtherAttribute`.`name`, `OtherAttribute`.`type`, `OtherAttribute`.`searchable`, `OtherAttribute`.`inverted_searchable`, `OtherAttribute`.`inverted_name`, `OtherAttribute`.`locked`, `OtherAttribute`.`created`, `OtherAttribute`.`modified`, `FlavorsAttribute`.`id`, `FlavorsAttribute`.`flavor_id`, `FlavorsAttribute`.`attribute_id` FROM `yogurtlandstage`.`attributes` AS `OtherAttribute` JOIN `yogurtlandstage`.`flavors_attributes` AS `FlavorsAttribute` ON (`FlavorsAttribute`.`flavor_id` IN (125, 139, 1006, 137, 146, 106, 144, 1504, 129, 110, 1050, 123, 4840, 2820) AND `FlavorsAttribute`.`attribute_id` = `OtherAttribute`.`id`) WHERE `OtherAttribute`.`archived` = '0' AND `OtherAttribute`.`type` = 'None' | 14 | 14 | 0 | |
SELECT `User`.`id`, `User`.`legacy_id`, `User`.`type`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`password`, `User`.`recover_hash`, `User`.`invite_hash`, `User`.`invited`, `User`.`receive_flavor_reminder_emails`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, `LocationsUser`.`id`, `LocationsUser`.`location_id`, `LocationsUser`.`user_id` FROM `yogurtlandstage`.`users` AS `User` JOIN `yogurtlandstage`.`locations_users` AS `LocationsUser` ON (`LocationsUser`.`location_id` = 1376 AND `LocationsUser`.`user_id` = `User`.`id`) | 0 | 0 | 0 | |
SELECT `Puree`.`id`, `Puree`.`name`, `Puree`.`description`, `Puree`.`calories`, `Puree`.`carbohydrates`, `Puree`.`protein`, `Puree`.`ingredients`, `Puree`.`contains`, `Puree`.`created`, `Puree`.`modified`, `LocationsPuree`.`id`, `LocationsPuree`.`location_id`, `LocationsPuree`.`puree_id` FROM `yogurtlandstage`.`purees` AS `Puree` JOIN `yogurtlandstage`.`locations_purees` AS `LocationsPuree` ON (`LocationsPuree`.`location_id` = 1376 AND `LocationsPuree`.`puree_id` = `Puree`.`id`) | 0 | 0 | 0 | |
SELECT `Sauce`.`id`, `Sauce`.`name`, `Sauce`.`description`, `Sauce`.`calories`, `Sauce`.`carbohydrates`, `Sauce`.`protein`, `Sauce`.`ingredients`, `Sauce`.`contains`, `Sauce`.`created`, `Sauce`.`modified`, `LocationsSauce`.`id`, `LocationsSauce`.`location_id`, `LocationsSauce`.`sauce_id` FROM `yogurtlandstage`.`sauces` AS `Sauce` JOIN `yogurtlandstage`.`locations_sauces` AS `LocationsSauce` ON (`LocationsSauce`.`location_id` = 1376 AND `LocationsSauce`.`sauce_id` = `Sauce`.`id`) | 0 | 0 | 0 | |
SELECT `SiteConfiguration`.`id`, `SiteConfiguration`.`key`, `SiteConfiguration`.`value`, `SiteConfiguration`.`help_text`, `SiteConfiguration`.`created`, `SiteConfiguration`.`modified` FROM `yogurtlandstage`.`site_configurations` AS `SiteConfiguration` WHERE `SiteConfiguration`.`key` = 'location_promo_url' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SiteConfiguration`.`id`, `SiteConfiguration`.`key`, `SiteConfiguration`.`value`, `SiteConfiguration`.`help_text`, `SiteConfiguration`.`created`, `SiteConfiguration`.`modified` FROM `yogurtlandstage`.`site_configurations` AS `SiteConfiguration` WHERE `key` = 'scheduled_location_text_start_date' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SiteConfiguration`.`id`, `SiteConfiguration`.`key`, `SiteConfiguration`.`value`, `SiteConfiguration`.`help_text`, `SiteConfiguration`.`created`, `SiteConfiguration`.`modified` FROM `yogurtlandstage`.`site_configurations` AS `SiteConfiguration` WHERE `key` = 'scheduled_location_text_end_date' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SiteConfiguration`.`id`, `SiteConfiguration`.`key`, `SiteConfiguration`.`value`, `SiteConfiguration`.`help_text`, `SiteConfiguration`.`created`, `SiteConfiguration`.`modified` FROM `yogurtlandstage`.`site_configurations` AS `SiteConfiguration` WHERE `key` = 'scheduled_location_text' LIMIT 1 | 1 | 1 | 0 | |
13 duplicate queries run.