Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.39 ms
(53.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
164.24 ms
(41.92%)
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
  3638
  75735
  338039
  398872
  431608
  444882
  481755
  483101
  491353
  507557
  508603
  508696
  509163
  511443
  512354
  514938
  527159
  535515
  535545
  537112
  541543
  544540
  544550
  547529
  555477
  556363
  559311
  560332
  562819
  563684
  569580
  571206
  577446
  579558
  581209
  583279
  583859
  589686
  591186
  591766
  591818
  591883
  592507
  593848
  595378
  597105
  603513
  606322
  611493
  612119
  615166
  616475
  616676
  617112
  617159
  619045
  620406
  623024
  623479
  627348
  628650
  629620
  632089
  635002
  635027
  635391
  644037
  651150
  651767
  653120
  661630
  662572
  666890
  666996
  671910
  679909
  682105
  689123
  697188
  702294
  714926
  718741
  718967
  720655
  723966
  724749
  724893
  725241
  725481
  730115
  732752
  735281
  736004
  738339
  738349
  738731
  742075
  742821
  748487
  749640
  771685
  775318
  778600
  779981
  782361
  785737
  787412
  787934
  794716
  795324
  795826
  796076
  796191
  799731
  803311
  803862
  808448
  808828
  814421
]
10.55 ms
(2.69%)
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
  556363
  795826
  736004
  742821
  796076
  803862
  511443
  615166
  632089
  635027
  651150
  666996
  702294
  718741
  718967
  775318
  778600
  779981
  787934
  738339
  738349
  730115
  771685
  3638
  559311
  616475
  444882
  507557
  689123
  795324
  748487
  583279
  537112
  338039
  628650
  732752
  735281
  749640
  527159
  651767
  544550
  555477
  589686
  720655
  662572
  808828
  738731
  723966
  603513
  569580
  616676
  591883
  583859
  623024
  547529
  597105
  563684
  619045
  509163
  571206
  606322
  592507
  724749
  635002
  398872
  508603
  535545
  617112
  724893
  725481
  512354
  593848
  623479
  508696
  544540
  562819
  431608
  814421
  483101
  666890
  629620
  611493
  785737
  796191
  803311
  725241
  742075
  799731
  808448
  760972
  697188
  541543
  591766
  591818
  560332
  627348
  644037
  75735
  535515
  577446
  653120
  620406
  635391
  787412
  794716
  661630
  782361
  714926
  591186
  491353
  481755
  671910
  581209
  595378
  682105
  579558
  612119
  617159
  514938
  679909
]
2.66 ms
(0.68%)
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
  3638
  75735
  338039
  398872
  431608
  444882
  481755
  483101
  491353
  507557
  508603
  508696
  509163
  511443
  512354
  514938
  527159
  535515
  535545
  537112
  541543
  544540
  544550
  547529
  555477
  556363
  559311
  560332
  562819
  563684
  569580
  571206
  577446
  579558
  581209
  583279
  583859
  589686
  591186
  591766
  591818
  591883
  592507
  593848
  595378
  597105
  603513
  606322
  611493
  612119
  615166
  616475
  616676
  617112
  617159
  619045
  620406
  623024
  623479
  627348
  628650
  629620
  632089
  635002
  635027
  635391
  644037
  651150
  651767
  653120
  661630
  662572
  666890
  666996
  671910
  679909
  682105
  689123
  697188
  702294
  714926
  718741
  718967
  720655
  723966
  724749
  724893
  725241
  725481
  730115
  732752
  735281
  736004
  738339
  738349
  738731
  742075
  742821
  748487
  749640
  771685
  775318
  778600
  779981
  782361
  785737
  787412
  787934
  794716
  795324
  795826
  796076
  796191
  799731
  803311
  803862
  808448
  808828
  814421
]
1.80 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм в вагин"
]
1.79 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончи в киску"
]
1.39 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм в вагин"
]

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.