Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.70 ms
(84.61%)
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
  383483
  409907
  414960
  423763
  428867
  432529
  432754
  433273
  434610
  435405
  435557
  437452
  437730
  438288
  439633
  442552
  446509
  447106
  447712
  448846
  454135
  456291
  457440
  457847
  459124
  462935
  464989
  465261
  469389
  477923
  477968
  478948
  479950
  479965
  480064
  480912
  483036
  489370
  489577
  489650
  492029
  492039
  492506
  494396
  495225
  495458
  498211
  498518
  498852
  498865
  498882
  500025
  501065
  501957
  501984
  503216
  504813
  505422
  505607
  505819
  506222
  506395
  506635
  508004
  508555
  508744
  515845
  515901
  516379
  516492
  518780
  519237
  519736
  519853
  520392
  520895
  522216
  522551
  526604
  527267
  528921
  548057
  551547
  552356
  552372
  552593
  553287
  558647
  560257
  561666
  562233
  563234
  564850
  565649
  565947
  569897
  569935
  570294
  572516
  573791
  574572
  575275
  578381
  579534
  579613
  584797
  590348
  599052
  599491
  662107
  693235
  713687
  740645
  742304
  751984
  761875
  792062
  793123
  823454
  823659
]
12.37 ms
(8.67%)
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
  793123
  409907
  480912
  432529
  501984
  494396
  713687
  423763
  383483
  477968
  434610
  519736
  483036
  492039
  505607
  506395
  506635
  522551
  501065
  489577
  508744
  823659
  492506
  569935
  662107
  459124
  495458
  457847
  501957
  506222
  516492
  823454
  552593
  590348
  435405
  515845
  433273
  432754
  442552
  435557
  477923
  479965
  526604
  489650
  492029
  518780
  519237
  500025
  498852
  584797
  551547
  570294
  573791
  574572
  558647
  569897
  792062
  742304
  437452
  437730
  446509
  479950
  516379
  505422
  498865
  522216
  508004
  740645
  553287
  575275
  579613
  456291
  462935
  504813
  527267
  439633
  520392
  561666
  572516
  562233
  565649
  563234
  693235
  548057
  552356
  579534
  761875
  447712
  428867
  438288
  447106
  464989
  465261
  489370
  498518
  498882
  599052
  457440
  480064
  552372
  560257
  565947
  599491
  414960
  469389
  454135
  448846
  520895
  528921
  508555
  495225
  503216
  505819
  498211
  578381
  564850
  751984
  478948
  515901
  519853
]
2.99 ms
(2.09%)
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
  383483
  409907
  414960
  423763
  428867
  432529
  432754
  433273
  434610
  435405
  435557
  437452
  437730
  438288
  439633
  442552
  446509
  447106
  447712
  448846
  454135
  456291
  457440
  457847
  459124
  462935
  464989
  465261
  469389
  477923
  477968
  478948
  479950
  479965
  480064
  480912
  483036
  489370
  489577
  489650
  492029
  492039
  492506
  494396
  495225
  495458
  498211
  498518
  498852
  498865
  498882
  500025
  501065
  501957
  501984
  503216
  504813
  505422
  505607
  505819
  506222
  506395
  506635
  508004
  508555
  508744
  515845
  515901
  516379
  516492
  518780
  519237
  519736
  519853
  520392
  520895
  522216
  522551
  526604
  527267
  528921
  548057
  551547
  552356
  552372
  552593
  553287
  558647
  560257
  561666
  562233
  563234
  564850
  565649
  565947
  569897
  569935
  570294
  572516
  573791
  574572
  575275
  578381
  579534
  579613
  584797
  590348
  599052
  599491
  662107
  693235
  713687
  740645
  742304
  751984
  761875
  792062
  793123
  823454
  823659
]
2.18 ms
(1.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian massage"
]
1.63 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.42 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск массаж"
]
1.36 ms
(0.96%)
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.