Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
242.19 ms
(92.18%)
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
  25650
  213598
  279873
  302173
  382743
  383267
  384430
  392107
  397173
  397216
  397225
  415742
  427542
  454210
  484063
  487434
  492431
  528295
  529841
  530107
  531858
  533317
  533532
  534624
  534963
  536515
  543282
  543656
  544013
  544135
  547022
  547041
  547046
  550659
  553439
  554848
  565670
  567553
  567962
  575297
  577266
  577268
  584047
  584048
  592119
  595052
  601611
  614199
  614236
  614360
  615110
  616635
  616675
  618763
  618946
  627343
  628019
  631086
  631865
  634734
  642241
  642292
  649476
  660384
  663971
  664547
  665307
  667231
  667896
  668978
  670204
  683372
  695393
  697227
  700897
  700908
  713457
  716104
  719385
  728983
  729007
  732942
  734255
  736188
  742964
  744150
  750856
  757520
  763139
  770194
  776419
  781934
  781949
  792586
  793624
  795321
  796787
  797337
  800023
  800083
  808499
  809555
  810034
  812284
  820368
  824293
  824415
  825972
  826005
  826011
  826438
  826757
  826995
  827408
  827630
  828714
  828824
]
10.11 ms
(3.85%)
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
  757520
  716104
  454210
  584047
  660384
  667231
  601611
  618763
  792586
  796787
  383267
  382743
  384430
  213598
  392107
  302173
  279873
  25650
  397216
  397173
  397225
  427542
  415742
  820368
  826390
  826757
  826995
  827408
  827630
  824282
  824293
  826438
  824415
  825972
  826005
  826011
  828117
  828824
  828714
  487434
  492431
  529841
  530107
  536515
  533532
  534963
  528295
  531858
  533317
  534624
  484063
  543656
  544135
  565670
  567962
  577268
  543282
  544013
  547022
  550659
  553439
  547041
  567553
  575297
  577266
  665307
  695393
  719385
  649476
  663971
  664547
  668978
  670204
  700908
  667896
  683372
  697227
  700897
  713457
  547046
  554848
  584048
  592119
  595052
  615110
  634734
  614236
  627343
  631865
  616635
  616675
  628019
  642241
  642292
  614199
  614360
  618946
  631086
  776419
  781934
  781949
  808499
  793624
  795321
  800023
  810034
  734255
  742964
  744150
  797337
  800083
  809555
  812284
  729007
  732942
  736188
  750856
  763139
  770194
  728983
]
3.31 ms
(1.26%)
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
  25650
  213598
  279873
  302173
  382743
  383267
  384430
  392107
  397173
  397216
  397225
  415742
  427542
  454210
  484063
  487434
  492431
  528295
  529841
  530107
  531858
  533317
  533532
  534624
  534963
  536515
  543282
  543656
  544013
  544135
  547022
  547041
  547046
  550659
  553439
  554848
  565670
  567553
  567962
  575297
  577266
  577268
  584047
  584048
  592119
  595052
  601611
  614199
  614236
  614360
  615110
  616635
  616675
  618763
  618946
  627343
  628019
  631086
  631865
  634734
  642241
  642292
  649476
  660384
  663971
  664547
  665307
  667231
  667896
  668978
  670204
  683372
  695393
  697227
  700897
  700908
  713457
  716104
  719385
  728983
  729007
  732942
  734255
  736188
  742964
  744150
  750856
  757520
  763139
  770194
  776419
  781934
  781949
  792586
  793624
  795321
  796787
  797337
  800023
  800083
  808499
  809555
  810034
  812284
  820368
  824293
  824415
  825972
  826005
  826011
  826438
  826757
  826995
  827408
  827630
  828714
  828824
]
1.99 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby девушк"
]
1.97 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby girl"
]
1.66 ms
(0.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby девушк"
]

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.