Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
148.19 ms
(85.60%)
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
  400684
  401202
  410324
  415885
  416970
  419567
  423626
  425960
  426357
  426936
  429151
  435968
  440684
  443061
  443744
  446560
  447865
  449385
  450321
  451672
  452456
  452593
  452854
  454744
  456040
  456837
  460586
  463678
  463834
  464952
  471690
  471743
  473040
  475401
  486421
  495769
  496703
  499147
  499395
  505885
  505902
  509899
  510296
  513872
  514966
  514982
  515034
  515542
  517057
  517480
  518007
  518635
  520686
  522250
  524262
  524297
  525474
  525699
  528632
  529306
  533131
  538543
  540026
  542757
  545292
  550606
  551566
  552565
  553920
  558148
  561877
  564659
  567331
  571138
  573332
  577540
  578116
  578129
  582889
  584384
  586858
  586900
  589407
  589899
  589900
  589968
  589970
  593009
  597861
  600627
  602019
  605735
  613871
  615170
  619593
  621055
  622346
  622391
  622392
  622399
  623494
  623613
  624897
  629363
  630527
  650748
  661395
  663730
  676535
  684658
  709024
  719407
  720871
  721613
  771517
  780419
  789589
  792612
  814741
  814870
]
16.55 ms
(9.56%)
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
  709024
  552565
  564659
  584384
  586900
  597861
  619593
  622346
  589899
  589970
  789589
  454744
  426936
  473040
  505902
  496703
  400684
  515034
  533131
  538543
  545292
  571138
  719407
  589407
  615170
  630527
  605735
  624897
  780419
  446560
  517057
  520686
  522250
  515542
  471690
  415885
  529306
  622391
  425960
  524297
  443744
  416970
  440684
  814741
  814870
  450321
  451672
  456837
  460586
  471743
  518007
  510296
  525699
  540026
  517480
  524262
  486421
  578116
  582889
  542757
  553920
  558148
  676535
  684658
  650748
  720871
  561877
  567331
  593009
  623494
  589900
  589968
  621055
  771517
  613871
  622392
  623613
  629363
  443061
  464952
  463834
  401202
  410324
  423626
  463678
  435968
  505885
  513872
  518635
  514966
  495769
  499395
  509899
  499147
  514982
  528632
  452456
  449385
  456040
  447865
  525474
  792612
  602019
  429151
  426357
  475401
  452593
  419567
  452854
  550606
  551566
  577540
  721613
  663730
  661395
  573332
  578129
  600627
  622399
  586858
]
2.17 ms
(1.25%)
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
  400684
  401202
  410324
  415885
  416970
  419567
  423626
  425960
  426357
  426936
  429151
  435968
  440684
  443061
  443744
  446560
  447865
  449385
  450321
  451672
  452456
  452593
  452854
  454744
  456040
  456837
  460586
  463678
  463834
  464952
  471690
  471743
  473040
  475401
  486421
  495769
  496703
  499147
  499395
  505885
  505902
  509899
  510296
  513872
  514966
  514982
  515034
  515542
  517057
  517480
  518007
  518635
  520686
  522250
  524262
  524297
  525474
  525699
  528632
  529306
  533131
  538543
  540026
  542757
  545292
  550606
  551566
  552565
  553920
  558148
  561877
  564659
  567331
  571138
  573332
  577540
  578116
  578129
  582889
  584384
  586858
  586900
  589407
  589899
  589900
  589968
  589970
  593009
  597861
  600627
  602019
  605735
  613871
  615170
  619593
  621055
  622346
  622391
  622392
  622399
  623494
  623613
  624897
  629363
  630527
  650748
  661395
  663730
  676535
  684658
  709024
  719407
  720871
  721613
  771517
  780419
  789589
  792612
  814741
  814870
]
1.90 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "body ass"
]
1.65 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "body жоп"
]
1.25 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "body жоп"
]

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.