Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.64 ms
(83.11%)
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
  11013
  88031
  123029
  316575
  324183
  341691
  382330
  382579
  387281
  387993
  390185
  394597
  398486
  398760
  398984
  399061
  400421
  400672
  400945
  401677
  407290
  411025
  414021
  416713
  421264
  445326
  452623
  453228
  466563
  468790
  469221
  487270
  493715
  497830
  497894
  498449
  517288
  529922
  530605
  530809
  532741
  536580
  536597
  537750
  539030
  546160
  546803
  548439
  550804
  556331
  556476
  556874
  559910
  576439
  576564
  580109
  580620
  597275
  621824
  629725
  630769
  633444
  634161
  636628
  647330
  656826
  657697
  666858
  670460
  678067
  679574
  680179
  680801
  693502
  694556
  696278
  704167
  705028
  707166
  708069
  719765
  722378
  722380
  725628
  726292
  735152
  738817
  740699
  745139
  751437
  752752
  752755
  761114
  770860
  783755
  788567
  789883
  791703
  792395
  794096
  794312
  796849
  796853
  799579
  800283
  800317
  800538
  809664
  810234
  811968
  819858
  820032
  821501
  822910
  824567
  827944
  827949
  827964
  827981
]
14.54 ms
(9.86%)
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
  800538
  726292
  466563
  382330
  400421
  580620
  123029
  387993
  390185
  398486
  821501
  822910
  824567
  468790
  530809
  529922
  517288
  580109
  548439
  670460
  705028
  694556
  550804
  629725
  800317
  740699
  796853
  761114
  708069
  800283
  819858
  827981
  827964
  827944
  679574
  789883
  794312
  791703
  811968
  809664
  810234
  735152
  621824
  382579
  316575
  398984
  794096
  416713
  752755
  487270
  11013
  421264
  556331
  401677
  88031
  399061
  537750
  536597
  576564
  657697
  757736
  796849
  678067
  820032
  799579
  387281
  559910
  719765
  634161
  597275
  407290
  452623
  696278
  324183
  532741
  633444
  536580
  469221
  722380
  398760
  400672
  493715
  539030
  497894
  498449
  530605
  576439
  556874
  666858
  707166
  722378
  656826
  680801
  546160
  630769
  636628
  751437
  752752
  770860
  725628
  745139
  704167
  341691
  827949
  792395
  783755
  394597
  445326
  453228
  546803
  556476
  647330
  693502
  680179
  788567
  738817
  414021
  400945
  411025
  497830
]
3.20 ms
(2.17%)
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
  11013
  88031
  123029
  316575
  324183
  341691
  382330
  382579
  387281
  387993
  390185
  394597
  398486
  398760
  398984
  399061
  400421
  400672
  400945
  401677
  407290
  411025
  414021
  416713
  421264
  445326
  452623
  453228
  466563
  468790
  469221
  487270
  493715
  497830
  497894
  498449
  517288
  529922
  530605
  530809
  532741
  536580
  536597
  537750
  539030
  546160
  546803
  548439
  550804
  556331
  556476
  556874
  559910
  576439
  576564
  580109
  580620
  597275
  621824
  629725
  630769
  633444
  634161
  636628
  647330
  656826
  657697
  666858
  670460
  678067
  679574
  680179
  680801
  693502
  694556
  696278
  704167
  705028
  707166
  708069
  719765
  722378
  722380
  725628
  726292
  735152
  738817
  740699
  745139
  751437
  752752
  752755
  761114
  770860
  783755
  788567
  789883
  791703
  792395
  794096
  794312
  796849
  796853
  799579
  800283
  800317
  800538
  809664
  810234
  811968
  819858
  820032
  821501
  822910
  824567
  827944
  827949
  827964
  827981
]
2.21 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex teens hardcore"
]
1.70 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс teens хардкор"
]
1.67 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс teens хардкор"
]

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.