Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
184.96 ms
(88.62%)
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
  395381
  396074
  396083
  400026
  400592
  428574
  471476
  486213
  489881
  493616
  518907
  519551
  519772
  520764
  521253
  522190
  530481
  532038
  538505
  539275
  539276
  541394
  541584
  541734
  544186
  544204
  547380
  547400
  549051
  556346
  567122
  568524
  568893
  571357
  575889
  576225
  582303
  584260
  584915
  588898
  592323
  594267
  595447
  603847
  604215
  605850
  608818
  610121
  617031
  617592
  623429
  636238
  643593
  655281
  657177
  661455
  662194
  666434
  676797
  680358
  680374
  682633
  683303
  685449
  685460
  685492
  686414
  691170
  692943
  696536
  709192
  715584
  715654
  715808
  717923
  720328
  724713
  730038
  731213
  734973
  735112
  736558
  736830
  740675
  746555
  748701
  752709
  752735
  756822
  761430
  764813
  765593
  766845
  767090
  767326
  768041
  769070
  777151
  777652
  781585
  783194
  785579
  787952
  788580
  789871
  790069
  791681
  793982
  800303
  800523
  801246
  804327
  804871
  809314
  810125
  814523
  818753
  823818
  827601
]
14.20 ms
(6.80%)
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
  539276
  584260
  662194
  655281
  636238
  785579
  804871
  734973
  748701
  752735
  764813
  765593
  767090
  777151
  777652
  396083
  657177
  769070
  400026
  539275
  538505
  809314
  766845
  549051
  761430
  736558
  680374
  691170
  489881
  520764
  518907
  541584
  692943
  676797
  685460
  594267
  608818
  680358
  395381
  604215
  532038
  686414
  486213
  736830
  575889
  544204
  682633
  685492
  683303
  643593
  709192
  519551
  696536
  595447
  617031
  471476
  588898
  541734
  791973
  823818
  827601
  521253
  568893
  571357
  720328
  781585
  793982
  756822
  717923
  428574
  547380
  715654
  661455
  685449
  791681
  801246
  740675
  783194
  810125
  768041
  752709
  715808
  789871
  804327
  568524
  623429
  814523
  530481
  800523
  396074
  818753
  556346
  731213
  541394
  610121
  788580
  519772
  493616
  724713
  584915
  522190
  544186
  576225
  582303
  547400
  715584
  666434
  567122
  605850
  617592
  592323
  787952
  790069
  767326
  735112
  730038
  746555
  603847
  800303
  400592
]
2.69 ms
(1.29%)
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
  395381
  396074
  396083
  400026
  400592
  428574
  471476
  486213
  489881
  493616
  518907
  519551
  519772
  520764
  521253
  522190
  530481
  532038
  538505
  539275
  539276
  541394
  541584
  541734
  544186
  544204
  547380
  547400
  549051
  556346
  567122
  568524
  568893
  571357
  575889
  576225
  582303
  584260
  584915
  588898
  592323
  594267
  595447
  603847
  604215
  605850
  608818
  610121
  617031
  617592
  623429
  636238
  643593
  655281
  657177
  661455
  662194
  666434
  676797
  680358
  680374
  682633
  683303
  685449
  685460
  685492
  686414
  691170
  692943
  696536
  709192
  715584
  715654
  715808
  717923
  720328
  724713
  730038
  731213
  734973
  735112
  736558
  736830
  740675
  746555
  748701
  752709
  752735
  756822
  761430
  764813
  765593
  766845
  767090
  767326
  768041
  769070
  777151
  777652
  781585
  783194
  785579
  787952
  788580
  789871
  790069
  791681
  793982
  800303
  800523
  801246
  804327
  804871
  809314
  810125
  814523
  818753
  823818
  827601
]
1.86 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск худые анал"
]
1.84 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade skinny anal"
]
1.67 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск худые анал"
]
1.50 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.