Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.28 ms
(89.72%)
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
  197574
  370332
  385386
  386784
  435388
  436462
  443417
  466333
  470117
  499020
  506504
  512592
  517966
  519330
  527819
  527845
  532642
  536245
  540728
  544089
  545029
  551622
  552903
  553663
  555346
  557574
  560263
  561534
  562566
  563252
  564806
  578352
  587655
  589648
  590537
  591229
  599352
  600741
  601897
  603389
  603752
  615042
  619964
  637507
  640905
  659350
  659353
  660276
  662074
  664455
  674587
  674603
  675193
  682943
  690744
  695432
  696395
  696764
  702636
  704955
  707786
  710041
  713753
  715964
  717949
  717977
  719109
  719302
  723429
  724887
  726143
  728756
  731062
  731160
  731697
  733155
  734465
  740997
  742768
  755048
  755918
  756661
  762994
  763146
  763173
  765084
  766361
  767669
  769443
  770509
  778748
  778837
  779008
  779973
  780388
  782969
  785056
  785422
  786080
  787308
  787801
  787982
  789483
  789726
  789859
  790558
  790701
  790839
  793653
  793739
  795575
  795985
  796008
  796017
  796023
  796158
  796214
  800956
  803685
  810373
]
9.09 ms
(4.84%)
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
  800956
  197574
  443417
  435388
  470117
  536245
  512592
  540728
  517966
  532642
  552903
  544089
  551622
  545029
  560263
  563252
  675193
  682943
  717977
  659353
  664455
  695432
  696395
  696764
  715964
  719302
  660276
  662074
  707786
  710041
  717949
  557574
  589648
  637507
  600741
  601897
  603752
  619964
  779008
  779973
  780388
  782969
  789726
  790701
  793653
  793739
  796158
  778837
  785422
  786080
  787308
  787801
  789483
  789859
  790839
  795985
  796023
  803685
  733155
  734465
  755048
  762994
  769443
  770509
  785056
  790558
  795575
  796214
  763173
  731062
  742768
  766361
  767669
  763146
  724887
  726143
  728756
  731160
  731697
  740997
  755918
  756661
  765084
  702636
  713753
  723429
  778748
  796017
  810373
  386784
  385386
  553663
  506504
  519330
  561534
  659350
  599352
  527845
  555346
  690744
  590537
  591229
  615042
  640905
  370332
  499020
  578352
  719109
  674603
  704955
  787982
  436462
  527819
  466333
  562566
  674587
  564806
  587655
  603389
  796008
]
2.74 ms
(1.46%)
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
  197574
  370332
  385386
  386784
  435388
  436462
  443417
  466333
  470117
  499020
  506504
  512592
  517966
  519330
  527819
  527845
  532642
  536245
  540728
  544089
  545029
  551622
  552903
  553663
  555346
  557574
  560263
  561534
  562566
  563252
  564806
  578352
  587655
  589648
  590537
  591229
  599352
  600741
  601897
  603389
  603752
  615042
  619964
  637507
  640905
  659350
  659353
  660276
  662074
  664455
  674587
  674603
  675193
  682943
  690744
  695432
  696395
  696764
  702636
  704955
  707786
  710041
  713753
  715964
  717949
  717977
  719109
  719302
  723429
  724887
  726143
  728756
  731062
  731160
  731697
  733155
  734465
  740997
  742768
  755048
  755918
  756661
  762994
  763146
  763173
  765084
  766361
  767669
  769443
  770509
  778748
  778837
  779008
  779973
  780388
  782969
  785056
  785422
  786080
  787308
  787801
  787982
  789483
  789726
  789859
  790558
  790701
  790839
  793653
  793739
  795575
  795985
  796008
  796017
  796023
  796158
  796214
  800956
  803685
  810373
]
2.07 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм рот"
]
1.83 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма для рот"
]
1.80 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм рот"
]
1.76 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.