Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.06 ms
(84.64%)
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
  406089
  409035
  413373
  415004
  417889
  421094
  423379
  423657
  428103
  428174
  431341
  434364
  439543
  443112
  452638
  452953
  452977
  462113
  462751
  464971
  466294
  467868
  467878
  468142
  468363
  468754
  479661
  483711
  486665
  494231
  497667
  499105
  500929
  502324
  505390
  507376
  509024
  510395
  514070
  514709
  520778
  526887
  527405
  527755
  530272
  530624
  533697
  534215
  535019
  535358
  535620
  536288
  537671
  540564
  544819
  545368
  550124
  550200
  550203
  552585
  556044
  564387
  566774
  584602
  589543
  599836
  599994
  602259
  606576
  608174
  628707
  631937
  633741
  633780
  634487
  636303
  636321
  639802
  640800
  641455
  642315
  642403
  643100
  647885
  647939
  650155
  650476
  650544
  660144
  660410
  669706
  693925
  709723
  710868
  720249
  729829
  734038
  738827
  750701
  751572
  752704
  770501
  772472
  775801
  778941
  785059
  788196
  792576
  800710
  801287
  801960
  810827
  811296
  813819
  814031
  816007
  818156
  823719
  824483
  826024
]
16.59 ms
(9.36%)
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
  550200
  650544
  709723
  606576
  628707
  642403
  775801
  788196
  778941
  801287
  729829
  785059
  810827
  738827
  751572
  752704
  483711
  608174
  428174
  564387
  552585
  602259
  415004
  660144
  520778
  468363
  452638
  467878
  823719
  800710
  826024
  494231
  818156
  468142
  540564
  631937
  486665
  550124
  514070
  406089
  502324
  545368
  452953
  599994
  423379
  816007
  464971
  499105
  509024
  537671
  479661
  544819
  693925
  720249
  642315
  643100
  811296
  734038
  770501
  466294
  434364
  497667
  505390
  824483
  431341
  417889
  530624
  535358
  536288
  550203
  556044
  660410
  589543
  640800
  750701
  462113
  535019
  584602
  443112
  428103
  421094
  423657
  514709
  527755
  533697
  535620
  467868
  468754
  409035
  510395
  647939
  633780
  462751
  534215
  500929
  650155
  813819
  633741
  507376
  599836
  439543
  526887
  566774
  669706
  772472
  710868
  413373
  650476
  647885
  636321
  639802
  636303
  634487
  641455
  801960
  792576
  452977
  814031
  527405
  530272
]
2.89 ms
(1.63%)
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
  406089
  409035
  413373
  415004
  417889
  421094
  423379
  423657
  428103
  428174
  431341
  434364
  439543
  443112
  452638
  452953
  452977
  462113
  462751
  464971
  466294
  467868
  467878
  468142
  468363
  468754
  479661
  483711
  486665
  494231
  497667
  499105
  500929
  502324
  505390
  507376
  509024
  510395
  514070
  514709
  520778
  526887
  527405
  527755
  530272
  530624
  533697
  534215
  535019
  535358
  535620
  536288
  537671
  540564
  544819
  545368
  550124
  550200
  550203
  552585
  556044
  564387
  566774
  584602
  589543
  599836
  599994
  602259
  606576
  608174
  628707
  631937
  633741
  633780
  634487
  636303
  636321
  639802
  640800
  641455
  642315
  642403
  643100
  647885
  647939
  650155
  650476
  650544
  660144
  660410
  669706
  693925
  709723
  710868
  720249
  729829
  734038
  738827
  750701
  751572
  752704
  770501
  772472
  775801
  778941
  785059
  788196
  792576
  800710
  801287
  801960
  810827
  811296
  813819
  814031
  816007
  818156
  823719
  824483
  826024
]
2.13 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anal squirt"
]
1.98 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анал сквирт оргазм"
]
1.79 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анал сквирт оргазм"
]

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.