Queries | Time | Rows |
SELECT *
FROM (`mmcms_main_categories`)
ORDER BY `id` DESC | 0.000 | 4 |
SELECT *
FROM (`mmcms_product_themes`)
ORDER BY `id` DESC | 0.000 | 11 |
SELECT *
FROM (`mmcms_product_purpose`)
ORDER BY `id` DESC | 0.000 | 7 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"15"%'
| 0.002 | 81 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"11"%'
| 0.002 | 4 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"10"%'
| 0.002 | 78 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"9"%'
| 0.002 | 26 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"8"%'
| 0.003 | 88 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"7"%'
| 0.002 | 4 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"6"%'
| 0.002 | 6 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"5"%'
| 0.002 | 49 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"4"%'
| 0.002 | 45 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"3"%'
| 0.001 | 40 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND theme_ids LIKE '%"1"%'
| 0.002 | 15 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"7"%'
| 0.002 | 236 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"6"%'
| 0.002 | 123 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"5"%'
| 0.002 | 120 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"4"%'
| 0.002 | 245 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"3"%'
| 0.002 | 118 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"2"%'
| 0.002 | 263 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND fototapeta = 1 AND purpose_ids LIKE '%"1"%'
| 0.001 | 229 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"15"%'
| 0.002 | 198 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"11"%'
| 0.001 | 39 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"10"%'
| 0.001 | 1 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"9"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"8"%'
| 0.002 | 63 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"7"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"6"%'
| 0.001 | 38 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"5"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"4"%'
| 0.001 | 44 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"3"%'
| 0.001 | 53 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND theme_ids LIKE '%"1"%'
| 0.001 | 22 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"7"%'
| 0.001 | 193 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"6"%'
| 0.001 | 173 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"5"%'
| 0.001 | 81 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"4"%'
| 0.001 | 276 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"3"%'
| 0.001 | 164 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"2"%'
| 0.001 | 276 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND plakat = 1 AND purpose_ids LIKE '%"1"%'
| 0.001 | 220 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"15"%'
| 0.001 | 1 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"11"%'
| 0.001 | 11 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"10"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"9"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"8"%'
| 0.001 | 16 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"7"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"6"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"5"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"4"%'
| 0.001 | 9 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"3"%'
| 0.001 | 20 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND theme_ids LIKE '%"1"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"7"%'
| 0.001 | 1 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"6"%'
| 0.001 | 9 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"5"%'
| 0.001 | 8 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"4"%'
| 0.001 | 12 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"3"%'
| 0.001 | 29 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"2"%'
| 0.001 | 16 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND naklejka = 1 AND purpose_ids LIKE '%"1"%'
| 0.001 | 3 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"15"%'
| 0.001 | 2 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"11"%'
| 0.001 | 117 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"10"%'
| 0.001 | 26 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"9"%'
| 0.001 | 0 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"8"%'
| 0.001 | 176 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"7"%'
| 0.001 | 7 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"6"%'
| 0.001 | 558 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"5"%'
| 0.001 | 3 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"4"%'
| 0.002 | 337 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"3"%'
| 0.001 | 163 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND theme_ids LIKE '%"1"%'
| 0.001 | 18 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"7"%'
| 0.002 | 502 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"6"%'
| 0.002 | 469 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"5"%'
| 0.002 | 215 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"4"%'
| 0.002 | 719 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"3"%'
| 0.002 | 695 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"2"%'
| 0.002 | 846 |
SELECT
id
FROM mmcms_products
WHERE
hidden = 0
AND tapeta = 1 AND purpose_ids LIKE '%"1"%'
| 0.002 | 300 |
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.000 | 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` = '1755-plakat-pastelowy-jednorozec-i-kwiaty' | 0.000 | 0 |
SELECT *
FROM (`mmcms_favourites`)
WHERE `session_id` = '5d84ebb95b438729c6df712808f7a99c'
ORDER BY `id` ASC | 0.000 | 0 |
SELECT *
FROM (`mmcms_products`)
WHERE `id` = 1755
AND `hidden` = 0 | 0.000 | 1 |
UPDATE mmcms_products SET shows = shows + 1 WHERE id=1755 | 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` = '51' | 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 = 1755
ORDER BY mmcms_products.priority ASC
| 0.000 | 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` = '1755' | 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` = '1755' | 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` = '1755' | 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` = '1755' | 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: 124 | 0.112 | 9314 |