Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.20 ms
(86.53%)
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
  68658
  329464
  391147
  392152
  392818
  396365
  396373
  396768
  397682
  402233
  403393
  404025
  404247
  404555
  410058
  411542
  413210
  415451
  417950
  425290
  457036
  475575
  487163
  505364
  516085
  516606
  517011
  519670
  528403
  529842
  531118
  531578
  534302
  535191
  540090
  542687
  543911
  570855
  595422
  605871
  622917
  624888
  626310
  626495
  627635
  628302
  630303
  643086
  643132
  646006
  649478
  661941
  670343
  680142
  681012
  681823
  682167
  683576
  685559
  693891
  696916
  701125
  720728
  721450
  722213
  724332
  728114
  729786
  730235
  731626
  748733
  749187
  753444
  753597
  755472
  759883
  771101
  778031
  778734
  779506
  779599
  780008
  786815
  787178
  788451
  789246
  789607
  789846
  791110
  791152
  793429
  793637
  794606
  795183
  797677
  798807
  799237
  799299
  800105
  801479
  802698
  804851
  809269
  813519
  814253
  814917
  815189
  815250
  815456
  815690
  815761
  815946
  816955
  816987
  817077
  818222
  819855
  823392
  823798
  825112
]
15.74 ms
(8.25%)
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
  778734
  809269
  392152
  404025
  595422
  779599
  404247
  425290
  815189
  681012
  795183
  813519
  396365
  413210
  543911
  626310
  683576
  701125
  622917
  626495
  749187
  815761
  815946
  819855
  534302
  661941
  799299
  728114
  794606
  696916
  804851
  755472
  771101
  797677
  731626
  627635
  814253
  531578
  646006
  779506
  789846
  505364
  487163
  516606
  411542
  475575
  516085
  517011
  528403
  643132
  816987
  816955
  817077
  818222
  823392
  542687
  682167
  628302
  789607
  793637
  802698
  793429
  798807
  800105
  788451
  753597
  753444
  778031
  329464
  519670
  791110
  643086
  457036
  780008
  721450
  786815
  392818
  693891
  685559
  535191
  624888
  801479
  759883
  397682
  415451
  540090
  531118
  823798
  417950
  815456
  815250
  570855
  670343
  722213
  720728
  605871
  799237
  724332
  787178
  396768
  403393
  730235
  649478
  630303
  791152
  789246
  729786
  748733
  391147
  825112
  68658
  402233
  410058
  681823
  404555
  396373
  680142
  814917
  815690
  529842
]
2.73 ms
(1.43%)
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
  68658
  329464
  391147
  392152
  392818
  396365
  396373
  396768
  397682
  402233
  403393
  404025
  404247
  404555
  410058
  411542
  413210
  415451
  417950
  425290
  457036
  475575
  487163
  505364
  516085
  516606
  517011
  519670
  528403
  529842
  531118
  531578
  534302
  535191
  540090
  542687
  543911
  570855
  595422
  605871
  622917
  624888
  626310
  626495
  627635
  628302
  630303
  643086
  643132
  646006
  649478
  661941
  670343
  680142
  681012
  681823
  682167
  683576
  685559
  693891
  696916
  701125
  720728
  721450
  722213
  724332
  728114
  729786
  730235
  731626
  748733
  749187
  753444
  753597
  755472
  759883
  771101
  778031
  778734
  779506
  779599
  780008
  786815
  787178
  788451
  789246
  789607
  789846
  791110
  791152
  793429
  793637
  794606
  795183
  797677
  798807
  799237
  799299
  800105
  801479
  802698
  804851
  809269
  813519
  814253
  814917
  815189
  815250
  815456
  815690
  815761
  815946
  816955
  816987
  817077
  818222
  819855
  823392
  823798
  825112
]
1.97 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deepthroat beauty"
]
1.94 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс beauty"
]
1.57 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "глубокийминет минет оральн секс beauty"
]

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.