Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
114.56 ms
(82.18%)
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
  54387
  271767
  382199
  382793
  383103
  384126
  385137
  385280
  392760
  392874
  398405
  401546
  402531
  404212
  405242
  406378
  408607
  413139
  417547
  417949
  419427
  420116
  420143
  420520
  421219
  422020
  423326
  424846
  426436
  426561
  427939
  428772
  428932
  429129
  430988
  431016
  434382
  435024
  436621
  438957
  439396
  440724
  441169
  442618
  442962
  442985
  443902
  445694
  447217
  449584
  450041
  451622
  451702
  452177
  452386
  453685
  454634
  455463
  456873
  458296
  459793
  460319
  462541
  465051
  465685
  465700
  469498
  471455
  471599
  471850
  472499
  473065
  475053
  475728
  476836
  481231
  484178
  484966
  485364
  485606
  488916
  491106
  493223
  494373
  495820
  497558
  498308
  499478
  513994
  514096
  515574
  517984
  518067
  520412
  526533
  527195
  528892
  532542
  535949
  547675
  549948
  550664
  551232
  552443
  554817
  566577
  576783
  578370
  590128
  598734
  615899
  631620
  636229
  678787
  696776
  718771
  739556
  750739
  774575
  774706
]
16.20 ms
(11.62%)
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
  494373
  495820
  513994
  518067
  384126
  417547
  422020
  441169
  426561
  439396
  440724
  423326
  413139
  452386
  458296
  469498
  447217
  451702
  452177
  456873
  460319
  465685
  471850
  445694
  449584
  450041
  454634
  459793
  473065
  493223
  498308
  532542
  535949
  475728
  485606
  547675
  554817
  550664
  578370
  551232
  576783
  718771
  696776
  678787
  549948
  552443
  631620
  636229
  598734
  590128
  774706
  750739
  739556
  615899
  774575
  54387
  398405
  420520
  428932
  430988
  443902
  453685
  455463
  392874
  431016
  442618
  442962
  471599
  481231
  401546
  402531
  426436
  427939
  434382
  436621
  442985
  462541
  385280
  404212
  405242
  417949
  420116
  438957
  451622
  465700
  475053
  406378
  408607
  476836
  528892
  485364
  491106
  499478
  514096
  484966
  497558
  515574
  517984
  526533
  484178
  488916
  520412
  435024
  421219
  472499
  566577
  471455
  465051
  527195
  382793
  385137
  383103
  392760
  271767
  382199
  419427
  420143
  424846
  428772
  429129
]
2.46 ms
(1.77%)
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
  54387
  271767
  382199
  382793
  383103
  384126
  385137
  385280
  392760
  392874
  398405
  401546
  402531
  404212
  405242
  406378
  408607
  413139
  417547
  417949
  419427
  420116
  420143
  420520
  421219
  422020
  423326
  424846
  426436
  426561
  427939
  428772
  428932
  429129
  430988
  431016
  434382
  435024
  436621
  438957
  439396
  440724
  441169
  442618
  442962
  442985
  443902
  445694
  447217
  449584
  450041
  451622
  451702
  452177
  452386
  453685
  454634
  455463
  456873
  458296
  459793
  460319
  462541
  465051
  465685
  465700
  469498
  471455
  471599
  471850
  472499
  473065
  475053
  475728
  476836
  481231
  484178
  484966
  485364
  485606
  488916
  491106
  493223
  494373
  495820
  497558
  498308
  499478
  513994
  514096
  515574
  517984
  518067
  520412
  526533
  527195
  528892
  532542
  535949
  547675
  549948
  550664
  551232
  552443
  554817
  566577
  576783
  578370
  590128
  598734
  615899
  631620
  636229
  678787
  696776
  718771
  739556
  750739
  774575
  774706
]
1.66 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красотки голые"
]
1.62 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая голые"
]
1.51 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.38 ms
(0.99%)
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.