Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
1048.48 ms
(85.72%)
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
  807004
  740450
  748450
  749284
  773073
  633066
  644509
  710285
  716318
  801480
  398612
  454692
  76268
  204778
  409305
  712415
  649367
  670214
  588632
  643751
  593216
  593301
  783462
  745324
  644536
  798571
  395513
  404304
  406204
  442679
  433592
  435358
  467908
  484355
  464102
  472543
  445553
  446232
  451890
  454412
  475468
  513910
  552114
  575797
  476981
  444978
  471347
  396056
  448108
  503887
  507668
  494771
  527793
  393688
  418782
  815938
  815428
  464558
  583178
  663371
  663469
  662846
  676130
  615355
  622031
  610243
  610262
  781099
  784841
  809458
  800738
  800831
  808042
  788594
  759725
  769334
  773857
  714881
  384795
  383660
  31708
  389135
  404286
  410688
  422025
  420157
  438533
  444968
  420140
  435407
  454573
  456532
  459637
  475485
  490504
  457767
  473183
  468720
  476105
  531477
  512923
  518347
  469577
  554777
  563796
  568281
  569820
  546607
  551293
  551422
  572010
  575801
  650841
  559958
  592815
  598774
  613850
  609071
  594237
  411821
]
148.11 ms
(12.11%)
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
  31708
  76268
  204778
  383660
  384795
  389135
  393688
  395513
  396056
  398612
  404286
  404304
  406204
  409305
  410688
  411821
  418782
  420140
  420157
  422025
  433592
  435358
  435407
  438533
  442679
  444968
  444978
  445553
  446232
  448108
  451890
  454412
  454573
  454692
  456532
  457767
  459637
  464102
  464558
  467908
  468720
  469577
  471347
  472543
  473183
  475468
  475485
  476105
  476981
  484355
  490504
  494771
  503887
  507668
  512923
  513910
  518347
  527793
  531477
  546607
  551293
  551422
  552114
  554777
  559958
  563796
  568281
  569820
  572010
  575797
  575801
  583178
  588632
  592815
  593216
  593301
  594237
  598774
  609071
  610243
  610262
  613850
  615355
  622031
  633066
  643751
  644509
  644536
  649367
  650841
  662846
  663371
  663469
  670214
  676130
  710285
  712415
  714881
  716318
  740450
  745324
  748450
  749284
  759725
  769334
  773073
  773857
  781099
  783462
  784841
  788594
  798571
  800738
  800831
  801480
  807004
  808042
  809458
  815428
  815938
]
20.07 ms
(1.64%)
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
  31708
  76268
  204778
  383660
  384795
  389135
  393688
  395513
  396056
  398612
  404286
  404304
  406204
  409305
  410688
  411821
  418782
  420140
  420157
  422025
  433592
  435358
  435407
  438533
  442679
  444968
  444978
  445553
  446232
  448108
  451890
  454412
  454573
  454692
  456532
  457767
  459637
  464102
  464558
  467908
  468720
  469577
  471347
  472543
  473183
  475468
  475485
  476105
  476981
  484355
  490504
  494771
  503887
  507668
  512923
  513910
  518347
  527793
  531477
  546607
  551293
  551422
  552114
  554777
  559958
  563796
  568281
  569820
  572010
  575797
  575801
  583178
  588632
  592815
  593216
  593301
  594237
  598774
  609071
  610243
  610262
  613850
  615355
  622031
  633066
  643751
  644509
  644536
  649367
  650841
  662846
  663371
  663469
  670214
  676130
  710285
  712415
  714881
  716318
  740450
  745324
  748450
  749284
  759725
  769334
  773073
  773857
  781099
  783462
  784841
  788594
  798571
  800738
  800831
  801480
  807004
  808042
  809458
  815428
  815938
]
1.73 ms
(0.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сиськ масл"
]
1.71 ms
(0.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tits oil"
]
1.56 ms
(0.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.13%)
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.