Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.46 ms
(85.30%)
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
  411893
  415941
  463863
  465618
  469619
  474670
  475032
  480390
  484404
  492232
  501534
  503127
  506801
  508273
  519440
  526895
  530750
  530795
  530934
  531217
  532743
  533724
  535467
  536571
  536632
  537662
  537882
  537927
  542207
  544848
  545197
  550380
  550409
  551892
  552514
  562791
  565525
  568054
  576637
  580622
  583449
  589472
  594008
  594467
  594635
  598194
  600083
  606648
  620661
  624280
  626144
  626293
  630487
  632605
  632696
  634543
  634849
  636003
  637115
  643234
  643263
  644952
  644960
  646014
  649560
  651613
  653559
  655871
  659404
  662870
  667392
  668537
  670198
  670342
  670619
  673969
  688068
  693356
  700851
  701771
  702619
  704916
  705180
  712887
  714256
  716557
  717720
  720117
  720621
  721150
  722224
  722330
  722619
  724255
  725151
  725169
  727687
  733852
  733896
  736412
  741306
  743040
  748661
  748706
  750550
  753545
  754147
  756207
  758194
  758523
  758989
  758997
  760453
  766706
  770429
  782402
  785324
  790199
  802375
  827642
]
17.50 ms
(9.48%)
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
  503127
  565525
  670619
  717720
  722224
  594635
  624280
  636003
  637115
  632605
  827642
  670198
  722619
  712887
  580622
  600083
  606648
  643234
  727687
  736412
  743040
  770429
  756207
  714256
  720117
  802375
  506801
  550409
  465618
  668537
  643263
  766706
  469619
  484404
  501534
  508273
  463863
  492232
  474670
  562791
  670342
  594467
  598194
  733896
  701771
  673969
  785324
  725151
  741306
  758194
  748706
  644960
  532743
  530934
  544848
  576637
  583449
  542207
  649560
  655871
  662870
  651613
  688068
  705180
  716557
  720621
  589472
  620661
  626144
  594008
  626293
  634849
  725169
  754147
  724255
  632696
  704916
  721150
  782402
  411893
  653559
  758989
  760453
  758523
  480390
  700851
  526895
  634543
  753545
  758997
  748661
  415941
  693356
  733852
  667392
  630487
  790199
  750550
  644952
  475032
  531217
  535467
  536571
  536632
  537882
  519440
  530795
  537662
  530750
  533724
  537927
  550380
  568054
  545197
  551892
  552514
  702619
  722330
  646014
  659404
]
2.95 ms
(1.60%)
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
  411893
  415941
  463863
  465618
  469619
  474670
  475032
  480390
  484404
  492232
  501534
  503127
  506801
  508273
  519440
  526895
  530750
  530795
  530934
  531217
  532743
  533724
  535467
  536571
  536632
  537662
  537882
  537927
  542207
  544848
  545197
  550380
  550409
  551892
  552514
  562791
  565525
  568054
  576637
  580622
  583449
  589472
  594008
  594467
  594635
  598194
  600083
  606648
  620661
  624280
  626144
  626293
  630487
  632605
  632696
  634543
  634849
  636003
  637115
  643234
  643263
  644952
  644960
  646014
  649560
  651613
  653559
  655871
  659404
  662870
  667392
  668537
  670198
  670342
  670619
  673969
  688068
  693356
  700851
  701771
  702619
  704916
  705180
  712887
  714256
  716557
  717720
  720117
  720621
  721150
  722224
  722330
  722619
  724255
  725151
  725169
  727687
  733852
  733896
  736412
  741306
  743040
  748661
  748706
  750550
  753545
  754147
  756207
  758194
  758523
  758989
  758997
  760453
  766706
  770429
  782402
  785324
  790199
  802375
  827642
]
2.18 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal ass casting"
]
1.54 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал жоп кастинг"
]
1.53 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.