Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.96 ms
(84.17%)
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
  391571
  396300
  397921
  398955
  400989
  401216
  403588
  415849
  416277
  418975
  426256
  429550
  433376
  434530
  437605
  439685
  440979
  442339
  443167
  443938
  443969
  444138
  450838
  453151
  454212
  455331
  455569
  457187
  462695
  462710
  466075
  469399
  470280
  474407
  474795
  475852
  479121
  481866
  490212
  495226
  496119
  502748
  506055
  506227
  506778
  507003
  510518
  515416
  516211
  518852
  529157
  531979
  532818
  542739
  542742
  546722
  546771
  546955
  549656
  549719
  549739
  549776
  549844
  554772
  557991
  558021
  564696
  578007
  586026
  596427
  603767
  606619
  612977
  626128
  633412
  659197
  685068
  687363
  689002
  689042
  699268
  701247
  704174
  709319
  709503
  713169
  719005
  723945
  723955
  725062
  725709
  731436
  736880
  744563
  751539
  753633
  757866
  758174
  764044
  769536
  772775
  773797
  777728
  777735
  777973
  785078
  785570
  786216
  788158
  788861
  789296
  799071
  799085
  800926
  801476
  807453
  812715
  814295
  818054
]
16.86 ms
(9.72%)
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
  612977
  626128
  633412
  603767
  764044
  699268
  532818
  462710
  518852
  398955
  396300
  443938
  818054
  516211
  549719
  719005
  799071
  807453
  800926
  725709
  736880
  757866
  799085
  801476
  812715
  457187
  437605
  429550
  474795
  415849
  443969
  549656
  709319
  713169
  786216
  455331
  689002
  779905
  443167
  426256
  758174
  709503
  401216
  416277
  481866
  506778
  542739
  546722
  546771
  549776
  549844
  558021
  542742
  546955
  564696
  549739
  557991
  586026
  400989
  434530
  440979
  474407
  475852
  433376
  444138
  470280
  439685
  479121
  442339
  450838
  506055
  529157
  495226
  502748
  506227
  507003
  515416
  496119
  418975
  814295
  453151
  531979
  777735
  785570
  777728
  772775
  785078
  725062
  731436
  751539
  753633
  773797
  777973
  788861
  789296
  391571
  397921
  469399
  455569
  403588
  462695
  466075
  454212
  701247
  510518
  788158
  723955
  744563
  769536
  723945
  490212
  554772
  578007
  659197
  685068
  689042
  704174
  687363
  596427
  606619
]
3.35 ms
(1.93%)
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
  391571
  396300
  397921
  398955
  400989
  401216
  403588
  415849
  416277
  418975
  426256
  429550
  433376
  434530
  437605
  439685
  440979
  442339
  443167
  443938
  443969
  444138
  450838
  453151
  454212
  455331
  455569
  457187
  462695
  462710
  466075
  469399
  470280
  474407
  474795
  475852
  479121
  481866
  490212
  495226
  496119
  502748
  506055
  506227
  506778
  507003
  510518
  515416
  516211
  518852
  529157
  531979
  532818
  542739
  542742
  546722
  546771
  546955
  549656
  549719
  549739
  549776
  549844
  554772
  557991
  558021
  564696
  578007
  586026
  596427
  603767
  606619
  612977
  626128
  633412
  659197
  685068
  687363
  689002
  689042
  699268
  701247
  704174
  709319
  709503
  713169
  719005
  723945
  723955
  725062
  725709
  731436
  736880
  744563
  751539
  753633
  757866
  758174
  764044
  769536
  772775
  773797
  777728
  777735
  777973
  785078
  785570
  786216
  788158
  788861
  789296
  799071
  799085
  800926
  801476
  807453
  812715
  814295
  818054
]
2.32 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade mom boy"
]
1.76 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск mom парен"
]
1.49 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск mom парен"
]

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.