Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.87 ms
(84.42%)
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
  382724
  388722
  395874
  396865
  398550
  398769
  401219
  401903
  404030
  406062
  406063
  407760
  407810
  409027
  409408
  409945
  411621
  411721
  411967
  413454
  413455
  413458
  413460
  413461
  413464
  418954
  419565
  420151
  431762
  443703
  446249
  452445
  453113
  454253
  462712
  474863
  474870
  476240
  479765
  483146
  491281
  494222
  496341
  496547
  506855
  513034
  519152
  521447
  525493
  527253
  534245
  559292
  559332
  578215
  583664
  601342
  610016
  610179
  618393
  663877
  663901
  665141
  665227
  665229
  665302
  665849
  667193
  667209
  667261
  667264
  667319
  667474
  667484
  667684
  667899
  668628
  670489
  678766
  678778
  678779
  678790
  678804
  699023
  699056
  701444
  719903
  726591
  730097
  731193
  732361
  733254
  739557
  744987
  744990
  758293
  766597
  770111
  770114
  771340
  772459
  773901
  780605
  780609
  780649
  780665
  780670
  781760
  781968
  785436
  788229
  788978
  789556
  792097
  794641
  817694
  824900
  825038
  825141
  826888
  828373
]
13.47 ms
(9.33%)
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
  771340
  780609
  817694
  665141
  663901
  789556
  667684
  825141
  826888
  758293
  667319
  731193
  825038
  794641
  663877
  701444
  780665
  828373
  780605
  781968
  559292
  618393
  494222
  665229
  667209
  773901
  519152
  730097
  785436
  733254
  781760
  409945
  398769
  667474
  395874
  396865
  411621
  824900
  667484
  398550
  744987
  780670
  453113
  413454
  413455
  744990
  770114
  406063
  446249
  462712
  665302
  678766
  792097
  780649
  411721
  665849
  382724
  388722
  479765
  401903
  667264
  409408
  766597
  788229
  732361
  670489
  667193
  699056
  407760
  496547
  525493
  788978
  770111
  610016
  443703
  401219
  496341
  474863
  534245
  667899
  583664
  665227
  407810
  521447
  476240
  601342
  418954
  491281
  413458
  419565
  483146
  726591
  413464
  513034
  404030
  411967
  719903
  772459
  668628
  678778
  678790
  610179
  699023
  559332
  527253
  409027
  413461
  578215
  420151
  454253
  406062
  474870
  506855
  678804
  678779
  667261
  739557
  413460
  431762
  452445
]
2.45 ms
(1.69%)
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
  382724
  388722
  395874
  396865
  398550
  398769
  401219
  401903
  404030
  406062
  406063
  407760
  407810
  409027
  409408
  409945
  411621
  411721
  411967
  413454
  413455
  413458
  413460
  413461
  413464
  418954
  419565
  420151
  431762
  443703
  446249
  452445
  453113
  454253
  462712
  474863
  474870
  476240
  479765
  483146
  491281
  494222
  496341
  496547
  506855
  513034
  519152
  521447
  525493
  527253
  534245
  559292
  559332
  578215
  583664
  601342
  610016
  610179
  618393
  663877
  663901
  665141
  665227
  665229
  665302
  665849
  667193
  667209
  667261
  667264
  667319
  667474
  667484
  667684
  667899
  668628
  670489
  678766
  678778
  678779
  678790
  678804
  699023
  699056
  701444
  719903
  726591
  730097
  731193
  732361
  733254
  739557
  744987
  744990
  758293
  766597
  770111
  770114
  771340
  772459
  773901
  780605
  780609
  780649
  780665
  780670
  781760
  781968
  785436
  788229
  788978
  789556
  792097
  794641
  817694
  824900
  825038
  825141
  826888
  828373
]
1.86 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "grandma old sex"
]
1.75 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "grandma old секс"
]
1.34 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "grandma old секс"
]

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.