Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.14 ms
(86.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
  33488
  34409
  61369
  88286
  108221
  118316
  238994
  318795
  385508
  387143
  388077
  389709
  399008
  399586
  401477
  405488
  407127
  419696
  425536
  453834
  454842
  459239
  460281
  461763
  476312
  479788
  480745
  486877
  489331
  505012
  511480
  516611
  516619
  516676
  522143
  530784
  532839
  533802
  535896
  536262
  536285
  536550
  536588
  536590
  536653
  540573
  549495
  552919
  565927
  569258
  581816
  588411
  588875
  591427
  595761
  612726
  624283
  626379
  650012
  663937
  665421
  666556
  666779
  667909
  676636
  678533
  679761
  682320
  683533
  691927
  698120
  707626
  711342
  711879
  712317
  723093
  730450
  737736
  738307
  738339
  739125
  741199
  742757
  744906
  745323
  753025
  756528
  762556
  764524
  772807
  774400
  776146
  776785
  781977
  786175
  787799
  793374
  793450
  793455
  793727
  794584
  796756
  797949
  800780
  803386
  805871
  807927
  810576
  811144
  815475
  817750
  818586
  818874
  820472
  823481
  825112
  826532
  827958
]
13.11 ms
(8.01%)
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
  683533
  800780
  676636
  818874
  552919
  399008
  480745
  815475
  588411
  505012
  536285
  489331
  762556
  34409
  818586
  811144
  682320
  827958
  711342
  318795
  61369
  461763
  678533
  665421
  825112
  388077
  787799
  797949
  741199
  535896
  793455
  810576
  774400
  536653
  530784
  595761
  385508
  516619
  516676
  591427
  739125
  536590
  712317
  522143
  723093
  744906
  407127
  745323
  459239
  532839
  817750
  823481
  511480
  549495
  793374
  738307
  753025
  826532
  707626
  650012
  793450
  667909
  401477
  479788
  569258
  581816
  486877
  711879
  389709
  516611
  781977
  663937
  666779
  737736
  405488
  730450
  565927
  399586
  536550
  536588
  667269
  624283
  387143
  691927
  533802
  764524
  756528
  786175
  118316
  776785
  679761
  540573
  238994
  805871
  742757
  454842
  425536
  460281
  612726
  698120
  793727
  108221
  769219
  796756
  738339
  776146
  807927
  88286
  419696
  666556
  626379
  33488
  453834
  476312
  536262
  588875
  772807
  820472
  803386
  794584
]
2.79 ms
(1.70%)
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
  33488
  34409
  61369
  88286
  108221
  118316
  238994
  318795
  385508
  387143
  388077
  389709
  399008
  399586
  401477
  405488
  407127
  419696
  425536
  453834
  454842
  459239
  460281
  461763
  476312
  479788
  480745
  486877
  489331
  505012
  511480
  516611
  516619
  516676
  522143
  530784
  532839
  533802
  535896
  536262
  536285
  536550
  536588
  536590
  536653
  540573
  549495
  552919
  565927
  569258
  581816
  588411
  588875
  591427
  595761
  612726
  624283
  626379
  650012
  663937
  665421
  666556
  666779
  667909
  676636
  678533
  679761
  682320
  683533
  691927
  698120
  707626
  711342
  711879
  712317
  723093
  730450
  737736
  738307
  738339
  739125
  741199
  742757
  744906
  745323
  753025
  756528
  762556
  764524
  772807
  774400
  776146
  776785
  781977
  786175
  787799
  793374
  793450
  793455
  793727
  794584
  796756
  797949
  800780
  803386
  805871
  807927
  810576
  811144
  815475
  817750
  818586
  818874
  820472
  823481
  825112
  826532
  827958
]
1.85 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge tits blowjob"
]
1.84 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные сиськ минет оральн секс"
]
1.56 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные сиськ минет оральн секс"
]
1.48 ms
(0.90%)
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.