Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.95 ms
(86.26%)
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
  6806
  395263
  413999
  416022
  437494
  438025
  439256
  444882
  450579
  452813
  464188
  469411
  501931
  508485
  508888
  512073
  516652
  527085
  531677
  531868
  533481
  533841
  533944
  537914
  565501
  566320
  584267
  585346
  592862
  594875
  595977
  596621
  598720
  599990
  600257
  601578
  619175
  620612
  628401
  633237
  635975
  639108
  639823
  642323
  648744
  649472
  651912
  660620
  663293
  671520
  672396
  683661
  697220
  705253
  705262
  711860
  714142
  715798
  718793
  719327
  720339
  720717
  725743
  726064
  728930
  735978
  736959
  740816
  744560
  744896
  746087
  748965
  756708
  758163
  765211
  765479
  770271
  772842
  772887
  781485
  784792
  784975
  787043
  787095
  788922
  789710
  790069
  791365
  793723
  794687
  796177
  796236
  797050
  797088
  799651
  800339
  802803
  805039
  805201
  806025
  806653
  806924
  807261
  807589
  809556
  809707
  810884
  813706
  814038
  814168
  814211
  815274
  815585
  816995
  818465
  818897
  819585
  824434
  824498
  826971
]
15.43 ms
(8.17%)
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
  635975
  600257
  601578
  565501
  592862
  437494
  452813
  416022
  395263
  438025
  413999
  813706
  824434
  818897
  816995
  469411
  531868
  531677
  584267
  648744
  660620
  672396
  649472
  663293
  671520
  715798
  720339
  711860
  633237
  781485
  789710
  791365
  796177
  806025
  807261
  793723
  794687
  806924
  809556
  725743
  740816
  802803
  806653
  758163
  744896
  756708
  765211
  735978
  744560
  746087
  748965
  726064
  736959
  772842
  772887
  705253
  705262
  718793
  797050
  797088
  810884
  6806
  594875
  596621
  598720
  439256
  444882
  464188
  566320
  595977
  628401
  639823
  599990
  728930
  770271
  620612
  450579
  512073
  508485
  516652
  527085
  501931
  533944
  537914
  619175
  814038
  533481
  683661
  639108
  807589
  805039
  765479
  819585
  814168
  814211
  824498
  826971
  815274
  815585
  818465
  508888
  533841
  651912
  697220
  720717
  714142
  719327
  642323
  585346
  784792
  787043
  787095
  788922
  796236
  799651
  800339
  805201
  809707
  784975
  790069
]
3.07 ms
(1.62%)
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
  6806
  395263
  413999
  416022
  437494
  438025
  439256
  444882
  450579
  452813
  464188
  469411
  501931
  508485
  508888
  512073
  516652
  527085
  531677
  531868
  533481
  533841
  533944
  537914
  565501
  566320
  584267
  585346
  592862
  594875
  595977
  596621
  598720
  599990
  600257
  601578
  619175
  620612
  628401
  633237
  635975
  639108
  639823
  642323
  648744
  649472
  651912
  660620
  663293
  671520
  672396
  683661
  697220
  705253
  705262
  711860
  714142
  715798
  718793
  719327
  720339
  720717
  725743
  726064
  728930
  735978
  736959
  740816
  744560
  744896
  746087
  748965
  756708
  758163
  765211
  765479
  770271
  772842
  772887
  781485
  784792
  784975
  787043
  787095
  788922
  789710
  790069
  791365
  793723
  794687
  796177
  796236
  797050
  797088
  799651
  800339
  802803
  805039
  805201
  806025
  806653
  806924
  807261
  807589
  809556
  809707
  810884
  813706
  814038
  814168
  814211
  815274
  815585
  816995
  818465
  818897
  819585
  824434
  824498
  826971
]
2.25 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сквирт татуированная …"
]
1.79 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сквирт оргазм татуированные"
]
1.74 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм татуированные"
]
1.69 ms
(0.89%)
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.