Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.14 ms
(55.80%)
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
  390360
  392422
  406982
  411025
  412779
  413446
  415776
  423480
  424248
  429362
  433001
  441232
  444022
  445538
  450023
  450474
  450889
  451149
  451758
  452430
  452937
  454275
  460168
  462342
  468035
  473005
  475102
  475416
  477586
  480788
  481904
  490511
  498279
  500910
  502369
  505725
  508686
  508883
  508909
  510876
  512486
  514652
  516491
  517431
  518085
  518403
  519478
  520270
  520834
  521343
  526492
  528315
  528502
  532221
  532746
  532940
  536459
  536474
  537943
  544510
  547576
  555104
  556884
  569223
  575566
  583425
  586294
  590204
  603468
  606405
  610683
  613757
  623736
  625660
  635169
  662389
  662428
  669514
  673578
  673923
  674467
  686214
  690936
  694958
  695878
  696920
  710096
  720139
  720198
  720207
  723606
  724264
  728493
  735198
  740309
  742286
  742356
  748053
  751452
  765221
  766830
  770413
  776248
  782452
  782633
  785503
  788294
  791844
  795396
  796221
  796976
  797080
  801542
  803043
  804700
  806384
  806514
  806943
  813275
  816711
]
143.64 ms
(38.14%)
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
  390360
  392422
  406982
  411025
  412779
  413446
  415776
  423480
  424248
  429362
  433001
  441232
  444022
  445538
  450023
  450474
  450889
  451149
  451758
  452430
  452937
  454275
  460168
  462342
  468035
  473005
  475102
  475416
  477586
  480788
  481904
  490511
  498279
  500910
  502369
  505725
  508686
  508883
  508909
  510876
  512486
  514652
  516491
  517431
  518085
  518403
  519478
  520270
  520834
  521343
  526492
  528315
  528502
  532221
  532746
  532940
  536459
  536474
  537943
  544510
  547576
  555104
  556884
  569223
  575566
  583425
  586294
  590204
  603468
  606405
  610683
  613757
  623736
  625660
  635169
  662389
  662428
  669514
  673578
  673923
  674467
  686214
  690936
  694958
  695878
  696920
  710096
  720139
  720198
  720207
  723606
  724264
  728493
  735198
  740309
  742286
  742356
  748053
  751452
  765221
  766830
  770413
  776248
  782452
  782633
  785503
  788294
  791844
  795396
  796221
  796976
  797080
  801542
  803043
  804700
  806384
  806514
  806943
  813275
  816711
]
15.48 ms
(4.11%)
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
  508686
  392422
  723606
  532221
  575566
  710096
  674467
  720207
  673923
  586294
  606405
  776248
  806514
  742286
  785503
  791844
  813275
  728493
  765221
  742356
  751452
  766830
  735198
  770413
  603468
  720139
  797080
  473005
  526492
  690936
  801542
  413446
  816711
  460168
  500910
  536474
  528315
  662389
  669514
  694958
  695878
  590204
  782633
  788294
  803043
  804700
  806943
  613757
  796221
  412779
  505725
  502369
  481904
  569223
  450889
  390360
  433001
  490511
  452430
  518085
  520834
  475416
  547576
  583425
  475102
  451149
  520270
  508883
  415776
  445538
  510876
  508909
  514652
  517431
  521343
  536459
  468035
  444022
  519478
  452937
  429362
  424248
  532746
  544510
  555104
  662428
  686214
  610683
  806384
  796976
  724264
  748053
  740309
  454275
  450023
  480788
  406982
  411025
  450474
  537943
  423480
  477586
  528502
  623736
  462342
  498279
  518403
  451758
  532940
  673578
  720198
  556884
  635169
  625660
  782452
  696920
  795396
  441232
  512486
  516491
]
2.12 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur double dildo"
]
1.90 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск double дилд"
]
1.69 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск double дилд"
]

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.