Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.33 ms
(85.41%)
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
  382669
  393558
  412632
  423498
  426911
  427172
  433594
  448078
  448412
  460407
  466297
  466327
  479162
  487982
  491290
  495063
  499066
  500634
  507780
  514662
  517620
  522392
  525576
  527769
  527786
  528199
  529870
  531264
  531574
  532536
  533498
  533539
  542042
  542520
  544783
  547730
  547848
  547852
  549119
  553000
  558958
  573246
  576131
  576360
  578002
  588798
  591503
  603707
  611119
  647003
  695849
  695882
  703687
  713970
  714409
  723019
  727423
  728735
  729058
  733230
  738009
  739871
  740484
  741874
  742875
  746993
  751431
  752502
  758459
  759243
  760696
  761484
  762710
  764485
  769119
  772216
  773045
  773320
  775711
  777355
  778788
  779747
  779884
  782755
  782776
  784394
  784724
  784735
  788093
  791305
  792126
  793104
  793722
  793724
  794945
  795354
  796064
  796199
  796728
  796769
  796968
  798704
  799448
  799477
  802931
  803194
  805334
  806864
  807203
  807868
  811806
  813805
  814269
  814312
  817126
  817145
  817727
  817750
  818522
]
15.91 ms
(9.04%)
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
  814312
  817145
  818522
  460407
  487982
  466327
  499066
  527769
  533498
  578002
  573246
  714409
  695849
  591503
  791305
  792126
  793104
  793722
  803194
  805334
  811806
  782776
  796064
  796728
  798704
  802931
  761484
  764485
  782755
  806864
  764783
  727423
  746993
  728735
  738009
  713970
  784724
  799477
  807868
  423498
  448078
  529870
  531574
  544783
  647003
  576131
  588798
  426911
  507780
  382669
  794945
  576360
  553000
  817750
  813805
  817126
  817727
  814269
  517620
  525576
  527786
  531264
  533539
  532536
  514662
  547848
  695882
  703687
  723019
  547852
  549119
  603707
  775711
  784394
  793724
  779884
  784735
  796199
  796968
  799448
  729058
  733230
  760696
  772216
  788093
  796769
  740484
  741874
  758459
  769119
  773045
  773320
  742875
  752502
  762710
  739871
  751431
  611119
  777355
  778788
  779747
  795354
  807203
  393558
  433594
  466297
  427172
  479162
  528199
  448412
  500634
  759243
  412632
  491290
  495063
  522392
  542520
  547730
  558958
  542042
]
2.93 ms
(1.67%)
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
  382669
  393558
  412632
  423498
  426911
  427172
  433594
  448078
  448412
  460407
  466297
  466327
  479162
  487982
  491290
  495063
  499066
  500634
  507780
  514662
  517620
  522392
  525576
  527769
  527786
  528199
  529870
  531264
  531574
  532536
  533498
  533539
  542042
  542520
  544783
  547730
  547848
  547852
  549119
  553000
  558958
  573246
  576131
  576360
  578002
  588798
  591503
  603707
  611119
  647003
  695849
  695882
  703687
  713970
  714409
  723019
  727423
  728735
  729058
  733230
  738009
  739871
  740484
  741874
  742875
  746993
  751431
  752502
  758459
  759243
  760696
  761484
  762710
  764485
  769119
  772216
  773045
  773320
  775711
  777355
  778788
  779747
  779884
  782755
  782776
  784394
  784724
  784735
  788093
  791305
  792126
  793104
  793722
  793724
  794945
  795354
  796064
  796199
  796728
  796769
  796968
  798704
  799448
  799477
  802931
  803194
  805334
  806864
  807203
  807868
  811806
  813805
  814269
  814312
  817126
  817145
  817727
  817750
  818522
]
1.90 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade bondage"
]
1.67 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск бдсм"
]
1.43 ms
(0.81%)
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.