Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.24 ms
(84.89%)
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
  403588
  420758
  426968
  427065
  435433
  435434
  440973
  446851
  448074
  453497
  459513
  460088
  466059
  467975
  468984
  472566
  475163
  479959
  485463
  488380
  490253
  507865
  508880
  508987
  510083
  511155
  513506
  518621
  519354
  521077
  521502
  523231
  524156
  524180
  524359
  525555
  527839
  528661
  555995
  556481
  560737
  561503
  561909
  562428
  564656
  577501
  583868
  585231
  589036
  590309
  605485
  606032
  608558
  609707
  609933
  610862
  612087
  625460
  626885
  632124
  633959
  636174
  639895
  641870
  649094
  659367
  668969
  669712
  674486
  677222
  682348
  682413
  687150
  698106
  700858
  705642
  712226
  721978
  725097
  727724
  731325
  732733
  733458
  734189
  737365
  740646
  740966
  741076
  741082
  742607
  742771
  744234
  748545
  748855
  749756
  759833
  768394
  778905
  779841
  780831
  782122
  786595
  794929
  796472
  796610
  796826
  797292
  799459
  800814
  803590
  805350
  808633
  809992
  817342
  820164
  823565
  824803
  825270
  826058
  828782
]
16.35 ms
(9.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
  510083
  560737
  440973
  527839
  528661
  485463
  488380
  435433
  513506
  609933
  636174
  826058
  828782
  820164
  734189
  825270
  561503
  800814
  823565
  585231
  786595
  759833
  742607
  824803
  682413
  698106
  610862
  733458
  742771
  796610
  817342
  562428
  639895
  803590
  778905
  779841
  782122
  748855
  768394
  737365
  712226
  641870
  805350
  727724
  748545
  426968
  659367
  721978
  583868
  780831
  740966
  725097
  749756
  700858
  796472
  460088
  590309
  605485
  609707
  808633
  740646
  809992
  797292
  674486
  632124
  796826
  741082
  744234
  741076
  705642
  459513
  472566
  669712
  677222
  649094
  687150
  608558
  799459
  731325
  479959
  427065
  468984
  453497
  511155
  524180
  508880
  524359
  561909
  668969
  606032
  625460
  633959
  794929
  435434
  518621
  508987
  524156
  523231
  507865
  556481
  577501
  555995
  682348
  564656
  519354
  490253
  466059
  475163
  732733
  446851
  448074
  525555
  521502
  403588
  467975
  420758
  521077
  589036
  612087
  626885
]
2.92 ms
(1.64%)
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
  403588
  420758
  426968
  427065
  435433
  435434
  440973
  446851
  448074
  453497
  459513
  460088
  466059
  467975
  468984
  472566
  475163
  479959
  485463
  488380
  490253
  507865
  508880
  508987
  510083
  511155
  513506
  518621
  519354
  521077
  521502
  523231
  524156
  524180
  524359
  525555
  527839
  528661
  555995
  556481
  560737
  561503
  561909
  562428
  564656
  577501
  583868
  585231
  589036
  590309
  605485
  606032
  608558
  609707
  609933
  610862
  612087
  625460
  626885
  632124
  633959
  636174
  639895
  641870
  649094
  659367
  668969
  669712
  674486
  677222
  682348
  682413
  687150
  698106
  700858
  705642
  712226
  721978
  725097
  727724
  731325
  732733
  733458
  734189
  737365
  740646
  740966
  741076
  741082
  742607
  742771
  744234
  748545
  748855
  749756
  759833
  768394
  778905
  779841
  780831
  782122
  786595
  794929
  796472
  796610
  796826
  797292
  799459
  800814
  803590
  805350
  808633
  809992
  817342
  820164
  823565
  824803
  825270
  826058
  828782
]
2.11 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "husband not home"
]
2.06 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "husband home"
]
1.62 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "husband home"
]

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.