Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.61 ms
(82.26%)
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
  229345
  399164
  401027
  415551
  423646
  427559
  440393
  442947
  446691
  446993
  447834
  448636
  453147
  453815
  454551
  455747
  461391
  465798
  466985
  470960
  471336
  474763
  477891
  491331
  493090
  494280
  498247
  504812
  507249
  507844
  508744
  513024
  514905
  515030
  515403
  518353
  520010
  520309
  520372
  521716
  526518
  528920
  529692
  530045
  532273
  534516
  535072
  535756
  540095
  540461
  541563
  543983
  546423
  546989
  551479
  551481
  552863
  562868
  563572
  566011
  576522
  578433
  579532
  589757
  595047
  597746
  598805
  599142
  607018
  607519
  615138
  621065
  621419
  637516
  639661
  646977
  651128
  669337
  670919
  671085
  675329
  677352
  687962
  694010
  694507
  695186
  695551
  695613
  697368
  697840
  697986
  699781
  700731
  710266
  710677
  714089
  716270
  716502
  725303
  732072
  733123
  735782
  742331
  750729
  751958
  756504
  758635
  758869
  762322
  783069
  784102
  784822
  787713
  789437
  797666
  803807
  810521
  811525
  822061
  823889
]
16.80 ms
(11.00%)
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
  700731
  784102
  797666
  803807
  427559
  423646
  470960
  498247
  541563
  551481
  563572
  651128
  695551
  716502
  589757
  762322
  732072
  526518
  401027
  442947
  822061
  491331
  446993
  474763
  446691
  453147
  453815
  477891
  515030
  515403
  530045
  514905
  507249
  535756
  540461
  471336
  546989
  552863
  669337
  677352
  694010
  597746
  599142
  639661
  811525
  783069
  725303
  750729
  751958
  756504
  399164
  229345
  461391
  465798
  415551
  440393
  454551
  455747
  504812
  520010
  513024
  518353
  520372
  508744
  520309
  823889
  447834
  493090
  448636
  494280
  528920
  529692
  540095
  507844
  534516
  532273
  535072
  521716
  466985
  566011
  576522
  579532
  543983
  551479
  562868
  646977
  670919
  671085
  687962
  699781
  710677
  714089
  675329
  694507
  695186
  695613
  710266
  697368
  697840
  697986
  716270
  546423
  578433
  598805
  607018
  615138
  595047
  607519
  621065
  637516
  621419
  787713
  810521
  784822
  758869
  789437
  735782
  742331
  733123
  758635
]
2.61 ms
(1.71%)
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
  229345
  399164
  401027
  415551
  423646
  427559
  440393
  442947
  446691
  446993
  447834
  448636
  453147
  453815
  454551
  455747
  461391
  465798
  466985
  470960
  471336
  474763
  477891
  491331
  493090
  494280
  498247
  504812
  507249
  507844
  508744
  513024
  514905
  515030
  515403
  518353
  520010
  520309
  520372
  521716
  526518
  528920
  529692
  530045
  532273
  534516
  535072
  535756
  540095
  540461
  541563
  543983
  546423
  546989
  551479
  551481
  552863
  562868
  563572
  566011
  576522
  578433
  579532
  589757
  595047
  597746
  598805
  599142
  607018
  607519
  615138
  621065
  621419
  637516
  639661
  646977
  651128
  669337
  670919
  671085
  675329
  677352
  687962
  694010
  694507
  695186
  695551
  695613
  697368
  697840
  697986
  699781
  700731
  710266
  710677
  714089
  716270
  716502
  725303
  732072
  733123
  735782
  742331
  750729
  751958
  756504
  758635
  758869
  762322
  783069
  784102
  784822
  787713
  789437
  797666
  803807
  810521
  811525
  822061
  823889
]
2.11 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "video ass"
]
1.98 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "video жоп"
]
1.90 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "video жоп"
]

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.