Quantity
create
0
read
10
update
0
delete
0
Time
create
0 s
read
250.93 ms
update
0 s
delete
0 s
Query Profiles
SQL
SELECT `Sessions`.* FROM `Sessions` WHERE `id` = :where1 AND `name` = :where2
Params
where1 => 'lapefbd1c53citg3p3in096qi5'
where2 => 'GeneralAppGenSession'
Time
433.92 µs
SQL
SELECT `Redirects`.* FROM `Redirects` WHERE `oldUrl` = :where1
Params
where1 => 'elektrouredi-i-otoplenie/otoplenie-i-klimatizaciya/'
Time
547.89 µs
SQL
SELECT `Friendly_Id_Slugs`.* FROM `Friendly_Id_Slugs` WHERE `slug` = :where1 ORDER BY `id` DESC
Params
where1 => 'elektrouredi-i-otoplenie/otoplenie-i-klimatizaciya/'
Time
442.98 µ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 => 1352
where2 => 1353
where3 => 1
Time
925.06 µ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) GROUP BY `p`.`id`) AS `original_select`
Params
subselect1where1 => 1
subselect1where2 => 1
subselect1where3 => 1
subselect1where4 => '1353'
subselect1where5 => '1354'
subselect1where6 => '1355'
subselect1where7 => '1356'
subselect1where8 => '1357'
subselect1where9 => '3347'
subselect1where10 => '3348'
subselect1where11 => '3349'
subselect1where12 => '1358'
subselect1where13 => '1359'
subselect1where14 => '3412'
subselect1where15 => '3413'
subselect1where16 => '3414'
subselect1where17 => '3415'
subselect1where18 => '3416'
subselect1where19 => '1360'
subselect1where20 => '3027'
subselect1where21 => '3344'
subselect1where22 => '3345'
subselect1where23 => '1361'
subselect1where24 => '1362'
subselect1where25 => '1363'
subselect1where26 => '1364'
subselect1where27 => '1365'
subselect1where28 => '1366'
subselect1where29 => '1367'
subselect1where30 => '1368'
subselect1where31 => '1369'
subselect1where32 => '1370'
subselect1where33 => '3029'
subselect1where34 => '1239'
subselect1where35 => '3127'
subselect1where36 => '1371'
subselect1where37 => '1372'
subselect1where38 => '1373'
subselect1where39 => '1228'
subselect1where40 => '1229'
subselect1where41 => '1230'
subselect1where42 => '1231'
subselect1where43 => '1232'
subselect1where44 => '1233'
subselect1where45 => '1234'
subselect1where46 => '1235'
subselect1where47 => '1229'
subselect1where48 => '1230'
subselect1where49 => '1231'
subselect1where50 => '1232'
subselect1where51 => '1233'
subselect1where52 => '1234'
subselect1where53 => '1235'
subselect1where54 => '1236'
subselect1where55 => '1237'
subselect1where56 => '1238'
subselect1where57 => '1239'
subselect1where58 => '1367'
subselect1where59 => '3128'
subselect1where60 => '3129'
subselect1where61 => '3130'
Time
109.99 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) ORDER BY `p`.`id` DESC
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1353'
where5 => '1354'
where6 => '1355'
where7 => '1356'
where8 => '1357'
where9 => '3347'
where10 => '3348'
where11 => '3349'
where12 => '1358'
where13 => '1359'
where14 => '3412'
where15 => '3413'
where16 => '3414'
where17 => '3415'
where18 => '3416'
where19 => '1360'
where20 => '3027'
where21 => '3344'
where22 => '3345'
where23 => '1361'
where24 => '1362'
where25 => '1363'
where26 => '1364'
where27 => '1365'
where28 => '1366'
where29 => '1367'
where30 => '1368'
where31 => '1369'
where32 => '1370'
where33 => '3029'
where34 => '1239'
where35 => '3127'
where36 => '1371'
where37 => '1372'
where38 => '1373'
where39 => '1228'
where40 => '1229'
where41 => '1230'
where42 => '1231'
where43 => '1232'
where44 => '1233'
where45 => '1234'
where46 => '1235'
where47 => '1229'
where48 => '1230'
where49 => '1231'
where50 => '1232'
where51 => '1233'
where52 => '1234'
where53 => '1235'
where54 => '1236'
where55 => '1237'
where56 => '1238'
where57 => '1239'
where58 => '1367'
where59 => '3128'
where60 => '3129'
where61 => '3130'
Time
13.47 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) GROUP BY `p`.`id` ORDER BY `p`.`id` DESC
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1353'
where5 => '1354'
where6 => '1355'
where7 => '1356'
where8 => '1357'
where9 => '3347'
where10 => '3348'
where11 => '3349'
where12 => '1358'
where13 => '1359'
where14 => '3412'
where15 => '3413'
where16 => '3414'
where17 => '3415'
where18 => '3416'
where19 => '1360'
where20 => '3027'
where21 => '3344'
where22 => '3345'
where23 => '1361'
where24 => '1362'
where25 => '1363'
where26 => '1364'
where27 => '1365'
where28 => '1366'
where29 => '1367'
where30 => '1368'
where31 => '1369'
where32 => '1370'
where33 => '3029'
where34 => '1239'
where35 => '3127'
where36 => '1371'
where37 => '1372'
where38 => '1373'
where39 => '1228'
where40 => '1229'
where41 => '1230'
where42 => '1231'
where43 => '1232'
where44 => '1233'
where45 => '1234'
where46 => '1235'
where47 => '1229'
where48 => '1230'
where49 => '1231'
where50 => '1232'
where51 => '1233'
where52 => '1234'
where53 => '1235'
where54 => '1236'
where55 => '1237'
where56 => '1238'
where57 => '1239'
where58 => '1367'
where59 => '3128'
where60 => '3129'
where61 => '3130'
Time
53.74 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) GROUP BY `p`.`id` ORDER BY `p`.`id` DESC LIMIT :limit OFFSET :offset
Params
where1 => 1
where2 => 1
where3 => 1
where4 => '1353'
where5 => '1354'
where6 => '1355'
where7 => '1356'
where8 => '1357'
where9 => '3347'
where10 => '3348'
where11 => '3349'
where12 => '1358'
where13 => '1359'
where14 => '3412'
where15 => '3413'
where16 => '3414'
where17 => '3415'
where18 => '3416'
where19 => '1360'
where20 => '3027'
where21 => '3344'
where22 => '3345'
where23 => '1361'
where24 => '1362'
where25 => '1363'
where26 => '1364'
where27 => '1365'
where28 => '1366'
where29 => '1367'
where30 => '1368'
where31 => '1369'
where32 => '1370'
where33 => '3029'
where34 => '1239'
where35 => '3127'
where36 => '1371'
where37 => '1372'
where38 => '1373'
where39 => '1228'
where40 => '1229'
where41 => '1230'
where42 => '1231'
where43 => '1232'
where44 => '1233'
where45 => '1234'
where46 => '1235'
where47 => '1229'
where48 => '1230'
where49 => '1231'
where50 => '1232'
where51 => '1233'
where52 => '1234'
where53 => '1235'
where54 => '1236'
where55 => '1237'
where56 => '1238'
where57 => '1239'
where58 => '1367'
where59 => '3128'
where60 => '3129'
where61 => '3130'
limit => 36
offset => 0
Time
70.29 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
612.02 µ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
490.19 µs