Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.79 ms
(57.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "онлифанс социальн сет mom"
]
137.61 ms
(37.07%)
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
  424547
  484521
  536724
  542744
  542789
  551086
  555565
  569575
  572872
  578606
  579651
  582336
  583142
  585539
  586408
  586442
  586728
  587153
  590783
  591167
  595734
  600798
  603842
  603977
  606088
  606292
  613011
  615438
  616091
  616521
  616944
  619186
  623444
  625320
  625711
  625914
  626184
  641886
  642556
  644189
  645196
  646872
  653594
  655482
  660002
  662602
  679001
  697909
  703930
  704951
  731473
  734484
  749925
  753205
  754224
  756491
  756803
  766022
  767585
  769487
  770493
  770663
  772190
  772893
  773582
  773850
  773890
  774563
  774707
  775246
  775276
  776531
  778297
  778820
  781173
  781459
  781615
  781924
  783205
  784080
  784092
  784729
  784776
  784922
  785145
  785161
  785392
  785657
  785909
  786406
  787047
  787120
  789481
  789846
  790469
  791504
  791679
  797756
  799553
  799592
  800604
  800936
  805497
  805832
  806445
  807219
  807619
  809009
  809381
  809415
  809482
  810998
  812418
  812585
  812831
  812891
  812894
  812896
]
14.20 ms
(3.83%)
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
  660002
  662602
  676582
  697909
  578606
  582336
  586442
  591167
  613011
  616521
  626184
  641886
  587153
  644189
  586408
  586728
  590783
  595734
  616944
  625711
  615438
  774682
  774707
  775276
  776531
  781173
  781924
  784092
  784729
  784776
  784922
  785145
  785161
  785392
  799592
  800604
  809009
  812418
  812585
  774563
  778297
  778820
  785909
  786406
  787047
  791679
  799553
  807219
  809415
  809482
  810998
  812831
  812894
  734484
  753205
  772190
  773582
  773850
  773890
  781459
  784080
  787120
  789481
  800936
  805497
  805832
  812891
  812896
  731473
  766022
  767585
  769487
  754224
  756491
  756803
  749925
  770493
  770663
  772893
  606088
  623444
  703930
  775246
  781615
  783205
  785657
  789846
  790469
  791504
  797756
  806445
  807619
  809381
  619186
  424547
  484521
  536724
  542789
  569575
  572872
  579651
  583142
  551086
  555565
  542744
  655482
  704951
  645196
  646872
  653594
  679001
  585539
  606292
  616091
  625320
  625914
  642556
  600798
  603842
  603977
]
2.42 ms
(0.65%)
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
  424547
  484521
  536724
  542744
  542789
  551086
  555565
  569575
  572872
  578606
  579651
  582336
  583142
  585539
  586408
  586442
  586728
  587153
  590783
  591167
  595734
  600798
  603842
  603977
  606088
  606292
  613011
  615438
  616091
  616521
  616944
  619186
  623444
  625320
  625711
  625914
  626184
  641886
  642556
  644189
  645196
  646872
  653594
  655482
  660002
  662602
  679001
  697909
  703930
  704951
  731473
  734484
  749925
  753205
  754224
  756491
  756803
  766022
  767585
  769487
  770493
  770663
  772190
  772893
  773582
  773850
  773890
  774563
  774707
  775246
  775276
  776531
  778297
  778820
  781173
  781459
  781615
  781924
  783205
  784080
  784092
  784729
  784776
  784922
  785145
  785161
  785392
  785657
  785909
  786406
  787047
  787120
  789481
  789846
  790469
  791504
  791679
  797756
  799553
  799592
  800604
  800936
  805497
  805832
  806445
  807219
  807619
  809009
  809381
  809415
  809482
  810998
  812418
  812585
  812831
  812891
  812894
  812896
]
1.99 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "onlyfans mom"
]
1.74 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "онлифанс социальн сет mom"
]
1.51 ms
(0.41%)
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.