Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.29 ms
(82.03%)
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
  188079
  323088
  382699
  382725
  384142
  388007
  388755
  389376
  390593
  397079
  397373
  397776
  402677
  402977
  403389
  403414
  403909
  410857
  422227
  431829
  476270
  538043
  544757
  544758
  589739
  592708
  593358
  604985
  619585
  633049
  635484
  635842
  635863
  635872
  636510
  641749
  649087
  649627
  651318
  651422
  653807
  653880
  654204
  654256
  654293
  654765
  657370
  657996
  658035
  658681
  659504
  664271
  665497
  667337
  675043
  680588
  681002
  681022
  681159
  684369
  688100
  690097
  690885
  692470
  693037
  693188
  694128
  696167
  714115
  715192
  718674
  718919
  719142
  720916
  721930
  721933
  722665
  723608
  724802
  725096
  729659
  732652
  732751
  733178
  739858
  740373
  744256
  744588
  749557
  750080
  750547
  760060
  767190
  770790
  770871
  771616
  773580
  781902
  782783
  787914
  789108
  790761
  792510
  794799
  798930
  799015
  799672
  801894
  802953
  803348
  803793
  811795
  815325
  817039
  817920
  818544
  820340
  822337
  827878
  827944
]
14.39 ms
(9.90%)
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
  690097
  692470
  694128
  718919
  649627
  653807
  657370
  657996
  658035
  659504
  681022
  684369
  688100
  693037
  651318
  651422
  653880
  654256
  654293
  654765
  658681
  675043
  681002
  681159
  693188
  696167
  714115
  544757
  635484
  592708
  619585
  633049
  635863
  635872
  589739
  604985
  781902
  782783
  787914
  790761
  798930
  799672
  803348
  811795
  789108
  794799
  803793
  724802
  729659
  744256
  792510
  725096
  749557
  773580
  732652
  732751
  744588
  767190
  771616
  750080
  721930
  799015
  403414
  384142
  690885
  382699
  750547
  397373
  431829
  402677
  188079
  760060
  382725
  476270
  323088
  667337
  665497
  733178
  770790
  422227
  388755
  390593
  817039
  715192
  719142
  720916
  722665
  721933
  641749
  801894
  403389
  389376
  827944
  397776
  815325
  817920
  818544
  649087
  680588
  593358
  770871
  718674
  410857
  397079
  723608
  822337
  820340
  538043
  664271
  635842
  636510
  740373
  802953
  739858
  402977
  388007
  403909
  827878
  544758
  654204
]
3.22 ms
(2.22%)
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
  188079
  323088
  382699
  382725
  384142
  388007
  388755
  389376
  390593
  397079
  397373
  397776
  402677
  402977
  403389
  403414
  403909
  410857
  422227
  431829
  476270
  538043
  544757
  544758
  589739
  592708
  593358
  604985
  619585
  633049
  635484
  635842
  635863
  635872
  636510
  641749
  649087
  649627
  651318
  651422
  653807
  653880
  654204
  654256
  654293
  654765
  657370
  657996
  658035
  658681
  659504
  664271
  665497
  667337
  675043
  680588
  681002
  681022
  681159
  684369
  688100
  690097
  690885
  692470
  693037
  693188
  694128
  696167
  714115
  715192
  718674
  718919
  719142
  720916
  721930
  721933
  722665
  723608
  724802
  725096
  729659
  732652
  732751
  733178
  739858
  740373
  744256
  744588
  749557
  750080
  750547
  760060
  767190
  770790
  770871
  771616
  773580
  781902
  782783
  787914
  789108
  790761
  792510
  794799
  798930
  799015
  799672
  801894
  802953
  803348
  803793
  811795
  815325
  817039
  817920
  818544
  820340
  822337
  827878
  827944
]
2.49 ms
(1.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс секс втро"
]
2.15 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex threesome"
]
2.05 ms
(1.41%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.25%)
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.