Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.20 ms
(85.03%)
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
  401531
  410272
  413223
  415077
  419220
  426259
  456736
  472659
  491399
  530465
  533060
  540262
  547472
  555004
  555121
  561445
  565341
  585726
  591615
  592428
  592805
  597898
  600444
  604306
  604905
  605320
  606283
  612188
  632008
  632289
  634528
  642659
  645365
  650312
  651685
  661657
  663254
  671725
  672184
  675276
  676127
  690144
  691561
  692813
  695103
  707308
  709240
  709594
  710236
  711628
  715524
  716784
  717072
  718041
  720243
  721910
  724194
  726602
  732804
  740473
  747533
  754208
  756237
  758213
  758910
  759867
  759873
  760616
  760841
  761555
  765227
  769894
  775956
  782562
  783145
  786197
  787289
  788131
  788178
  788585
  788847
  789953
  789961
  790958
  795141
  797728
  798999
  800296
  800426
  801909
  802316
  802514
  804014
  806201
  811474
  811490
  811510
  811989
  812926
  815151
  815168
  815180
  815890
  815905
  815910
  815939
  816063
  816886
  816970
  816991
  817299
  817318
  818438
  820840
  820888
  821238
  821521
  821551
  822421
  823466
]
16.39 ms
(9.16%)
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
  675276
  561445
  597898
  798999
  801909
  413223
  540262
  533060
  555121
  663254
  720243
  604905
  632008
  775956
  782562
  811490
  724194
  758910
  754208
  758213
  632289
  709240
  787289
  419220
  604306
  585726
  812926
  788178
  820840
  547472
  645365
  650312
  651685
  691561
  695103
  709594
  721910
  671725
  672184
  676127
  710236
  690144
  711628
  716784
  717072
  555004
  592805
  600444
  605320
  606283
  786197
  800296
  802316
  788585
  788847
  806201
  732804
  756237
  789953
  797728
  804014
  811510
  759867
  759873
  726602
  747533
  761555
  765227
  740473
  760616
  634528
  707308
  718041
  783145
  789961
  815180
  815890
  816063
  816991
  816886
  821238
  822421
  815910
  821521
  530465
  692813
  715524
  592428
  795141
  811989
  760841
  802514
  811474
  410272
  816970
  817318
  820888
  815905
  815939
  815151
  815168
  817299
  818438
  821551
  823466
  661657
  591615
  612188
  642659
  790958
  788131
  800426
  769894
  401531
  426259
  415077
  491399
  456736
  472659
  565341
]
3.12 ms
(1.74%)
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
  401531
  410272
  413223
  415077
  419220
  426259
  456736
  472659
  491399
  530465
  533060
  540262
  547472
  555004
  555121
  561445
  565341
  585726
  591615
  592428
  592805
  597898
  600444
  604306
  604905
  605320
  606283
  612188
  632008
  632289
  634528
  642659
  645365
  650312
  651685
  661657
  663254
  671725
  672184
  675276
  676127
  690144
  691561
  692813
  695103
  707308
  709240
  709594
  710236
  711628
  715524
  716784
  717072
  718041
  720243
  721910
  724194
  726602
  732804
  740473
  747533
  754208
  756237
  758213
  758910
  759867
  759873
  760616
  760841
  761555
  765227
  769894
  775956
  782562
  783145
  786197
  787289
  788131
  788178
  788585
  788847
  789953
  789961
  790958
  795141
  797728
  798999
  800296
  800426
  801909
  802316
  802514
  804014
  806201
  811474
  811490
  811510
  811989
  812926
  815151
  815168
  815180
  815890
  815905
  815910
  815939
  816063
  816886
  816970
  816991
  817299
  817318
  818438
  820840
  820888
  821238
  821521
  821551
  822421
  823466
]
2.10 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "милфы в попу"
]
1.98 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "милф анал"
]
1.72 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.83%)
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.