Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.04 ms
(87.48%)
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
  2808
  387097
  391554
  400342
  401575
  426784
  438314
  459665
  463255
  466338
  470690
  473962
  477144
  477970
  478348
  486118
  487246
  497341
  510390
  542259
  544018
  547683
  548016
  549642
  551157
  557506
  558476
  559467
  575223
  581549
  581554
  590471
  618196
  619908
  629480
  637454
  666491
  667984
  669244
  669867
  669894
  669902
  672789
  673033
  695840
  697900
  705769
  705784
  716023
  719475
  719484
  719881
  723024
  730987
  732830
  732956
  733334
  733773
  734129
  734269
  739360
  739585
  741823
  742295
  743898
  747423
  748536
  749870
  751604
  759068
  759377
  761394
  761403
  762084
  766282
  766329
  766981
  767776
  768002
  768329
  768491
  769131
  769188
  780193
  782358
  784312
  789385
  790258
  791915
  793067
  794031
  794709
  795337
  795361
  797258
  799748
  800840
  801429
  801433
  801451
  801505
  801783
  802092
  802279
  809672
  811783
  811819
  811831
  812088
  816163
  817737
  818135
  819358
  820323
  823588
  824803
  824850
  825610
  825797
]
7.86 ms
(5.98%)
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
  619908
  816163
  825610
  544018
  549642
  669902
  672789
  669867
  581549
  794709
  799748
  780193
  795361
  733334
  733773
  734269
  742295
  743898
  747423
  761394
  769131
  789385
  812088
  732830
  759068
  761403
  759377
  768329
  748536
  766282
  768002
  779805
  793067
  801429
  811831
  486118
  473962
  470690
  819358
  824850
  825797
  497341
  551157
  719475
  719484
  795337
  801433
  782358
  790258
  797258
  800840
  802092
  802279
  811819
  741823
  751604
  766981
  784312
  794031
  762084
  766329
  767776
  739585
  723024
  801451
  801505
  400342
  459665
  463255
  559467
  705784
  478348
  809672
  791915
  739360
  705769
  629480
  618196
  466338
  768491
  547683
  769188
  426784
  732956
  801783
  811783
  749870
  730987
  391554
  581554
  667984
  669244
  669894
  695840
  548016
  575223
  590471
  697900
  510390
  734129
  637454
  387097
  558476
  487246
  401575
  477970
  2808
  438314
  824803
  818135
  823588
  817737
  820323
  477144
  542259
  557506
  673033
  716023
  719881
  666491
]
2.10 ms
(1.60%)
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
  2808
  387097
  391554
  400342
  401575
  426784
  438314
  459665
  463255
  466338
  470690
  473962
  477144
  477970
  478348
  486118
  487246
  497341
  510390
  542259
  544018
  547683
  548016
  549642
  551157
  557506
  558476
  559467
  575223
  581549
  581554
  590471
  618196
  619908
  629480
  637454
  666491
  667984
  669244
  669867
  669894
  669902
  672789
  673033
  695840
  697900
  705769
  705784
  716023
  719475
  719484
  719881
  723024
  730987
  732830
  732956
  733334
  733773
  734129
  734269
  739360
  739585
  741823
  742295
  743898
  747423
  748536
  749870
  751604
  759068
  759377
  761394
  761403
  762084
  766282
  766329
  766981
  767776
  768002
  768329
  768491
  769131
  769188
  780193
  782358
  784312
  789385
  790258
  791915
  793067
  794031
  794709
  795337
  795361
  797258
  799748
  800840
  801429
  801433
  801451
  801505
  801783
  802092
  802279
  809672
  811783
  811819
  811831
  812088
  816163
  817737
  818135
  819358
  820323
  823588
  824803
  824850
  825610
  825797
]
1.84 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее русская жена…"
]
1.73 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск русск жен"
]
1.33 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск русск жен"
]

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.