Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.90 ms
(87.28%)
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
  395574
  428062
  461735
  461933
  482335
  496076
  510879
  511572
  512718
  514802
  516957
  523554
  531655
  533301
  534087
  537667
  541708
  541718
  550345
  553757
  558082
  559996
  560987
  564391
  565552
  566873
  567684
  604361
  606767
  609343
  610851
  624360
  646289
  652927
  654906
  660414
  661936
  665745
  668102
  668449
  669074
  670727
  671704
  675612
  683242
  686558
  689359
  691511
  691611
  691738
  694083
  697600
  701396
  715020
  715552
  715627
  716086
  719245
  719300
  720206
  720224
  720982
  721390
  721726
  736830
  742458
  746160
  747709
  752987
  754584
  756301
  756535
  761528
  765597
  766768
  766797
  768358
  773734
  777021
  787567
  788557
  788912
  789205
  790496
  790531
  794366
  804325
  804590
  808152
  814390
  814490
  814570
  814998
  815266
  817215
  818959
  819020
  820197
  820565
  820572
  820855
  821110
  821121
  821136
  821319
  821434
  821437
  822686
  823490
  823740
  824425
  824679
  826242
  826674
  827221
  827359
  828539
  828760
]
17.78 ms
(8.26%)
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
  826674
  826242
  817215
  819020
  827221
  818959
  820855
  821121
  815266
  820197
  821110
  822686
  823740
  824425
  824679
  827359
  828539
  665745
  683242
  691511
  691738
  715552
  652927
  720224
  721726
  701396
  715020
  624360
  794366
  746160
  766768
  787567
  788912
  790531
  804590
  808152
  752987
  742458
  744999
  747709
  754584
  761528
  765597
  766797
  773734
  606767
  719245
  721975
  777021
  788557
  804325
  566873
  604361
  790496
  756535
  669074
  720206
  821136
  828760
  533301
  646289
  720982
  610851
  789205
  697600
  510879
  736830
  768358
  756301
  559996
  609343
  395574
  428062
  814490
  821319
  823490
  814570
  820565
  814390
  820572
  814998
  821434
  821437
  482335
  514802
  534087
  537667
  496076
  512718
  516957
  523554
  531655
  511572
  461735
  461933
  541718
  558082
  560987
  565552
  541708
  550345
  553757
  564391
  567684
  654906
  660414
  661936
  668102
  668449
  670727
  671704
  675612
  686558
  689359
  691611
  694083
  715627
  716086
  719300
  721390
]
2.87 ms
(1.33%)
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
  395574
  428062
  461735
  461933
  482335
  496076
  510879
  511572
  512718
  514802
  516957
  523554
  531655
  533301
  534087
  537667
  541708
  541718
  550345
  553757
  558082
  559996
  560987
  564391
  565552
  566873
  567684
  604361
  606767
  609343
  610851
  624360
  646289
  652927
  654906
  660414
  661936
  665745
  668102
  668449
  669074
  670727
  671704
  675612
  683242
  686558
  689359
  691511
  691611
  691738
  694083
  697600
  701396
  715020
  715552
  715627
  716086
  719245
  719300
  720206
  720224
  720982
  721390
  721726
  736830
  742458
  746160
  747709
  752987
  754584
  756301
  756535
  761528
  765597
  766768
  766797
  768358
  773734
  777021
  787567
  788557
  788912
  789205
  790496
  790531
  794366
  804325
  804590
  808152
  814390
  814490
  814570
  814998
  815266
  817215
  818959
  819020
  820197
  820565
  820572
  820855
  821110
  821121
  821136
  821319
  821434
  821437
  822686
  823490
  823740
  824425
  824679
  826242
  826674
  827221
  827359
  828539
  828760
]
1.97 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(0.89%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "long hair anal"
]
1.47 ms
(0.68%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "длинные hair анал"
]
1.38 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "длинные hair анал"
]

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.