Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.17 ms
(84.96%)
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
  16559
  29148
  232978
  384050
  385297
  388346
  400685
  401390
  401589
  402700
  402771
  403187
  403419
  405707
  409811
  417989
  420001
  424242
  429590
  429706
  437617
  455113
  457134
  458357
  461474
  462044
  470042
  471916
  473977
  476388
  485364
  492824
  493484
  494398
  504581
  506602
  508117
  509500
  511193
  512641
  512653
  513603
  521192
  524707
  535934
  537982
  549999
  568351
  570466
  576165
  580986
  596620
  597085
  598783
  611521
  631358
  640469
  652865
  654825
  655428
  655662
  655663
  656957
  657416
  658690
  660523
  663247
  663250
  669414
  669642
  675817
  689212
  695097
  709501
  718768
  721367
  721433
  721595
  722833
  723234
  736908
  739622
  740705
  744860
  751603
  751627
  753456
  753459
  753462
  753467
  755891
  756672
  763079
  765270
  765803
  765840
  765859
  766537
  770637
  777893
  778638
  778752
  779607
  785377
  785382
  787410
  787923
  788901
  797809
  799802
  802596
  803230
  803581
  807324
  807594
  808468
  810497
  814339
  825540
  825830
]
15.49 ms
(9.07%)
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
  384050
  402771
  470042
  476388
  16559
  403187
  437617
  455113
  493484
  494398
  509500
  803230
  825540
  656957
  669642
  654825
  655428
  655662
  657416
  658690
  669414
  675817
  640469
  778638
  810497
  740705
  755891
  770637
  825830
  549999
  580986
  576165
  723234
  660523
  721433
  598783
  611521
  596620
  631358
  797809
  799802
  807324
  777893
  778752
  808468
  751603
  802596
  807594
  739622
  756672
  751627
  765270
  765859
  766537
  744860
  753459
  753462
  753467
  763079
  765840
  736908
  753456
  765803
  718768
  721367
  779607
  785377
  785382
  788901
  803581
  417989
  462044
  458357
  485364
  535934
  504581
  403419
  513603
  521192
  511193
  506602
  232978
  429706
  29148
  401390
  570466
  655663
  695097
  787410
  787923
  424242
  471916
  473977
  385297
  400685
  402700
  405707
  461474
  388346
  401589
  409811
  420001
  429590
  492824
  524707
  508117
  512641
  512653
  814339
  457134
  537982
  568351
  663250
  689212
  722833
  663247
  721595
  652865
  709501
  597085
]
2.88 ms
(1.69%)
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
  16559
  29148
  232978
  384050
  385297
  388346
  400685
  401390
  401589
  402700
  402771
  403187
  403419
  405707
  409811
  417989
  420001
  424242
  429590
  429706
  437617
  455113
  457134
  458357
  461474
  462044
  470042
  471916
  473977
  476388
  485364
  492824
  493484
  494398
  504581
  506602
  508117
  509500
  511193
  512641
  512653
  513603
  521192
  524707
  535934
  537982
  549999
  568351
  570466
  576165
  580986
  596620
  597085
  598783
  611521
  631358
  640469
  652865
  654825
  655428
  655662
  655663
  656957
  657416
  658690
  660523
  663247
  663250
  669414
  669642
  675817
  689212
  695097
  709501
  718768
  721367
  721433
  721595
  722833
  723234
  736908
  739622
  740705
  744860
  751603
  751627
  753456
  753459
  753462
  753467
  755891
  756672
  763079
  765270
  765803
  765840
  765859
  766537
  770637
  777893
  778638
  778752
  779607
  785377
  785382
  787410
  787923
  788901
  797809
  799802
  802596
  803230
  803581
  807324
  807594
  808468
  810497
  814339
  825540
  825830
]
1.93 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty русск"
]
1.91 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty russian"
]
1.82 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty русск"
]
1.67 ms
(0.98%)
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.