Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.83 ms
(87.24%)
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
  341675
  390831
  391941
  418417
  422342
  424433
  428958
  436032
  436042
  436178
  443764
  443779
  443796
  447810
  451572
  452041
  456437
  457791
  457793
  458555
  461609
  464327
  468527
  469764
  470291
  470541
  470590
  470657
  472340
  473780
  474013
  474652
  474654
  474663
  474686
  474689
  474696
  474702
  484051
  484558
  484651
  484656
  484665
  484668
  484678
  484696
  484705
  484724
  484737
  488734
  490201
  490836
  497569
  497871
  509998
  514404
  521438
  521866
  525089
  530373
  532954
  533697
  533726
  533746
  534090
  535620
  535631
  542864
  542956
  543731
  547997
  552267
  555805
  558126
  558131
  565247
  567304
  567581
  568315
  575810
  586770
  587864
  590411
  597494
  597963
  598057
  599361
  599969
  601478
  613179
  614747
  619204
  621612
  622817
  631193
  631247
  632695
  644968
  647340
  647936
  648845
  648871
  650155
  651148
  651647
  662137
  671863
  683261
  683264
  696997
  702166
  714449
  716030
  716032
  731665
  733870
  775860
  775958
  805487
  825812
]
18.07 ms
(8.48%)
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
  696997
  714449
  474013
  484678
  390831
  650155
  341675
  514404
  533697
  535620
  567304
  567581
  601478
  775958
  474652
  456437
  436042
  452041
  484051
  484558
  484705
  497569
  535631
  621612
  443764
  443779
  443796
  422342
  424433
  474696
  484651
  484737
  484668
  644968
  547997
  568315
  683261
  590411
  733870
  631247
  428958
  474686
  488734
  447810
  597494
  470541
  825812
  552267
  558126
  716032
  565247
  598057
  731665
  716030
  451572
  469764
  470657
  509998
  586770
  534090
  490836
  622817
  474654
  533726
  647936
  683264
  555805
  484724
  484656
  464327
  775860
  418417
  468527
  457791
  532954
  543731
  702166
  575810
  473780
  470291
  470590
  521866
  662137
  458555
  474702
  542864
  651647
  542956
  484696
  805487
  525089
  597963
  461609
  648845
  497871
  614747
  474689
  472340
  530373
  599969
  436032
  457793
  484665
  436178
  647340
  671863
  587864
  599361
  521438
  613179
  648871
  632695
  631193
  490201
  558131
  391941
  651148
  619204
  533746
  474663
]
2.46 ms
(1.16%)
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
  341675
  390831
  391941
  418417
  422342
  424433
  428958
  436032
  436042
  436178
  443764
  443779
  443796
  447810
  451572
  452041
  456437
  457791
  457793
  458555
  461609
  464327
  468527
  469764
  470291
  470541
  470590
  470657
  472340
  473780
  474013
  474652
  474654
  474663
  474686
  474689
  474696
  474702
  484051
  484558
  484651
  484656
  484665
  484668
  484678
  484696
  484705
  484724
  484737
  488734
  490201
  490836
  497569
  497871
  509998
  514404
  521438
  521866
  525089
  530373
  532954
  533697
  533726
  533746
  534090
  535620
  535631
  542864
  542956
  543731
  547997
  552267
  555805
  558126
  558131
  565247
  567304
  567581
  568315
  575810
  586770
  587864
  590411
  597494
  597963
  598057
  599361
  599969
  601478
  613179
  614747
  619204
  621612
  622817
  631193
  631247
  632695
  644968
  647340
  647936
  648845
  648871
  650155
  651148
  651647
  662137
  671863
  683261
  683264
  696997
  702166
  714449
  716030
  716032
  731665
  733870
  775860
  775958
  805487
  825812
]
1.74 ms
(0.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian group anal"
]
1.65 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск group анал"
]
1.58 ms
(0.74%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "русск group анал"
]

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.