Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.82 ms
(51.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
173.28 ms
(42.17%)
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
  391372
  399652
  414385
  415365
  415821
  416874
  417250
  417656
  420300
  422308
  422561
  422847
  423039
  423635
  425477
  428481
  429669
  431969
  437592
  444452
  445835
  447127
  447277
  447407
  447965
  447969
  450540
  450826
  450939
  451252
  451746
  454284
  456215
  456818
  456897
  457189
  457389
  459364
  460302
  460929
  461231
  462418
  463243
  463915
  465645
  465951
  467920
  468011
  468132
  468741
  471956
  471965
  472845
  473837
  473967
  474487
  477882
  478653
  479728
  480245
  480941
  481780
  481792
  481795
  486872
  487251
  488771
  490003
  491319
  492119
  492187
  492414
  494568
  495144
  495689
  495763
  496611
  497729
  499553
  500907
  501290
  503899
  504623
  505842
  506255
  506297
  507702
  507939
  507943
  509799
  511840
  513261
  515213
  516439
  516499
  517444
  517778
  518577
  518936
  519508
  520172
  520604
  522081
  523036
  523121
  525219
  525352
  525550
  526548
  527645
  530734
  531212
  531905
  532969
  532978
  537122
  537732
  537915
  538837
  540316
]
18.52 ms
(4.51%)
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
  391372
  399652
  422561
  423039
  423635
  428481
  414385
  415365
  422847
  425477
  437592
  416874
  431969
  415821
  417250
  417656
  420300
  422308
  429669
  444452
  450826
  450939
  457189
  457389
  460302
  463915
  471956
  478653
  480245
  487251
  488771
  447277
  447407
  447965
  447969
  456818
  456897
  459364
  460929
  463243
  465951
  471965
  472845
  473837
  479728
  481795
  486872
  491319
  492119
  492414
  445835
  447127
  450540
  451252
  451746
  454284
  456215
  461231
  462418
  465645
  467920
  468011
  468132
  468741
  473967
  474487
  477882
  480941
  481780
  481792
  490003
  492187
  494568
  495689
  496611
  499553
  501290
  505842
  506255
  511840
  516499
  518936
  523036
  523121
  526548
  530734
  532978
  537915
  500907
  504623
  506297
  507939
  507943
  513261
  515213
  518577
  519508
  522081
  525550
  527645
  531212
  531905
  532969
  537122
  537732
  538837
  540316
  495144
  495763
  497729
  503899
  507702
  509799
  516439
  517444
  517778
  520172
  520604
  525219
  525352
]
3.73 ms
(0.91%)
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
  391372
  399652
  414385
  415365
  415821
  416874
  417250
  417656
  420300
  422308
  422561
  422847
  423039
  423635
  425477
  428481
  429669
  431969
  437592
  444452
  445835
  447127
  447277
  447407
  447965
  447969
  450540
  450826
  450939
  451252
  451746
  454284
  456215
  456818
  456897
  457189
  457389
  459364
  460302
  460929
  461231
  462418
  463243
  463915
  465645
  465951
  467920
  468011
  468132
  468741
  471956
  471965
  472845
  473837
  473967
  474487
  477882
  478653
  479728
  480245
  480941
  481780
  481792
  481795
  486872
  487251
  488771
  490003
  491319
  492119
  492187
  492414
  494568
  495144
  495689
  495763
  496611
  497729
  499553
  500907
  501290
  503899
  504623
  505842
  506255
  506297
  507702
  507939
  507943
  509799
  511840
  513261
  515213
  516439
  516499
  517444
  517778
  518577
  518936
  519508
  520172
  520604
  522081
  523036
  523121
  525219
  525352
  525550
  526548
  527645
  530734
  531212
  531905
  532969
  532978
  537122
  537732
  537915
  538837
  540316
]
1.95 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white доминирован"
]
1.86 ms
(0.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white submissive"
]
1.73 ms
(0.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.