Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
196.51 ms
(89.06%)
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
  187960
  188009
  307940
  377154
  385070
  386717
  386793
  389785
  396139
  396206
  397867
  400679
  402226
  402715
  403725
  411459
  414763
  418193
  418338
  420793
  421874
  422169
  424114
  424210
  424622
  425356
  426531
  427252
  429416
  432823
  434443
  439731
  439783
  440878
  441074
  441288
  441587
  443603
  446169
  446363
  446908
  447218
  452641
  453769
  454111
  454165
  458269
  462806
  464596
  466256
  468181
  468340
  470154
  471919
  472198
  472691
  474125
  475294
  478200
  479018
  485165
  486221
  486578
  486635
  489299
  490446
  491837
  493618
  496732
  500605
  500620
  503477
  505107
  506132
  507003
  511596
  513517
  519542
  520861
  521232
  521912
  522087
  524188
  524528
  528501
  529087
  536417
  536431
  536648
  537815
  539372
  541400
  549822
  554356
  560823
  561033
  561834
  565347
  575156
  584946
  591959
  598088
  599092
  624351
  652927
  677344
  702038
  720645
  726897
  741578
  742345
  745679
  751159
  758498
  769496
  783067
  786493
  803556
  804344
]
13.92 ms
(6.31%)
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
  441587
  396206
  424114
  528501
  745679
  677344
  702038
  561033
  420793
  418193
  396139
  418338
  377154
  188009
  598088
  443603
  402226
  751159
  758498
  490446
  486635
  493618
  500620
  429416
  491837
  472691
  624351
  414763
  385070
  599092
  536431
  400679
  427252
  500605
  741578
  720645
  441288
  529087
  486578
  486221
  496732
  565347
  411459
  187960
  441074
  522087
  507003
  462806
  440878
  424622
  472198
  478200
  561834
  575156
  454111
  512847
  485165
  471919
  458269
  524188
  537815
  403725
  452641
  549822
  424210
  521232
  446908
  539372
  453769
  470154
  447218
  468181
  554356
  521912
  536417
  520861
  439783
  439731
  505107
  402715
  489299
  541400
  464596
  421874
  479018
  426531
  466256
  446169
  432823
  511596
  560823
  422169
  503477
  446363
  454165
  434443
  506132
  519542
  307940
  425356
  513517
  536648
  475294
  524528
  474125
  591959
  386717
  386793
  786493
  803556
  389785
  652927
  468340
  742345
  726897
  783067
  804344
  584946
  769496
  397867
]
2.73 ms
(1.24%)
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
  187960
  188009
  307940
  377154
  385070
  386717
  386793
  389785
  396139
  396206
  397867
  400679
  402226
  402715
  403725
  411459
  414763
  418193
  418338
  420793
  421874
  422169
  424114
  424210
  424622
  425356
  426531
  427252
  429416
  432823
  434443
  439731
  439783
  440878
  441074
  441288
  441587
  443603
  446169
  446363
  446908
  447218
  452641
  453769
  454111
  454165
  458269
  462806
  464596
  466256
  468181
  468340
  470154
  471919
  472198
  472691
  474125
  475294
  478200
  479018
  485165
  486221
  486578
  486635
  489299
  490446
  491837
  493618
  496732
  500605
  500620
  503477
  505107
  506132
  507003
  511596
  513517
  519542
  520861
  521232
  521912
  522087
  524188
  524528
  528501
  529087
  536417
  536431
  536648
  537815
  539372
  541400
  549822
  554356
  560823
  561033
  561834
  565347
  575156
  584946
  591959
  598088
  599092
  624351
  652927
  677344
  702038
  720645
  726897
  741578
  742345
  745679
  751159
  758498
  769496
  783067
  786493
  803556
  804344
]
2.23 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "рако анал"
]
1.87 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак анал"
]
1.75 ms
(0.79%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак анал"
]
1.63 ms
(0.74%)
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.