Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.32 ms
(82.96%)
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
  393701
  414688
  414734
  428966
  430977
  446600
  447501
  451528
  454722
  455211
  466187
  470773
  471997
  475965
  478875
  481311
  482073
  487207
  489499
  489597
  489818
  489856
  497074
  502115
  503962
  505952
  508035
  508830
  511600
  512129
  513724
  518053
  525938
  543750
  546004
  546715
  548788
  552647
  556574
  557981
  558003
  558844
  561825
  562208
  563063
  563188
  563803
  565947
  565953
  567335
  568121
  569134
  569878
  570031
  570197
  571893
  573345
  573557
  573667
  573814
  574826
  575503
  575774
  576062
  576098
  586493
  586605
  592071
  596871
  597066
  598617
  617340
  619509
  654317
  654575
  655671
  658358
  659394
  671127
  672466
  676465
  676529
  677345
  678541
  678552
  679044
  679060
  679062
  679067
  679350
  679368
  714432
  722695
  722730
  722867
  722888
  722901
  723421
  730987
  742181
  744262
  744441
  745075
  745381
  751770
  753360
  753364
  753418
  753847
  753870
  755836
  758987
  760514
  766242
  769811
  788717
  811439
  819963
  824146
]
14.98 ms
(10.24%)
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
  744262
  503962
  745075
  447501
  489499
  819963
  672466
  744441
  671127
  597066
  475965
  576098
  505952
  518053
  596871
  760514
  446600
  576062
  565953
  574826
  451528
  562208
  502115
  393701
  478875
  487207
  659394
  561825
  543750
  730987
  552647
  679350
  563063
  430977
  598617
  570031
  567335
  676465
  617340
  679067
  573557
  714432
  548788
  569134
  454722
  654575
  678541
  753847
  753364
  753418
  788717
  481311
  677345
  753870
  455211
  573345
  573667
  428966
  508830
  766242
  558003
  676529
  679062
  722901
  811439
  753360
  755836
  722695
  414688
  466187
  556574
  654317
  658358
  569878
  571893
  563188
  508035
  570197
  619509
  546004
  546715
  568121
  592071
  586493
  586605
  511600
  497074
  679368
  722867
  678552
  745381
  769811
  751770
  723421
  824146
  672488
  558844
  563803
  565947
  573814
  470773
  512129
  557981
  482073
  513724
  575503
  575774
  489818
  489597
  471997
  655671
  525938
  489856
  679044
  679060
  722888
  722730
  758987
  742181
  414734
]
2.78 ms
(1.90%)
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
  393701
  414688
  414734
  428966
  430977
  446600
  447501
  451528
  454722
  455211
  466187
  470773
  471997
  475965
  478875
  481311
  482073
  487207
  489499
  489597
  489818
  489856
  497074
  502115
  503962
  505952
  508035
  508830
  511600
  512129
  513724
  518053
  525938
  543750
  546004
  546715
  548788
  552647
  556574
  557981
  558003
  558844
  561825
  562208
  563063
  563188
  563803
  565947
  565953
  567335
  568121
  569134
  569878
  570031
  570197
  571893
  573345
  573557
  573667
  573814
  574826
  575503
  575774
  576062
  576098
  586493
  586605
  592071
  596871
  597066
  598617
  617340
  619509
  654317
  654575
  655671
  658358
  659394
  671127
  672466
  676465
  676529
  677345
  678541
  678552
  679044
  679060
  679062
  679067
  679350
  679368
  714432
  722695
  722730
  722867
  722888
  722901
  723421
  730987
  742181
  744262
  744441
  745075
  745381
  751770
  753360
  753364
  753418
  753847
  753870
  755836
  758987
  760514
  766242
  769811
  788717
  811439
  819963
  824146
]
2.08 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское худые куни"
]
1.68 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск худые куннилингус оральн секс"
]
1.36 ms
(0.93%)
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.