Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.01 ms
(87.20%)
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
  193462
  207970
  397689
  398643
  460245
  483792
  512841
  529691
  539949
  541043
  550968
  552180
  552713
  558590
  559334
  561052
  563268
  574020
  577034
  577610
  583453
  586377
  586657
  591975
  598943
  607365
  611260
  616846
  617368
  617889
  622303
  626398
  627332
  631298
  632793
  642144
  644600
  647530
  653066
  654911
  657234
  665076
  667998
  668814
  669858
  676555
  677366
  684583
  689871
  700947
  704629
  705769
  705784
  716125
  719987
  720541
  721149
  724780
  728916
  729038
  729262
  736334
  739288
  741503
  742903
  743860
  744159
  744171
  746197
  746199
  746293
  747482
  747510
  748499
  748593
  749641
  751319
  751943
  756975
  757126
  761728
  764836
  767519
  773334
  773351
  774872
  775590
  775624
  775658
  780028
  780323
  781515
  782109
  782749
  782936
  783029
  783186
  783370
  785366
  785651
  785653
  786366
  790463
  792253
  792668
  794639
  794765
  795070
  798769
  799423
  800041
  801818
  810904
  812106
  812695
  813331
  816152
  817028
  827394
  827578
]
12.69 ms
(6.55%)
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
  563268
  577610
  583453
  653066
  654911
  667998
  700947
  705784
  716125
  647530
  705769
  719987
  720541
  586377
  617889
  626398
  644600
  591975
  632793
  627332
  774872
  775658
  782749
  785653
  792253
  801818
  783186
  794639
  736334
  741503
  744171
  746199
  746293
  748499
  751943
  757126
  782109
  782936
  783370
  792668
  794765
  729038
  739288
  744159
  747510
  773334
  724780
  728916
  729262
  742903
  747482
  748593
  773351
  751319
  761728
  767519
  743860
  756975
  775590
  775624
  780028
  780323
  795070
  798769
  812695
  398643
  207970
  193462
  397689
  827578
  827394
  816152
  817028
  483792
  460245
  529691
  539949
  512841
  552180
  558590
  559334
  541043
  550968
  552713
  561052
  574020
  657234
  665076
  721149
  669858
  684583
  704629
  668814
  676555
  677366
  689871
  577034
  607365
  611260
  616846
  617368
  622303
  586657
  598943
  642144
  631298
  785366
  786366
  799423
  813331
  783029
  785651
  790463
  800041
  810904
  812106
  746197
  749641
  764836
  781515
]
3.57 ms
(1.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс orgasm"
]
3.14 ms
(1.62%)
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
  193462
  207970
  397689
  398643
  460245
  483792
  512841
  529691
  539949
  541043
  550968
  552180
  552713
  558590
  559334
  561052
  563268
  574020
  577034
  577610
  583453
  586377
  586657
  591975
  598943
  607365
  611260
  616846
  617368
  617889
  622303
  626398
  627332
  631298
  632793
  642144
  644600
  647530
  653066
  654911
  657234
  665076
  667998
  668814
  669858
  676555
  677366
  684583
  689871
  700947
  704629
  705769
  705784
  716125
  719987
  720541
  721149
  724780
  728916
  729038
  729262
  736334
  739288
  741503
  742903
  743860
  744159
  744171
  746197
  746199
  746293
  747482
  747510
  748499
  748593
  749641
  751319
  751943
  756975
  757126
  761728
  764836
  767519
  773334
  773351
  774872
  775590
  775624
  775658
  780028
  780323
  781515
  782109
  782749
  782936
  783029
  783186
  783370
  785366
  785651
  785653
  786366
  790463
  792253
  792668
  794639
  794765
  795070
  798769
  799423
  800041
  801818
  810904
  812106
  812695
  813331
  816152
  817028
  827394
  827578
]
1.89 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс orgasm"
]
1.73 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck to orgasm"
]

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.