Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.19 ms
(84.06%)
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
  22843
  51569
  55903
  101853
  116852
  154123
  173963
  186823
  197609
  256371
  266977
  280656
  310581
  311798
  311884
  323899
  333706
  350614
  381863
  386467
  387806
  389266
  390940
  391217
  397666
  397704
  399541
  401413
  402649
  408623
  408627
  420636
  428289
  429895
  431002
  431154
  448081
  451536
  456358
  457543
  457567
  469468
  471069
  471102
  472498
  473962
  487234
  493820
  496845
  513623
  529083
  529772
  534477
  535661
  537997
  540224
  540284
  540287
  548161
  548898
  551464
  552378
  555497
  556194
  558317
  560895
  561778
  561784
  571099
  578563
  579667
  580743
  594306
  595890
  610926
  617564
  644205
  645418
  645681
  649738
  656909
  664457
  665331
  687341
  692913
  698459
  701235
  708329
  710440
  711194
  711712
  716125
  736359
  736831
  743094
  743276
  751323
  751331
  758525
  763401
  764795
  765079
  766167
  767908
  782343
  782957
  784216
  790192
  790230
  791336
  801813
  803189
  805389
  805699
  809958
  810745
  810949
  811023
  812187
  814171
]
12.18 ms
(8.52%)
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
  493820
  578563
  457543
  431002
  428289
  431154
  256371
  311798
  311884
  266977
  310581
  387806
  448081
  487234
  540224
  540284
  496845
  472498
  548898
  645418
  656909
  665331
  687341
  561778
  571099
  594306
  617564
  805389
  736831
  743094
  758525
  767908
  763401
  751323
  751331
  610926
  698459
  782343
  782957
  791336
  323899
  397666
  401413
  154123
  397704
  408627
  471102
  402649
  429895
  551464
  451536
  471069
  469468
  381863
  420636
  513623
  197609
  186823
  173963
  280656
  22843
  51569
  55903
  390940
  391217
  399541
  408623
  814171
  456358
  457567
  473962
  529083
  534477
  535661
  540287
  529772
  537997
  555497
  558317
  560895
  579667
  552378
  561784
  645681
  716125
  649738
  692913
  711194
  664457
  710440
  711712
  548161
  556194
  580743
  595890
  644205
  801813
  803189
  810949
  811023
  812187
  790192
  784216
  790230
  805699
  809958
  736359
  764795
  743276
  765079
  766167
  701235
  708329
  810745
  101853
  116852
  333706
  386467
  389266
  350614
]
2.98 ms
(2.08%)
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
  22843
  51569
  55903
  101853
  116852
  154123
  173963
  186823
  197609
  256371
  266977
  280656
  310581
  311798
  311884
  323899
  333706
  350614
  381863
  386467
  387806
  389266
  390940
  391217
  397666
  397704
  399541
  401413
  402649
  408623
  408627
  420636
  428289
  429895
  431002
  431154
  448081
  451536
  456358
  457543
  457567
  469468
  471069
  471102
  472498
  473962
  487234
  493820
  496845
  513623
  529083
  529772
  534477
  535661
  537997
  540224
  540284
  540287
  548161
  548898
  551464
  552378
  555497
  556194
  558317
  560895
  561778
  561784
  571099
  578563
  579667
  580743
  594306
  595890
  610926
  617564
  644205
  645418
  645681
  649738
  656909
  664457
  665331
  687341
  692913
  698459
  701235
  708329
  710440
  711194
  711712
  716125
  736359
  736831
  743094
  743276
  751323
  751331
  758525
  763401
  764795
  765079
  766167
  767908
  782343
  782957
  784216
  790192
  790230
  791336
  801813
  803189
  805389
  805699
  809958
  810745
  810949
  811023
  812187
  814171
]
2.17 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "соло ласкает себя"
]
2.02 ms
(1.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "соло ласка"
]
1.73 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "соло ласка"
]
1.70 ms
(1.19%)
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.