Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.25 ms
(82.84%)
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
  89346
  154257
  230762
  352211
  382121
  389703
  395479
  415324
  449916
  449921
  452791
  476658
  477507
  494531
  505137
  507691
  516574
  519352
  529713
  529714
  530368
  530425
  535290
  539470
  540945
  541507
  545453
  545876
  564856
  569379
  583420
  584047
  590370
  595986
  599477
  602329
  616117
  629732
  630752
  640081
  640266
  640306
  640353
  643159
  644219
  648649
  648898
  649372
  654978
  656879
  656888
  664441
  668305
  671020
  673612
  686830
  689566
  690630
  697108
  697582
  698385
  702375
  703806
  706154
  713940
  731139
  735535
  738468
  739084
  739130
  739791
  739804
  741186
  744018
  745915
  749672
  750145
  751314
  752630
  752669
  752682
  753105
  756828
  758318
  758330
  760200
  761191
  761430
  766945
  767731
  772242
  772272
  776034
  777752
  777760
  777838
  778449
  780151
  780165
  780274
  780339
  783056
  784701
  786017
  786232
  787469
  791132
  792148
  796326
  796673
  796996
  797001
  803367
  803633
  806834
  807122
  807170
  808969
  809686
  814140
]
15.59 ms
(10.74%)
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
  477507
  797001
  352211
  382121
  494531
  507691
  648649
  643159
  395479
  731139
  706154
  595986
  564856
  545876
  89346
  449916
  539470
  505137
  599477
  415324
  154257
  452791
  814140
  449921
  476658
  529713
  529714
  530368
  545453
  541507
  540945
  671020
  668305
  590370
  602329
  784701
  752669
  752682
  758330
  745915
  749672
  752630
  791132
  806834
  389703
  664441
  673612
  516574
  230762
  519352
  530425
  535290
  583420
  584047
  569379
  648898
  686830
  703806
  649372
  656879
  713940
  654978
  656888
  689566
  690630
  616117
  629732
  640081
  640266
  640306
  644219
  630752
  640353
  776034
  777760
  780165
  780274
  780339
  792148
  796326
  803367
  807122
  777752
  777838
  778449
  780151
  796673
  796996
  803633
  807170
  808969
  739791
  741186
  744018
  756828
  761430
  772272
  783056
  786017
  786232
  787469
  809686
  751314
  767731
  738468
  739130
  766945
  735535
  739084
  739804
  760200
  761191
  772242
  750145
  753105
  758318
  697108
  697582
  698385
  702375
]
2.63 ms
(1.81%)
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
  89346
  154257
  230762
  352211
  382121
  389703
  395479
  415324
  449916
  449921
  452791
  476658
  477507
  494531
  505137
  507691
  516574
  519352
  529713
  529714
  530368
  530425
  535290
  539470
  540945
  541507
  545453
  545876
  564856
  569379
  583420
  584047
  590370
  595986
  599477
  602329
  616117
  629732
  630752
  640081
  640266
  640306
  640353
  643159
  644219
  648649
  648898
  649372
  654978
  656879
  656888
  664441
  668305
  671020
  673612
  686830
  689566
  690630
  697108
  697582
  698385
  702375
  703806
  706154
  713940
  731139
  735535
  738468
  739084
  739130
  739791
  739804
  741186
  744018
  745915
  749672
  750145
  751314
  752630
  752669
  752682
  753105
  756828
  758318
  758330
  760200
  761191
  761430
  766945
  767731
  772242
  772272
  776034
  777752
  777760
  777838
  778449
  780151
  780165
  780274
  780339
  783056
  784701
  786017
  786232
  787469
  791132
  792148
  796326
  796673
  796996
  797001
  803367
  803633
  806834
  807122
  807170
  808969
  809686
  814140
]
2.23 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dildo ridding"
]
1.67 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дилд наездниц поз"
]
1.45 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.33 ms
(0.92%)
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.