Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
126.27 ms
(83.61%)
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
  107606
  388766
  397115
  398909
  400948
  401223
  401226
  403900
  404313
  407681
  409105
  409109
  409258
  413908
  414946
  416407
  421887
  424096
  428472
  428826
  431691
  432837
  438219
  445424
  446022
  446311
  448954
  449760
  450797
  450803
  450811
  451086
  460179
  464404
  464407
  469167
  477335
  479019
  481068
  481794
  484768
  489971
  492096
  499333
  507834
  509503
  512895
  513116
  515031
  516209
  516886
  516966
  517278
  519238
  519931
  520021
  522168
  522645
  523323
  524867
  524874
  524896
  525469
  529170
  529305
  531523
  531528
  531935
  532114
  535318
  536347
  542908
  543774
  554899
  565623
  571494
  573749
  573990
  591155
  591258
  602194
  610343
  611330
  616049
  619775
  621235
  628653
  703144
  713065
  713262
  716927
  731464
  736770
  748212
  756714
  788160
  789525
  799028
  799050
  801323
  802578
  803246
  804612
  805945
  806093
  809791
  813913
  814583
  816177
  816929
  817089
  817332
  817523
  817724
  818469
  818609
  820117
  825763
  825862
  826663
]
15.25 ms
(10.10%)
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
  788160
  799028
  799050
  802578
  803246
  804612
  806093
  809791
  407681
  107606
  481068
  519238
  535318
  477335
  448954
  524896
  519931
  400948
  409109
  826663
  813913
  481794
  446311
  450811
  536347
  499333
  531523
  531528
  524867
  524874
  532114
  531935
  542908
  565623
  543774
  573749
  554899
  573990
  716927
  703144
  713065
  571494
  591258
  602194
  611330
  616049
  619775
  621235
  591155
  610343
  628653
  801323
  805945
  789525
  731464
  748212
  736770
  756714
  713262
  403900
  438219
  446022
  464407
  469167
  388766
  404313
  409105
  416407
  450797
  460179
  398909
  401223
  413908
  421887
  424096
  428826
  431691
  432837
  450803
  451086
  479019
  401226
  409258
  428472
  445424
  464404
  414946
  449760
  509503
  507834
  516966
  520021
  529170
  484768
  489971
  512895
  516886
  517278
  522645
  523323
  529305
  492096
  513116
  515031
  516209
  522168
  525469
  397115
  816177
  816929
  817089
  817523
  817724
  818469
  818609
  825763
  825862
  814583
  817332
  820117
]
2.79 ms
(1.84%)
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
  107606
  388766
  397115
  398909
  400948
  401223
  401226
  403900
  404313
  407681
  409105
  409109
  409258
  413908
  414946
  416407
  421887
  424096
  428472
  428826
  431691
  432837
  438219
  445424
  446022
  446311
  448954
  449760
  450797
  450803
  450811
  451086
  460179
  464404
  464407
  469167
  477335
  479019
  481068
  481794
  484768
  489971
  492096
  499333
  507834
  509503
  512895
  513116
  515031
  516209
  516886
  516966
  517278
  519238
  519931
  520021
  522168
  522645
  523323
  524867
  524874
  524896
  525469
  529170
  529305
  531523
  531528
  531935
  532114
  535318
  536347
  542908
  543774
  554899
  565623
  571494
  573749
  573990
  591155
  591258
  602194
  610343
  611330
  616049
  619775
  621235
  628653
  703144
  713065
  713262
  716927
  731464
  736770
  748212
  756714
  788160
  789525
  799028
  799050
  801323
  802578
  803246
  804612
  805945
  806093
  809791
  813913
  814583
  816177
  816929
  817089
  817332
  817523
  817724
  818469
  818609
  820117
  825763
  825862
  826663
]
1.97 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf but mom"
]
1.70 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf mom"
]
1.41 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf 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.