Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.40 ms
(81.99%)
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
  31583
  383705
  384419
  391099
  395218
  396470
  396821
  398527
  409713
  414329
  420006
  423849
  423928
  423958
  428797
  429248
  433995
  438055
  454332
  457805
  466503
  467096
  468062
  468925
  469106
  470009
  472065
  472811
  484152
  487102
  504359
  505857
  510015
  510937
  513136
  514941
  518590
  518786
  519625
  527246
  528613
  529046
  530144
  530403
  530698
  533403
  534619
  535390
  537538
  542734
  543021
  546307
  547781
  548076
  550946
  557349
  558100
  558106
  562903
  565968
  574630
  575701
  576746
  579949
  581040
  583374
  586364
  594409
  600980
  602522
  604849
  608705
  613769
  614890
  624116
  630063
  643669
  650606
  658469
  660356
  660364
  661356
  661359
  667338
  671078
  673100
  680690
  691219
  692712
  710666
  714042
  729421
  746092
  747048
  753583
  754064
  757207
  762802
  776890
  779644
  782978
  785376
  798784
  802236
  813460
  813804
  813822
  816817
  817554
  817776
  817813
  818489
  818621
  819503
  819862
  824027
  824502
  828256
  828260
  828370
]
23.18 ms
(12.64%)
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
  692712
  710666
  600980
  785376
  469106
  398527
  438055
  505857
  528613
  661356
  31583
  547781
  660364
  658469
  661359
  602522
  673100
  548076
  518590
  691219
  594409
  423928
  396470
  813822
  468925
  530698
  514941
  550946
  802236
  608705
  423849
  428797
  484152
  510015
  824502
  816817
  824027
  828260
  828256
  537538
  650606
  660356
  747048
  753583
  819862
  813460
  729421
  535390
  529046
  518786
  468062
  467096
  558106
  409713
  433995
  429248
  466503
  533403
  513136
  472065
  558100
  575701
  614890
  586364
  643669
  624116
  757207
  776890
  414329
  504359
  510937
  423958
  454332
  530144
  527246
  487102
  557349
  542734
  543021
  565968
  562903
  680690
  576746
  630063
  782978
  472811
  420006
  470009
  457805
  383705
  391099
  818621
  828370
  671078
  581040
  613769
  798784
  746092
  779644
  818489
  534619
  714042
  574630
  817554
  817776
  817813
  819503
  813804
  530403
  546307
  667338
  762802
  754064
  396821
  583374
  384419
  579949
  604849
  519625
  395218
]
2.75 ms
(1.50%)
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
  31583
  383705
  384419
  391099
  395218
  396470
  396821
  398527
  409713
  414329
  420006
  423849
  423928
  423958
  428797
  429248
  433995
  438055
  454332
  457805
  466503
  467096
  468062
  468925
  469106
  470009
  472065
  472811
  484152
  487102
  504359
  505857
  510015
  510937
  513136
  514941
  518590
  518786
  519625
  527246
  528613
  529046
  530144
  530403
  530698
  533403
  534619
  535390
  537538
  542734
  543021
  546307
  547781
  548076
  550946
  557349
  558100
  558106
  562903
  565968
  574630
  575701
  576746
  579949
  581040
  583374
  586364
  594409
  600980
  602522
  604849
  608705
  613769
  614890
  624116
  630063
  643669
  650606
  658469
  660356
  660364
  661356
  661359
  667338
  671078
  673100
  680690
  691219
  692712
  710666
  714042
  729421
  746092
  747048
  753583
  754064
  757207
  762802
  776890
  779644
  782978
  785376
  798784
  802236
  813460
  813804
  813822
  816817
  817554
  817776
  817813
  818489
  818621
  819503
  819862
  824027
  824502
  828256
  828260
  828370
]
2.20 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "glasses public"
]
1.71 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "очкастая на улиц"
]
1.50 ms
(0.82%)
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.