Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
132.55 ms
(79.81%)
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
  400237
  400249
  401114
  405485
  408240
  411838
  413161
  425802
  425966
  426369
  426384
  428653
  431750
  435226
  435917
  437494
  440620
  446718
  447104
  447746
  449613
  451932
  457446
  460135
  460204
  462465
  464395
  472544
  473871
  474761
  475410
  476105
  476228
  478333
  482228
  482679
  486594
  487344
  492268
  493244
  496771
  497473
  497478
  498030
  499446
  504423
  507512
  508275
  508474
  510177
  511895
  512896
  514097
  514804
  518176
  519930
  520253
  520639
  520766
  521723
  523659
  524200
  524262
  527085
  527377
  528406
  533505
  537600
  545779
  556819
  557534
  561512
  563844
  565317
  566317
  566606
  568052
  568641
  577390
  578492
  583329
  587907
  606649
  608049
  623444
  626353
  638360
  640721
  642556
  647901
  650806
  674056
  702460
  714973
  724656
  758585
  771924
  788161
  789690
  790019
  790026
  790878
  792610
  792612
  793340
  798683
  801240
  806430
  807363
  808470
  810663
  810669
  810983
  815232
  815449
  815865
  816569
  817917
  820683
  820973
]
23.53 ms
(14.17%)
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
  815449
  817917
  815865
  460204
  476105
  533505
  537600
  514804
  493244
  568052
  578492
  638360
  606649
  810669
  790026
  793340
  810663
  810983
  623444
  702460
  808470
  447746
  431750
  476228
  478333
  608049
  565317
  425802
  519930
  492268
  563844
  789690
  447104
  464395
  475410
  425966
  426369
  527085
  508275
  437494
  435226
  446718
  520766
  496771
  405485
  650806
  408240
  426384
  413161
  428653
  411838
  820973
  820683
  449613
  460135
  524262
  626353
  642556
  587907
  798683
  806430
  801240
  771924
  714973
  790878
  474761
  518176
  524200
  497478
  497473
  462465
  435917
  400249
  499446
  510177
  498030
  507512
  788161
  724656
  486594
  816569
  815232
  482679
  482228
  514097
  472544
  545779
  566606
  556819
  568641
  583329
  561512
  647901
  674056
  566317
  790019
  792610
  792612
  758585
  401114
  400237
  451932
  523659
  528406
  527377
  504423
  511895
  512896
  520639
  487344
  521723
  473871
  457446
  440620
  508474
  520253
  557534
  577390
  640721
  807363
]
2.52 ms
(1.52%)
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
  400237
  400249
  401114
  405485
  408240
  411838
  413161
  425802
  425966
  426369
  426384
  428653
  431750
  435226
  435917
  437494
  440620
  446718
  447104
  447746
  449613
  451932
  457446
  460135
  460204
  462465
  464395
  472544
  473871
  474761
  475410
  476105
  476228
  478333
  482228
  482679
  486594
  487344
  492268
  493244
  496771
  497473
  497478
  498030
  499446
  504423
  507512
  508275
  508474
  510177
  511895
  512896
  514097
  514804
  518176
  519930
  520253
  520639
  520766
  521723
  523659
  524200
  524262
  527085
  527377
  528406
  533505
  537600
  545779
  556819
  557534
  561512
  563844
  565317
  566317
  566606
  568052
  568641
  577390
  578492
  583329
  587907
  606649
  608049
  623444
  626353
  638360
  640721
  642556
  647901
  650806
  674056
  702460
  714973
  724656
  758585
  771924
  788161
  789690
  790019
  790026
  790878
  792610
  792612
  793340
  798683
  801240
  806430
  807363
  808470
  810663
  810669
  810983
  815232
  815449
  815865
  816569
  817917
  820683
  820973
]
1.99 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina mom boy"
]
1.86 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская mom парен"
]
1.69 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская mom парен"
]

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.