Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
224.58 ms
(90.20%)
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
  381952
  389994
  390139
  390257
  390947
  391597
  391667
  391767
  391983
  392021
  392025
  401374
  411402
  421828
  422201
  424114
  426821
  427001
  429953
  432545
  433640
  434242
  437369
  443135
  444132
  445288
  447716
  450285
  451525
  455118
  455128
  455202
  457359
  458190
  460408
  460425
  462522
  462580
  465133
  466899
  472392
  475097
  476494
  477933
  477937
  478382
  479604
  480851
  485383
  485971
  489172
  489225
  490383
  491124
  492967
  492991
  494594
  495520
  495573
  495814
  496019
  498158
  507081
  509044
  509651
  514015
  514028
  517696
  522334
  525695
  533679
  543689
  548010
  558178
  558324
  565302
  565303
  576208
  576915
  586199
  590539
  623385
  630112
  642237
  642249
  685509
  728489
  730936
  731018
  733232
  741710
  741751
  742056
  742386
  742407
  742412
  743719
  744101
  746118
  749617
  749620
  751513
  758206
  766288
  768896
  778492
  778521
  789748
  792607
  794878
  796563
  796836
  797351
  800736
  800742
  803433
  807837
  819401
  824528
  824735
]
14.50 ms
(5.82%)
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
  744101
  746118
  749617
  749620
  766288
  768896
  630112
  778521
  789748
  792607
  794878
  796836
  797351
  800736
  800742
  803433
  392025
  429953
  457359
  458190
  476494
  433640
  466899
  390947
  391983
  392021
  477937
  390257
  455118
  450285
  472392
  509651
  489172
  507081
  495814
  728489
  485971
  525695
  514028
  558178
  445288
  391667
  443135
  533679
  543689
  741710
  742386
  623385
  460425
  391767
  492991
  565302
  444132
  558324
  778492
  437369
  489225
  475097
  496019
  495520
  548010
  391597
  432545
  479604
  421828
  427001
  460408
  401374
  411402
  422201
  462522
  477933
  389994
  426821
  434242
  455202
  491124
  492967
  494594
  498158
  390139
  462580
  796563
  733232
  742056
  522334
  565303
  642237
  741751
  807837
  730936
  742412
  742407
  642249
  381952
  819401
  824528
  824735
  455128
  485383
  576208
  743719
  758206
  478382
  480851
  451525
  509044
  514015
  495573
  590539
  424114
  685509
  576915
  586199
  731018
  751513
  447716
  465133
  517696
  490383
]
2.57 ms
(1.03%)
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
  381952
  389994
  390139
  390257
  390947
  391597
  391667
  391767
  391983
  392021
  392025
  401374
  411402
  421828
  422201
  424114
  426821
  427001
  429953
  432545
  433640
  434242
  437369
  443135
  444132
  445288
  447716
  450285
  451525
  455118
  455128
  455202
  457359
  458190
  460408
  460425
  462522
  462580
  465133
  466899
  472392
  475097
  476494
  477933
  477937
  478382
  479604
  480851
  485383
  485971
  489172
  489225
  490383
  491124
  492967
  492991
  494594
  495520
  495573
  495814
  496019
  498158
  507081
  509044
  509651
  514015
  514028
  517696
  522334
  525695
  533679
  543689
  548010
  558178
  558324
  565302
  565303
  576208
  576915
  586199
  590539
  623385
  630112
  642237
  642249
  685509
  728489
  730936
  731018
  733232
  741710
  741751
  742056
  742386
  742407
  742412
  743719
  744101
  746118
  749617
  749620
  751513
  758206
  766288
  768896
  778492
  778521
  789748
  792607
  794878
  796563
  796836
  797351
  800736
  800742
  803433
  807837
  819401
  824528
  824735
]
2.13 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian chubby wife"
]
1.61 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск chubby жен"
]
1.58 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск chubby жен"
]

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.