Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.47 ms
(52.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "black любительск"
]
164.38 ms
(41.01%)
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
  154491
  328446
  329912
  390129
  397973
  405504
  405812
  416044
  423539
  423996
  429221
  429823
  432418
  433618
  434207
  438279
  443237
  445973
  449161
  451161
  453373
  456405
  456685
  461756
  461830
  466324
  466642
  467049
  467110
  468339
  468475
  472804
  477387
  480541
  485027
  485795
  488797
  496311
  497683
  499717
  503816
  505096
  508282
  510330
  514289
  516704
  516746
  518794
  519862
  530063
  538725
  540979
  540987
  554797
  568257
  572901
  575172
  581580
  590165
  593416
  596479
  596895
  601668
  605196
  605249
  607576
  608516
  613932
  618036
  621752
  626482
  634711
  643817
  651003
  663749
  666024
  669062
  675065
  675441
  675645
  691724
  694116
  695464
  708667
  713727
  715089
  715533
  715833
  715853
  719243
  719832
  720176
  720186
  729181
  733307
  737673
  739089
  740268
  755698
  757232
  757974
  765959
  766656
  769476
  771366
  777008
  784814
  784959
  784976
  786412
  788073
  790963
  793151
  796650
  796696
  800475
  804567
  805307
  808580
  812372
]
15.84 ms
(3.95%)
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
  719243
  708667
  590165
  445973
  329912
  397973
  416044
  438279
  429823
  429221
  453373
  466642
  449161
  467110
  468339
  480541
  485027
  451161
  456685
  467049
  485795
  519862
  538725
  496311
  518794
  477387
  568257
  554797
  669062
  713727
  715089
  695464
  720186
  719832
  575172
  634711
  608516
  784976
  788073
  796650
  796696
  804567
  808580
  784959
  786412
  793151
  800475
  812372
  757974
  740268
  765959
  766656
  769476
  729181
  733307
  771366
  737673
  739089
  757232
  715533
  720176
  784814
  432418
  434207
  461830
  456405
  466324
  433618
  472804
  510330
  508282
  499717
  581580
  423539
  613932
  503816
  691724
  675065
  675441
  675645
  651003
  572901
  605196
  626482
  596479
  605249
  596895
  607576
  618036
  643817
  405504
  443237
  468475
  694116
  790963
  755698
  777008
  390129
  405812
  461756
  497683
  505096
  516704
  530063
  540979
  540987
  663749
  666024
  593416
  621752
  601668
  715833
  423996
  514289
  488797
  154491
  328446
  516746
  715853
  805307
]
4.21 ms
(1.05%)
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
  154491
  328446
  329912
  390129
  397973
  405504
  405812
  416044
  423539
  423996
  429221
  429823
  432418
  433618
  434207
  438279
  443237
  445973
  449161
  451161
  453373
  456405
  456685
  461756
  461830
  466324
  466642
  467049
  467110
  468339
  468475
  472804
  477387
  480541
  485027
  485795
  488797
  496311
  497683
  499717
  503816
  505096
  508282
  510330
  514289
  516704
  516746
  518794
  519862
  530063
  538725
  540979
  540987
  554797
  568257
  572901
  575172
  581580
  590165
  593416
  596479
  596895
  601668
  605196
  605249
  607576
  608516
  613932
  618036
  621752
  626482
  634711
  643817
  651003
  663749
  666024
  669062
  675065
  675441
  675645
  691724
  694116
  695464
  708667
  713727
  715089
  715533
  715833
  715853
  719243
  719832
  720176
  720186
  729181
  733307
  737673
  739089
  740268
  755698
  757232
  757974
  765959
  766656
  769476
  771366
  777008
  784814
  784959
  784976
  786412
  788073
  790963
  793151
  796650
  796696
  800475
  804567
  805307
  808580
  812372
]
1.99 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.98 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "black amateur"
]
1.90 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "black любительск"
]

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.