Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.42 ms
(84.73%)
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
  89409
  106185
  397534
  401590
  418254
  429544
  430209
  444127
  445575
  449291
  451454
  454970
  456961
  482619
  486294
  489863
  507416
  532344
  543110
  547910
  552869
  558619
  559384
  559902
  561414
  565837
  570991
  580705
  581393
  587061
  594411
  606035
  607285
  608606
  613874
  616795
  618916
  623107
  623322
  623884
  627057
  627758
  628463
  643040
  644160
  645207
  649608
  650145
  653551
  659339
  663838
  672355
  672396
  672466
  675173
  675906
  676344
  676345
  676924
  677880
  678579
  679055
  680204
  680590
  693234
  694557
  695236
  703095
  703318
  704180
  708156
  714455
  721188
  722836
  722876
  722903
  723609
  723964
  725165
  736267
  742039
  742194
  746852
  747259
  750546
  750628
  760942
  764184
  767040
  769839
  770348
  770979
  774966
  779120
  779914
  783840
  786031
  786924
  788000
  788299
  796958
  800451
  800531
  802105
  802851
  804053
  804092
  805797
  807709
  808091
  812151
  813172
  815075
  816026
  817922
  818582
  822003
  822057
  823018
  827152
]
14.02 ms
(9.18%)
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
  827152
  823018
  454970
  486294
  558619
  559902
  570991
  653551
  676345
  649608
  672355
  675906
  679055
  552869
  644160
  587061
  623322
  607285
  623107
  788299
  796958
  800451
  808091
  723964
  750546
  770979
  736267
  767040
  760942
  747259
  764184
  742039
  770348
  703095
  779914
  804053
  813172
  401590
  106185
  418254
  714455
  430209
  723609
  722903
  746852
  444127
  680590
  676924
  618916
  812151
  429544
  815075
  818582
  482619
  445575
  456961
  581393
  559384
  565837
  678579
  721188
  672466
  680204
  547910
  580705
  616795
  643040
  807709
  800531
  802105
  802851
  804092
  769839
  725165
  742194
  722836
  774966
  449291
  451454
  489863
  507416
  89409
  397534
  817922
  816026
  822003
  822057
  532344
  543110
  561414
  650145
  672396
  675173
  695236
  645207
  663838
  677880
  693234
  704180
  722876
  659339
  676344
  694557
  703318
  708156
  606035
  608606
  627057
  627758
  594411
  613874
  623884
  628463
  788000
  805797
  779120
  786031
  750628
  783840
  786924
]
2.89 ms
(1.89%)
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
  89409
  106185
  397534
  401590
  418254
  429544
  430209
  444127
  445575
  449291
  451454
  454970
  456961
  482619
  486294
  489863
  507416
  532344
  543110
  547910
  552869
  558619
  559384
  559902
  561414
  565837
  570991
  580705
  581393
  587061
  594411
  606035
  607285
  608606
  613874
  616795
  618916
  623107
  623322
  623884
  627057
  627758
  628463
  643040
  644160
  645207
  649608
  650145
  653551
  659339
  663838
  672355
  672396
  672466
  675173
  675906
  676344
  676345
  676924
  677880
  678579
  679055
  680204
  680590
  693234
  694557
  695236
  703095
  703318
  704180
  708156
  714455
  721188
  722836
  722876
  722903
  723609
  723964
  725165
  736267
  742039
  742194
  746852
  747259
  750546
  750628
  760942
  764184
  767040
  769839
  770348
  770979
  774966
  779120
  779914
  783840
  786031
  786924
  788000
  788299
  796958
  800451
  800531
  802105
  802851
  804053
  804092
  805797
  807709
  808091
  812151
  813172
  815075
  816026
  817922
  818582
  822003
  822057
  823018
  827152
]
1.84 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teens girls facesitting"
]
1.69 ms
(1.11%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.55 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teens девушк фейсситтинг"
]
1.34 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teens девушк фейсситтинг"
]

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.