Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.50 ms
(80.08%)
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
  334950
  389264
  397369
  400195
  400869
  401953
  402247
  407015
  416841
  418035
  425636
  426540
  428837
  437583
  441626
  442946
  444588
  447971
  448745
  449866
  449879
  454923
  457649
  460190
  460693
  462897
  465355
  467329
  467338
  469072
  472162
  479346
  481798
  482350
  489185
  489938
  495088
  500832
  504739
  504897
  506113
  510754
  512377
  513397
  514337
  515122
  515952
  516332
  517049
  517143
  518960
  519138
  519322
  519838
  520265
  522424
  524456
  527675
  528538
  530734
  531120
  531523
  535684
  535960
  544495
  547644
  548848
  550076
  556865
  565752
  566708
  569421
  571033
  571715
  580744
  581341
  581737
  582236
  585392
  587228
  588041
  591413
  598993
  599664
  605484
  610293
  611562
  615762
  635920
  665121
  672328
  672777
  680824
  695153
  696557
  704533
  710594
  724651
  727465
  742810
  745397
  757638
  770642
  784922
  792910
  799360
  802104
  803069
  803293
  809064
  811037
  813435
  814830
  815170
  815278
  815490
  815885
  815960
]
21.34 ms
(13.72%)
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
  710594
  672777
  695153
  581737
  605484
  784922
  809064
  813435
  727465
  742810
  803069
  724651
  745397
  770642
  811037
  400869
  418035
  479346
  472162
  519838
  527675
  334950
  814830
  815170
  815960
  448745
  481798
  513397
  530734
  522424
  531523
  517143
  696557
  547644
  550076
  585392
  599664
  611562
  588041
  635920
  792910
  802104
  757638
  704533
  799360
  401953
  402247
  447971
  460190
  400195
  425636
  462897
  500832
  504897
  519322
  495088
  520265
  426540
  407015
  815490
  815885
  815278
  467329
  467338
  449879
  460693
  489185
  489938
  515952
  519138
  514337
  544495
  571715
  580744
  665121
  565752
  581341
  610293
  803293
  389264
  437583
  449866
  504739
  524456
  506113
  441626
  535684
  535960
  548848
  672328
  587228
  591413
  615762
  465355
  397369
  457649
  428837
  454923
  516332
  531120
  566708
  598993
  442946
  469072
  512377
  416841
  517049
  571033
  556865
  482350
  444588
  510754
  528538
  569421
  582236
  515122
  518960
  680824
]
2.56 ms
(1.64%)
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
  334950
  389264
  397369
  400195
  400869
  401953
  402247
  407015
  416841
  418035
  425636
  426540
  428837
  437583
  441626
  442946
  444588
  447971
  448745
  449866
  449879
  454923
  457649
  460190
  460693
  462897
  465355
  467329
  467338
  469072
  472162
  479346
  481798
  482350
  489185
  489938
  495088
  500832
  504739
  504897
  506113
  510754
  512377
  513397
  514337
  515122
  515952
  516332
  517049
  517143
  518960
  519138
  519322
  519838
  520265
  522424
  524456
  527675
  528538
  530734
  531120
  531523
  535684
  535960
  544495
  547644
  548848
  550076
  556865
  565752
  566708
  569421
  571033
  571715
  580744
  581341
  581737
  582236
  585392
  587228
  588041
  591413
  598993
  599664
  605484
  610293
  611562
  615762
  635920
  665121
  672328
  672777
  680824
  695153
  696557
  704533
  710594
  724651
  727465
  742810
  745397
  757638
  770642
  784922
  792910
  799360
  802104
  803069
  803293
  809064
  811037
  813435
  814830
  815170
  815278
  815490
  815885
  815960
]
2.12 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "catches"
]
1.76 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "catches"
]
1.60 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "catches"
]
1.59 ms
(1.02%)
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.