Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.18 ms
(84.31%)
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
  20190
  117221
  130089
  130506
  318318
  320078
  381883
  383387
  388091
  389315
  390538
  393314
  397192
  397232
  398666
  401325
  403966
  414058
  420471
  467606
  470273
  476111
  485147
  488721
  495218
  510180
  517840
  541853
  544848
  564392
  597018
  601544
  603172
  604331
  604566
  613179
  615900
  617421
  622656
  629409
  629886
  630536
  630764
  632632
  632650
  632674
  632706
  633447
  640858
  641413
  644995
  645891
  648819
  649543
  656904
  666579
  668527
  671739
  673353
  673363
  673366
  673369
  674492
  684126
  690809
  692796
  695188
  695620
  695930
  696355
  699691
  705514
  707262
  709261
  711891
  714613
  719335
  723468
  724179
  738821
  742015
  742194
  748951
  756023
  756092
  759326
  759485
  760240
  762257
  762268
  772667
  775140
  775787
  775798
  775810
  775858
  784308
  788930
  791370
  792059
  794817
  794824
  795139
  801934
  802610
  805594
  806268
  809493
  816568
  817080
  817898
  818468
  818516
  818517
  818541
  819272
  821532
  824052
  824130
  827201
]
14.00 ms
(9.00%)
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
  397232
  738821
  495218
  630764
  817080
  632650
  775810
  541853
  617421
  705514
  824052
  403966
  818516
  818468
  695188
  695620
  709261
  604566
  762268
  759485
  401325
  564392
  719335
  806268
  724179
  476111
  467606
  20190
  818541
  673366
  788930
  613179
  117221
  630536
  632632
  320078
  690809
  615900
  802610
  632706
  485147
  668527
  470273
  707262
  389315
  388091
  517840
  673369
  674492
  629409
  597018
  775798
  742015
  772667
  648819
  632674
  601544
  792059
  759326
  381883
  723468
  622656
  390538
  784308
  756092
  756023
  420471
  656904
  629886
  775858
  791370
  393314
  824130
  827201
  696355
  649543
  684126
  809493
  775140
  801934
  794824
  130089
  318318
  510180
  641413
  794817
  383387
  748951
  414058
  819272
  544848
  645891
  633447
  488721
  130506
  821532
  671739
  604331
  397192
  398666
  817898
  818517
  695930
  699691
  714613
  666579
  673363
  692796
  805594
  760240
  742194
  644995
  816568
  673353
  711891
  603172
  640858
  775787
  795139
  762257
]
3.06 ms
(1.97%)
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
  20190
  117221
  130089
  130506
  318318
  320078
  381883
  383387
  388091
  389315
  390538
  393314
  397192
  397232
  398666
  401325
  403966
  414058
  420471
  467606
  470273
  476111
  485147
  488721
  495218
  510180
  517840
  541853
  544848
  564392
  597018
  601544
  603172
  604331
  604566
  613179
  615900
  617421
  622656
  629409
  629886
  630536
  630764
  632632
  632650
  632674
  632706
  633447
  640858
  641413
  644995
  645891
  648819
  649543
  656904
  666579
  668527
  671739
  673353
  673363
  673366
  673369
  674492
  684126
  690809
  692796
  695188
  695620
  695930
  696355
  699691
  705514
  707262
  709261
  711891
  714613
  719335
  723468
  724179
  738821
  742015
  742194
  748951
  756023
  756092
  759326
  759485
  760240
  762257
  762268
  772667
  775140
  775787
  775798
  775810
  775858
  784308
  788930
  791370
  792059
  794817
  794824
  795139
  801934
  802610
  805594
  806268
  809493
  816568
  817080
  817898
  818468
  818516
  818517
  818541
  819272
  821532
  824052
  824130
  827201
]
2.26 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big anal gangbang"
]
1.99 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие анал gangbang"
]
1.47 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие анал gangbang"
]

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.