Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.43 ms
(52.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina pov"
]
171.03 ms
(42.69%)
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
  72499
  387871
  395530
  403539
  413735
  454050
  455261
  455929
  464410
  489158
  509770
  512448
  513057
  522717
  526235
  531149
  532207
  536018
  540435
  553115
  560103
  577226
  601222
  602107
  617174
  623305
  627123
  627886
  647897
  667797
  676150
  691303
  701407
  701554
  701687
  708078
  710189
  730229
  734500
  735851
  737315
  757288
  758901
  759267
  760678
  761283
  761462
  761764
  763054
  763599
  765394
  765438
  770700
  771083
  771249
  776142
  776613
  777801
  778834
  780903
  783277
  784821
  785162
  785294
  785547
  787965
  787981
  793669
  796683
  797794
  799242
  799320
  801618
  803854
  804061
  804549
  804968
  805672
  808078
  808672
  811728
  811956
  811962
  812210
  812873
  812947
  813023
  813444
  813669
  813789
  814328
  815001
  815098
  817240
  818537
  820096
  820664
  820989
  821431
  821458
  821484
  821986
  822057
  822211
  822231
  822263
  822553
  822669
  822850
  823231
  823332
  823341
  823426
  823473
  825310
  825756
  825915
  827888
]
12.75 ms
(3.18%)
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
  796683
  805672
  811728
  812947
  813444
  730229
  755642
  757288
  758901
  761462
  765438
  783277
  784821
  785162
  785294
  787965
  787981
  793669
  797794
  799320
  801618
  804549
  808078
  811956
  735851
  759267
  737315
  760678
  761283
  763054
  771083
  763599
  770700
  602107
  617174
  627123
  701687
  710189
  777801
  778834
  799242
  804061
  808672
  811962
  812210
  812873
  813023
  489158
  822553
  823231
  821986
  560103
  785547
  72499
  531149
  701554
  691303
  553115
  623305
  761764
  734500
  774140
  771249
  765394
  822211
  540435
  780903
  803854
  776142
  776613
  804968
  395530
  455929
  387871
  403539
  413735
  813789
  820989
  821484
  822850
  825915
  813669
  815098
  823341
  825756
  814328
  815001
  818537
  820096
  822263
  822669
  823332
  823426
  823473
  825310
  817240
  820664
  821431
  821458
  822057
  822231
  827888
  455261
  454050
  464410
  513057
  522717
  509770
  532207
  512448
  526235
  536018
  577226
  647897
  667797
  676150
  701407
  708078
  627886
  601222
]
3.58 ms
(0.89%)
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
  72499
  387871
  395530
  403539
  413735
  454050
  455261
  455929
  464410
  489158
  509770
  512448
  513057
  522717
  526235
  531149
  532207
  536018
  540435
  553115
  560103
  577226
  601222
  602107
  617174
  623305
  627123
  627886
  647897
  667797
  676150
  691303
  701407
  701554
  701687
  708078
  710189
  730229
  734500
  735851
  737315
  757288
  758901
  759267
  760678
  761283
  761462
  761764
  763054
  763599
  765394
  765438
  770700
  771083
  771249
  776142
  776613
  777801
  778834
  780903
  783277
  784821
  785162
  785294
  785547
  787965
  787981
  793669
  796683
  797794
  799242
  799320
  801618
  803854
  804061
  804549
  804968
  805672
  808078
  808672
  811728
  811956
  811962
  812210
  812873
  812947
  813023
  813444
  813669
  813789
  814328
  815001
  815098
  817240
  818537
  820096
  820664
  820989
  821431
  821458
  821484
  821986
  822057
  822211
  822231
  822263
  822553
  822669
  822850
  823231
  823332
  823341
  823426
  823473
  825310
  825756
  825915
  827888
]
1.82 ms
(0.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская пов"
]
1.59 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская пов"
]
1.47 ms
(0.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.