Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.59 ms
(58.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy horny"
]
127.10 ms
(35.04%)
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
  381963
  386518
  390214
  432683
  434903
  435611
  435625
  437562
  449699
  454040
  469486
  473724
  473868
  482585
  490664
  504331
  512664
  524820
  538024
  539326
  543219
  545684
  552192
  556853
  559789
  559868
  563114
  565647
  566250
  569382
  569852
  571887
  581377
  583602
  619147
  621459
  621537
  621603
  632296
  634760
  641176
  641418
  658853
  661941
  661949
  665063
  665134
  665508
  666974
  668623
  679698
  680946
  681307
  684672
  693388
  696310
  699788
  704912
  707981
  713598
  717509
  721438
  724197
  729180
  730163
  730301
  738461
  739903
  744823
  746477
  748322
  753190
  757225
  758177
  759575
  759982
  760617
  762244
  762369
  763447
  764004
  764082
  766698
  767928
  770184
  773044
  778864
  784471
  784704
  785011
  785014
  785468
  787373
  790139
  791301
  792772
  795776
  796974
  797053
  800345
  800953
  801093
  801474
  804648
  805030
  807200
  807235
  807440
  807755
  809669
  809948
  809966
  810208
  810356
  811351
  814670
  815739
  817086
  817957
  821691
]
16.43 ms
(4.53%)
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
  632296
  785011
  790139
  800953
  801093
  801474
  805030
  807235
  810208
  811351
  784471
  785014
  791301
  796974
  807440
  809669
  730163
  748322
  753190
  759575
  762244
  785468
  787373
  792772
  807200
  807755
  809948
  810356
  730301
  744823
  766698
  767928
  724197
  739903
  758177
  763447
  764004
  764082
  773044
  729180
  738461
  746477
  770184
  757225
  759982
  760617
  762369
  634760
  641176
  713598
  717509
  778864
  784704
  795776
  797053
  800345
  804648
  809966
  381963
  386518
  449699
  512664
  641418
  390214
  435611
  432683
  435625
  434903
  437562
  817957
  815739
  814670
  817086
  821691
  454040
  469486
  473724
  473868
  490664
  539326
  524820
  504331
  538024
  482585
  543219
  559868
  565647
  563114
  566250
  569852
  583602
  545684
  658853
  661941
  666974
  699788
  661949
  665063
  665134
  665508
  668623
  679698
  680946
  681307
  684672
  693388
  696310
  704912
  721438
  707981
  552192
  556853
  559789
  569382
  571887
  581377
  621603
  619147
  621459
  621537
]
3.27 ms
(0.90%)
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
  381963
  386518
  390214
  432683
  434903
  435611
  435625
  437562
  449699
  454040
  469486
  473724
  473868
  482585
  490664
  504331
  512664
  524820
  538024
  539326
  543219
  545684
  552192
  556853
  559789
  559868
  563114
  565647
  566250
  569382
  569852
  571887
  581377
  583602
  619147
  621459
  621537
  621603
  632296
  634760
  641176
  641418
  658853
  661941
  661949
  665063
  665134
  665508
  666974
  668623
  679698
  680946
  681307
  684672
  693388
  696310
  699788
  704912
  707981
  713598
  717509
  721438
  724197
  729180
  730163
  730301
  738461
  739903
  744823
  746477
  748322
  753190
  757225
  758177
  759575
  759982
  760617
  762244
  762369
  763447
  764004
  764082
  766698
  767928
  770184
  773044
  778864
  784471
  784704
  785011
  785014
  785468
  787373
  790139
  791301
  792772
  795776
  796974
  797053
  800345
  800953
  801093
  801474
  804648
  805030
  807200
  807235
  807440
  807755
  809669
  809948
  809966
  810208
  810356
  811351
  814670
  815739
  817086
  817957
  821691
]
1.92 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy horny"
]
1.59 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy horny"
]

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.