Query Metrics

7 Database Queries
7 Different statements
370.44 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
222.92 ms
(60.18%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  434488
  445041
  408768
  418553
  444118
  411834
  440292
  446136
  450280
  450795
  458804
  460842
  468316
  469240
  469976
  473786
  486008
  488564
  445576
  447162
  450136
  453197
  493808
  447342
  454682
  465706
  477266
  489335
  491601
  495322
  496981
  497235
  504079
  512605
  532498
  507127
  509372
  495211
  509959
  469571
  474657
  486365
  493834
  548659
  551397
  570559
  575129
  578138
  570528
  552208
  552222
  574358
  579456
  674125
  722557
  548713
  551334
  554143
  563135
  566301
  570533
  573051
  575630
  590334
  596625
  730751
  753155
  219740
  220774
  400235
  417608
  438540
  441376
  449216
  449316
  454361
  463812
  472798
  479567
  392785
  402234
  446215
  454106
  456125
  464270
  386915
  426003
  427004
  430858
  455450
  465200
  468793
  471938
  476439
  476534
  478520
  382734
  420329
  428848
  433827
  437727
  452925
  474260
  479283
  447083
  449712
  455284
  501435
  502727
  503196
  508304
  513628
  516077
  518259
  526668
  485976
  487300
  489164
  495620
  497498
]
137.84 ms
(37.21%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  219740
  220774
  382734
  386915
  392785
  400235
  402234
  408768
  411834
  417608
  418553
  420329
  426003
  427004
  428848
  430858
  433827
  434488
  437727
  438540
  440292
  441376
  444118
  445041
  445576
  446136
  446215
  447083
  447162
  447342
  449216
  449316
  449712
  450136
  450280
  450795
  452925
  453197
  454106
  454361
  454682
  455284
  455450
  456125
  458804
  460842
  463812
  464270
  465200
  465706
  468316
  468793
  469240
  469571
  469976
  471938
  472798
  473786
  474260
  474657
  476439
  476534
  477266
  478520
  479283
  479567
  485976
  486008
  486365
  487300
  488564
  489164
  489335
  491601
  493808
  493834
  495211
  495322
  495620
  496981
  497235
  497498
  501435
  502727
  503196
  504079
  507127
  508304
  509372
  509959
  512605
  513628
  516077
  518259
  526668
  532498
  548659
  548713
  551334
  551397
  552208
  552222
  554143
  563135
  566301
  570528
  570533
  570559
  573051
  574358
  575129
  575630
  578138
  579456
  590334
  596625
  674125
  722557
  730751
  753155
]
3.13 ms
(0.84%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  219740
  220774
  382734
  386915
  392785
  400235
  402234
  408768
  411834
  417608
  418553
  420329
  426003
  427004
  428848
  430858
  433827
  434488
  437727
  438540
  440292
  441376
  444118
  445041
  445576
  446136
  446215
  447083
  447162
  447342
  449216
  449316
  449712
  450136
  450280
  450795
  452925
  453197
  454106
  454361
  454682
  455284
  455450
  456125
  458804
  460842
  463812
  464270
  465200
  465706
  468316
  468793
  469240
  469571
  469976
  471938
  472798
  473786
  474260
  474657
  476439
  476534
  477266
  478520
  479283
  479567
  485976
  486008
  486365
  487300
  488564
  489164
  489335
  491601
  493808
  493834
  495211
  495322
  495620
  496981
  497235
  497498
  501435
  502727
  503196
  504079
  507127
  508304
  509372
  509959
  512605
  513628
  516077
  518259
  526668
  532498
  548659
  548713
  551334
  551397
  552208
  552222
  554143
  563135
  566301
  570528
  570533
  570559
  573051
  574358
  575129
  575630
  578138
  579456
  590334
  596625
  674125
  722557
  730751
  753155
]
1.85 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "коже"
]
1.74 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кож"
]
1.61 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кож"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.