Queries | Time | Rows |
SELECT *
FROM (`mmp_categories`)
WHERE `trash` = 0
ORDER BY `priority` ASC | 0.001 | 22 |
SELECT *
FROM (`mmp_site_config`)
ORDER BY `id` ASC | 0.000 | 16 |
SELECT *
FROM (`mmp_recommended`)
WHERE `hidden` = 0
ORDER BY `date` DESC | 0.001 | 18 |
SELECT `mmp_pages`.*, `mmp_categories`.`plugin`, `mmp_categories`.`subpage`, `mmp_categories`.`name_pl`, `mmp_categories`.`name_en`, `mmp_categories`.`name_de`, `mmp_categories`.`name_cz`, `mmp_categories`.`icon`, `mmp_categories`.`banner`, `mmp_categories`.`parent`, `mmp_galleries`.`name` AS `gallery_title`, `mmp_movies`.`movie_file`, `mmp_movies`.`movie_title`, `mmp_movies`.`movie_text`
FROM (`mmp_pages`)
LEFT JOIN `mmp_categories` ON (`mmp_categories`.`id` = `mmp_pages`.`id`)
LEFT JOIN `mmp_galleries` ON (`mmp_galleries`.`id` = `mmp_pages`.`gallery`)
LEFT JOIN `mmp_movies` ON (`mmp_movies`.`id` = `mmp_pages`.`movie`)
WHERE `mmp_categories`.`id` = 18 | 0.001 | 1 |
SELECT *
FROM (`mmp_galleries`)
WHERE `id` = 18 | 0.000 | 1 |
SELECT *
FROM (`mmp_gallery_desc`)
WHERE `gallery_id` = 18
ORDER BY `priority` ASC, `id` DESC | 0.001 | 24 |
SELECT *
FROM (`mmp_galleries`)
WHERE `id` = 18 | 0.000 | 1 |
SELECT
mmp_galleries.*,
COUNT(mmp_gallery_desc.id) as ile,
(SELECT mmp_gallery_desc.file FROM mmp_gallery_desc WHERE mmp_gallery_desc.gallery_id = mmp_galleries.id ORDER BY priority ASC, id ASC LIMIT 1) AS photo
FROM mmp_galleries
LEFT JOIN mmp_gallery_desc ON mmp_gallery_desc.gallery_id = mmp_galleries.id
WHERE mmp_galleries.id != 18
GROUP BY mmp_galleries.id
ORDER BY mmp_galleries.date DESC
LIMIT 0,3
| 0.007 | 3 |
SELECT COUNT(*) AS `records_found`
FROM (`mmp_galleries`)
WHERE `id` != '18' | 0.000 | 1 |
Total: 9 | 0.011 | 87 |