Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.39 ms
(82.31%)
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
  401880
  410959
  414337
  417344
  420769
  425118
  426368
  446529
  476753
  477483
  501498
  506143
  518467
  518470
  519567
  522157
  527412
  530493
  530625
  530630
  530791
  530805
  531089
  531202
  531215
  531254
  531272
  531419
  532343
  532703
  532754
  533374
  534995
  535584
  536249
  536262
  536310
  536588
  536752
  537654
  537659
  537675
  537903
  540405
  540785
  541202
  542519
  543917
  543918
  545441
  550194
  573479
  584022
  587542
  588283
  595775
  596082
  599902
  599994
  600061
  600194
  600295
  600334
  600342
  600352
  600354
  600401
  601114
  601625
  602532
  605338
  606501
  614401
  628086
  628093
  628368
  632561
  632694
  633444
  633747
  633768
  634199
  636311
  636579
  639762
  639793
  640759
  641667
  642038
  643376
  646242
  646771
  647635
  649556
  649970
  651209
  651607
  666852
  666853
  668534
  668549
  670758
  674952
  674986
  676014
  676090
  676112
  677781
  678052
  678089
  678141
  678493
  679016
  679465
  679810
  687257
  696579
  708443
  731665
  801923
]
19.89 ms
(11.34%)
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
  633747
  634199
  636311
  636579
  600061
  600401
  601114
  601625
  602532
  606501
  639762
  639793
  588283
  600352
  600354
  628086
  628093
  628368
  632561
  587542
  595775
  596082
  599902
  599994
  600194
  600295
  600334
  600342
  640759
  641667
  643376
  801923
  731665
  605338
  614401
  632694
  633444
  633768
  642038
  708443
  401880
  417344
  414337
  420769
  425118
  518467
  518470
  527412
  530493
  519567
  543918
  410959
  426368
  540785
  476753
  446529
  522157
  531215
  531272
  532754
  531202
  532343
  533374
  537654
  506143
  530625
  530630
  530791
  531089
  531254
  531419
  532703
  536249
  536262
  536310
  536588
  537675
  537903
  501498
  530805
  534995
  535584
  536752
  537659
  540405
  477483
  545441
  542519
  573479
  584022
  541202
  543917
  550194
  646242
  649970
  651607
  668549
  674952
  674986
  676090
  677781
  678052
  678089
  678141
  678493
  679016
  679465
  679810
  687257
  696579
  646771
  647635
  649556
  651209
  666852
  666853
  668534
  670758
  676014
  676112
]
3.50 ms
(1.99%)
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
  401880
  410959
  414337
  417344
  420769
  425118
  426368
  446529
  476753
  477483
  501498
  506143
  518467
  518470
  519567
  522157
  527412
  530493
  530625
  530630
  530791
  530805
  531089
  531202
  531215
  531254
  531272
  531419
  532343
  532703
  532754
  533374
  534995
  535584
  536249
  536262
  536310
  536588
  536752
  537654
  537659
  537675
  537903
  540405
  540785
  541202
  542519
  543917
  543918
  545441
  550194
  573479
  584022
  587542
  588283
  595775
  596082
  599902
  599994
  600061
  600194
  600295
  600334
  600342
  600352
  600354
  600401
  601114
  601625
  602532
  605338
  606501
  614401
  628086
  628093
  628368
  632561
  632694
  633444
  633747
  633768
  634199
  636311
  636579
  639762
  639793
  640759
  641667
  642038
  643376
  646242
  646771
  647635
  649556
  649970
  651209
  651607
  666852
  666853
  668534
  668549
  670758
  674952
  674986
  676014
  676090
  676112
  677781
  678052
  678089
  678141
  678493
  679016
  679465
  679810
  687257
  696579
  708443
  731665
  801923
]
2.14 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gangbang interracial"
]
1.91 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gangbang межрасов"
]
1.77 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gangbang межрасов"
]

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.