Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.57 ms
(85.78%)
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
  35136
  43748
  91829
  187590
  280774
  385247
  387744
  395624
  404024
  407045
  415028
  415048
  416866
  417116
  419967
  426647
  427031
  427632
  429553
  429855
  432583
  433888
  434871
  435890
  437381
  439318
  440767
  444052
  445642
  446017
  453976
  456364
  463545
  463618
  464176
  466759
  468968
  475387
  475733
  479268
  489222
  505997
  506893
  507258
  515023
  516633
  525803
  528414
  530545
  531014
  536038
  542385
  545502
  549546
  555857
  556250
  559935
  564546
  565312
  571510
  575174
  577725
  580425
  581578
  585077
  588402
  588791
  590392
  593100
  598469
  599738
  601497
  602470
  603372
  603630
  605779
  614842
  615936
  617107
  617231
  627103
  629164
  630983
  645528
  648285
  650765
  655496
  661421
  662582
  667464
  675062
  675132
  675725
  683054
  691280
  691626
  693931
  695714
  723716
  725524
  740826
  751274
  755152
  758329
  758354
  760318
  765238
  768670
  768751
  770041
  785041
  785924
  789100
  792319
  800978
  804281
  823706
  823799
  823965
  827735
]
16.77 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
  571510
  804281
  427632
  91829
  187590
  387744
  823965
  827735
  542385
  675725
  444052
  603630
  463545
  555857
  516633
  468968
  655496
  580425
  593100
  416866
  588791
  489222
  823706
  823799
  693931
  789100
  466759
  683054
  565312
  475733
  445642
  453976
  429855
  479268
  601497
  648285
  415028
  564546
  507258
  463618
  602470
  429553
  385247
  437381
  585077
  515023
  667464
  691626
  599738
  419967
  404024
  605779
  415048
  440767
  446017
  505997
  506893
  525803
  530545
  528414
  536038
  581578
  549546
  661421
  675062
  615936
  617231
  588402
  590392
  603372
  598469
  627103
  765238
  740826
  758329
  629164
  792319
  432583
  407045
  435890
  439318
  43748
  417116
  433888
  456364
  434871
  617107
  426647
  280774
  464176
  545502
  35136
  475387
  531014
  556250
  577725
  575174
  559935
  645528
  662582
  675132
  691280
  650765
  695714
  630983
  785924
  800978
  725524
  758354
  760318
  755152
  768751
  723716
  768670
  770041
  751274
  614842
  785041
  395624
  427031
]
2.72 ms
(1.47%)
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
  35136
  43748
  91829
  187590
  280774
  385247
  387744
  395624
  404024
  407045
  415028
  415048
  416866
  417116
  419967
  426647
  427031
  427632
  429553
  429855
  432583
  433888
  434871
  435890
  437381
  439318
  440767
  444052
  445642
  446017
  453976
  456364
  463545
  463618
  464176
  466759
  468968
  475387
  475733
  479268
  489222
  505997
  506893
  507258
  515023
  516633
  525803
  528414
  530545
  531014
  536038
  542385
  545502
  549546
  555857
  556250
  559935
  564546
  565312
  571510
  575174
  577725
  580425
  581578
  585077
  588402
  588791
  590392
  593100
  598469
  599738
  601497
  602470
  603372
  603630
  605779
  614842
  615936
  617107
  617231
  627103
  629164
  630983
  645528
  648285
  650765
  655496
  661421
  662582
  667464
  675062
  675132
  675725
  683054
  691280
  691626
  693931
  695714
  723716
  725524
  740826
  751274
  755152
  758329
  758354
  760318
  765238
  768670
  768751
  770041
  785041
  785924
  789100
  792319
  800978
  804281
  823706
  823799
  823965
  827735
]
2.05 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass panties"
]
1.85 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп трусик нижн бел"
]
1.48 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.77%)
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.