Queries | Time | Rows |
SELECT
mmcms_categories.hidden,
mmcms_pages.*
FROM mmcms_pages
LEFT JOIN mmcms_categories ON mmcms_pages.id = mmcms_categories.id
WHERE mmcms_categories.parent = 29 AND mmcms_categories.trash = 0
ORDER BY mmcms_categories.priority ASC | 0.001 | 2 |
SELECT *
FROM (`mmcms_top_texts`)
WHERE `hidden` = 0
ORDER BY RAND() | 0.000 | 1 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `hidden` = 0
ORDER BY `priority` ASC | 0.000 | 4 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 1
ORDER BY `title` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 2
ORDER BY `title` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_types`)
WHERE `hidden` = 0
ORDER BY `title` ASC | 0.000 | 2 |
SELECT *
FROM (`mmcms_product_themes`)
WHERE `hidden` = 0
ORDER BY `title` ASC | 0.000 | 11 |
SELECT *
FROM (`mmcms_product_purpose`)
WHERE `hidden` = 0
ORDER BY `title` ASC | 0.000 | 7 |
SELECT *
FROM (`mmcms_product_colors`)
WHERE `hidden` = 0
ORDER BY `priority` ASC | 0.000 | 13 |
SELECT *
FROM (`mmcms_settings`)
WHERE `id` = 1 | 0.000 | 1 |
SELECT *
FROM (`mmcms_top_layer`)
WHERE `hidden` = 0 | 0.000 | 0 |
SELECT *
FROM (`mmcms_categories`)
WHERE `trash` = 0
ORDER BY `priority` ASC | 0.000 | 58 |
SELECT *
FROM (`mmcms_metatags`)
WHERE `name` = '1323-plakat-brazowe-ryby-na-bialym-tle' | 0.000 | 0 |
SELECT *
FROM (`mmcms_favourites`)
WHERE `session_id` = '56a409fb5585e524645dc2d4922162fc'
ORDER BY `id` ASC | 0.000 | 0 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = 1323
AND `hidden` = 0 | 0.000 | 1 |
UPDATE mmcms_products SET shows = shows + 1 WHERE id=1323 | 0.000 | 1 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE id IS NULL | 0.000 | 0 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `id` = 3 | 0.000 | 1 |
SELECT *
FROM (`mmcms_types`)
WHERE `main_cat_id` = 3
AND `hidden` = 0
ORDER BY `priority` ASC | 0.000 | 1 |
SELECT *
FROM (`mmcms_plakat_passe`)
WHERE `hidden` = 0
ORDER BY `size` ASC | 0.000 | 4 |
SELECT *
FROM (`mmcms_ramki_sizes`)
GROUP BY `width`, `height`
ORDER BY `width` ASC, `height` ASC | 0.000 | 8 |
SELECT *
FROM (`mmcms_product_collection`)
WHERE `id` = '4' | 0.000 | 1 |
SELECT
mmcms_products.*
FROM mmcms_colors_ver
LEFT JOIN mmcms_products ON mmcms_products.id=mmcms_colors_ver.prod_to
WHERE
mmcms_products.hidden = 0 AND
mmcms_colors_ver.prod_org = 1323
ORDER BY mmcms_products.priority ASC
| 0.001 | 0 |
SELECT `mmcms_favourites`.*, `mmcms_products`.`title`, `mmcms_products`.`tapeta`, `mmcms_products`.`fototapeta`, `mmcms_products`.`plakat`, `mmcms_products`.`naklejka`, `mmcms_products`.`photo`, `mmcms_products`.`photo_min`
FROM (`mmcms_favourites`)
LEFT JOIN `mmcms_products` ON (`mmcms_products`.`id` = `mmcms_favourites`.`idprod`)
WHERE mmcms_favourites.session_id IS NULL
ORDER BY `mmcms_favourites`.`id` ASC | 0.000 | 0 |
SELECT `mmcms_temp`.*, `mmcms_promocje`.`title` AS `promocje_title`, `mmcms_main_categories`.`title` AS `main_categorie_title`, `mmcms_main_categories`.`title_single` AS `main_categorie_title_single`, `mmcms_main_categories`.`controller_name`, `mmcms_main_categories`.`days`, `mmcms_types`.`title` AS `type_title`, `mmcms_plakat_passe`.`title` AS `plakat_passe_title`, `mmcms_sticker_shape`.`title` AS `cuts_title`, `mmcms_sticker_shape`.`desc` AS `cuts_desc`, `mmcms_effects`.`title` AS `effect_title`, `mmcms_corrects`.`title` AS `correct_title`, `mmcms_products`.`title` AS `product_title`, `mmcms_products_extra`.`title` AS `extra_title`, `mmcms_products_extra`.`photo` AS `extra_photo`, `mmcms_ramki`.`title` AS `ramka_title`, `mmcms_ramki_sizes`.`width` AS `ramka_width`, `mmcms_ramki_sizes`.`height` AS `ramka_height`, `mmcms_ramki`.`photo` AS `ramka_photo`
FROM (`mmcms_temp`)
LEFT JOIN `mmcms_promocje` ON (`mmcms_promocje`.`id` = `mmcms_temp`.`id_obraz`)
LEFT JOIN `mmcms_main_categories` ON (`mmcms_main_categories`.`id` = `mmcms_temp`.`main_categories`)
LEFT JOIN `mmcms_types` ON (`mmcms_types`.`id` = `mmcms_temp`.`type`)
LEFT JOIN `mmcms_plakat_passe` ON (`mmcms_plakat_passe`.`id` = `mmcms_temp`.`plakat_passe`)
LEFT JOIN `mmcms_sticker_shape` ON (`mmcms_sticker_shape`.`id` = `mmcms_temp`.`cuts`)
LEFT JOIN `mmcms_effects` ON (`mmcms_effects`.`id` = `mmcms_temp`.`effect`)
LEFT JOIN `mmcms_corrects` ON (`mmcms_corrects`.`id` = `mmcms_temp`.`correct`)
LEFT JOIN `mmcms_products` ON (`mmcms_products`.`id` = `mmcms_temp`.`id_obraz`)
LEFT JOIN `mmcms_products_extra` ON (`mmcms_products_extra`.`id` = `mmcms_temp`.`extra`)
LEFT JOIN `mmcms_ramki` ON (`mmcms_ramki`.`id` = `mmcms_temp`.`ramka`)
LEFT JOIN `mmcms_ramki_sizes` ON (`mmcms_ramki_sizes`.`id` = `mmcms_temp`.`ramka_size`)
WHERE mmcms_temp.id_koszyk IS NULL
ORDER BY `mmcms_temp`.`id` ASC | 0.000 | 0 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 1
ORDER BY `title` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_collection`)
WHERE `hidden` = 0
ORDER BY RAND() | 0.000 | 53 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 2
ORDER BY `title` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_collection`)
WHERE `hidden` = 0
ORDER BY RAND() | 0.000 | 53 |
SELECT *
FROM (`mmcms_product_collection`)
WHERE `hidden` = 0
ORDER BY RAND() | 0.000 | 53 |
SELECT *
FROM (`mmcms_product_collection`)
WHERE `hidden` = 0
ORDER BY RAND() | 0.000 | 53 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 1
ORDER BY `id` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 2
ORDER BY `id` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_steps`)
WHERE `name` = 'create_plakat' | 0.000 | 1 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `id` = 3 | 0.000 | 1 |
SELECT *
FROM (`mmcms_types`)
WHERE `id` = '6' | 0.000 | 1 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = '1323' | 0.000 | 1 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `id` = 3 | 0.000 | 1 |
SELECT *
FROM (`mmcms_types`)
WHERE `id` = '6' | 0.000 | 1 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = '1323' | 0.000 | 1 |
SELECT `mmcms_ramki`.`photo`, `mmcms_ramki`.`title`, `mmcms_ramki`.`text`, `mmcms_ramki_sizes`.`id`, `mmcms_ramki_sizes`.`id_ramki`, `mmcms_ramki_sizes`.`cost`, `mmcms_ramki_sizes`.`margin`, `mmcms_ramki_sizes`.`width`, `mmcms_ramki_sizes`.`height`
FROM (`mmcms_ramki`)
LEFT JOIN `mmcms_ramki_sizes` ON (`mmcms_ramki_sizes`.`id_ramki` = `mmcms_ramki`.`id`)
WHERE `mmcms_ramki_sizes`.`width` = '70'
AND `mmcms_ramki_sizes`.`height` = '100'
AND `mmcms_ramki`.`hidden` = 0
ORDER BY `mmcms_ramki_sizes`.`cost` ASC | 0.000 | 4 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `id` = 3 | 0.000 | 1 |
SELECT *
FROM (`mmcms_types`)
WHERE `id` = '6' | 0.000 | 1 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = '1323' | 0.000 | 1 |
SELECT *
FROM (`mmcms_main_categories`)
WHERE `id` = 3 | 0.000 | 1 |
SELECT *
FROM (`mmcms_types`)
WHERE `id` = '6' | 0.000 | 1 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = '1323' | 0.000 | 1 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 1
ORDER BY `id` ASC | 0.000 | 6 |
SELECT *
FROM (`mmcms_product_cats`)
WHERE `hidden` = 0
AND `type` = 2
ORDER BY `id` ASC | 0.000 | 6 |
Total: 49 | 0.007 | 393 |