Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.39 ms
(54.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade public"
]
150.43 ms
(39.45%)
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
  72889
  76312
  146523
  219957
  274100
  348413
  382514
  385781
  387299
  392902
  393157
  418456
  423963
  424615
  425007
  427057
  428446
  430572
  436481
  439516
  444053
  445636
  453584
  455486
  458635
  458830
  460891
  462950
  464046
  465587
  466365
  466492
  467072
  469618
  472366
  477205
  478008
  484035
  485560
  486601
  488692
  491719
  492495
  495412
  496646
  497974
  498434
  501943
  504220
  506477
  507755
  512765
  514045
  516704
  516961
  518962
  521953
  525984
  526153
  526335
  527814
  530063
  535664
  549911
  550475
  551106
  556493
  561952
  565020
  569859
  569874
  569899
  569911
  570290
  570646
  571596
  571612
  572108
  572818
  573565
  574043
  575357
  580993
  583367
  589357
  590446
  590461
  598493
  605691
  611694
  614989
  624480
  625050
  627782
  636155
  637945
  644151
  666463
  666614
  675583
  696342
  696381
  721958
  722019
  732154
  738653
  740966
  757889
  757908
  769469
  778265
  782306
  782813
  787317
  787563
  788367
  792690
  801398
  805109
  827950
]
14.57 ms
(3.82%)
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
  696381
  605691
  512765
  488692
  583367
  486601
  571612
  427057
  627782
  625050
  76312
  485560
  549911
  792690
  516704
  504220
  666614
  387299
  146523
  464046
  425007
  465587
  458635
  382514
  424615
  561952
  696342
  526335
  445636
  385781
  573565
  458830
  572108
  788367
  740966
  769469
  732154
  418456
  527814
  580993
  611694
  637945
  497974
  787563
  484035
  598493
  496646
  423963
  466492
  675583
  644151
  467072
  569859
  569899
  572818
  590461
  521953
  570646
  569911
  721958
  782813
  472366
  827950
  569874
  570290
  72889
  518962
  274100
  530063
  462950
  535664
  551106
  614989
  348413
  219957
  782306
  624480
  430572
  453584
  516961
  575357
  556493
  805109
  787317
  757889
  722019
  460891
  492495
  778265
  525984
  495412
  526153
  590446
  506477
  455486
  466365
  439516
  514045
  469618
  436481
  393157
  428446
  478008
  507755
  574043
  491719
  636155
  477205
  565020
  666463
  738653
  501943
  550475
  392902
  571596
  589357
  801398
  757908
  498434
  444053
]
2.54 ms
(0.66%)
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
  72889
  76312
  146523
  219957
  274100
  348413
  382514
  385781
  387299
  392902
  393157
  418456
  423963
  424615
  425007
  427057
  428446
  430572
  436481
  439516
  444053
  445636
  453584
  455486
  458635
  458830
  460891
  462950
  464046
  465587
  466365
  466492
  467072
  469618
  472366
  477205
  478008
  484035
  485560
  486601
  488692
  491719
  492495
  495412
  496646
  497974
  498434
  501943
  504220
  506477
  507755
  512765
  514045
  516704
  516961
  518962
  521953
  525984
  526153
  526335
  527814
  530063
  535664
  549911
  550475
  551106
  556493
  561952
  565020
  569859
  569874
  569899
  569911
  570290
  570646
  571596
  571612
  572108
  572818
  573565
  574043
  575357
  580993
  583367
  589357
  590446
  590461
  598493
  605691
  611694
  614989
  624480
  625050
  627782
  636155
  637945
  644151
  666463
  666614
  675583
  696342
  696381
  721958
  722019
  732154
  738653
  740966
  757889
  757908
  769469
  778265
  782306
  782813
  787317
  787563
  788367
  792690
  801398
  805109
  827950
]
1.59 ms
(0.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск на улиц"
]
1.29 ms
(0.34%)
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.