Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.92 ms
(58.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "year old девушк"
]
125.72 ms
(34.76%)
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
  4429
  387652
  391677
  396339
  399874
  400263
  418347
  418654
  422027
  425656
  429188
  429221
  429226
  429237
  429244
  429357
  445909
  455917
  456627
  458609
  461625
  468116
  475541
  489144
  490698
  495171
  495599
  509600
  510100
  523735
  525495
  525658
  529056
  529090
  537472
  545167
  547731
  550408
  556562
  557445
  560408
  560510
  560971
  560984
  564139
  564619
  564802
  569443
  570762
  571765
  571777
  572261
  574198
  577719
  577831
  577865
  583274
  586689
  586918
  590478
  591393
  593964
  594115
  594784
  597276
  603468
  607335
  610504
  614820
  614843
  622565
  625134
  628824
  628828
  631470
  634221
  643396
  647762
  648670
  651885
  654048
  657547
  673229
  673877
  686210
  689442
  708655
  713494
  715575
  722330
  723373
  725098
  725141
  731768
  732775
  740597
  741958
  743455
  745804
  748416
  749294
  752605
  754205
  755854
  758540
  758560
  765094
  771948
  772053
  777646
  785369
  788672
  788720
  789028
  793575
  800583
  804436
  807464
  810728
  812844
]
17.88 ms
(4.94%)
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
  647762
  648670
  590478
  614820
  586918
  628824
  771948
  772053
  713494
  785369
  807464
  445909
  574198
  673229
  686210
  607335
  625134
  594784
  614843
  622565
  628828
  788672
  800583
  804436
  812844
  793575
  810728
  741958
  749294
  725098
  475541
  418347
  570762
  643396
  560408
  396339
  564619
  571765
  571777
  654048
  657547
  545167
  586689
  748416
  418654
  569443
  557445
  560971
  564802
  577831
  651885
  723373
  789028
  731768
  755854
  758560
  732775
  743455
  754205
  740597
  708655
  429188
  455917
  429226
  429237
  529090
  495599
  4429
  425656
  429244
  429221
  429357
  458609
  489144
  523735
  525658
  509600
  537472
  547731
  560510
  577719
  550408
  564139
  572261
  722330
  689442
  560984
  593964
  594115
  597276
  610504
  634221
  591393
  777646
  788720
  725141
  758540
  765094
  745804
  752605
  603468
  631470
  715575
  387652
  400263
  461625
  391677
  468116
  490698
  495171
  510100
  399874
  456627
  422027
  525495
  529056
  583274
  556562
  577865
  673877
]
2.77 ms
(0.77%)
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
  4429
  387652
  391677
  396339
  399874
  400263
  418347
  418654
  422027
  425656
  429188
  429221
  429226
  429237
  429244
  429357
  445909
  455917
  456627
  458609
  461625
  468116
  475541
  489144
  490698
  495171
  495599
  509600
  510100
  523735
  525495
  525658
  529056
  529090
  537472
  545167
  547731
  550408
  556562
  557445
  560408
  560510
  560971
  560984
  564139
  564619
  564802
  569443
  570762
  571765
  571777
  572261
  574198
  577719
  577831
  577865
  583274
  586689
  586918
  590478
  591393
  593964
  594115
  594784
  597276
  603468
  607335
  610504
  614820
  614843
  622565
  625134
  628824
  628828
  631470
  634221
  643396
  647762
  648670
  651885
  654048
  657547
  673229
  673877
  686210
  689442
  708655
  713494
  715575
  722330
  723373
  725098
  725141
  731768
  732775
  740597
  741958
  743455
  745804
  748416
  749294
  752605
  754205
  755854
  758540
  758560
  765094
  771948
  772053
  777646
  785369
  788672
  788720
  789028
  793575
  800583
  804436
  807464
  810728
  812844
]
1.90 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "year old girl"
]
1.79 ms
(0.49%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "year 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.