Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
144.41 ms
(85.83%)
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
  392165
  397193
  397474
  429470
  439373
  443010
  448164
  456315
  472599
  481252
  486084
  489642
  495528
  495838
  498530
  499541
  500144
  500585
  502369
  503717
  509080
  510645
  510729
  512953
  514609
  515826
  516023
  517946
  518668
  521639
  523540
  524531
  527946
  528591
  529685
  530319
  530667
  533620
  537819
  539281
  540897
  541986
  542000
  544456
  545018
  545646
  549417
  560713
  562765
  562923
  566477
  567198
  570375
  579952
  582008
  582068
  583857
  585244
  590848
  598184
  627672
  640791
  645453
  648246
  648983
  651760
  652119
  653550
  657394
  657946
  658305
  658424
  658703
  659091
  659641
  659647
  660326
  663695
  664768
  668372
  668417
  668584
  670162
  670171
  670701
  671099
  673156
  674606
  684406
  695591
  704905
  706965
  718908
  719981
  722350
  817905
  818110
  818668
  820128
  820655
  821824
  824335
  824426
  824907
  825738
  825923
  825930
  826076
  826411
  826422
  826423
  827165
  827587
  827989
  828378
  828727
]
14.34 ms
(8.52%)
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
  456315
  481252
  429470
  439373
  448164
  509080
  510729
  518668
  521639
  537819
  498530
  499541
  503717
  517946
  527946
  486084
  489642
  495838
  510645
  512953
  514609
  515826
  528591
  495528
  500144
  500585
  502369
  530667
  516023
  523540
  562765
  582068
  567198
  598184
  443010
  524531
  392165
  397193
  397474
  820655
  825930
  826170
  818110
  824398
  826076
  826411
  826423
  827165
  818668
  821824
  822574
  825738
  826422
  817905
  820128
  824335
  824426
  824907
  825923
  827989
  828378
  828391
  827587
  828727
  529685
  530319
  533620
  539281
  472599
  541986
  545646
  560713
  583857
  540897
  542000
  544456
  566477
  545018
  549417
  562923
  579952
  645453
  648246
  659641
  663695
  664768
  668417
  670171
  670701
  674606
  706965
  718908
  651760
  657394
  658305
  658424
  659091
  659647
  668372
  671099
  695591
  704905
  719981
  722350
  648983
  652119
  653550
  657946
  658703
  660326
  668584
  670162
  673156
  684406
  570375
  582008
  585244
  627672
  640791
  590848
]
3.16 ms
(1.88%)
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
  392165
  397193
  397474
  429470
  439373
  443010
  448164
  456315
  472599
  481252
  486084
  489642
  495528
  495838
  498530
  499541
  500144
  500585
  502369
  503717
  509080
  510645
  510729
  512953
  514609
  515826
  516023
  517946
  518668
  521639
  523540
  524531
  527946
  528591
  529685
  530319
  530667
  533620
  537819
  539281
  540897
  541986
  542000
  544456
  545018
  545646
  549417
  560713
  562765
  562923
  566477
  567198
  570375
  579952
  582008
  582068
  583857
  585244
  590848
  598184
  627672
  640791
  645453
  648246
  648983
  651760
  652119
  653550
  657394
  657946
  658305
  658424
  658703
  659091
  659641
  659647
  660326
  663695
  664768
  668372
  668417
  668584
  670162
  670171
  670701
  671099
  673156
  674606
  684406
  695591
  704905
  706965
  718908
  719981
  722350
  817905
  818110
  818668
  820128
  820655
  821824
  824335
  824426
  824907
  825738
  825923
  825930
  826076
  826411
  826422
  826423
  827165
  827587
  827989
  828378
  828727
]
1.75 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "раком худых"
]
1.66 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак худые"
]
1.41 ms
(0.84%)
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.