Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.38 ms
(82.71%)
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
  393872
  397687
  420736
  424030
  434883
  443151
  444262
  452736
  453007
  453497
  455525
  457625
  458277
  463596
  466137
  468881
  471528
  472888
  473390
  477613
  478995
  479070
  479183
  479446
  483262
  483663
  487371
  490648
  493004
  493886
  494553
  494849
  495117
  495458
  496140
  496203
  497783
  497903
  498855
  499694
  500099
  500639
  500818
  502103
  502372
  503977
  504048
  504114
  507442
  507459
  508138
  508322
  508808
  509752
  511615
  512635
  514064
  514109
  517758
  518184
  518642
  518911
  519071
  520504
  524788
  524820
  524824
  525057
  526136
  526863
  527467
  528238
  528332
  528667
  529123
  529231
  529357
  529856
  531962
  532201
  532417
  532469
  533317
  533666
  534180
  534615
  535289
  535653
  535993
  536145
  537401
  537980
  538070
  538502
  539349
  540603
  542256
  548832
  551693
  556080
  631009
  634190
  689524
  719725
  719742
  719968
  720231
  729431
  733361
  734661
  739882
  760990
  761686
  769710
  783386
  800852
  810544
  816759
  818704
  819738
]
15.61 ms
(9.68%)
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
  508138
  498855
  509752
  524788
  478995
  479446
  458277
  500099
  507459
  511615
  526136
  535289
  500818
  529123
  529357
  514109
  529856
  534615
  535993
  536145
  537401
  494849
  496203
  497903
  517758
  520504
  525057
  532469
  472888
  473390
  542256
  556080
  719968
  689524
  800852
  810544
  729431
  734661
  760990
  719725
  720231
  466137
  455525
  424030
  531962
  502372
  434883
  452736
  494553
  500639
  503977
  495458
  528332
  487371
  518642
  508808
  483262
  490648
  504114
  443151
  453007
  457625
  468881
  471528
  502103
  540603
  528667
  529231
  537980
  493886
  444262
  519071
  483663
  518184
  539349
  532201
  538070
  453497
  527467
  479183
  534180
  495117
  514064
  524820
  524824
  504048
  528238
  532417
  507442
  508322
  393872
  420736
  816759
  818704
  819738
  477613
  463596
  493004
  497783
  499694
  512635
  526863
  538502
  518911
  533666
  496140
  533317
  535653
  479070
  548832
  551693
  719742
  634190
  631009
  761686
  783386
  733361
  769710
  739882
  397687
]
3.79 ms
(2.35%)
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
  393872
  397687
  420736
  424030
  434883
  443151
  444262
  452736
  453007
  453497
  455525
  457625
  458277
  463596
  466137
  468881
  471528
  472888
  473390
  477613
  478995
  479070
  479183
  479446
  483262
  483663
  487371
  490648
  493004
  493886
  494553
  494849
  495117
  495458
  496140
  496203
  497783
  497903
  498855
  499694
  500099
  500639
  500818
  502103
  502372
  503977
  504048
  504114
  507442
  507459
  508138
  508322
  508808
  509752
  511615
  512635
  514064
  514109
  517758
  518184
  518642
  518911
  519071
  520504
  524788
  524820
  524824
  525057
  526136
  526863
  527467
  528238
  528332
  528667
  529123
  529231
  529357
  529856
  531962
  532201
  532417
  532469
  533317
  533666
  534180
  534615
  535289
  535653
  535993
  536145
  537401
  537980
  538070
  538502
  539349
  540603
  542256
  548832
  551693
  556080
  631009
  634190
  689524
  719725
  719742
  719968
  720231
  729431
  733361
  734661
  739882
  760990
  761686
  769710
  783386
  800852
  810544
  816759
  818704
  819738
]
2.45 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жен white сперм"
]
2.05 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife white sperm"
]
2.02 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен white сперм"
]

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.