Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.44 ms
(82.37%)
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
  282649
  417839
  423444
  424932
  424995
  424996
  425003
  425079
  426336
  428154
  428166
  428783
  432532
  435174
  436627
  439274
  441366
  441442
  443565
  444067
  444099
  444836
  445883
  445967
  446453
  446914
  449120
  450585
  453018
  454929
  455574
  455787
  455869
  455875
  457413
  457687
  457880
  458713
  459628
  459865
  459866
  459872
  464152
  465792
  465873
  466981
  470284
  472147
  472175
  476333
  478705
  480960
  484899
  492136
  496616
  497413
  497805
  499771
  502144
  504735
  504739
  504906
  507685
  507785
  517214
  518231
  518233
  520415
  521241
  521537
  521664
  523578
  524340
  525591
  532826
  534494
  538520
  542021
  551132
  555851
  557027
  562637
  566939
  574049
  575710
  580177
  582297
  584498
  584716
  590076
  590381
  592180
  604155
  604330
  604338
  604368
  604384
  610808
  616807
  648144
  695719
  696128
  703268
  710032
  717966
  737848
  745673
  748981
  750308
  757370
  766734
  771055
  773911
  794307
  794807
  795212
  810382
  813566
  816687
  823819
]
16.24 ms
(10.92%)
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
  745673
  748981
  282649
  757370
  750308
  773911
  710032
  496616
  423444
  524340
  424932
  436627
  737848
  766734
  459872
  813566
  823819
  771055
  703268
  478705
  470284
  432532
  472175
  450585
  810382
  604338
  794807
  525591
  459628
  551132
  459866
  816687
  604384
  604330
  532826
  610808
  604155
  446914
  457413
  794307
  443565
  449120
  555851
  534494
  424996
  582297
  465873
  444067
  428154
  439274
  484899
  696128
  428166
  455787
  465792
  417839
  507685
  444099
  458713
  521241
  648144
  492136
  455574
  717966
  520415
  604368
  435174
  444836
  455869
  695719
  425079
  480960
  446453
  795212
  464152
  428783
  453018
  574049
  504735
  518233
  523578
  584498
  445967
  584716
  455875
  504906
  575710
  424995
  441366
  441442
  459865
  557027
  566939
  499771
  457880
  472147
  580177
  425003
  426336
  518231
  590381
  542021
  616807
  562637
  457687
  504739
  497413
  538520
  454929
  521664
  476333
  502144
  590076
  521537
  466981
  517214
  592180
  507785
  445883
  497805
]
2.93 ms
(1.97%)
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
  282649
  417839
  423444
  424932
  424995
  424996
  425003
  425079
  426336
  428154
  428166
  428783
  432532
  435174
  436627
  439274
  441366
  441442
  443565
  444067
  444099
  444836
  445883
  445967
  446453
  446914
  449120
  450585
  453018
  454929
  455574
  455787
  455869
  455875
  457413
  457687
  457880
  458713
  459628
  459865
  459866
  459872
  464152
  465792
  465873
  466981
  470284
  472147
  472175
  476333
  478705
  480960
  484899
  492136
  496616
  497413
  497805
  499771
  502144
  504735
  504739
  504906
  507685
  507785
  517214
  518231
  518233
  520415
  521241
  521537
  521664
  523578
  524340
  525591
  532826
  534494
  538520
  542021
  551132
  555851
  557027
  562637
  566939
  574049
  575710
  580177
  582297
  584498
  584716
  590076
  590381
  592180
  604155
  604330
  604338
  604368
  604384
  610808
  616807
  648144
  695719
  696128
  703268
  710032
  717966
  737848
  745673
  748981
  750308
  757370
  766734
  771055
  773911
  794307
  794807
  795212
  810382
  813566
  816687
  823819
]
2.04 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sister anal homemade"
]
1.89 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sister анал домашн любительск"
]
1.19 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sister анал домашн любительск"
]

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.