Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.61 ms
(84.66%)
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
  370949
  395889
  400513
  406882
  407054
  413175
  414317
  418069
  418073
  418079
  421862
  421872
  422171
  424118
  424274
  425462
  426940
  430228
  433362
  439713
  439753
  439798
  439809
  443348
  445060
  445065
  446522
  446967
  448751
  448996
  449622
  449623
  451456
  453660
  457468
  464337
  468934
  470980
  474780
  474783
  478377
  480246
  481937
  482556
  485061
  488749
  490413
  493156
  496346
  510296
  513194
  514273
  514275
  516140
  516236
  519825
  520679
  520792
  524896
  527779
  529209
  546116
  546119
  547834
  549507
  553972
  556021
  560021
  561588
  569408
  569415
  569972
  573739
  573760
  578037
  582591
  589682
  591010
  591664
  592938
  599524
  621492
  626866
  633529
  673992
  678734
  687561
  691626
  703900
  720120
  726753
  732482
  773850
  782593
  784080
  784776
  786460
  788289
  788295
  788881
  790874
  792531
  792660
  793886
  797909
  799262
  799585
  800936
  801173
  801363
  803297
  805331
  807479
  809482
  810292
  812585
  812891
  813917
  815410
  820330
]
13.24 ms
(9.00%)
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
  449623
  480246
  446522
  496346
  516236
  439798
  439713
  422171
  395889
  414317
  813917
  820330
  474783
  470980
  446967
  464337
  553972
  578037
  546116
  569972
  573739
  687561
  678734
  673992
  691626
  547834
  556021
  560021
  626866
  633529
  591010
  591664
  592938
  621492
  589682
  599524
  782593
  784776
  786460
  801363
  805331
  812585
  788289
  788881
  790874
  793886
  797909
  809482
  773850
  784080
  788295
  792531
  792660
  799262
  799585
  800936
  801173
  810292
  812891
  726753
  732482
  703900
  720120
  803297
  807479
  433362
  448751
  457468
  481937
  421862
  424118
  425462
  439809
  443348
  449622
  421872
  424274
  426940
  448996
  474780
  400513
  418069
  418073
  439753
  478377
  406882
  430228
  513194
  493156
  514273
  516140
  520792
  529209
  490413
  514275
  485061
  569415
  524896
  370949
  407054
  413175
  445065
  418079
  445060
  815410
  453660
  488749
  451456
  468934
  482556
  510296
  519825
  520679
  527779
  546119
  569408
  549507
  561588
  573760
  582591
]
2.79 ms
(1.89%)
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
  370949
  395889
  400513
  406882
  407054
  413175
  414317
  418069
  418073
  418079
  421862
  421872
  422171
  424118
  424274
  425462
  426940
  430228
  433362
  439713
  439753
  439798
  439809
  443348
  445060
  445065
  446522
  446967
  448751
  448996
  449622
  449623
  451456
  453660
  457468
  464337
  468934
  470980
  474780
  474783
  478377
  480246
  481937
  482556
  485061
  488749
  490413
  493156
  496346
  510296
  513194
  514273
  514275
  516140
  516236
  519825
  520679
  520792
  524896
  527779
  529209
  546116
  546119
  547834
  549507
  553972
  556021
  560021
  561588
  569408
  569415
  569972
  573739
  573760
  578037
  582591
  589682
  591010
  591664
  592938
  599524
  621492
  626866
  633529
  673992
  678734
  687561
  691626
  703900
  720120
  726753
  732482
  773850
  782593
  784080
  784776
  786460
  788289
  788295
  788881
  790874
  792531
  792660
  793886
  797909
  799262
  799585
  800936
  801173
  801363
  803297
  805331
  807479
  809482
  810292
  812585
  812891
  813917
  815410
  820330
]
2.16 ms
(1.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom and stepson"
]
1.70 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom stepson"
]
1.44 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.25 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom stepson"
]

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.