Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.24 ms
(83.75%)
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
  72889
  413653
  441289
  441659
  441664
  446674
  457898
  457926
  459560
  464022
  465291
  466365
  468426
  468978
  468991
  473825
  474226
  476893
  480334
  481757
  483683
  484231
  486139
  486827
  487539
  490074
  494552
  496963
  497684
  499759
  504197
  504665
  507833
  511516
  512143
  521404
  521599
  522947
  524102
  525944
  526272
  526684
  526694
  528315
  534428
  547881
  565883
  576560
  576942
  577608
  581104
  584036
  584456
  584955
  585749
  587609
  589678
  591858
  593163
  596796
  597258
  600856
  601728
  602753
  603313
  603836
  604106
  605683
  606549
  609078
  613375
  616510
  616793
  618384
  620566
  625435
  630673
  644490
  645669
  647430
  648618
  652683
  666374
  672261
  683028
  695146
  696593
  698124
  700470
  715089
  718091
  721640
  725720
  727532
  729337
  730315
  738786
  741185
  750072
  756626
  756634
  757277
  759127
  762817
  767236
  776310
  784042
  784655
  787511
  795812
  796339
  797264
  797857
  801119
  803776
  806695
  807835
  808796
  811152
  814272
]
16.13 ms
(10.14%)
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
  465291
  473825
  525944
  604106
  796339
  762817
  483683
  468426
  486139
  494552
  526694
  648618
  672261
  696593
  587609
  803776
  787511
  797857
  808796
  497684
  507833
  565883
  584456
  666374
  645669
  585749
  600856
  603836
  616793
  630673
  591858
  496963
  581104
  620566
  625435
  606549
  756634
  526684
  504665
  521404
  413653
  487539
  464022
  521599
  584955
  721640
  576560
  618384
  589678
  596796
  776310
  725720
  727532
  741185
  759127
  767236
  729337
  750072
  730315
  756626
  784042
  784655
  801119
  446674
  457926
  459560
  474226
  480334
  457898
  524102
  522947
  72889
  602753
  466365
  698124
  441289
  441664
  441659
  814272
  484231
  468978
  499759
  526272
  528315
  468991
  476893
  547881
  715089
  718091
  584036
  613375
  807835
  806695
  757277
  795812
  797264
  811152
  481757
  512143
  511516
  738786
  577608
  700470
  534428
  647430
  683028
  695146
  652683
  593163
  601728
  597258
  603313
  605683
  644490
  616510
  504197
  486827
  490074
  576942
  609078
]
2.96 ms
(1.86%)
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
  72889
  413653
  441289
  441659
  441664
  446674
  457898
  457926
  459560
  464022
  465291
  466365
  468426
  468978
  468991
  473825
  474226
  476893
  480334
  481757
  483683
  484231
  486139
  486827
  487539
  490074
  494552
  496963
  497684
  499759
  504197
  504665
  507833
  511516
  512143
  521404
  521599
  522947
  524102
  525944
  526272
  526684
  526694
  528315
  534428
  547881
  565883
  576560
  576942
  577608
  581104
  584036
  584456
  584955
  585749
  587609
  589678
  591858
  593163
  596796
  597258
  600856
  601728
  602753
  603313
  603836
  604106
  605683
  606549
  609078
  613375
  616510
  616793
  618384
  620566
  625435
  630673
  644490
  645669
  647430
  648618
  652683
  666374
  672261
  683028
  695146
  696593
  698124
  700470
  715089
  718091
  721640
  725720
  727532
  729337
  730315
  738786
  741185
  750072
  756626
  756634
  757277
  759127
  762817
  767236
  776310
  784042
  784655
  787511
  795812
  796339
  797264
  797857
  801119
  803776
  806695
  807835
  808796
  811152
  814272
]
1.86 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "riding hard homemade"
]
1.80 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "riding hard домашн любительск"
]
1.57 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "riding hard домашн любительск"
]

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.