Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.11 ms
(87.79%)
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
  26026
  155175
  396389
  398229
  398999
  401769
  403984
  413124
  419201
  419616
  419650
  419969
  421783
  425288
  425843
  428116
  439425
  444233
  444236
  445665
  447002
  448031
  448896
  450671
  452356
  453028
  453386
  453443
  454015
  454384
  455065
  456938
  457639
  458446
  459634
  460281
  462813
  464687
  467986
  469342
  479707
  492460
  496020
  530600
  532397
  534731
  537341
  538147
  548454
  553130
  561346
  565124
  567672
  576468
  584336
  586175
  592700
  604837
  605492
  607683
  612243
  615020
  616652
  623425
  634326
  639436
  641267
  642076
  642851
  643455
  653047
  654945
  662894
  668705
  669957
  680484
  693848
  695477
  697543
  712334
  714211
  715600
  715816
  716534
  716754
  716773
  725713
  732625
  735895
  735911
  744374
  745323
  745979
  749871
  750873
  761257
  768258
  769354
  769533
  771761
  778383
  778815
  779383
  779973
  781102
  783327
  789848
  791405
  796595
  796612
  799382
  799528
  808379
  809744
  811919
  813749
  821761
  824340
  825560
  826989
]
17.05 ms
(7.83%)
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
  778383
  778815
  811919
  769354
  789848
  799528
  808379
  735911
  745979
  769533
  725713
  732625
  735895
  768258
  715600
  779383
  781102
  403984
  419616
  425843
  450671
  530600
  428116
  460281
  680484
  453028
  492460
  464687
  447002
  454384
  479707
  534731
  654945
  669957
  641267
  604837
  639436
  642851
  643455
  586175
  634326
  615020
  444236
  26026
  398229
  398999
  413124
  813749
  821761
  825560
  445665
  455065
  459634
  452356
  453443
  453386
  454015
  538147
  532397
  565124
  567672
  592700
  616652
  642076
  607683
  779973
  799382
  809744
  796612
  783327
  796595
  761257
  745323
  771761
  744374
  749871
  716754
  456938
  425288
  457639
  715816
  419969
  401769
  537341
  576468
  668705
  612243
  750873
  623425
  791405
  396389
  467986
  448896
  439425
  448031
  561346
  584336
  605492
  155175
  419201
  421783
  444233
  419650
  826989
  824340
  458446
  496020
  462813
  469342
  548454
  653047
  712334
  714211
  662894
  693848
  695477
  697543
  716534
  716773
  553130
]
2.30 ms
(1.06%)
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
  26026
  155175
  396389
  398229
  398999
  401769
  403984
  413124
  419201
  419616
  419650
  419969
  421783
  425288
  425843
  428116
  439425
  444233
  444236
  445665
  447002
  448031
  448896
  450671
  452356
  453028
  453386
  453443
  454015
  454384
  455065
  456938
  457639
  458446
  459634
  460281
  462813
  464687
  467986
  469342
  479707
  492460
  496020
  530600
  532397
  534731
  537341
  538147
  548454
  553130
  561346
  565124
  567672
  576468
  584336
  586175
  592700
  604837
  605492
  607683
  612243
  615020
  616652
  623425
  634326
  639436
  641267
  642076
  642851
  643455
  653047
  654945
  662894
  668705
  669957
  680484
  693848
  695477
  697543
  712334
  714211
  715600
  715816
  716534
  716754
  716773
  725713
  732625
  735895
  735911
  744374
  745323
  745979
  749871
  750873
  761257
  768258
  769354
  769533
  771761
  778383
  778815
  779383
  779973
  781102
  783327
  789848
  791405
  796595
  796612
  799382
  799528
  808379
  809744
  811919
  813749
  821761
  824340
  825560
  826989
]
2.10 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge boobs homemade"
]
1.96 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные boobs домашн любительск"
]
1.58 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные boobs домашн любительск"
]

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.