Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.78 ms
(86.36%)
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
  11582
  154463
  386813
  387301
  391027
  400878
  400932
  414048
  415203
  416600
  417075
  417839
  417841
  418825
  423464
  424174
  424556
  424995
  430801
  439109
  439325
  439463
  443335
  444099
  444470
  444638
  446943
  447079
  447526
  447557
  448065
  448317
  448320
  448560
  454091
  457406
  459666
  462623
  464910
  466104
  468122
  469782
  476148
  479726
  485575
  486391
  489573
  497941
  498544
  498649
  501533
  503203
  508224
  515339
  518217
  518233
  519187
  519690
  521970
  522468
  523064
  536819
  536835
  541274
  546665
  558132
  560416
  567335
  575170
  575810
  576412
  577068
  577376
  577520
  577544
  577816
  591468
  596228
  600382
  607021
  607315
  611322
  621648
  622400
  624375
  627635
  628865
  630081
  637520
  641638
  642359
  649163
  649576
  650158
  650802
  653549
  676024
  677295
  687339
  690153
  695262
  695831
  703089
  705160
  708444
  708714
  720401
  721088
  721579
  723492
  724139
  737153
  738786
  748053
  758072
  763437
  765807
  786526
  804756
  814246
]
16.03 ms
(8.30%)
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
  650158
  386813
  11582
  439463
  443335
  454091
  497941
  523064
  498544
  567335
  653549
  596228
  622400
  607315
  591468
  607021
  423464
  417839
  457406
  466104
  417075
  447557
  676024
  154463
  418825
  444099
  448560
  459666
  464910
  476148
  501533
  577376
  708444
  649576
  546665
  577520
  637520
  627635
  765807
  400878
  415203
  424556
  444470
  448065
  536819
  503203
  518217
  521970
  387301
  417841
  430801
  439109
  814246
  508224
  541274
  560416
  650802
  687339
  695262
  695831
  708714
  721579
  720401
  641638
  628865
  804756
  748053
  737153
  724139
  738786
  721088
  723492
  786526
  424174
  448317
  519690
  519187
  400932
  424995
  414048
  690153
  448320
  518233
  515339
  468122
  479726
  577816
  649163
  705160
  577068
  621648
  758072
  763437
  611322
  630081
  703089
  416600
  444638
  469782
  391027
  462623
  446943
  439325
  447526
  522468
  485575
  486391
  498649
  489573
  576412
  575810
  536835
  577544
  575170
  677295
  558132
  600382
  624375
  642359
  447079
]
3.38 ms
(1.75%)
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
  11582
  154463
  386813
  387301
  391027
  400878
  400932
  414048
  415203
  416600
  417075
  417839
  417841
  418825
  423464
  424174
  424556
  424995
  430801
  439109
  439325
  439463
  443335
  444099
  444470
  444638
  446943
  447079
  447526
  447557
  448065
  448317
  448320
  448560
  454091
  457406
  459666
  462623
  464910
  466104
  468122
  469782
  476148
  479726
  485575
  486391
  489573
  497941
  498544
  498649
  501533
  503203
  508224
  515339
  518217
  518233
  519187
  519690
  521970
  522468
  523064
  536819
  536835
  541274
  546665
  558132
  560416
  567335
  575170
  575810
  576412
  577068
  577376
  577520
  577544
  577816
  591468
  596228
  600382
  607021
  607315
  611322
  621648
  622400
  624375
  627635
  628865
  630081
  637520
  641638
  642359
  649163
  649576
  650158
  650802
  653549
  676024
  677295
  687339
  690153
  695262
  695831
  703089
  705160
  708444
  708714
  720401
  721088
  721579
  723492
  724139
  737153
  738786
  748053
  758072
  763437
  765807
  786526
  804756
  814246
]
2.13 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen fucking анал"
]
2.00 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen fucking anal"
]
1.49 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.32 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen fucking анал"
]

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.