Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.54 ms
(86.80%)
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
  7219
  29242
  81214
  210281
  307633
  382275
  386593
  389226
  396051
  400719
  401558
  406217
  408974
  415818
  417711
  426128
  431850
  432786
  439652
  440441
  440700
  442523
  446103
  447883
  453366
  453471
  453638
  454883
  454953
  457012
  458521
  460227
  460680
  464673
  465182
  468062
  468301
  470108
  470826
  472333
  472370
  474193
  474795
  476744
  477236
  487859
  488928
  490590
  491711
  491831
  492458
  494273
  497581
  500923
  502913
  504120
  504415
  508062
  512044
  514160
  514289
  516993
  518862
  520391
  520587
  521906
  521909
  523954
  523974
  526019
  526361
  526480
  529027
  531423
  543085
  544386
  551190
  551654
  552051
  553003
  553037
  554231
  558995
  559030
  561442
  565398
  565401
  565455
  565755
  569850
  569881
  570311
  570319
  570339
  570384
  570460
  570506
  571594
  571924
  572792
  573416
  573635
  576281
  576309
  578848
  595808
  599777
  606069
  609103
  612171
  626127
  649888
  663347
  672423
  687620
  695646
  736544
  750190
  785775
  787985
]
20.14 ms
(8.46%)
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
  454883
  516993
  572792
  570506
  571924
  453366
  446103
  529027
  396051
  672423
  470108
  508062
  518862
  544386
  609103
  787985
  386593
  29242
  454953
  543085
  570384
  565455
  389226
  210281
  490590
  526480
  457012
  500923
  474193
  460227
  453638
  464673
  460680
  488928
  439652
  474795
  440700
  504120
  426128
  565755
  558995
  514160
  514289
  468062
  570339
  382275
  785775
  400719
  415818
  551190
  521909
  612171
  578848
  595808
  736544
  750190
  599777
  526361
  626127
  606069
  502913
  442523
  520391
  649888
  472333
  468301
  554231
  565401
  553003
  559030
  551654
  487859
  521906
  526019
  531423
  570319
  569881
  571594
  576281
  576309
  417711
  504415
  491711
  552051
  561442
  687620
  695646
  81214
  458521
  570460
  573416
  565398
  573635
  569850
  406217
  307633
  7219
  431850
  432786
  453471
  476744
  494273
  491831
  553037
  570311
  408974
  497581
  512044
  447883
  663347
  477236
  492458
  440441
  465182
  472370
  470826
  523954
  520587
  523974
  401558
]
2.54 ms
(1.07%)
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
  7219
  29242
  81214
  210281
  307633
  382275
  386593
  389226
  396051
  400719
  401558
  406217
  408974
  415818
  417711
  426128
  431850
  432786
  439652
  440441
  440700
  442523
  446103
  447883
  453366
  453471
  453638
  454883
  454953
  457012
  458521
  460227
  460680
  464673
  465182
  468062
  468301
  470108
  470826
  472333
  472370
  474193
  474795
  476744
  477236
  487859
  488928
  490590
  491711
  491831
  492458
  494273
  497581
  500923
  502913
  504120
  504415
  508062
  512044
  514160
  514289
  516993
  518862
  520391
  520587
  521906
  521909
  523954
  523974
  526019
  526361
  526480
  529027
  531423
  543085
  544386
  551190
  551654
  552051
  553003
  553037
  554231
  558995
  559030
  561442
  565398
  565401
  565455
  565755
  569850
  569881
  570311
  570319
  570339
  570384
  570460
  570506
  571594
  571924
  572792
  573416
  573635
  576281
  576309
  578848
  595808
  599777
  606069
  609103
  612171
  626127
  649888
  663347
  672423
  687620
  695646
  736544
  750190
  785775
  787985
]
2.42 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public homemade"
]
2.25 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на улиц домашн любительск"
]
2.19 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на улиц домашн любительск"
]
1.88 ms
(0.79%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.