Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.53 ms
(50.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "девушка лижет женщинам"
]
172.56 ms
(41.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
  145335
  152882
  388862
  396074
  414306
  420635
  424749
  425655
  429409
  430190
  447032
  448845
  452387
  456847
  463837
  464139
  466561
  472638
  474302
  476234
  479780
  479794
  482606
  486805
  492364
  493211
  498882
  505504
  512722
  523394
  523491
  523680
  523778
  524986
  528038
  534334
  535835
  541630
  551209
  555314
  556656
  559601
  559874
  561807
  567110
  573379
  573470
  576691
  583314
  591189
  592532
  594907
  595835
  599927
  605308
  606101
  607079
  607450
  610138
  632010
  632031
  636053
  639739
  643041
  644373
  650188
  650313
  650660
  664960
  667525
  670951
  675084
  680611
  686035
  686044
  687972
  699599
  720758
  725353
  728169
  729200
  729284
  732258
  736233
  758492
  759775
  760809
  764909
  765841
  767040
  773799
  779069
  789659
  789992
  795024
  795104
  796193
  796494
  797801
  799601
  803173
  803343
  803541
  804249
  804763
  806203
  806530
  806777
  807687
  810982
  812259
  813520
  815212
  815381
  815524
  815941
  817724
  817924
  824208
  825187
]
22.96 ms
(5.58%)
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
  817924
  815212
  474302
  479780
  479794
  486805
  452387
  493211
  535835
  523394
  476234
  559601
  567110
  573470
  555314
  687972
  573379
  591189
  643041
  632031
  636053
  592532
  594907
  606101
  803343
  806777
  799601
  765841
  797801
  813520
  760809
  764909
  728169
  773799
  607079
  810982
  424749
  498882
  523491
  388862
  815524
  807687
  505504
  595835
  817724
  686044
  806530
  650313
  512722
  675084
  523778
  145335
  796193
  789992
  789659
  804763
  429409
  466561
  599927
  639739
  420635
  664960
  644373
  425655
  670951
  632010
  472638
  556656
  152882
  804249
  448845
  524986
  396074
  447032
  725353
  736233
  551209
  610138
  759775
  767040
  729284
  758492
  796494
  464139
  825187
  824208
  482606
  559874
  680611
  720758
  583314
  607450
  795024
  795104
  803173
  803541
  812259
  729200
  806203
  815381
  561807
  699599
  605308
  779069
  456847
  523680
  667525
  541630
  815941
  686035
  732258
  430190
  414306
  492364
  534334
  528038
  463837
  576691
  650188
  650660
]
3.48 ms
(0.85%)
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
  145335
  152882
  388862
  396074
  414306
  420635
  424749
  425655
  429409
  430190
  447032
  448845
  452387
  456847
  463837
  464139
  466561
  472638
  474302
  476234
  479780
  479794
  482606
  486805
  492364
  493211
  498882
  505504
  512722
  523394
  523491
  523680
  523778
  524986
  528038
  534334
  535835
  541630
  551209
  555314
  556656
  559601
  559874
  561807
  567110
  573379
  573470
  576691
  583314
  591189
  592532
  594907
  595835
  599927
  605308
  606101
  607079
  607450
  610138
  632010
  632031
  636053
  639739
  643041
  644373
  650188
  650313
  650660
  664960
  667525
  670951
  675084
  680611
  686035
  686044
  687972
  699599
  720758
  725353
  728169
  729200
  729284
  732258
  736233
  758492
  759775
  760809
  764909
  765841
  767040
  773799
  779069
  789659
  789992
  795024
  795104
  796193
  796494
  797801
  799601
  803173
  803343
  803541
  804249
  804763
  806203
  806530
  806777
  807687
  810982
  812259
  813520
  815212
  815381
  815524
  815941
  817724
  817924
  824208
  825187
]
2.12 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.05 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк лиза женщин"
]
1.72 ms
(0.42%)
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.