Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.75 ms
(88.97%)
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
  33804
  47989
  91578
  230986
  271234
  391681
  397435
  414720
  475311
  478410
  490966
  495517
  521724
  529575
  549430
  554499
  582709
  590240
  591220
  593647
  642614
  668818
  676434
  696220
  696605
  697673
  701275
  701468
  714560
  715782
  716609
  718861
  720804
  722113
  734515
  736113
  736256
  737002
  739253
  741880
  743824
  744429
  745357
  747077
  747541
  754851
  756268
  758134
  759194
  761094
  761456
  763525
  763655
  763905
  763972
  765987
  769697
  771363
  773380
  773721
  777459
  777486
  778087
  779497
  780394
  781034
  781137
  781284
  781563
  783862
  787222
  787237
  787622
  787840
  788733
  790332
  790350
  790354
  791903
  793754
  794473
  795189
  795193
  795806
  795844
  796357
  796566
  797225
  798301
  799690
  800250
  801179
  808026
  808251
  810626
  816110
  818966
  818986
  819326
  819699
  819798
  820734
  821796
  823448
  823783
  824099
  824113
  824716
  825107
  825200
  825244
  825280
  825356
  826536
  826654
  826831
  826986
  827119
  828672
]
11.76 ms
(6.17%)
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
  701468
  642614
  821796
  825200
  826831
  827119
  783862
  790354
  741880
  771363
  773380
  763525
  47989
  33804
  790332
  761094
  495517
  414720
  391681
  788733
  696220
  758134
  819699
  816110
  828672
  529575
  715782
  718861
  781137
  778087
  737002
  763972
  781563
  745357
  736113
  714560
  716609
  787222
  800250
  824716
  824099
  818986
  825356
  795193
  797225
  736256
  271234
  826536
  825107
  826986
  824113
  819326
  790350
  769697
  795189
  820734
  823448
  810626
  697673
  765987
  744429
  796566
  676434
  582709
  780394
  793754
  230986
  825280
  825244
  799690
  796357
  801179
  739253
  763905
  787622
  795806
  798301
  747541
  754851
  761456
  763655
  763712
  781284
  787237
  787840
  791903
  747077
  826654
  521724
  549430
  696605
  668818
  701275
  593647
  591220
  590240
  777459
  777486
  779497
  743824
  773721
  756268
  759194
  808251
  818966
  795844
  808026
  722113
  794473
  475311
  91578
  490966
  478410
  819798
  781034
  720804
  734515
  554499
  397435
  823783
]
2.52 ms
(1.32%)
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
  33804
  47989
  91578
  230986
  271234
  391681
  397435
  414720
  475311
  478410
  490966
  495517
  521724
  529575
  549430
  554499
  582709
  590240
  591220
  593647
  642614
  668818
  676434
  696220
  696605
  697673
  701275
  701468
  714560
  715782
  716609
  718861
  720804
  722113
  734515
  736113
  736256
  737002
  739253
  741880
  743824
  744429
  745357
  747077
  747541
  754851
  756268
  758134
  759194
  761094
  761456
  763525
  763655
  763905
  763972
  765987
  769697
  771363
  773380
  773721
  777459
  777486
  778087
  779497
  780394
  781034
  781137
  781284
  781563
  783862
  787222
  787237
  787622
  787840
  788733
  790332
  790350
  790354
  791903
  793754
  794473
  795189
  795193
  795806
  795844
  796357
  796566
  797225
  798301
  799690
  800250
  801179
  808026
  808251
  810626
  816110
  818966
  818986
  819326
  819699
  819798
  820734
  821796
  823448
  823783
  824099
  824113
  824716
  825107
  825200
  825244
  825280
  825356
  826536
  826654
  826831
  826986
  827119
  828672
]
1.93 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск минет оральн секс"
]
1.65 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск минет оральн секс"
]
1.63 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.