Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.05 ms
(54.34%)
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
  222010
  386732
  388393
  397660
  426099
  433406
  436899
  493423
  504524
  512032
  518431
  530245
  533398
  540099
  541301
  541722
  543534
  545688
  553932
  557580
  560181
  564098
  571257
  575382
  578171
  578546
  578906
  583347
  583775
  585167
  585235
  585520
  585586
  585909
  586197
  595035
  602034
  603839
  605380
  607030
  621674
  628053
  628626
  629774
  631871
  639229
  640034
  665012
  666628
  674136
  676673
  679689
  683698
  684468
  691584
  697668
  705220
  713174
  713892
  724785
  729322
  737286
  746708
  756518
  757831
  761959
  764371
  766388
  766513
  767695
  768155
  768708
  769137
  769464
  771413
  771725
  776361
  777633
  777691
  778272
  778518
  778927
  779903
  782381
  782782
  784283
  787687
  790848
  791047
  791509
  791811
  792082
  794541
  794611
  794931
  795094
  795902
  797477
  800806
  802048
  802622
  802788
  803870
  808433
  809877
  810324
  813518
  817181
  819548
  819737
  820839
  821555
  821644
  822062
  823506
  823757
  824890
  825348
  825512
  827970
]
149.19 ms
(39.16%)
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
  222010
  386732
  388393
  397660
  426099
  433406
  436899
  493423
  504524
  512032
  518431
  530245
  533398
  540099
  541301
  541722
  543534
  545688
  553932
  557580
  560181
  564098
  571257
  575382
  578171
  578546
  578906
  583347
  583775
  585167
  585235
  585520
  585586
  585909
  586197
  595035
  602034
  603839
  605380
  607030
  621674
  628053
  628626
  629774
  631871
  639229
  640034
  665012
  666628
  674136
  676673
  679689
  683698
  684468
  691584
  697668
  705220
  713174
  713892
  724785
  729322
  737286
  746708
  756518
  757831
  761959
  764371
  766388
  766513
  767695
  768155
  768708
  769137
  769464
  771413
  771725
  776361
  777633
  777691
  778272
  778518
  778927
  779903
  782381
  782782
  784283
  787687
  790848
  791047
  791509
  791811
  792082
  794541
  794611
  794931
  795094
  795902
  797477
  800806
  802048
  802622
  802788
  803870
  808433
  809877
  810324
  813518
  817181
  819548
  819737
  820839
  821555
  821644
  822062
  823506
  823757
  824890
  825348
  825512
  827970
]
17.71 ms
(4.65%)
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
  639229
  705220
  776361
  784283
  794611
  802048
  802788
  809877
  386732
  397660
  436899
  679689
  388393
  518431
  583347
  713174
  585235
  504524
  512032
  665012
  557580
  585586
  595035
  585167
  605380
  607030
  631871
  792082
  757831
  571257
  222010
  560181
  583775
  433406
  426099
  820839
  824890
  817181
  819737
  821644
  823757
  825348
  819548
  821555
  822062
  823506
  825512
  827970
  493423
  530245
  540099
  533398
  578171
  578546
  541301
  543534
  553932
  541722
  564098
  575382
  684468
  674136
  683698
  666628
  676673
  691584
  697668
  713892
  545688
  578906
  621674
  640034
  585520
  585909
  603839
  586197
  629774
  778518
  778927
  782381
  791811
  794931
  800806
  777633
  777691
  778272
  782782
  791047
  795094
  803870
  813518
  729322
  764371
  767695
  769137
  771413
  787687
  790848
  791509
  794541
  795902
  797477
  802622
  808433
  810324
  761959
  766388
  766513
  769464
  724785
  737286
  746708
  771725
  756518
  768708
  768155
  602034
  628053
  628626
  779903
]
1.86 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женск пов"
]
1.81 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женское пов"
]
1.72 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.