Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.47 ms
(86.14%)
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
  415287
  433066
  447931
  452862
  469311
  470400
  493214
  499964
  506066
  509575
  510064
  512711
  518763
  526089
  526794
  533331
  533335
  536444
  536473
  543135
  549718
  552687
  555334
  563271
  563791
  566337
  567619
  568908
  576992
  584095
  591917
  593676
  603847
  604196
  612060
  613286
  616852
  618755
  621186
  627362
  636147
  636224
  659052
  668580
  671889
  680440
  699291
  699409
  707314
  709382
  710589
  714868
  718613
  725252
  725592
  726960
  726994
  727731
  727774
  728992
  729678
  730148
  733465
  736113
  736547
  737185
  738322
  740115
  740879
  742827
  742866
  744061
  748003
  750902
  751524
  756551
  756986
  757276
  758766
  759697
  759958
  759960
  760249
  760973
  761119
  761531
  761599
  761716
  763547
  766668
  768783
  770499
  770522
  775202
  775761
  776204
  777220
  777499
  783376
  788856
  790887
  791366
  791846
  794599
  794858
  795136
  795632
  795894
  796203
  796343
  796344
  797396
  798725
  798734
  800712
  800891
  801672
  802053
  805455
  810274
]
14.68 ms
(7.93%)
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
  621186
  536473
  543135
  709382
  591917
  618755
  725592
  733465
  751524
  759697
  710589
  775761
  555334
  469311
  499964
  526794
  576992
  738322
  707314
  568908
  699409
  563791
  604196
  725252
  744061
  533331
  584095
  699291
  718613
  636147
  796344
  750902
  736113
  748003
  470400
  512711
  659052
  549718
  777220
  777499
  798725
  798734
  810274
  757276
  761531
  761599
  791366
  794858
  796343
  797396
  756986
  760249
  766668
  726994
  727731
  759960
  727774
  761716
  770522
  603847
  616852
  783376
  790887
  791846
  800891
  533335
  567619
  668580
  563271
  636224
  794599
  795894
  801672
  768783
  805455
  728992
  736547
  742827
  742866
  730148
  536444
  415287
  775202
  758766
  770499
  788856
  795136
  802053
  756551
  800712
  761119
  566337
  433066
  493214
  680440
  613286
  729678
  447931
  714868
  796203
  518763
  506066
  510064
  526089
  552687
  627362
  740115
  759958
  763547
  760973
  726960
  452862
  509575
  671889
  593676
  612060
  776204
  795632
  740879
  737185
]
3.54 ms
(1.91%)
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
  415287
  433066
  447931
  452862
  469311
  470400
  493214
  499964
  506066
  509575
  510064
  512711
  518763
  526089
  526794
  533331
  533335
  536444
  536473
  543135
  549718
  552687
  555334
  563271
  563791
  566337
  567619
  568908
  576992
  584095
  591917
  593676
  603847
  604196
  612060
  613286
  616852
  618755
  621186
  627362
  636147
  636224
  659052
  668580
  671889
  680440
  699291
  699409
  707314
  709382
  710589
  714868
  718613
  725252
  725592
  726960
  726994
  727731
  727774
  728992
  729678
  730148
  733465
  736113
  736547
  737185
  738322
  740115
  740879
  742827
  742866
  744061
  748003
  750902
  751524
  756551
  756986
  757276
  758766
  759697
  759958
  759960
  760249
  760973
  761119
  761531
  761599
  761716
  763547
  766668
  768783
  770499
  770522
  775202
  775761
  776204
  777220
  777499
  783376
  788856
  790887
  791366
  791846
  794599
  794858
  795136
  795632
  795894
  796203
  796343
  796344
  797396
  798725
  798734
  800712
  800891
  801672
  802053
  805455
  810274
]
2.15 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.01 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончает внутрь мамы"
]
1.64 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "кремпа сперм мам женщин"
]
1.64 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.