Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.29 ms
(82.63%)
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
  187800
  397861
  397881
  400474
  400498
  402715
  404950
  411036
  412299
  415246
  419653
  421826
  421847
  421860
  421864
  421867
  421875
  421887
  421889
  421894
  421895
  421897
  421936
  422165
  422191
  422923
  424410
  426139
  426220
  428026
  428143
  428421
  428716
  430002
  439682
  439710
  439724
  440649
  444723
  444870
  445187
  447549
  447914
  451246
  453387
  454848
  457432
  457442
  459072
  464550
  466263
  466474
  466603
  469389
  472338
  473479
  475724
  478525
  478640
  483637
  483656
  484639
  489381
  490886
  496820
  497470
  502615
  506529
  508143
  513972
  517711
  519586
  519958
  522508
  528440
  544790
  544858
  544860
  549842
  549846
  549848
  551870
  560946
  566834
  573266
  576702
  580174
  589747
  604286
  614968
  617350
  618449
  620900
  623528
  624299
  628414
  631948
  649576
  650326
  656575
  660416
  666591
  669012
  669038
  669410
  716787
  720289
  722889
  735515
  741158
  750121
  751092
  756506
  770495
  797799
  799146
  799360
  803046
  803524
  812909
]
20.28 ms
(9.73%)
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
  544790
  580174
  669038
  720289
  656575
  669410
  716787
  649576
  650326
  660416
  666591
  549842
  549846
  576702
  623528
  624299
  604286
  803524
  741158
  797799
  812909
  756506
  735515
  750121
  770495
  751092
  631948
  722889
  799360
  803046
  397861
  422165
  424410
  469389
  400498
  421875
  428143
  459072
  466263
  400474
  421847
  421887
  421889
  421897
  445187
  454848
  466474
  411036
  421936
  426139
  428716
  440649
  453387
  464550
  472338
  421826
  422923
  430002
  444723
  451246
  517711
  519958
  483637
  483656
  490886
  497470
  519586
  522508
  484639
  489381
  496820
  502615
  187800
  397881
  426220
  419653
  422191
  617350
  447914
  478640
  473479
  508143
  528440
  506529
  513972
  475724
  566834
  544860
  551870
  544858
  560946
  573266
  669012
  549848
  589747
  620900
  628414
  618449
  799146
  614968
  415246
  402715
  421860
  428026
  428421
  439724
  457432
  478525
  404950
  412299
  421864
  421867
  421894
  421895
  439682
  439710
  444870
  447549
  457442
  466603
]
5.71 ms
(2.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
4.32 ms
(2.07%)
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
  187800
  397861
  397881
  400474
  400498
  402715
  404950
  411036
  412299
  415246
  419653
  421826
  421847
  421860
  421864
  421867
  421875
  421887
  421889
  421894
  421895
  421897
  421936
  422165
  422191
  422923
  424410
  426139
  426220
  428026
  428143
  428421
  428716
  430002
  439682
  439710
  439724
  440649
  444723
  444870
  445187
  447549
  447914
  451246
  453387
  454848
  457432
  457442
  459072
  464550
  466263
  466474
  466603
  469389
  472338
  473479
  475724
  478525
  478640
  483637
  483656
  484639
  489381
  490886
  496820
  497470
  502615
  506529
  508143
  513972
  517711
  519586
  519958
  522508
  528440
  544790
  544858
  544860
  549842
  549846
  549848
  551870
  560946
  566834
  573266
  576702
  580174
  589747
  604286
  614968
  617350
  618449
  620900
  623528
  624299
  628414
  631948
  649576
  650326
  656575
  660416
  666591
  669012
  669038
  669410
  716787
  720289
  722889
  735515
  741158
  750121
  751092
  756506
  770495
  797799
  799146
  799360
  803046
  803524
  812909
]
2.31 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red anal"
]
1.98 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red анал"
]
1.62 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red анал"
]

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.