| Queries | Time | Rows |
| SELECT *
FROM (`mmp_categories`)
WHERE `trash` = 0
ORDER BY `priority` ASC | 0.000 | 8 |
| SELECT COUNT(*) AS `records_found`
FROM (`mmp_advert`)
WHERE `active` = 1
AND `end_date` > 1729066614 | 0.000 | 1 |
| SELECT *
FROM (`mmp_pages`)
WHERE `id` = 6 | 0.000 | 1 |
| SELECT `mmp_pages`.*, `mmp_categories`.`plugin`, `mmp_categories`.`subpage`, `mmp_categories`.`name`, `mmp_categories`.`icon`, `mmp_categories`.`banner`, `mmp_categories`.`parent`, `mmp_galleries`.`name` AS `gallery_title`
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`)
WHERE `mmp_categories`.`id` = 9 | 0.021 | 1 |
| UPDATE mmp_firms SET shows = shows + 1 WHERE id=9 | 0.159 | 1 |
| SELECT *
FROM (`mmp_firms`)
WHERE `id` = 9 | 0.001 | 1 |
| SELECT `mmp_advert`.*, `mmp_firms`.`name` AS `firm_name`, (SELECT name FROM mmp_advert_category WHERE id = advert_category_id) AS category_name, (SELECT name FROM mmp_advert_category WHERE id = advert_scategory_id) AS scategory_name
FROM (`mmp_advert`)
LEFT JOIN `mmp_firms` ON (`mmp_firms`.`id` = `mmp_advert`.`firm_id`)
WHERE `mmp_advert`.`end_date` > 1729066614
AND `mmp_advert`.`active` = 1
AND `mmp_advert`.`firm_id` = 9
ORDER BY `date` DESC
LIMIT 0, 8 | 0.001 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`mmp_advert`)
WHERE `mmp_advert`.`end_date` > 1729066614
AND `mmp_advert`.`active` = 1
AND `mmp_advert`.`firm_id` = 9 | 0.001 | 1 |
| SELECT `mmp_education`.*, `mmp_firms`.`name` AS `firm_name`, (SELECT name FROM mmp_advert_category WHERE id = mmp_education.education_category_id) AS category_name, (SELECT name FROM mmp_advert_category WHERE id = mmp_education.education_scategory_id) AS scategory_name
FROM (`mmp_education`)
LEFT JOIN `mmp_firms` ON (`mmp_firms`.`id` = `mmp_education`.`firm_id`)
WHERE `mmp_education`.`end_date` > 1729066614
AND `mmp_education`.`active` = 1
AND `mmp_education`.`firm_id` = 9
ORDER BY `date` DESC
LIMIT 0, 8 | 0.151 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`mmp_education`)
WHERE `mmp_education`.`end_date` > 1729066614
AND `mmp_education`.`active` = 1
AND `mmp_education`.`firm_id` = 9 | 0.001 | 1 |
| SELECT
mmp_news.*,
mmp_categories.name AS category_name,
mmp_firms.name AS firm_name
FROM mmp_news
LEFT JOIN mmp_categories ON mmp_categories.id = mmp_news.cat_id
LEFT JOIN mmp_firms ON mmp_firms.id = mmp_news.firm_id
WHERE mmp_news.hidden = 0 AND mmp_news.trash = 0 AND mmp_news.cat_id = 7 AND mmp_news.firm_id = 9
GROUP BY mmp_news.id
ORDER BY mmp_news.locked DESC, mmp_news.pub_date DESC
LIMIT 0,8
| 0.004 | 0 |
| SELECT COUNT(*) AS `records_found`
FROM (`mmp_news`)
WHERE `hidden` = 0
AND `trash` = 0
AND `cat_id` = 7
AND `firm_id` = 9 | 0.001 | 1 |
| SELECT *
FROM (`mmp_firms_gallery`)
WHERE `firm_id` = 9
ORDER BY `id` ASC | 0.001 | 0 |
| Total: 13 | 0.340 | 16 |