Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.41 ms
(83.33%)
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
  282626
  386271
  395654
  395849
  396100
  398368
  413707
  418538
  420201
  423428
  423482
  425878
  428253
  431333
  432777
  434491
  435400
  441476
  443312
  444807
  445322
  445903
  447755
  448355
  448403
  449060
  451175
  451625
  451752
  451907
  459099
  463110
  463124
  463809
  466987
  470173
  470320
  473182
  474021
  475483
  476752
  477146
  480856
  484400
  484483
  485319
  488725
  489931
  491286
  491472
  491663
  491669
  491672
  491686
  491946
  494121
  501232
  501283
  503406
  506195
  507291
  508876
  509064
  510550
  510618
  512922
  513284
  516615
  517854
  518005
  518048
  520736
  520740
  523190
  523996
  524694
  527215
  527623
  529854
  529855
  531106
  533531
  533949
  536233
  546202
  550560
  550747
  561008
  583670
  591224
  594338
  597079
  597169
  604329
  606268
  611336
  619169
  626539
  626735
  633215
  636285
  641667
  643233
  643653
  674943
  675001
  720739
  722499
  726205
  728768
  736265
  738636
  746722
  751503
  761013
  761746
  793749
  817115
  819530
  819593
]
15.91 ms
(9.94%)
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
  720739
  722499
  546202
  550560
  550747
  561008
  597169
  606268
  619169
  636285
  643653
  594338
  597079
  604329
  626539
  643233
  591224
  611336
  626735
  633215
  793749
  736265
  746722
  761746
  738636
  761013
  726205
  751503
  728768
  463110
  463124
  470173
  480856
  470320
  395654
  398368
  435400
  474021
  441476
  451752
  477146
  508876
  509064
  517854
  527623
  491472
  491669
  491946
  512922
  518048
  489931
  491663
  491672
  510618
  513284
  524694
  484400
  488725
  491686
  501232
  518005
  418538
  466987
  449060
  451625
  475483
  529854
  533949
  641667
  463809
  459099
  431333
  510550
  516615
  520740
  491286
  503406
  507291
  523996
  527215
  523190
  675001
  445903
  529855
  533531
  536233
  506195
  531106
  583670
  425878
  451175
  476752
  473182
  494121
  501283
  520736
  484483
  674943
  386271
  395849
  282626
  396100
  423482
  444807
  434491
  432777
  420201
  428253
  443312
  413707
  423428
  445322
  817115
  819593
  819530
  448355
  448403
  451907
  485319
  447755
]
4.36 ms
(2.72%)
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
  282626
  386271
  395654
  395849
  396100
  398368
  413707
  418538
  420201
  423428
  423482
  425878
  428253
  431333
  432777
  434491
  435400
  441476
  443312
  444807
  445322
  445903
  447755
  448355
  448403
  449060
  451175
  451625
  451752
  451907
  459099
  463110
  463124
  463809
  466987
  470173
  470320
  473182
  474021
  475483
  476752
  477146
  480856
  484400
  484483
  485319
  488725
  489931
  491286
  491472
  491663
  491669
  491672
  491686
  491946
  494121
  501232
  501283
  503406
  506195
  507291
  508876
  509064
  510550
  510618
  512922
  513284
  516615
  517854
  518005
  518048
  520736
  520740
  523190
  523996
  524694
  527215
  527623
  529854
  529855
  531106
  533531
  533949
  536233
  546202
  550560
  550747
  561008
  583670
  591224
  594338
  597079
  597169
  604329
  606268
  611336
  619169
  626539
  626735
  633215
  636285
  641667
  643233
  643653
  674943
  675001
  720739
  722499
  726205
  728768
  736265
  738636
  746722
  751503
  761013
  761746
  793749
  817115
  819530
  819593
]
2.06 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "slave teen"
]
1.60 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "доминирован teen"
]
1.30 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "доминирован teen"
]

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.