Quantity
create
0
read
10
update
0
delete
0
Time
create
0 s
read
679.80 ms
update
0 s
delete
0 s
Query Profiles
SQL
SELECT `Sessions`.* FROM `Sessions` WHERE `id` = :where1 AND `name` = :where2
Params
where1 => 'qro5dp57an77fvs9ki0vlan4n0'
where2 => 'GeneralAppGenSession'
Time
319.96 µs
SQL
SELECT `Redirects`.* FROM `Redirects` WHERE `oldUrl` = :where1
Params
where1 => 'interior-i-dekoraciya/osvetlenie/'
Time
369.07 µs
SQL
SELECT `Friendly_Id_Slugs`.* FROM `Friendly_Id_Slugs` WHERE `slug` = :where1 ORDER BY `id` DESC
Params
where1 => 'interior-i-dekoraciya/osvetlenie/'
Time
234.13 µs
SQL
SELECT `Categories`.*, `Categories_Properties`.`mainImage` AS `mainImage`, `Categories_Properties`.`description` AS `description`, `Categories_Properties`.`h1Title` AS `h1Title`, `Categories_Properties`.`metaTitle` AS `metaTitle`, `Categories_Properties`.`metaDescription` AS `metaDescription`, `Categories_Properties`.`metaKeywords` AS `metaKeywords`, `Categories_Properties`.`canonicalCategoryId` AS `canonicalCategoryId` FROM `Categories` LEFT JOIN `Categories_Properties` ON `Categories_Properties`.`categoryId` = `Categories`.`id` WHERE `Categories`.`id` IN (:where1, :where2) AND `status` = :where3 ORDER BY `level` ASC
Params
where1 => 1761
where2 => 1916
where3 => 1
Time
581.03 µs
SQL
SELECT COUNT(1) AS `C` FROM (SELECT `p`.*, `pc`.`categoryId` AS `catId`, (SELECT GROUP_CONCAT(CONCAT_WS('-',pfv.fieldId,pfv.fieldValueId)) AS `fields` FROM `Products_Fields_Values` AS `pfv` WHERE pfv.productId = p.id) AS `fields`, `c`.`title` AS `categoryTitle`, `c`.`parentId` AS `categoryParentId` FROM `Products` AS `p` INNER JOIN `Products_Categories` AS `pc` ON `p`.`id` = `pc`.`productId` INNER JOIN `Categories` AS `c` ON `pc`.`categoryId` = `c`.`id` WHERE `p`.`status` = :subselect1where1 AND `c`.`status` = :subselect1where2 AND mainImage is NOT NULL AND p.price > 0 AND `p`.`sellableOnline` = :subselect1where3 AND `pc`.`categoryId` IN (:subselect1where4, :subselect1where5, :subselect1where6, :subselect1where7, :subselect1where8, :subselect1where9, :subselect1where10, :subselect1where11, :subselect1where12, :subselect1where13, :subselect1where14, :subselect1where15, :subselect1where16, :subselect1where17, :subselect1where18, :subselect1where19, :subselect1where20, :subselect1where21, :subselect1where22, :subselect1where23, :subselect1where24, :subselect1where25, :subselect1where26, :subselect1where27, :subselect1where28, :subselect1where29, :subselect1where30, :subselect1where31, :subselect1where32, :subselect1where33, :subselect1where34, :subselect1where35, :subselect1where36, :subselect1where37, :subselect1where38, :subselect1where39, :subselect1where40, :subselect1where41, :subselect1where42, :subselect1where43, :subselect1where44, :subselect1where45, :subselect1where46, :subselect1where47, :subselect1where48, :subselect1where49, :subselect1where50, :subselect1where51, :subselect1where52, :subselect1where53, :subselect1where54, :subselect1where55, :subselect1where56, :subselect1where57, :subselect1where58, :subselect1where59, :subselect1where60, :subselect1where61, :subselect1where62, :subselect1where63, :subselect1where64, :subselect1where65, :subselect1where66, :subselect1where67, :subselect1where68, :subselect1where69, :subselect1where70, :subselect1where71) GROUP BY `p`.`id`) AS `original_select`
Params
subselect1where1 => 1
subselect1where2 => 1
subselect1where3 => 1
subselect1where4 => '1916'
subselect1where5 => '1917'
subselect1where6 => '1918'
subselect1where7 => '1919'
subselect1where8 => '1920'
subselect1where9 => '1921'
subselect1where10 => '1922'
subselect1where11 => '1923'
subselect1where12 => '1924'
subselect1where13 => '1925'
subselect1where14 => '1926'
subselect1where15 => '1927'
subselect1where16 => '1928'
subselect1where17 => '1929'
subselect1where18 => '1930'
subselect1where19 => '1931'
subselect1where20 => '1932'
subselect1where21 => '1933'
subselect1where22 => '1934'
subselect1where23 => '1935'
subselect1where24 => '1936'
subselect1where25 => '1937'
subselect1where26 => '1938'
subselect1where27 => '1939'
subselect1where28 => '1940'
subselect1where29 => '1941'
subselect1where30 => '1942'
subselect1where31 => '1943'
subselect1where32 => '1944'
subselect1where33 => '1945'
subselect1where34 => '1946'
subselect1where35 => '1947'
subselect1where36 => '1948'
subselect1where37 => '1949'
subselect1where38 => '1950'
subselect1where39 => '1951'
subselect1where40 => '1952'
subselect1where41 => '1953'
subselect1where42 => '1954'
subselect1where43 => '1955'
subselect1where44 => '1956'
subselect1where45 => '1957'
subselect1where46 => '1958'
subselect1where47 => '1959'
subselect1where48 => '1960'
subselect1where49 => '1961'
subselect1where50 => '1962'
subselect1where51 => '1963'
subselect1where52 => '1964'
subselect1where53 => '1965'
subselect1where54 => '1966'
subselect1where55 => '1967'
subselect1where56 => '1968'
subselect1where57 => '1969'
subselect1where58 => '1970'
subselect1where59 => '1971'
subselect1where60 => '1972'
subselect1where61 => '1973'
subselect1where62 => '1974'
subselect1where63 => '1975'
subselect1where64 => '1976'
subselect1where65 => '1977'
subselect1where66 => '1978'
subselect1where67 => '1979'
subselect1where68 => '3401'
subselect1where69 => '3402'
subselect1where70 => '3403'
subselect1where71 => '3095'
Time
376.02 ms
SQL
SELECT MAX(p.price) AS `maxPrice`, MIN(p.price) AS `minPrice`, `pc`.`categoryId` AS `catId`, (SELECT GROUP_CONCAT(CONCAT_WS('-',pfv.fieldId,pfv.fieldValueId)) AS `fields` FROM `Products_Fields_Values` AS `pfv` WHERE pfv.productId = p.id) AS `fields`, `c`.`title` AS `categoryTitle`, `c`.`parentId` AS `categoryParentId` FROM `Products` AS `p` INNER JOIN `Products_Categories` AS `pc` ON `p`.`id` = `pc`.`productId` INNER JOIN `Categories` AS `c` ON `pc`.`categoryId` = `c`.`id` WHERE `p`.`status` = :where1 AND `c`.`status` = :where2 AND mainImage is NOT NULL AND p.price > 0 AND `p`.`sellableOnline` = :where3 AND `pc`.`categoryId` IN (:where4, :where5, :where6, :where7, :where8, :where9, :where10, :where11, :where12, :where13, :where14, :where15, :where16, :where17, :where18, :where19, :where20, :where21, :where22, :where23, :where24, :where25, :where26, :where27, :where28, :where29, :where30, :where31, :where32, :where33, :where34, :where35, :where36, :where37, :where38, :where39, :where40, :where41, :where42, :where43, :where44, :where45, :where46, :where47, :where48, :where49, :where50, :where51, :where52, :where53, :where54, :where55, :where56, :where57, :where58, :where59, :where60, :where61, :where62, :where63, :where64, :where65, :where66, :where67, :where68, :where69, :where70, :where71) ORDER BY `p`.`id` DESC
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1916'
where5 => '1917'
where6 => '1918'
where7 => '1919'
where8 => '1920'
where9 => '1921'
where10 => '1922'
where11 => '1923'
where12 => '1924'
where13 => '1925'
where14 => '1926'
where15 => '1927'
where16 => '1928'
where17 => '1929'
where18 => '1930'
where19 => '1931'
where20 => '1932'
where21 => '1933'
where22 => '1934'
where23 => '1935'
where24 => '1936'
where25 => '1937'
where26 => '1938'
where27 => '1939'
where28 => '1940'
where29 => '1941'
where30 => '1942'
where31 => '1943'
where32 => '1944'
where33 => '1945'
where34 => '1946'
where35 => '1947'
where36 => '1948'
where37 => '1949'
where38 => '1950'
where39 => '1951'
where40 => '1952'
where41 => '1953'
where42 => '1954'
where43 => '1955'
where44 => '1956'
where45 => '1957'
where46 => '1958'
where47 => '1959'
where48 => '1960'
where49 => '1961'
where50 => '1962'
where51 => '1963'
where52 => '1964'
where53 => '1965'
where54 => '1966'
where55 => '1967'
where56 => '1968'
where57 => '1969'
where58 => '1970'
where59 => '1971'
where60 => '1972'
where61 => '1973'
where62 => '1974'
where63 => '1975'
where64 => '1976'
where65 => '1977'
where66 => '1978'
where67 => '1979'
where68 => '3401'
where69 => '3402'
where70 => '3403'
where71 => '3095'
Time
52.79 ms
SQL
SELECT `p`.`id` AS `id`, `pc`.`categoryId` AS `catId`, (SELECT GROUP_CONCAT(CONCAT_WS('-',pfv.fieldId,pfv.fieldValueId)) AS `fields` FROM `Products_Fields_Values` AS `pfv` WHERE pfv.productId = p.id) AS `fields`, `c`.`title` AS `categoryTitle`, `c`.`parentId` AS `categoryParentId` FROM `Products` AS `p` INNER JOIN `Products_Categories` AS `pc` ON `p`.`id` = `pc`.`productId` INNER JOIN `Categories` AS `c` ON `pc`.`categoryId` = `c`.`id` WHERE `p`.`status` = :where1 AND `c`.`status` = :where2 AND mainImage is NOT NULL AND p.price > 0 AND `p`.`sellableOnline` = :where3 AND `pc`.`categoryId` IN (:where4, :where5, :where6, :where7, :where8, :where9, :where10, :where11, :where12, :where13, :where14, :where15, :where16, :where17, :where18, :where19, :where20, :where21, :where22, :where23, :where24, :where25, :where26, :where27, :where28, :where29, :where30, :where31, :where32, :where33, :where34, :where35, :where36, :where37, :where38, :where39, :where40, :where41, :where42, :where43, :where44, :where45, :where46, :where47, :where48, :where49, :where50, :where51, :where52, :where53, :where54, :where55, :where56, :where57, :where58, :where59, :where60, :where61, :where62, :where63, :where64, :where65, :where66, :where67, :where68, :where69, :where70, :where71) GROUP BY `p`.`id` ORDER BY `p`.`id` DESC
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1916'
where5 => '1917'
where6 => '1918'
where7 => '1919'
where8 => '1920'
where9 => '1921'
where10 => '1922'
where11 => '1923'
where12 => '1924'
where13 => '1925'
where14 => '1926'
where15 => '1927'
where16 => '1928'
where17 => '1929'
where18 => '1930'
where19 => '1931'
where20 => '1932'
where21 => '1933'
where22 => '1934'
where23 => '1935'
where24 => '1936'
where25 => '1937'
where26 => '1938'
where27 => '1939'
where28 => '1940'
where29 => '1941'
where30 => '1942'
where31 => '1943'
where32 => '1944'
where33 => '1945'
where34 => '1946'
where35 => '1947'
where36 => '1948'
where37 => '1949'
where38 => '1950'
where39 => '1951'
where40 => '1952'
where41 => '1953'
where42 => '1954'
where43 => '1955'
where44 => '1956'
where45 => '1957'
where46 => '1958'
where47 => '1959'
where48 => '1960'
where49 => '1961'
where50 => '1962'
where51 => '1963'
where52 => '1964'
where53 => '1965'
where54 => '1966'
where55 => '1967'
where56 => '1968'
where57 => '1969'
where58 => '1970'
where59 => '1971'
where60 => '1972'
where61 => '1973'
where62 => '1974'
where63 => '1975'
where64 => '1976'
where65 => '1977'
where66 => '1978'
where67 => '1979'
where68 => '3401'
where69 => '3402'
where70 => '3403'
where71 => '3095'
Time
97.60 ms
SQL
SELECT `p`.*, `pc`.`categoryId` AS `catId`, (SELECT GROUP_CONCAT(CONCAT_WS('-',pfv.fieldId,pfv.fieldValueId)) AS `fields` FROM `Products_Fields_Values` AS `pfv` WHERE pfv.productId = p.id) AS `fields`, `c`.`title` AS `categoryTitle`, `c`.`parentId` AS `categoryParentId` FROM `Products` AS `p` INNER JOIN `Products_Categories` AS `pc` ON `p`.`id` = `pc`.`productId` INNER JOIN `Categories` AS `c` ON `pc`.`categoryId` = `c`.`id` WHERE `p`.`status` = :where1 AND `c`.`status` = :where2 AND mainImage is NOT NULL AND p.price > 0 AND `p`.`sellableOnline` = :where3 AND `pc`.`categoryId` IN (:where4, :where5, :where6, :where7, :where8, :where9, :where10, :where11, :where12, :where13, :where14, :where15, :where16, :where17, :where18, :where19, :where20, :where21, :where22, :where23, :where24, :where25, :where26, :where27, :where28, :where29, :where30, :where31, :where32, :where33, :where34, :where35, :where36, :where37, :where38, :where39, :where40, :where41, :where42, :where43, :where44, :where45, :where46, :where47, :where48, :where49, :where50, :where51, :where52, :where53, :where54, :where55, :where56, :where57, :where58, :where59, :where60, :where61, :where62, :where63, :where64, :where65, :where66, :where67, :where68, :where69, :where70, :where71) GROUP BY `p`.`id` ORDER BY `p`.`id` DESC LIMIT :limit OFFSET :offset
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1916'
where5 => '1917'
where6 => '1918'
where7 => '1919'
where8 => '1920'
where9 => '1921'
where10 => '1922'
where11 => '1923'
where12 => '1924'
where13 => '1925'
where14 => '1926'
where15 => '1927'
where16 => '1928'
where17 => '1929'
where18 => '1930'
where19 => '1931'
where20 => '1932'
where21 => '1933'
where22 => '1934'
where23 => '1935'
where24 => '1936'
where25 => '1937'
where26 => '1938'
where27 => '1939'
where28 => '1940'
where29 => '1941'
where30 => '1942'
where31 => '1943'
where32 => '1944'
where33 => '1945'
where34 => '1946'
where35 => '1947'
where36 => '1948'
where37 => '1949'
where38 => '1950'
where39 => '1951'
where40 => '1952'
where41 => '1953'
where42 => '1954'
where43 => '1955'
where44 => '1956'
where45 => '1957'
where46 => '1958'
where47 => '1959'
where48 => '1960'
where49 => '1961'
where50 => '1962'
where51 => '1963'
where52 => '1964'
where53 => '1965'
where54 => '1966'
where55 => '1967'
where56 => '1968'
where57 => '1969'
where58 => '1970'
where59 => '1971'
where60 => '1972'
where61 => '1973'
where62 => '1974'
where63 => '1975'
where64 => '1976'
where65 => '1977'
where66 => '1978'
where67 => '1979'
where68 => '3401'
where69 => '3402'
where70 => '3403'
where71 => '3095'
limit => 36
offset => 0
Time
150.74 ms
SQL
SELECT `Brochures`.* FROM `Brochures` WHERE `status` = :where1 AND validFrom <= :where2 ORDER BY `validFrom` DESC LIMIT :limit
Params
where1 => 1
where2 => '2025-05-31'
limit => 1
Time
595.81 µs
SQL
SELECT `Brochures`.* FROM `Brochures` WHERE `status` = :where1 AND validFrom <= :where2 ORDER BY `validFrom` DESC LIMIT :limit
Params
where1 => 1
where2 => '2025-05-31'
limit => 1
Time
555.99 µs