Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.31 ms
(84.62%)
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
  7051
  7118
  102892
  196316
  309283
  383880
  385111
  385677
  386033
  393475
  395379
  396033
  398144
  398274
  401268
  403112
  406793
  411218
  414198
  419862
  421907
  422208
  426527
  426765
  426866
  427959
  428756
  433260
  437830
  439621
  439627
  439720
  439751
  439755
  439764
  439765
  439773
  439779
  439780
  439786
  439812
  439815
  439816
  440139
  440593
  440598
  441004
  442545
  442612
  443358
  444018
  444344
  444589
  444703
  444890
  451983
  452526
  454085
  457434
  462353
  463790
  468754
  469367
  470487
  473539
  474706
  475294
  484227
  485274
  489194
  489652
  496792
  497613
  497885
  506017
  506860
  516481
  517052
  523948
  534193
  555103
  590867
  593606
  599889
  600036
  602268
  611287
  616205
  625660
  630553
  634777
  665760
  695124
  696947
  707323
  716633
  718790
  724403
  739997
  743278
  747194
  747195
  747223
  747228
  747231
  747236
  760004
  761084
  761768
  766337
  766866
  769749
  769808
  769859
  778949
  783657
  783704
  790978
  803900
  820792
]
16.33 ms
(9.32%)
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
  485274
  517052
  462353
  437830
  630553
  439627
  444703
  469367
  442612
  442545
  463790
  426866
  696947
  444589
  440598
  506017
  489194
  747194
  497613
  439786
  497885
  427959
  426765
  440139
  516481
  489652
  439780
  196316
  496792
  625660
  474706
  506860
  695124
  439765
  468754
  414198
  590867
  611287
  443358
  439773
  439764
  439755
  747195
  747228
  419862
  439621
  440593
  433260
  444344
  747223
  444018
  634777
  439779
  451983
  457434
  473539
  747231
  439815
  422208
  439816
  428756
  484227
  439720
  444890
  426527
  600036
  439812
  421907
  747236
  523948
  439751
  441004
  470487
  475294
  616205
  602268
  398144
  766866
  769859
  761768
  766337
  769808
  707323
  395379
  820792
  403112
  385111
  406793
  665760
  396033
  778949
  716633
  383880
  790978
  724403
  454085
  803900
  393475
  534193
  102892
  593606
  760004
  309283
  743278
  385677
  599889
  398274
  783704
  7118
  411218
  555103
  783657
  401268
  452526
  769749
  7051
  386033
  739997
  718790
  761084
]
2.96 ms
(1.69%)
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
  7051
  7118
  102892
  196316
  309283
  383880
  385111
  385677
  386033
  393475
  395379
  396033
  398144
  398274
  401268
  403112
  406793
  411218
  414198
  419862
  421907
  422208
  426527
  426765
  426866
  427959
  428756
  433260
  437830
  439621
  439627
  439720
  439751
  439755
  439764
  439765
  439773
  439779
  439780
  439786
  439812
  439815
  439816
  440139
  440593
  440598
  441004
  442545
  442612
  443358
  444018
  444344
  444589
  444703
  444890
  451983
  452526
  454085
  457434
  462353
  463790
  468754
  469367
  470487
  473539
  474706
  475294
  484227
  485274
  489194
  489652
  496792
  497613
  497885
  506017
  506860
  516481
  517052
  523948
  534193
  555103
  590867
  593606
  599889
  600036
  602268
  611287
  616205
  625660
  630553
  634777
  665760
  695124
  696947
  707323
  716633
  718790
  724403
  739997
  743278
  747194
  747195
  747223
  747228
  747231
  747236
  760004
  761084
  761768
  766337
  766866
  769749
  769808
  769859
  778949
  783657
  783704
  790978
  803900
  820792
]
2.29 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal blowjob"
]
1.97 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал минет оральн секс"
]
1.73 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.95%)
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.