Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.62 ms
(87.57%)
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
  63344
  86309
  131602
  154310
  154692
  230762
  369221
  382121
  382158
  382361
  385884
  387337
  387760
  391081
  397869
  397882
  398097
  460203
  465629
  474163
  486778
  515060
  530438
  536524
  555004
  560910
  561479
  562536
  569749
  586100
  587541
  591156
  595213
  601026
  601095
  607683
  613559
  620734
  621229
  625778
  626889
  630054
  638693
  640306
  644870
  648649
  648696
  650408
  651132
  653028
  666682
  681388
  686183
  687313
  697876
  698385
  701303
  710853
  711624
  713088
  718987
  733406
  734265
  735535
  738475
  744180
  751453
  752275
  752668
  753120
  758336
  759198
  760417
  761449
  762130
  762975
  776158
  780663
  781255
  781298
  781844
  784672
  790009
  791511
  793017
  793709
  797875
  798457
  799279
  800723
  803490
  803771
  804666
  805291
  806694
  807211
  808524
  811112
  812382
  813817
  814363
  815420
  815787
  817012
  817082
  817113
  817993
  819251
  822060
  823789
  823996
  824733
  825329
  825768
  825858
  826610
  826618
  826829
  827009
  827722
]
13.05 ms
(6.78%)
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
  648696
  697876
  651132
  613559
  595213
  781298
  803771
  806694
  752668
  762975
  793017
  751453
  625778
  369221
  131602
  382361
  230762
  63344
  154310
  530438
  536524
  644870
  799279
  744180
  812382
  387760
  813817
  640306
  638693
  397869
  698385
  382121
  398097
  759198
  474163
  601026
  648649
  382158
  387337
  397882
  391081
  738475
  630054
  805291
  465629
  515060
  798457
  825329
  824733
  687313
  815420
  620734
  569749
  823996
  827009
  781844
  562536
  815787
  650408
  793709
  591156
  154692
  686183
  825768
  808524
  734265
  804666
  718987
  601095
  753120
  681388
  586100
  621229
  735535
  86309
  780663
  385884
  817993
  826610
  826618
  817082
  825858
  817012
  823789
  817113
  819251
  822060
  486778
  460203
  561479
  701303
  713088
  587541
  626889
  790009
  776158
  803490
  733406
  758336
  760417
  784672
  791511
  797875
  800723
  811112
  762130
  752275
  761449
  781255
  807211
  826829
  827722
  560910
  814363
  653028
  710853
  711624
  666682
  555004
  607683
]
3.36 ms
(1.74%)
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
  63344
  86309
  131602
  154310
  154692
  230762
  369221
  382121
  382158
  382361
  385884
  387337
  387760
  391081
  397869
  397882
  398097
  460203
  465629
  474163
  486778
  515060
  530438
  536524
  555004
  560910
  561479
  562536
  569749
  586100
  587541
  591156
  595213
  601026
  601095
  607683
  613559
  620734
  621229
  625778
  626889
  630054
  638693
  640306
  644870
  648649
  648696
  650408
  651132
  653028
  666682
  681388
  686183
  687313
  697876
  698385
  701303
  710853
  711624
  713088
  718987
  733406
  734265
  735535
  738475
  744180
  751453
  752275
  752668
  753120
  758336
  759198
  760417
  761449
  762130
  762975
  776158
  780663
  781255
  781298
  781844
  784672
  790009
  791511
  793017
  793709
  797875
  798457
  799279
  800723
  803490
  803771
  804666
  805291
  806694
  807211
  808524
  811112
  812382
  813817
  814363
  815420
  815787
  817012
  817082
  817113
  817993
  819251
  822060
  823789
  823996
  824733
  825329
  825768
  825858
  826610
  826618
  826829
  827009
  827722
]
2.19 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð▒ð¥ð╗ÐîÐêð©ðÁ Ðüð©ÐüÐîð║ð© Ðü ð┤ð©ð╗ð┤ðÔǪ"
]
1.83 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ дилд"
]
1.78 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ дилд"
]
1.74 ms
(0.90%)
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.