Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
193.99 ms
(87.45%)
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
  103758
  233335
  233410
  388990
  396026
  401564
  408905
  415894
  424337
  445819
  446231
  448573
  448925
  451677
  454014
  461069
  464044
  465624
  467059
  468291
  468308
  471977
  484234
  492617
  493732
  495864
  512465
  513161
  516400
  523368
  526667
  529579
  532413
  534608
  535363
  535990
  536031
  537232
  540146
  542454
  543958
  546409
  547111
  547234
  547761
  549031
  550535
  553160
  553571
  559156
  563249
  564027
  571695
  574933
  575662
  577999
  578045
  579545
  581557
  581774
  585498
  588346
  589371
  598358
  598867
  600190
  600783
  602113
  602316
  603136
  603430
  604090
  605245
  607859
  615395
  616054
  618985
  621079
  632288
  634640
  638956
  639624
  639635
  644823
  646162
  653902
  655479
  679891
  706384
  708850
  710685
  727981
  738694
  741520
  749385
  749897
  750505
  751200
  751384
  752477
  758271
  760633
  770234
  771944
  781043
  783123
  784689
  787677
  789766
  796041
  796067
  800825
  806476
  808682
  809049
  811852
  811905
  812285
  824196
  825870
]
18.95 ms
(8.54%)
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
  749897
  602316
  616054
  708850
  781043
  784689
  471977
  233335
  598867
  632288
  563249
  547234
  454014
  484234
  495864
  512465
  467059
  468291
  401564
  493732
  577999
  396026
  824196
  825870
  644823
  464044
  526667
  532413
  536031
  535363
  537232
  534608
  516400
  529579
  543958
  553160
  559156
  579545
  542454
  546409
  547111
  549031
  581557
  547761
  564027
  574933
  710685
  653902
  646162
  655479
  553571
  571695
  578045
  605245
  588346
  598358
  615395
  618985
  585498
  589371
  604090
  639624
  600783
  607859
  634640
  639635
  811905
  796041
  760633
  771944
  787677
  796067
  811852
  812285
  741520
  751384
  770234
  727981
  752477
  738694
  749385
  751200
  758271
  638956
  783123
  800825
  806476
  808682
  809049
  233410
  445819
  492617
  621079
  581774
  465624
  602113
  424337
  448925
  388990
  513161
  603136
  446231
  603430
  103758
  461069
  540146
  523368
  575662
  679891
  706384
  550535
  789766
  750505
  451677
  415894
  468308
  535990
  600190
  448573
  408905
]
2.63 ms
(1.19%)
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
  103758
  233335
  233410
  388990
  396026
  401564
  408905
  415894
  424337
  445819
  446231
  448573
  448925
  451677
  454014
  461069
  464044
  465624
  467059
  468291
  468308
  471977
  484234
  492617
  493732
  495864
  512465
  513161
  516400
  523368
  526667
  529579
  532413
  534608
  535363
  535990
  536031
  537232
  540146
  542454
  543958
  546409
  547111
  547234
  547761
  549031
  550535
  553160
  553571
  559156
  563249
  564027
  571695
  574933
  575662
  577999
  578045
  579545
  581557
  581774
  585498
  588346
  589371
  598358
  598867
  600190
  600783
  602113
  602316
  603136
  603430
  604090
  605245
  607859
  615395
  616054
  618985
  621079
  632288
  634640
  638956
  639624
  639635
  644823
  646162
  653902
  655479
  679891
  706384
  708850
  710685
  727981
  738694
  741520
  749385
  749897
  750505
  751200
  751384
  752477
  758271
  760633
  770234
  771944
  781043
  783123
  784689
  787677
  789766
  796041
  796067
  800825
  806476
  808682
  809049
  811852
  811905
  812285
  824196
  825870
]
1.85 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo girl webcam"
]
1.56 ms
(0.70%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло девушк вебкамер"
]
1.53 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.59%)
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.