Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.49 ms
(51.17%)
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
  99145
  153311
  191602
  358398
  388522
  394780
  408150
  409152
  421813
  422152
  422168
  422347
  423318
  426510
  439732
  439812
  449872
  450767
  450803
  460659
  462198
  470433
  470451
  478994
  489325
  493117
  500099
  500911
  504927
  506518
  506770
  515685
  518573
  523370
  523412
  524669
  528215
  532007
  532048
  538970
  539450
  540174
  541905
  543794
  546617
  547252
  548499
  549276
  549917
  553160
  555021
  561454
  563075
  563830
  563971
  566569
  570818
  572565
  578067
  578642
  580642
  588858
  591636
  600863
  612904
  612918
  615533
  619140
  622687
  632471
  658919
  666087
  668419
  669896
  684235
  699401
  705966
  710928
  714324
  715904
  736384
  737650
  745749
  748627
  753710
  761761
  771145
  773766
  775167
  776844
  788031
  788513
  790337
  793602
  800634
  801701
  802160
  803301
  803313
  804153
  811319
  811917
  815497
  816563
  817304
  820026
  820134
  823725
  823888
  823933
  824274
  825191
  827085
  828306
  828472
  828520
  828592
  828688
  828803
  828820
]
178.29 ms
(43.34%)
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
  99145
  153311
  191602
  358398
  388522
  394780
  408150
  409152
  421813
  422152
  422168
  422347
  423318
  426510
  439732
  439812
  449872
  450767
  450803
  460659
  462198
  470433
  470451
  478994
  489325
  493117
  500099
  500911
  504927
  506518
  506770
  515685
  518573
  523370
  523412
  524669
  528215
  532007
  532048
  538970
  539450
  540174
  541905
  543794
  546617
  547252
  548499
  549276
  549917
  553160
  555021
  561454
  563075
  563830
  563971
  566569
  570818
  572565
  578067
  578642
  580642
  588858
  591636
  600863
  612904
  612918
  615533
  619140
  622687
  632471
  658919
  666087
  668419
  669896
  684235
  699401
  705966
  710928
  714324
  715904
  736384
  737650
  745749
  748627
  753710
  761761
  771145
  773766
  775167
  776844
  788031
  788513
  790337
  793602
  800634
  801701
  802160
  803301
  803313
  804153
  811319
  811917
  815497
  816563
  817304
  820026
  820134
  823725
  823888
  823933
  824274
  825191
  827085
  828306
  828472
  828520
  828592
  828688
  828803
  828820
]
15.60 ms
(3.79%)
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
  668419
  549917
  591636
  801701
  811917
  803301
  773766
  622687
  699401
  710928
  388522
  423318
  426510
  462198
  524669
  506518
  506770
  493117
  561454
  563075
  578642
  580642
  619140
  800634
  449872
  422152
  460659
  450767
  450803
  422347
  538970
  515685
  528215
  504927
  816563
  817304
  828803
  828306
  827085
  828520
  828592
  828472
  828688
  563830
  572565
  570818
  666087
  547252
  549276
  788031
  737650
  771145
  99145
  408150
  409152
  815497
  470433
  500099
  532007
  548499
  553160
  541905
  658919
  669896
  555021
  588858
  612918
  615533
  802160
  811319
  803313
  736384
  745749
  753710
  761761
  715904
  439812
  823888
  823725
  820026
  825191
  820134
  824274
  828820
  823933
  540174
  532048
  546617
  684235
  705966
  563971
  566569
  793602
  804153
  790337
  748627
  632471
  775167
  776844
  788513
  714324
  191602
  478994
  523370
  523412
  518573
  500911
  539450
  543794
  578067
  600863
  612904
  421813
  422168
  470451
  439732
  489325
  153311
  394780
  358398
]
1.82 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf toilet"
]
1.76 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf туалет"
]
1.61 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf туалет"
]

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.