Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
139.91 ms
(83.58%)
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
  429181
  429729
  445274
  446108
  451531
  453862
  457078
  482359
  486470
  517743
  528761
  530385
  530697
  530798
  531134
  531179
  531233
  531256
  531258
  532744
  532965
  533016
  533044
  533521
  533798
  533855
  534216
  534647
  534992
  534999
  536287
  536289
  536542
  536606
  536620
  537776
  537880
  537886
  537890
  537932
  538881
  540330
  541925
  542877
  544854
  545418
  545718
  550200
  570691
  597236
  597254
  599851
  599894
  599928
  599958
  600017
  600175
  600329
  601609
  617421
  630547
  630806
  631199
  631203
  631948
  632586
  632638
  632658
  632660
  632684
  634154
  634786
  636316
  636991
  637089
  637096
  637107
  637120
  637431
  637432
  639048
  639257
  639335
  639792
  639797
  640795
  644940
  645973
  646448
  648850
  648862
  651620
  651669
  666585
  672329
  676066
  677295
  679326
  679721
  679742
  679757
  679761
  679772
  679785
  680115
  680150
  680153
  696229
  699627
  704216
  704226
  708444
  716085
  716870
  733843
  733849
  733863
  733883
  748236
  758180
]
17.31 ms
(10.34%)
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
  599928
  600175
  599851
  758180
  457078
  534216
  534647
  534992
  536542
  537776
  531134
  533016
  536620
  531179
  531233
  531256
  532744
  533855
  537880
  537890
  531258
  532965
  536606
  537886
  537932
  542877
  550200
  570691
  645973
  679785
  696229
  699627
  716870
  666585
  680115
  704216
  708444
  648862
  679761
  680150
  680153
  597254
  599894
  632638
  634154
  637107
  637431
  637432
  639048
  639335
  639792
  640795
  600329
  601609
  632658
  632684
  636991
  637089
  637096
  637120
  632660
  636316
  639797
  597236
  600017
  632586
  733849
  733883
  733843
  634786
  716085
  446108
  429181
  453862
  486470
  530697
  631203
  445274
  528761
  533521
  533044
  534999
  482359
  679772
  648850
  651620
  704226
  599958
  630806
  631199
  733863
  748236
  631948
  451531
  544854
  672329
  651669
  630547
  639257
  545718
  545418
  646448
  617421
  540330
  679742
  676066
  536289
  530798
  538881
  541925
  677295
  679721
  679326
  679757
  517743
  429729
  644940
  530385
  533798
  536287
]
2.81 ms
(1.68%)
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
  429181
  429729
  445274
  446108
  451531
  453862
  457078
  482359
  486470
  517743
  528761
  530385
  530697
  530798
  531134
  531179
  531233
  531256
  531258
  532744
  532965
  533016
  533044
  533521
  533798
  533855
  534216
  534647
  534992
  534999
  536287
  536289
  536542
  536606
  536620
  537776
  537880
  537886
  537890
  537932
  538881
  540330
  541925
  542877
  544854
  545418
  545718
  550200
  570691
  597236
  597254
  599851
  599894
  599928
  599958
  600017
  600175
  600329
  601609
  617421
  630547
  630806
  631199
  631203
  631948
  632586
  632638
  632658
  632660
  632684
  634154
  634786
  636316
  636991
  637089
  637096
  637107
  637120
  637431
  637432
  639048
  639257
  639335
  639792
  639797
  640795
  644940
  645973
  646448
  648850
  648862
  651620
  651669
  666585
  672329
  676066
  677295
  679326
  679721
  679742
  679757
  679761
  679772
  679785
  680115
  680150
  680153
  696229
  699627
  704216
  704226
  708444
  716085
  716870
  733843
  733849
  733863
  733883
  748236
  758180
]
2.04 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кастинг трахают толпо…"
]
1.80 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "кастинг секс группов секс"
]
1.54 ms
(0.92%)
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.