Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
156.10 ms
(82.46%)
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
  382207
  383287
  390650
  394212
  395628
  398038
  401773
  403087
  407753
  409083
  409226
  410439
  411626
  412521
  413164
  413268
  416063
  417308
  418853
  418905
  419565
  419956
  420219
  425611
  426006
  428410
  428752
  428884
  429899
  430293
  433968
  437559
  437679
  442114
  442836
  443786
  445474
  445498
  445874
  446644
  446855
  447740
  447937
  448319
  448837
  449623
  452353
  452446
  452968
  453091
  453390
  453550
  454271
  454327
  454565
  456127
  458278
  459476
  460192
  460195
  460921
  460954
  462126
  462817
  463942
  464022
  464023
  464601
  464667
  465214
  465431
  466392
  466709
  466995
  468100
  468228
  468927
  468946
  470612
  470679
  471647
  472198
  472216
  473247
  473400
  473634
  474124
  474226
  475685
  476237
  476310
  478063
  481914
  484923
  486814
  487347
  489087
  492192
  492462
  494547
  494833
  499829
  502108
  505253
  505397
  507181
  510425
  518868
  518873
  519309
  561077
  563166
  567527
  578528
  585851
  610228
  613015
  666188
  726876
  728956
]
22.63 ms
(11.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
  437679
  409226
  445874
  452968
  462817
  561077
  428884
  466995
  417308
  463942
  459476
  489087
  518873
  468927
  383287
  390650
  403087
  411626
  425611
  430293
  426006
  433968
  418905
  428410
  445474
  447937
  448319
  465214
  468228
  474124
  456127
  471647
  452446
  464022
  466709
  472216
  475685
  478063
  484923
  502108
  505253
  505397
  518868
  494547
  499829
  460192
  460195
  476310
  567527
  613015
  728956
  726876
  413268
  453091
  454565
  462126
  473247
  395628
  470612
  474226
  458278
  473634
  449623
  452353
  464667
  470679
  486814
  429899
  442114
  419956
  466392
  481914
  453550
  563166
  464023
  473400
  454271
  465431
  510425
  519309
  382207
  398038
  401773
  410439
  412521
  416063
  420219
  413164
  418853
  419565
  428752
  442836
  445498
  460954
  468100
  487347
  492192
  448837
  454327
  464601
  468946
  472198
  476237
  492462
  446644
  446855
  447740
  494833
  507181
  578528
  666188
  585851
  610228
  407753
  409083
  453390
  394212
  443786
  460921
  437559
]
3.53 ms
(1.87%)
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
  382207
  383287
  390650
  394212
  395628
  398038
  401773
  403087
  407753
  409083
  409226
  410439
  411626
  412521
  413164
  413268
  416063
  417308
  418853
  418905
  419565
  419956
  420219
  425611
  426006
  428410
  428752
  428884
  429899
  430293
  433968
  437559
  437679
  442114
  442836
  443786
  445474
  445498
  445874
  446644
  446855
  447740
  447937
  448319
  448837
  449623
  452353
  452446
  452968
  453091
  453390
  453550
  454271
  454327
  454565
  456127
  458278
  459476
  460192
  460195
  460921
  460954
  462126
  462817
  463942
  464022
  464023
  464601
  464667
  465214
  465431
  466392
  466709
  466995
  468100
  468228
  468927
  468946
  470612
  470679
  471647
  472198
  472216
  473247
  473400
  473634
  474124
  474226
  475685
  476237
  476310
  478063
  481914
  484923
  486814
  487347
  489087
  492192
  492462
  494547
  494833
  499829
  502108
  505253
  505397
  507181
  510425
  518868
  518873
  519309
  561077
  563166
  567527
  578528
  585851
  610228
  613015
  666188
  726876
  728956
]
2.35 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстуха с волосатой %…"
]
1.93 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "толстая волосатая"
]
1.24 ms
(0.65%)
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.