Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.48 ms
(86.99%)
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
  33974
  91890
  100642
  161427
  177802
  195513
  229270
  336704
  383577
  385478
  390389
  390810
  454657
  462860
  464625
  474248
  475305
  478141
  483822
  488640
  488880
  495598
  504854
  520254
  521090
  523331
  525546
  530343
  531078
  533212
  533598
  533941
  535241
  538638
  540587
  546150
  546152
  546153
  546155
  547013
  549965
  551860
  554142
  555203
  556687
  558727
  561237
  563955
  564847
  571439
  571696
  574115
  574138
  575125
  575401
  576007
  577655
  578153
  578312
  580541
  583797
  584457
  584590
  595224
  597283
  598736
  600060
  607340
  609241
  611782
  615506
  617618
  618222
  618299
  618300
  618301
  618303
  618304
  619350
  620667
  620746
  621978
  623086
  626844
  627558
  628709
  629808
  631563
  631869
  632279
  638302
  638980
  641120
  646078
  652716
  661490
  663341
  666664
  673326
  673332
  680759
  704632
  705519
  707497
  718740
  719052
  735113
  737972
  759336
  761162
  766193
  768870
  777294
  785387
  785713
  799480
  804125
  816183
  818744
  821680
]
15.92 ms
(7.98%)
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
  571696
  533941
  768870
  619350
  549965
  777294
  766193
  818744
  546155
  680759
  704632
  719052
  546150
  759336
  799480
  454657
  673332
  737972
  571439
  646078
  611782
  609241
  631869
  546152
  618304
  556687
  576007
  575401
  546153
  618299
  530343
  574115
  574138
  615506
  627558
  478141
  584590
  821680
  91890
  626844
  621978
  385478
  578312
  735113
  607340
  521090
  533598
  629808
  620746
  229270
  583797
  554142
  661490
  597283
  488880
  623086
  804125
  638980
  177802
  336704
  561237
  673326
  718740
  33974
  628709
  761162
  707497
  523331
  535241
  563955
  632279
  785713
  462860
  558727
  666664
  652716
  577655
  504854
  638302
  575125
  390389
  631563
  533212
  595224
  663341
  618303
  531078
  816183
  474248
  488640
  547013
  618222
  195513
  705519
  100642
  390810
  618301
  600060
  161427
  520254
  584457
  551860
  383577
  538638
  578153
  598736
  641120
  785387
  483822
  564847
  555203
  580541
  617618
  618300
  525546
  620667
  475305
  495598
  540587
  464625
]
3.14 ms
(1.57%)
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
  33974
  91890
  100642
  161427
  177802
  195513
  229270
  336704
  383577
  385478
  390389
  390810
  454657
  462860
  464625
  474248
  475305
  478141
  483822
  488640
  488880
  495598
  504854
  520254
  521090
  523331
  525546
  530343
  531078
  533212
  533598
  533941
  535241
  538638
  540587
  546150
  546152
  546153
  546155
  547013
  549965
  551860
  554142
  555203
  556687
  558727
  561237
  563955
  564847
  571439
  571696
  574115
  574138
  575125
  575401
  576007
  577655
  578153
  578312
  580541
  583797
  584457
  584590
  595224
  597283
  598736
  600060
  607340
  609241
  611782
  615506
  617618
  618222
  618299
  618300
  618301
  618303
  618304
  619350
  620667
  620746
  621978
  623086
  626844
  627558
  628709
  629808
  631563
  631869
  632279
  638302
  638980
  641120
  646078
  652716
  661490
  663341
  666664
  673326
  673332
  680759
  704632
  705519
  707497
  718740
  719052
  735113
  737972
  759336
  761162
  766193
  768870
  777294
  785387
  785713
  799480
  804125
  816183
  818744
  821680
]
1.97 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "car riding sex"
]
1.68 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вмашин riding секс"
]
1.68 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вмашин riding секс"
]
1.55 ms
(0.78%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.