Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.02 ms
(81.94%)
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
  387078
  391358
  394309
  397775
  418663
  419144
  420020
  431038
  431234
  437624
  439427
  447734
  450933
  452807
  452824
  452825
  454140
  468207
  471011
  484236
  484966
  491106
  492537
  497778
  500525
  500679
  505355
  511375
  513253
  514221
  514960
  515624
  515667
  517703
  520285
  525342
  528557
  531867
  533153
  536086
  539370
  539774
  543350
  547228
  548210
  550907
  551484
  554178
  555033
  555551
  556167
  557650
  559786
  561529
  579145
  579451
  579454
  579863
  582281
  582438
  583375
  584354
  586689
  588622
  594115
  602056
  602305
  602592
  607244
  607401
  608955
  614787
  614852
  618803
  628567
  628692
  629742
  630267
  639236
  643209
  648370
  651845
  652057
  658860
  660013
  664192
  664441
  666180
  674918
  689065
  691179
  733594
  738446
  739165
  740920
  742417
  746135
  752263
  752298
  757569
  758629
  760403
  762035
  772512
  774842
  784524
  784969
  785864
  795718
  796663
  797825
  802340
  806384
  807002
  808025
  809008
  809070
  811283
  816122
]
15.33 ms
(10.46%)
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
  514221
  520285
  550907
  557650
  583375
  658860
  588622
  608955
  639236
  614852
  774842
  784524
  784969
  746135
  758629
  762035
  630267
  394309
  471011
  454140
  511375
  418663
  816122
  531867
  536086
  533153
  500679
  484236
  555551
  543350
  584354
  666180
  689065
  547228
  556167
  602305
  607401
  614787
  802340
  752263
  752298
  807002
  811283
  757569
  795718
  808025
  420020
  431234
  491106
  513253
  484966
  397775
  387078
  447734
  452807
  452824
  517703
  505355
  561529
  579451
  548210
  554178
  579145
  652057
  674918
  555033
  628567
  643209
  629742
  586689
  594115
  796663
  809070
  772512
  809008
  733594
  738446
  602056
  797825
  468207
  514960
  492537
  497778
  391358
  419144
  525342
  539774
  500525
  648370
  691179
  664441
  664192
  579454
  602592
  604621
  618803
  628692
  607244
  806384
  785864
  742417
  739165
  450933
  437624
  452825
  515667
  515624
  539370
  439427
  579863
  551484
  559786
  582438
  660013
  651845
  582281
  740920
  760403
  431038
  528557
]
3.26 ms
(2.22%)
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
  387078
  391358
  394309
  397775
  418663
  419144
  420020
  431038
  431234
  437624
  439427
  447734
  450933
  452807
  452824
  452825
  454140
  468207
  471011
  484236
  484966
  491106
  492537
  497778
  500525
  500679
  505355
  511375
  513253
  514221
  514960
  515624
  515667
  517703
  520285
  525342
  528557
  531867
  533153
  536086
  539370
  539774
  543350
  547228
  548210
  550907
  551484
  554178
  555033
  555551
  556167
  557650
  559786
  561529
  579145
  579451
  579454
  579863
  582281
  582438
  583375
  584354
  586689
  588622
  594115
  602056
  602305
  602592
  607244
  607401
  608955
  614787
  614852
  618803
  628567
  628692
  629742
  630267
  639236
  643209
  648370
  651845
  652057
  658860
  660013
  664192
  664441
  666180
  674918
  689065
  691179
  733594
  738446
  739165
  740920
  742417
  746135
  752263
  752298
  757569
  758629
  760403
  762035
  772512
  774842
  784524
  784969
  785864
  795718
  796663
  797825
  802340
  806384
  807002
  808025
  809008
  809070
  811283
  816122
]
2.19 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "solo love"
]
1.93 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.31%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло love"
]
1.83 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло love"
]

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.