Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.23 ms
(84.91%)
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
  124144
  191398
  382075
  382165
  387856
  389482
  389966
  391559
  391614
  391668
  391925
  397861
  397896
  401229
  403588
  405029
  406042
  411344
  416694
  418013
  420295
  420635
  421871
  422199
  422205
  424428
  432662
  435398
  439521
  439529
  439591
  439595
  439623
  439641
  439643
  439667
  439673
  439696
  439699
  440669
  440993
  441004
  441978
  446238
  449428
  452228
  452677
  454277
  456697
  457140
  459382
  460175
  460739
  461364
  462515
  464649
  465525
  465892
  466021
  466191
  466369
  466869
  469909
  470941
  472148
  474631
  474635
  477730
  483558
  484585
  484629
  484644
  484671
  484704
  484738
  484750
  486341
  486344
  490304
  493260
  494567
  496862
  502326
  513149
  517841
  518547
  518827
  520127
  520319
  522343
  523019
  528483
  543296
  549799
  553269
  564407
  569682
  573800
  574244
  581806
  584779
  586219
  586628
  594581
  598569
  628267
  679657
  693965
  696126
  739532
  739568
  743065
  751565
  757340
  766613
  785572
  793376
  807327
  807340
  825812
]
16.71 ms
(9.70%)
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
  477730
  432662
  490304
  403588
  439521
  391668
  401229
  439591
  452677
  406042
  553269
  543296
  397861
  474631
  584779
  439529
  422205
  743065
  439643
  474635
  440669
  416694
  586219
  462515
  191398
  382075
  391614
  483558
  411344
  484644
  486344
  598569
  628267
  459382
  564407
  766613
  391925
  696126
  452228
  418013
  422199
  457140
  472148
  594581
  523019
  494567
  446238
  389966
  449428
  465892
  484585
  484704
  486341
  124144
  569682
  420295
  464649
  518547
  693965
  793376
  807340
  785572
  435398
  461364
  439641
  460175
  493260
  465525
  439595
  581806
  466869
  439673
  460739
  454277
  528483
  549799
  466021
  517841
  522343
  440993
  389482
  397896
  421871
  586628
  424428
  825812
  439699
  520127
  520319
  751565
  679657
  420635
  441004
  502326
  574244
  387856
  405029
  513149
  484629
  496862
  439623
  456697
  466191
  807327
  739532
  391559
  466369
  469909
  470941
  484671
  484738
  518827
  382165
  441978
  739568
  757340
  573800
  439667
  439696
  484750
]
3.08 ms
(1.79%)
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
  124144
  191398
  382075
  382165
  387856
  389482
  389966
  391559
  391614
  391668
  391925
  397861
  397896
  401229
  403588
  405029
  406042
  411344
  416694
  418013
  420295
  420635
  421871
  422199
  422205
  424428
  432662
  435398
  439521
  439529
  439591
  439595
  439623
  439641
  439643
  439667
  439673
  439696
  439699
  440669
  440993
  441004
  441978
  446238
  449428
  452228
  452677
  454277
  456697
  457140
  459382
  460175
  460739
  461364
  462515
  464649
  465525
  465892
  466021
  466191
  466369
  466869
  469909
  470941
  472148
  474631
  474635
  477730
  483558
  484585
  484629
  484644
  484671
  484704
  484738
  484750
  486341
  486344
  490304
  493260
  494567
  496862
  502326
  513149
  517841
  518547
  518827
  520127
  520319
  522343
  523019
  528483
  543296
  549799
  553269
  564407
  569682
  573800
  574244
  581806
  584779
  586219
  586628
  594581
  598569
  628267
  679657
  693965
  696126
  739532
  739568
  743065
  751565
  757340
  766613
  785572
  793376
  807327
  807340
  825812
]
1.72 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade young anal"
]
1.58 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск young анал"
]
1.57 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск young анал"
]

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.