Search for Resources

Where Do Frogs Go in the Winter?

Late November 2021

Top R4R Picks

Resources for extending the learning

Featured Process:  Frogsicles   

Quite soon, buried in shallow soil beneath leaf litter, some frogs will turn into frogsicles.  As the temperature plummets, Wood Frogs and Spring Peepers, among others, fill their cells with glycerol, a natural antifreeze derived from sugar.  This allows more than half the water in a frog to freeze, without disrupting cells, tissues or organs.  Breathing and heartbeat stop as they become little blocks of ice, which can thaw and become active again in as little as an hour. 

Here are some other nifty ways that amphibians and reptiles get through the winter:

Method

Herptiles

Overwinter in mud at bottom of ponds and marshes

Green FrogsBullfrogsMink FrogsSnapping TurtleMidland Painted TurtleStinkpot (these turtles are true hibernators)

Overwinter in mud at bottom of streams and rivers

Leopard Frog

In loose soil, burrows or crevices below the frost line

American ToadEastern Red-backed SalamanderBlue-spotted Salamandersnakes

Other quick-frozen critters

Boreal Chorus FrogWestern Chorus FrogGray Treefrogturtle hatchlings that overwinter in nest:  Painted TurtleEastern Box Turtle (Extirpated in Ontario), Snapping Turtle (very occasional), possibly Blanding’s Turtle

Semi-active in water

Aquatic salamanders such as the Mudpuppy and Red-spotted Newt

 

Other Happenings:

  • At this time of year bat species such as the Little Brown Bat are also moving into safe areas like caves and mines for their long winter hibernation. Many people feel that bats are creepy and scary but in reality these amazing creatures are nature’s superheroes of insect control.  Their immense appetite for flying pests such as moths and mosquitoes helps support a healthy environment by reducing the need for insecticides.

  Invasive Alert!

  • Unfortunately, North American bat species are under attack by a nasty and fast-moving invasive microbe. White nose syndrome is caused by a fungus that originated in Europe known as Pseudogymnoascus destructans (formerly Geomyces destructans).  This fungus grows and thrives in the humid cool conditions of the caves where bats gather.  Researchers believe the fungus interrupts the hibernation process by irritating the skin. This causes the bats to awaken and use their fat reserves, leading to starvation and death. White nose syndrome was first found in eastern Canada (first row, second map) in 2010 and has quickly ravaged bat populations in NB, NS, Quebec and ON to the point where three of our most common bat species (Little Brown Bat, Northern Myotis and Tri-colored Bat) are now endangered. There are now reasons for optimism.  Bat numbers are increasing in some of the caves where White-nose was first discovered, perhaps an early sign that bats can adapt to the disease.  However, it has now been found in Washington state, 2100 km further west than previously found, as well as in Newfoundland and Manitoba, supporting the notion that people can spread the syndrome.  It is up to all of us to help protect these remarkable flying mammals. Report unusual bat sightings like daytime flying in winter.  You could also take action by building and installing a bat house that creates summer habitat for these night creatures who provide us with free pest control services!
  • Now that most of the leaves are down, basketball-sized leaf balls are very evident in some trees.  These are actually squirrel nests (Red or Eastern Gray), and are called dreys.  They are lined with shredded vines and grasses, and may have a floor of twigs.  Here’s a view in cross-section.  Squirrels will also utilize cavities in trees, adapt old crow’s nests or even use large bird boxes.  Red Squirrels will also burrow underground, often in a scale midden (note the burrow entrance) that they produce by shredding cones to get at the seeds.  By doing this in the same place, year after year, a midden builds up.  If you go quietly enough through the woods, you can often hear Red Squirrels tearing these cones apart with their teeth.  Squirrels are active all winter, hunkering down only in the worst weather. 
  • Migrating Bald and (more occasionally) Golden Eagles are arriving in the Kawarthas, and may visit your area as well.  As northern lakes and rivers freeze, these birds are forced south to look for food.  Areas of high deer populations attract eagles, as they will scavenge on carcasses.  They will also feed on fish and ducks, or ducks either frozen in new ice, or unable to take off across it.  A good place to look for eagles is you local dump early in the morning.                                                                                                                        
  • American Crows are migrating.  Look for flocks high in the sky, moving towards the southwest.  The crows will gather to form massive roosts at this time of year.  From late November until March, hundreds of thousands of crows may gather in your area each evening until spring arrives and they go back to their home territories to start the nest-building and breeding process. For some hypotheses on why crows do this, go here and scroll down a bit.  American Crows are fairly easy to identify and their intelligence is legendary, going back literally thousands of years.  Try this activity for Primary and early Junior students, based on Aesop’s Fable, “The Crow and the Pitcher”, and see if the fable holds true.                                                                                                                     
  • Enjoy the first snows (you probably have some time ago!)  Snowflakes come in many shapes and sizes, depending on the atmospheric conditions where they formed, and as they made their way to the ground.  Go outside during a light snowfall, and catch flakes on jacket sleeves or mitts (but perhaps not tongues), and look at them through a magnifying lens.  Here’s a great site about snowflakes – you can even watch snowflakes grow.  Activities for kids can be found here.                                                                               
  • The Summer Triangle continues to shine. Look high in the western sky after sunset. As it falls to the west, Orion rises in the east. The highest star in his belt, Mintaka, helps form a celestial bridge between hemispheres and can be used to judge east and west as Orion rises or sets.

76 total queries
(query time) (total time) (query)
0.0009 0.0009 (SET NAMES 'utf8')
0.0003 0.0012 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='1' ORDER BY issue_content.title ASC ) [14 row(s)]
0.0004 0.0016 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='step-outside' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0004 0.002 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='nature-guides' AND parent_page=50 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0004 0.0024 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='page' AND parent_page=80 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0003 0.0027 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='late-november-2021' AND parent_page=80 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0002 0.0029 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0004 0.0033 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0003 0.0036 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='80' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0039 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=80 ORDER BY page_order) [3 row(s)]
0.0003 0.0042 (SELECT * FROM page_details WHERE page_id='80') [1 row(s)]
0.0002 0.0044 (SELECT * FROM page_details WHERE page_id='50') [1 row(s)]
0.0003 0.0047 (SELECT path FROM page_details WHERE page_id = 50) [1 row(s)]
0.0002 0.0049 (SELECT path FROM page_details WHERE page_id = 50) [1 row(s)]
0.0003 0.0052 ( SELECT page_details.*, page_content.title, if(menu_order=0,0,1) as map_order FROM page_details LEFT JOIN page_content USING (page_id) WHERE lang_id='1' AND parent_page='50' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [5 row(s)]
0.0003 0.0055 ( SELECT curriculum_province.province_id as id, curriculum_province_content.name FROM curriculum_province LEFT JOIN curriculum_province_content USING (province_id) WHERE curriculum_province_content.lang_id='1' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0.0003 0.0058 ( SELECT curriculum_audience.audience_id as id, curriculum_audience_content.name FROM curriculum_audience LEFT JOIN curriculum_audience_content USING (audience_id) WHERE curriculum_audience_content.lang_id='1' ORDER BY curriculum_audience.number ASC ) [13 row(s)]
0.0003 0.0061 ( SELECT curriculum_subject_group_content.subject_group_id as id, curriculum_subject_group_content.name FROM curriculum_subject_group_content WHERE curriculum_subject_group_content.lang_id='1' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0.0002 0.0063 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='1' ORDER BY issue_content.title ASC ) [14 row(s)]
0.0003 0.0066 ( SELECT sdg_content.sdg_id as id, sdg_content.title FROM sdg_content WHERE sdg_content.lang_id='1' ORDER BY sdg_content.sdg_id ASC ) [18 row(s)]
0.0002 0.0068 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0071 ( SELECT curriculum_subject_group_content.subject_group_id as id, curriculum_subject_group_content.name FROM curriculum_subject_group_content WHERE curriculum_subject_group_content.lang_id='1' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0.0003 0.0074 ( SELECT curriculum_province.province_id as id, curriculum_province_content.name FROM curriculum_province LEFT JOIN curriculum_province_content USING (province_id) WHERE curriculum_province_content.lang_id='1' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0.0007 0.0081 (SELECT * FROM page_details LEFT JOIN page_content ON page_content.page_id = page_details.page_id WHERE page = 'late-november-2021' AND page_details.live = 'yes' AND lang_id = 1 AND page_details.live='yes') [1 row(s)]
0.0002 0.0083 ( SELECT resource_compilation.resource_id, resources.slug, resources.date_published, resource_content.title FROM resources LEFT JOIN resource_compilation USING (resource_id) LEFT JOIN resource_content USING (resource_id) WHERE resource_compilation.compilation_id = 550 AND resources.language_id = 1 ) [10 row(s)]
0.0002 0.0085 ( SELECT n.resource_id, nc.content FROM resource_compilation_notes as n LEFT JOIN resource_compilation_note_content as nc USING (note_id) WHERE nc.lang_id = 1 AND n.compilation_id = 550 AND n.resource_id IN (913, 1345, 1887, 2111, 2217, 2472, 3022, 3074, 3098, 3271) ) [0 row(s)]
0.0002 0.0087 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0089 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='913' ) [1 row(s)]
0.0002 0.0091 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0093 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1345' ) [1 row(s)]
0.0002 0.0095 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0097 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1887' ) [1 row(s)]
0.0002 0.0099 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0101 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2111' ) [1 row(s)]
0.0002 0.0103 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0105 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2217' ) [1 row(s)]
0.0002 0.0107 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0109 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2472' ) [1 row(s)]
0.0002 0.0111 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0113 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3022' ) [1 row(s)]
0.0002 0.0115 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0118 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3074' ) [1 row(s)]
0.0003 0.0121 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0123 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3098' ) [1 row(s)]
0.0002 0.0125 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0128 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3271' ) [1 row(s)]
0.0002 0.013 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0133 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3022' ) [1 row(s)]
0.0003 0.0136 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3022 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [6 row(s)]
0.0003 0.0139 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0142 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3098' ) [1 row(s)]
0.0003 0.0145 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3098 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0002 0.0147 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0149 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2217' ) [1 row(s)]
0.0013 0.0162 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2217 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [8 row(s)]
0.0003 0.0165 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0167 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3074' ) [1 row(s)]
0.0002 0.0169 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3074 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [5 row(s)]
0.0003 0.0172 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0174 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3271' ) [1 row(s)]
0.0003 0.0177 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3271 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0002 0.0179 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0181 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2111' ) [1 row(s)]
0.0006 0.0187 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2111 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0002 0.0189 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.0192 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='913' ) [1 row(s)]
0.0003 0.0195 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 913 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [5 row(s)]
0.0002 0.0197 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0003 0.02 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1887' ) [1 row(s)]
0.0003 0.0203 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1887 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [7 row(s)]
0.0003 0.0206 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0208 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1345' ) [1 row(s)]
0.0003 0.0211 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1345 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0002 0.0213 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0215 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2472' ) [1 row(s)]
0.0003 0.0218 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2472 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [6 row(s)]