Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.60 ms
(85.76%)
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
  25053
  85792
  182526
  325910
  348234
  388254
  388716
  398492
  400947
  401368
  431516
  491626
  509501
  518473
  519273
  522345
  530256
  530377
  531137
  533363
  533594
  533717
  534020
  534269
  534544
  538925
  539533
  540511
  541774
  545605
  547477
  548474
  550852
  551057
  552597
  553272
  557158
  557210
  567396
  580159
  586294
  588265
  596292
  600257
  621066
  625694
  628380
  630869
  634134
  634208
  634818
  639334
  640917
  644309
  644952
  644995
  649151
  650316
  651082
  651306
  652831
  652885
  660299
  665197
  665973
  666732
  666868
  668144
  669046
  670773
  673719
  677088
  680195
  681045
  681053
  683183
  689305
  692453
  693628
  694447
  695249
  698537
  698597
  699751
  703062
  705519
  705520
  706936
  708144
  711997
  718983
  719057
  719335
  720236
  723660
  738824
  748529
  750081
  760240
  769584
  787379
  797908
  799582
  814893
  815557
  815723
  815927
  816015
  816211
  816222
  816317
  816568
  817173
  817446
  818309
  820765
  820768
  821877
  824423
  825221
]
12.67 ms
(7.90%)
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
  388254
  815557
  815927
  820765
  824423
  519273
  539533
  538925
  534544
  530256
  533717
  551057
  711997
  677088
  681053
  698597
  705520
  720236
  665197
  673719
  694447
  719057
  644309
  621066
  797908
  799582
  760240
  769584
  748529
  738824
  750081
  703062
  706936
  718983
  787379
  182526
  348234
  530377
  518473
  540511
  533363
  541774
  545605
  553272
  680195
  650316
  666868
  634134
  634818
  639334
  628380
  630869
  588265
  600257
  634208
  522345
  85792
  325910
  25053
  388716
  398492
  401368
  400947
  431516
  815723
  817446
  644952
  644995
  723660
  818309
  821877
  814893
  816015
  816317
  816568
  825221
  816211
  816222
  817173
  820768
  509501
  534020
  531137
  533594
  534269
  491626
  548474
  567396
  580159
  552597
  547477
  550852
  557158
  651082
  668144
  669046
  670773
  681045
  692453
  699751
  649151
  652831
  665973
  683183
  689305
  705519
  651306
  652885
  660299
  666732
  693628
  695249
  698537
  708144
  719335
  557210
  586294
  596292
  625694
  640917
]
3.10 ms
(1.93%)
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
  25053
  85792
  182526
  325910
  348234
  388254
  388716
  398492
  400947
  401368
  431516
  491626
  509501
  518473
  519273
  522345
  530256
  530377
  531137
  533363
  533594
  533717
  534020
  534269
  534544
  538925
  539533
  540511
  541774
  545605
  547477
  548474
  550852
  551057
  552597
  553272
  557158
  557210
  567396
  580159
  586294
  588265
  596292
  600257
  621066
  625694
  628380
  630869
  634134
  634208
  634818
  639334
  640917
  644309
  644952
  644995
  649151
  650316
  651082
  651306
  652831
  652885
  660299
  665197
  665973
  666732
  666868
  668144
  669046
  670773
  673719
  677088
  680195
  681045
  681053
  683183
  689305
  692453
  693628
  694447
  695249
  698537
  698597
  699751
  703062
  705519
  705520
  706936
  708144
  711997
  718983
  719057
  719335
  720236
  723660
  738824
  748529
  750081
  760240
  769584
  787379
  797908
  799582
  814893
  815557
  815723
  815927
  816015
  816211
  816222
  816317
  816568
  817173
  817446
  818309
  820765
  820768
  821877
  824423
  825221
]
1.99 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "двойное брюнетки"
]
1.84 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "двойн черноволосая"
]
1.54 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.