Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.89 ms
(56.26%)
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
  390389
  405699
  435962
  438748
  469113
  473607
  474248
  475425
  478100
  487758
  494878
  503059
  505073
  513587
  514657
  518049
  518629
  520262
  520835
  528608
  529474
  529911
  534673
  539774
  542215
  550122
  550475
  553786
  555542
  555977
  555983
  555986
  555991
  556751
  558089
  558718
  558719
  560252
  560694
  561614
  563955
  567077
  573993
  578255
  579724
  580984
  581412
  583238
  583855
  586363
  588930
  590702
  591335
  592605
  592852
  593057
  593098
  594989
  595258
  599803
  602614
  605182
  605266
  613777
  615073
  615182
  618035
  618300
  618301
  618303
  621174
  631358
  635828
  637975
  640894
  652716
  657775
  657782
  662046
  662072
  665083
  667360
  667455
  667471
  670534
  672742
  679270
  680785
  680800
  696061
  701231
  710946
  736018
  739556
  741368
  745329
  750739
  751470
  774575
  774949
  780114
  787527
  788624
  790154
  802920
  804649
  807862
  811350
  812779
  813136
  813141
  820656
  824666
]
143.43 ms
(38.08%)
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
  390389
  405699
  435962
  438748
  469113
  473607
  474248
  475425
  478100
  487758
  494878
  503059
  505073
  513587
  514657
  518049
  518629
  520262
  520835
  528608
  529474
  529911
  534673
  539774
  542215
  550122
  550475
  553786
  555542
  555977
  555983
  555986
  555991
  556751
  558089
  558718
  558719
  560252
  560694
  561614
  563955
  567077
  573993
  578255
  579724
  580984
  581412
  583238
  583855
  586363
  588930
  590702
  591335
  592605
  592852
  593057
  593098
  594989
  595258
  599803
  602614
  605182
  605266
  613777
  615073
  615182
  618035
  618300
  618301
  618303
  621174
  631358
  635828
  637975
  640894
  652716
  657775
  657782
  662046
  662072
  665083
  667360
  667455
  667471
  670534
  672742
  679270
  680785
  680800
  696061
  701231
  710946
  736018
  739556
  741368
  745329
  750739
  751470
  774575
  774949
  780114
  787527
  788624
  790154
  802920
  804649
  807862
  811350
  812779
  813136
  813141
  820656
  824666
]
14.72 ms
(3.91%)
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
  563955
  652716
  640894
  804649
  736018
  680785
  662072
  621174
  583238
  513587
  586363
  595258
  807862
  750739
  739556
  774575
  813136
  824666
  474248
  580984
  542215
  665083
  615073
  593098
  618303
  631358
  811350
  637975
  478100
  635828
  593057
  618035
  494878
  680800
  710946
  555983
  405699
  518629
  503059
  573993
  670534
  592852
  590702
  812779
  774949
  567077
  550122
  556751
  594989
  618301
  588930
  618300
  813141
  390389
  555542
  558719
  560694
  539774
  662046
  751470
  701231
  591335
  560252
  679270
  592605
  613777
  520835
  505073
  672742
  579724
  514657
  518049
  553786
  581412
  578255
  820656
  528608
  561614
  605266
  615182
  599803
  802920
  696061
  529911
  780114
  788624
  438748
  583855
  667360
  745329
  787527
  667471
  667455
  558718
  435962
  469113
  741368
  605182
  475425
  790154
  473607
  534673
  657782
  558089
  529474
  555977
  555986
  487758
  602614
  555991
  657775
  550475
  520262
]
1.81 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло девушк вмашин"
]
1.73 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo girl car"
]
1.59 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.39%)
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.