Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.31 ms
(84.00%)
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
  117596
  193890
  209384
  229555
  385306
  392455
  395392
  397188
  405682
  466045
  488806
  499621
  505561
  508719
  513236
  535444
  537608
  539251
  543359
  545091
  545218
  547130
  547220
  551466
  555632
  560030
  560754
  564466
  565993
  570777
  578635
  578789
  588117
  588124
  604110
  605537
  614006
  624235
  631994
  632989
  635789
  637232
  639361
  639929
  644681
  645730
  645826
  653347
  659482
  673159
  682253
  694228
  712593
  712687
  718499
  719087
  720269
  721729
  723279
  723433
  724359
  726284
  729662
  730921
  730924
  731131
  732650
  734270
  735664
  736239
  742113
  742592
  742766
  743458
  744573
  749629
  750552
  753208
  754505
  756290
  758017
  762029
  764751
  766411
  768447
  769675
  772011
  772398
  772551
  776835
  781746
  783055
  783536
  784140
  787054
  787102
  787711
  788047
  791842
  793412
  797019
  797329
  798245
  798862
  802855
  803590
  809904
  809991
  813315
  813426
  813901
  817658
  818046
  818841
  820103
  823445
  825217
  825325
  825394
  827535
]
12.95 ms
(8.89%)
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
  788047
  798245
  809991
  726284
  736239
  756290
  769675
  732650
  734270
  735664
  743458
  768447
  772551
  742592
  753208
  772011
  631994
  719087
  723279
  783055
  784140
  813315
  499621
  817658
  395392
  385306
  229555
  209384
  653347
  694228
  545091
  723433
  791842
  405682
  639361
  803590
  776835
  729662
  754505
  392455
  825394
  823445
  578635
  565993
  682253
  712687
  645826
  645730
  673159
  570777
  578789
  639929
  635789
  781746
  787711
  787054
  793412
  809904
  731131
  758017
  764751
  742113
  762029
  750552
  766411
  632989
  798862
  466045
  508719
  193890
  397188
  820103
  825325
  813901
  827535
  818046
  825217
  513236
  535444
  560030
  555632
  551466
  560754
  564466
  712593
  659482
  720269
  721729
  718499
  547130
  547220
  604110
  614006
  637232
  588117
  644681
  588124
  605537
  783536
  797019
  802855
  787102
  797329
  730921
  749629
  724359
  730924
  744573
  772398
  742766
  624235
  813426
  505561
  117596
  818841
  488806
  537608
  539251
  543359
  545218
]
2.94 ms
(2.02%)
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
  117596
  193890
  209384
  229555
  385306
  392455
  395392
  397188
  405682
  466045
  488806
  499621
  505561
  508719
  513236
  535444
  537608
  539251
  543359
  545091
  545218
  547130
  547220
  551466
  555632
  560030
  560754
  564466
  565993
  570777
  578635
  578789
  588117
  588124
  604110
  605537
  614006
  624235
  631994
  632989
  635789
  637232
  639361
  639929
  644681
  645730
  645826
  653347
  659482
  673159
  682253
  694228
  712593
  712687
  718499
  719087
  720269
  721729
  723279
  723433
  724359
  726284
  729662
  730921
  730924
  731131
  732650
  734270
  735664
  736239
  742113
  742592
  742766
  743458
  744573
  749629
  750552
  753208
  754505
  756290
  758017
  762029
  764751
  766411
  768447
  769675
  772011
  772398
  772551
  776835
  781746
  783055
  783536
  784140
  787054
  787102
  787711
  788047
  791842
  793412
  797019
  797329
  798245
  798862
  802855
  803590
  809904
  809991
  813315
  813426
  813901
  817658
  818046
  818841
  820103
  823445
  825217
  825325
  825394
  827535
]
2.08 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fuck friend"
]
1.97 ms
(1.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс friend"
]
1.65 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс friend"
]

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.