Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
227.19 ms
(49.09%)
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
  34830
  384193
  384813
  388122
  388254
  396052
  396891
  402217
  402219
  402536
  412238
  416320
  422343
  422524
  425839
  426886
  441229
  447180
  447411
  451551
  452380
  472449
  475602
  480315
  487214
  496571
  502439
  503825
  503907
  505042
  506216
  510048
  510127
  510639
  510806
  513719
  513865
  522044
  536662
  543249
  548766
  549866
  552784
  554795
  561647
  574477
  587761
  592736
  593106
  593171
  599045
  599729
  602575
  604307
  607314
  619310
  619652
  622546
  624857
  626734
  648519
  659218
  659428
  660475
  663098
  670076
  670342
  675499
  675839
  676528
  676976
  676982
  677028
  678010
  682882
  684554
  696970
  697130
  701504
  708802
  716414
  716563
  716583
  716659
  718656
  722258
  722274
  722478
  722812
  722843
  727639
  732145
  739423
  741434
  744291
  747407
  747640
  748668
  750025
  753782
  756808
  759543
  760252
  773609
  775825
  778623
  781802
  790560
  792180
  794547
  797091
  797915
  802252
  807527
  810271
  818023
  819860
  820617
  821433
  821854
]
212.93 ms
(46.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cutie blowjob"
]
13.82 ms
(2.99%)
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
  592736
  797091
  744291
  756808
  447180
  821433
  818023
  447411
  554795
  676528
  701504
  781802
  802252
  748668
  708802
  790560
  820617
  663098
  425839
  682882
  536662
  587761
  549866
  510806
  676982
  505042
  396052
  660475
  659428
  718656
  388122
  384813
  697130
  716583
  722274
  622546
  604307
  747640
  753782
  759543
  747407
  513865
  819860
  659218
  593171
  626734
  794547
  648519
  510127
  722843
  422524
  548766
  593106
  792180
  451551
  503825
  510639
  716414
  716563
  670076
  675839
  678010
  696970
  619310
  624857
  810271
  732145
  760252
  741434
  422343
  396891
  475602
  502439
  722478
  402536
  684554
  388254
  506216
  775825
  821854
  543249
  722258
  807527
  416320
  487214
  552784
  561647
  750025
  402219
  402217
  480315
  510048
  503907
  496571
  677028
  739423
  778623
  34830
  472449
  670342
  607314
  727639
  716659
  384193
  452380
  441229
  412238
  722812
  797915
  574477
  599045
  602575
  513719
  522044
  676976
  619652
  426886
  675499
  599729
  773609
]
3.02 ms
(0.65%)
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
  34830
  384193
  384813
  388122
  388254
  396052
  396891
  402217
  402219
  402536
  412238
  416320
  422343
  422524
  425839
  426886
  441229
  447180
  447411
  451551
  452380
  472449
  475602
  480315
  487214
  496571
  502439
  503825
  503907
  505042
  506216
  510048
  510127
  510639
  510806
  513719
  513865
  522044
  536662
  543249
  548766
  549866
  552784
  554795
  561647
  574477
  587761
  592736
  593106
  593171
  599045
  599729
  602575
  604307
  607314
  619310
  619652
  622546
  624857
  626734
  648519
  659218
  659428
  660475
  663098
  670076
  670342
  675499
  675839
  676528
  676976
  676982
  677028
  678010
  682882
  684554
  696970
  697130
  701504
  708802
  716414
  716563
  716583
  716659
  718656
  722258
  722274
  722478
  722812
  722843
  727639
  732145
  739423
  741434
  744291
  747407
  747640
  748668
  750025
  753782
  756808
  759543
  760252
  773609
  775825
  778623
  781802
  790560
  792180
  794547
  797091
  797915
  802252
  807527
  810271
  818023
  819860
  820617
  821433
  821854
]
2.15 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cutie минет оральн секс"
]
1.73 ms
(0.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cutie минет оральн секс"
]

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.