Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.87 ms
(86.79%)
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
  509451
  542538
  543825
  546671
  548657
  548706
  549802
  551198
  552224
  552518
  553493
  558052
  558827
  558857
  559021
  559032
  560381
  560481
  560617
  561001
  561672
  563452
  564408
  567403
  567741
  569848
  569858
  569913
  570018
  570365
  570465
  570500
  570591
  570607
  571037
  571515
  571615
  572030
  572169
  572368
  572819
  573107
  573116
  573416
  573560
  573619
  573624
  573704
  573853
  573945
  573962
  573968
  574539
  574835
  574871
  574874
  575071
  575727
  576276
  576411
  578385
  578972
  580688
  597499
  631260
  632719
  635117
  653287
  654356
  654514
  654670
  654721
  654826
  654833
  655348
  655656
  655730
  655750
  656076
  656360
  656785
  657393
  657705
  658065
  658257
  658359
  658403
  658670
  658698
  659113
  659140
  659155
  659161
  659502
  659565
  659638
  659650
  659739
  659759
  660974
  661249
  661885
  669644
  670405
  675462
  679057
  686453
  709466
  721317
  722764
  730718
  736373
  742215
  746978
  748548
  754264
  754355
  754540
  766542
  793982
]
15.05 ms
(7.47%)
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
  658257
  658359
  658698
  659113
  659155
  659161
  659565
  659638
  659739
  675462
  679057
  686453
  654356
  654670
  654721
  655750
  656360
  657393
  658403
  659502
  659759
  660974
  661249
  661885
  670405
  654514
  654826
  654833
  656785
  657705
  658670
  659140
  659650
  722764
  546671
  563452
  573853
  597499
  632719
  631260
  635117
  742215
  748548
  766542
  793982
  736373
  754264
  730718
  754355
  746978
  754540
  709466
  721317
  509451
  542538
  543825
  548657
  549802
  553493
  558827
  558857
  560381
  561672
  567403
  567741
  570018
  570465
  571037
  571515
  571615
  572030
  573619
  573962
  575071
  575727
  580688
  548706
  559021
  559032
  560481
  560617
  569848
  569858
  570365
  570500
  570591
  570607
  572169
  572368
  572819
  573107
  573116
  573416
  573560
  573704
  574539
  574835
  576411
  551198
  552224
  552518
  558052
  561001
  564408
  569913
  573624
  573945
  573968
  574871
  574874
  576276
  578385
  578972
  653287
  655730
  656076
  669644
  655348
  655656
  658065
]
3.77 ms
(1.87%)
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
  509451
  542538
  543825
  546671
  548657
  548706
  549802
  551198
  552224
  552518
  553493
  558052
  558827
  558857
  559021
  559032
  560381
  560481
  560617
  561001
  561672
  563452
  564408
  567403
  567741
  569848
  569858
  569913
  570018
  570365
  570465
  570500
  570591
  570607
  571037
  571515
  571615
  572030
  572169
  572368
  572819
  573107
  573116
  573416
  573560
  573619
  573624
  573704
  573853
  573945
  573962
  573968
  574539
  574835
  574871
  574874
  575071
  575727
  576276
  576411
  578385
  578972
  580688
  597499
  631260
  632719
  635117
  653287
  654356
  654514
  654670
  654721
  654826
  654833
  655348
  655656
  655730
  655750
  656076
  656360
  656785
  657393
  657705
  658065
  658257
  658359
  658403
  658670
  658698
  659113
  659140
  659155
  659161
  659502
  659565
  659638
  659650
  659739
  659759
  660974
  661249
  661885
  669644
  670405
  675462
  679057
  686453
  709466
  721317
  722764
  730718
  736373
  742215
  746978
  748548
  754264
  754355
  754540
  766542
  793982
]
2.24 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small russian"
]
1.92 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая русск"
]
1.80 ms
(0.89%)
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.