Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.57 ms
(84.44%)
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
  391983
  393560
  396911
  401893
  403163
  405761
  416969
  426990
  452212
  491618
  504334
  520233
  527864
  544171
  558694
  577309
  584985
  585021
  585035
  591154
  591452
  592635
  595671
  596503
  599091
  599099
  601726
  609625
  610001
  611343
  613493
  619363
  627218
  627263
  629340
  629432
  630084
  630230
  631281
  632450
  632920
  633039
  637512
  637831
  639153
  640166
  644617
  649100
  653728
  657189
  665939
  669680
  680746
  682993
  686494
  687441
  690035
  691146
  702860
  707161
  712755
  714344
  717447
  720220
  721688
  723208
  726272
  726391
  727384
  728184
  728492
  728891
  730668
  735478
  736280
  736504
  744956
  749768
  752462
  753919
  754238
  754816
  755110
  755184
  757925
  757943
  757992
  758696
  760386
  763472
  764759
  764796
  766390
  768921
  769123
  773834
  775089
  779130
  779939
  780912
  780947
  781194
  790354
  792052
  792198
  799984
  802242
  804909
  812255
  813565
  825154
  825291
  826735
  826831
  826982
  827387
  827418
  828549
  828676
]
11.91 ms
(8.48%)
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
  727384
  749768
  755110
  769123
  802242
  753919
  773834
  726272
  726391
  736280
  736504
  757992
  758696
  728492
  728891
  763472
  764796
  728184
  764759
  768921
  627263
  629432
  631281
  632450
  633039
  637831
  639153
  644617
  702860
  707161
  680746
  591452
  585035
  649100
  657189
  601726
  632920
  592635
  599099
  613493
  595671
  596503
  630084
  637512
  591154
  416969
  426990
  584985
  520233
  653728
  781194
  393560
  826735
  825291
  826831
  826982
  827418
  827387
  825154
  828676
  828549
  717447
  721688
  723208
  780947
  790354
  792052
  775089
  779130
  792198
  804909
  766390
  744956
  757943
  760386
  730668
  735478
  752462
  754238
  755184
  766932
  720220
  780912
  396911
  401893
  403163
  799984
  813565
  558694
  682993
  687441
  712755
  669680
  690035
  691146
  610001
  619363
  629340
  779939
  812255
  757925
  504334
  527864
  686494
  665939
  714344
  627218
  611343
  640166
  599091
  609625
  630230
  405761
  544171
  577309
  754816
  391983
  585021
  452212
  491618
]
2.67 ms
(1.90%)
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
  391983
  393560
  396911
  401893
  403163
  405761
  416969
  426990
  452212
  491618
  504334
  520233
  527864
  544171
  558694
  577309
  584985
  585021
  585035
  591154
  591452
  592635
  595671
  596503
  599091
  599099
  601726
  609625
  610001
  611343
  613493
  619363
  627218
  627263
  629340
  629432
  630084
  630230
  631281
  632450
  632920
  633039
  637512
  637831
  639153
  640166
  644617
  649100
  653728
  657189
  665939
  669680
  680746
  682993
  686494
  687441
  690035
  691146
  702860
  707161
  712755
  714344
  717447
  720220
  721688
  723208
  726272
  726391
  727384
  728184
  728492
  728891
  730668
  735478
  736280
  736504
  744956
  749768
  752462
  753919
  754238
  754816
  755110
  755184
  757925
  757943
  757992
  758696
  760386
  763472
  764759
  764796
  766390
  768921
  769123
  773834
  775089
  779130
  779939
  780912
  780947
  781194
  790354
  792052
  792198
  799984
  802242
  804909
  812255
  813565
  825154
  825291
  826735
  826831
  826982
  827387
  827418
  828549
  828676
]
2.13 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "тату домашнее реально…"
]
1.85 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные домашн любительск любительск"
]
1.60 ms
(1.14%)
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.