Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
176.15 ms
(88.31%)
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
  79913
  410844
  413963
  457917
  459138
  459354
  465939
  498273
  514213
  515984
  517839
  531006
  541054
  542179
  546400
  554229
  555646
  561536
  565010
  566742
  575625
  577648
  585289
  588136
  589636
  615068
  617974
  626285
  633535
  634432
  635446
  636687
  637486
  639593
  643190
  645804
  646012
  650556
  654893
  656556
  657781
  663396
  665253
  665499
  667558
  667903
  678879
  682387
  683770
  687555
  697216
  697512
  707451
  708073
  711935
  714382
  714583
  717977
  721156
  722346
  724751
  727405
  728971
  737900
  738463
  741235
  742074
  743768
  745265
  745929
  746305
  752312
  755118
  756914
  759939
  760889
  764189
  765605
  767556
  769064
  769587
  771830
  776993
  777124
  778109
  778953
  780230
  781272
  781913
  783085
  786350
  787027
  789023
  790021
  790305
  791763
  793739
  793818
  794428
  795095
  797724
  798521
  800176
  801339
  801453
  801768
  802616
  804085
  809092
  809741
  816025
  817934
  819705
  820165
  822834
  823181
  823473
  824420
  826560
]
13.30 ms
(6.67%)
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
  633535
  777124
  410844
  413963
  817934
  665253
  816025
  646012
  717977
  722346
  687555
  663396
  667903
  683770
  697512
  714583
  637486
  589636
  636687
  787027
  789023
  798521
  800176
  809092
  737900
  742074
  745929
  765605
  781272
  786350
  791763
  802616
  769064
  724751
  760889
  769587
  771830
  764189
  635446
  721156
  778109
  790021
  801768
  459354
  457917
  819705
  820165
  531006
  575625
  554229
  555646
  678879
  682387
  714382
  650556
  697216
  711935
  654893
  656556
  708073
  577648
  585289
  588136
  617974
  626285
  634432
  639593
  795095
  794428
  804085
  746305
  759939
  783085
  738463
  756914
  743768
  755118
  615068
  778953
  801339
  79913
  824420
  826560
  822834
  823473
  823181
  459138
  514213
  498273
  515984
  517839
  465939
  542179
  541054
  546400
  566742
  707451
  665499
  667558
  645804
  657781
  561536
  565010
  643190
  780230
  790305
  793739
  801453
  776993
  781913
  809741
  727405
  741235
  752312
  767556
  793818
  797724
  798465
  745265
  728971
]
2.84 ms
(1.42%)
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
  79913
  410844
  413963
  457917
  459138
  459354
  465939
  498273
  514213
  515984
  517839
  531006
  541054
  542179
  546400
  554229
  555646
  561536
  565010
  566742
  575625
  577648
  585289
  588136
  589636
  615068
  617974
  626285
  633535
  634432
  635446
  636687
  637486
  639593
  643190
  645804
  646012
  650556
  654893
  656556
  657781
  663396
  665253
  665499
  667558
  667903
  678879
  682387
  683770
  687555
  697216
  697512
  707451
  708073
  711935
  714382
  714583
  717977
  721156
  722346
  724751
  727405
  728971
  737900
  738463
  741235
  742074
  743768
  745265
  745929
  746305
  752312
  755118
  756914
  759939
  760889
  764189
  765605
  767556
  769064
  769587
  771830
  776993
  777124
  778109
  778953
  780230
  781272
  781913
  783085
  786350
  787027
  789023
  790021
  790305
  791763
  793739
  793818
  794428
  795095
  797724
  798521
  800176
  801339
  801453
  801768
  802616
  804085
  809092
  809741
  816025
  817934
  819705
  820165
  822834
  823181
  823473
  824420
  826560
]
1.98 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "him fuck"
]
1.91 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "him секс"
]
1.68 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "him секс"
]
1.60 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.