Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.17 ms
(84.90%)
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
  515060
  532135
  546138
  546822
  554452
  559348
  562450
  563416
  570127
  580241
  581661
  588084
  589821
  601885
  605202
  609647
  615937
  617440
  623943
  630068
  652573
  663390
  663417
  663431
  663865
  663946
  664539
  665401
  665406
  665408
  665419
  665447
  665470
  665479
  666790
  667279
  667522
  667541
  667607
  667621
  667655
  667766
  667876
  667906
  668897
  670479
  684364
  691523
  695634
  702179
  709544
  712625
  712804
  712927
  714145
  714165
  714504
  717683
  717700
  718498
  721454
  722281
  724290
  726962
  730097
  732399
  733254
  735477
  738310
  738314
  739686
  740645
  742786
  743800
  744194
  744915
  746060
  746406
  746710
  755684
  756620
  759439
  759810
  770248
  771357
  773901
  775571
  777167
  781682
  781693
  781707
  781755
  782186
  782234
  782249
  782276
  785436
  785940
  785941
  788237
  788411
  788473
  788680
  789424
  790158
  793694
  794667
  794697
  794705
  796101
  798901
  800557
  801009
  803342
  804112
  806241
  807886
  808280
  809857
  812232
]
12.38 ms
(8.33%)
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
  515060
  532135
  546822
  554452
  580241
  546138
  563416
  559348
  663417
  664539
  665401
  665408
  665447
  665470
  665479
  667607
  667655
  667906
  684364
  691523
  702179
  712625
  712804
  717683
  717700
  663946
  667279
  667621
  667766
  667876
  695634
  712927
  714165
  718498
  721454
  722281
  652573
  663390
  663431
  663865
  665406
  665419
  666790
  667522
  667541
  668897
  670479
  709544
  714145
  562450
  570127
  581661
  605202
  615937
  589821
  601885
  588084
  609647
  630068
  623943
  775571
  781755
  782249
  785941
  788411
  788473
  788680
  794697
  794705
  796101
  798901
  801009
  777167
  781693
  781707
  785940
  793694
  794667
  800557
  803342
  806241
  807886
  809857
  730097
  740645
  744194
  746406
  746710
  755684
  759439
  770248
  773901
  781682
  782186
  782234
  782276
  785436
  788237
  789424
  790158
  804112
  808280
  812232
  726962
  738310
  759810
  738314
  744915
  746060
  756620
  771357
  724290
  732399
  735477
  739686
  742786
  743800
  733254
  617440
  714504
]
3.09 ms
(2.08%)
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
  515060
  532135
  546138
  546822
  554452
  559348
  562450
  563416
  570127
  580241
  581661
  588084
  589821
  601885
  605202
  609647
  615937
  617440
  623943
  630068
  652573
  663390
  663417
  663431
  663865
  663946
  664539
  665401
  665406
  665408
  665419
  665447
  665470
  665479
  666790
  667279
  667522
  667541
  667607
  667621
  667655
  667766
  667876
  667906
  668897
  670479
  684364
  691523
  695634
  702179
  709544
  712625
  712804
  712927
  714145
  714165
  714504
  717683
  717700
  718498
  721454
  722281
  724290
  726962
  730097
  732399
  733254
  735477
  738310
  738314
  739686
  740645
  742786
  743800
  744194
  744915
  746060
  746406
  746710
  755684
  756620
  759439
  759810
  770248
  771357
  773901
  775571
  777167
  781682
  781693
  781707
  781755
  782186
  782234
  782249
  782276
  785436
  785940
  785941
  788237
  788411
  788473
  788680
  789424
  790158
  793694
  794667
  794697
  794705
  796101
  798901
  800557
  801009
  803342
  804112
  806241
  807886
  808280
  809857
  812232
]
1.98 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "saggy old"
]
1.81 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "saggy old"
]
1.51 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "saggy old"
]

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.