Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.87 ms
(83.67%)
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
  7456
  16808
  123862
  124308
  181422
  188129
  188258
  188293
  188655
  229834
  291356
  358398
  381842
  387104
  387448
  388098
  389729
  391571
  391930
  398532
  440908
  443154
  473334
  474817
  488414
  488961
  492969
  509627
  515546
  517383
  523296
  530679
  531275
  531323
  532817
  535533
  536305
  536348
  536519
  537856
  541451
  542472
  543585
  543904
  544181
  544587
  545042
  555192
  555274
  558718
  562997
  568040
  568252
  572668
  574411
  581231
  583820
  592652
  595997
  607697
  617390
  642820
  643542
  647689
  665394
  667822
  702144
  709214
  716570
  717514
  718909
  728657
  729153
  732809
  734301
  741700
  752641
  752679
  755089
  761021
  761587
  762288
  765250
  765454
  766637
  773686
  777953
  784008
  788141
  790821
  791155
  791860
  794070
  794735
  795404
  796081
  798696
  799910
  800313
  800405
  800431
  800513
  805706
  810290
  815509
  817562
  817591
  817600
  818712
  818948
  819020
  823831
  825670
  827593
  827704
  827861
  828037
  828257
  828258
  828539
]
14.68 ms
(9.24%)
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
  572668
  541451
  718909
  617390
  795404
  752641
  765250
  752679
  766637
  800513
  492969
  509627
  517383
  523296
  188129
  443154
  536305
  544587
  761021
  790821
  188293
  229834
  188655
  530679
  558718
  16808
  398532
  124308
  387104
  387448
  818712
  817591
  828257
  827593
  543904
  583820
  543585
  647689
  799910
  755089
  788141
  800405
  794070
  474817
  532817
  515546
  581231
  123862
  188258
  391930
  381842
  388098
  488414
  531275
  536519
  555274
  642820
  741700
  391571
  488961
  358398
  440908
  815509
  818948
  536348
  545042
  716570
  702144
  734301
  765454
  291356
  389729
  181422
  7456
  825670
  817562
  819020
  827704
  817600
  823831
  828037
  828258
  827861
  828539
  531323
  537856
  544181
  555192
  568040
  568252
  542472
  562997
  667822
  709214
  574411
  595997
  784008
  791155
  777953
  798696
  800313
  761587
  805706
  810290
  762288
  729153
  732809
  773686
  791860
  794735
  796081
  800431
  473334
  535533
  665394
  592652
  607697
  643542
  728657
  717514
]
3.54 ms
(2.23%)
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
  7456
  16808
  123862
  124308
  181422
  188129
  188258
  188293
  188655
  229834
  291356
  358398
  381842
  387104
  387448
  388098
  389729
  391571
  391930
  398532
  440908
  443154
  473334
  474817
  488414
  488961
  492969
  509627
  515546
  517383
  523296
  530679
  531275
  531323
  532817
  535533
  536305
  536348
  536519
  537856
  541451
  542472
  543585
  543904
  544181
  544587
  545042
  555192
  555274
  558718
  562997
  568040
  568252
  572668
  574411
  581231
  583820
  592652
  595997
  607697
  617390
  642820
  643542
  647689
  665394
  667822
  702144
  709214
  716570
  717514
  718909
  728657
  729153
  732809
  734301
  741700
  752641
  752679
  755089
  761021
  761587
  762288
  765250
  765454
  766637
  773686
  777953
  784008
  788141
  790821
  791155
  791860
  794070
  794735
  795404
  796081
  798696
  799910
  800313
  800405
  800431
  800513
  805706
  810290
  815509
  817562
  817591
  817600
  818712
  818948
  819020
  823831
  825670
  827593
  827704
  827861
  828037
  828257
  828258
  828539
]
2.23 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf mature riding"
]
1.99 ms
(1.25%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mature riding"
]
1.64 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf mature riding"
]

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.