Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.56 ms
(58.20%)
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
  391966
  442795
  466408
  486118
  489222
  523611
  533752
  544161
  549503
  563762
  564549
  575621
  579719
  583323
  586146
  586253
  588433
  589644
  590465
  600279
  604837
  610830
  611284
  687942
  718053
  719284
  722083
  724535
  725301
  728393
  730361
  734301
  734574
  741866
  743793
  763972
  764026
  764505
  766451
  767688
  768200
  769135
  769207
  769616
  773339
  778291
  778592
  781153
  782493
  783802
  784237
  787459
  787822
  788644
  788733
  788761
  789152
  789365
  789643
  790946
  791449
  791606
  791817
  792298
  793955
  794262
  794580
  794595
  794721
  794957
  795338
  795353
  796257
  797037
  802292
  803213
  803738
  803871
  803943
  805455
  807857
  808279
  810318
  811086
  811546
  813638
  813936
  814106
  817201
  817555
  817588
  818766
  819040
  819172
  819728
  819733
  819916
  819944
  820215
  821757
  821758
  821776
  823571
  823600
  823763
  824003
  824086
  824777
  824792
  824852
  825035
  825090
  825350
  825425
  826155
  827010
  827220
  827492
  827562
]
132.99 ms
(36.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
  391966
  442795
  466408
  486118
  489222
  523611
  533752
  544161
  549503
  563762
  564549
  575621
  579719
  583323
  586146
  586253
  588433
  589644
  590465
  600279
  604837
  610830
  611284
  687942
  718053
  719284
  722083
  724535
  725301
  728393
  730361
  734301
  734574
  741866
  743793
  763972
  764026
  764505
  766451
  767688
  768200
  769135
  769207
  769616
  773339
  778291
  778592
  781153
  782493
  783802
  784237
  787459
  787822
  788644
  788733
  788761
  789152
  789365
  789643
  790946
  791449
  791606
  791817
  792298
  793955
  794262
  794580
  794595
  794721
  794957
  795338
  795353
  796257
  797037
  802292
  803213
  803738
  803871
  803943
  805455
  807857
  808279
  810318
  811086
  811546
  813638
  813936
  814106
  817201
  817555
  817588
  818766
  819040
  819172
  819728
  819733
  819916
  819944
  820215
  821757
  821758
  821776
  823571
  823600
  823763
  824003
  824086
  824777
  824792
  824852
  825035
  825090
  825350
  825425
  826155
  827010
  827220
  827492
  827562
]
9.66 ms
(2.68%)
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
  778592
  794957
  725301
  768200
  730361
  763806
  769616
  813936
  533752
  564549
  579719
  549503
  590465
  810318
  807857
  600279
  391966
  819728
  814106
  824086
  803213
  767688
  781153
  784237
  793955
  687942
  563762
  604837
  586253
  588433
  611284
  589644
  486118
  734301
  803943
  769135
  791449
  811546
  575621
  583323
  442795
  610830
  489222
  466408
  586146
  818766
  819040
  824003
  824792
  813638
  826155
  823763
  817555
  819916
  823571
  824852
  825090
  825350
  827010
  827220
  827492
  821757
  821758
  819733
  825035
  523611
  544161
  719284
  782493
  783802
  788733
  788761
  789152
  789365
  791606
  811086
  763972
  766451
  769207
  787459
  788644
  794580
  802292
  724535
  741866
  728393
  764505
  773339
  764026
  734574
  743793
  718053
  722083
  778291
  787822
  794721
  795353
  796257
  797037
  803738
  803871
  817588
  825425
  821776
  823600
  827562
  819172
  817201
  819944
  820215
  824777
  789643
  792298
  808279
  791817
  794262
  794595
  790946
  795338
  805455
]
2.37 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.20 ms
(0.61%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade milf pov"
]
1.68 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск milf пов"
]
1.60 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск milf пов"
]

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.