Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.45 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.12 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "шеи"
]
3 16.27 ms
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
  681446
  684064
  684066
  686593
  690797
  690841
  647403
  650213
  652586
  652773
  653300
  659380
  663936
  664854
  665493
  670383
  672324
  672344
  672367
  673082
  680892
  682098
  682124
  684067
  686572
  688287
  647140
  653330
  655405
  659270
  660613
  664612
  664836
  670565
  672975
  674255
  674587
  674618
  683047
  684688
  689862
  689897
  689932
  709292
  546705
  547610
  547780
  550560
  551020
  553242
  553285
  554517
  555928
  556537
  557519
  557933
  558106
  560222
  560984
  563121
  563462
  564197
  564611
  569539
  571728
  571931
  578719
  579163
  579170
  581514
  582553
  582560
  586800
  588365
  589204
  591608
  592221
  592450
  592852
  592870
  594114
  594826
  597081
  597827
  599981
  601014
  601373
  601691
  603003
  606095
  606605
  606747
  607597
  609870
  611265
  611813
  614105
  615311
  618845
  624865
  628328
  630192
  634736
  635194
  635203
  644175
  585799
  591375
  593014
  594778
  598438
  599139
  601133
  601503
  602568
  603359
  603558
  603795
  604028
  606436
]
4 210.18 ms
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
  546705
  547610
  547780
  550560
  551020
  553242
  553285
  554517
  555928
  556537
  557519
  557933
  558106
  560222
  560984
  563121
  563462
  564197
  564611
  569539
  571728
  571931
  578719
  579163
  579170
  581514
  582553
  582560
  585799
  586800
  588365
  589204
  591375
  591608
  592221
  592450
  592852
  592870
  593014
  594114
  594778
  594826
  597081
  597827
  598438
  599139
  599981
  601014
  601133
  601373
  601503
  601691
  602568
  603003
  603359
  603558
  603795
  604028
  606095
  606436
  606605
  606747
  607597
  609870
  611265
  611813
  614105
  615311
  618845
  624865
  628328
  630192
  634736
  635194
  635203
  644175
  647140
  647403
  650213
  652586
  652773
  653300
  653330
  655405
  659270
  659380
  660613
  663936
  664612
  664836
  664854
  665493
  670383
  670565
  672324
  672344
  672367
  672975
  673082
  674255
  674587
  674618
  680892
  681446
  682098
  682124
  683047
  684064
  684066
  684067
  684688
  686572
  686593
  688287
  689862
  689897
  689932
  690797
  690841
  709292
]
5 167.94 ms
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
  546705
  547610
  547780
  550560
  551020
  553242
  553285
  554517
  555928
  556537
  557519
  557933
  558106
  560222
  560984
  563121
  563462
  564197
  564611
  569539
  571728
  571931
  578719
  579163
  579170
  581514
  582553
  582560
  585799
  586800
  588365
  589204
  591375
  591608
  592221
  592450
  592852
  592870
  593014
  594114
  594778
  594826
  597081
  597827
  598438
  599139
  599981
  601014
  601133
  601373
  601503
  601691
  602568
  603003
  603359
  603558
  603795
  604028
  606095
  606436
  606605
  606747
  607597
  609870
  611265
  611813
  614105
  615311
  618845
  624865
  628328
  630192
  634736
  635194
  635203
  644175
  647140
  647403
  650213
  652586
  652773
  653300
  653330
  655405
  659270
  659380
  660613
  663936
  664612
  664836
  664854
  665493
  670383
  670565
  672324
  672344
  672367
  672975
  673082
  674255
  674587
  674618
  680892
  681446
  682098
  682124
  683047
  684064
  684066
  684067
  684688
  686572
  686593
  688287
  689862
  689897
  689932
  690797
  690841
  709292
]
6 1.69 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ше"
]
7 1.44 ms
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.