Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.98 ms
(83.34%)
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
  78307
  156688
  383107
  386514
  396115
  411219
  415858
  418064
  423426
  431488
  433566
  445751
  445946
  448040
  448987
  450219
  456265
  458742
  459593
  459655
  460194
  460691
  461124
  461516
  461545
  465930
  466322
  467617
  472172
  472349
  477467
  478260
  478325
  478526
  478534
  479814
  480831
  481664
  482120
  485996
  487025
  487086
  491535
  491637
  491671
  495715
  500463
  502086
  508881
  511720
  511743
  511746
  512239
  512242
  512297
  512335
  516161
  516270
  517604
  518756
  519927
  520185
  522590
  540530
  542056
  552783
  560464
  560476
  574746
  574758
  574765
  574843
  574871
  575148
  575757
  575806
  576408
  603179
  603623
  605520
  606690
  624650
  630916
  654575
  654583
  655094
  655110
  655715
  656453
  656696
  656965
  656988
  657315
  657352
  657375
  657608
  657697
  658646
  658713
  660523
  661333
  663430
  663456
  663863
  663952
  668440
  678967
  681893
  721219
  731326
  732892
  745844
  747919
  755447
  802067
  807725
  812305
  817122
  819747
  823562
]
15.72 ms
(10.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
  386514
  460691
  663952
  445751
  491637
  491535
  575757
  681893
  603179
  605520
  732892
  78307
  472349
  433566
  480831
  411219
  512242
  745844
  755447
  383107
  819747
  540530
  656696
  657315
  657697
  663430
  663863
  654583
  657375
  721219
  654575
  655715
  657608
  658713
  668440
  624650
  747919
  478534
  500463
  485996
  552783
  678967
  802067
  731326
  630916
  481664
  450219
  482120
  478526
  479814
  518756
  516270
  396115
  418064
  423426
  431488
  477467
  445946
  448040
  461124
  517604
  511720
  478325
  560476
  576408
  574746
  560464
  574871
  663456
  574843
  575148
  606690
  807725
  458742
  156688
  459655
  460194
  466322
  478260
  415858
  456265
  459593
  461516
  461545
  465930
  467617
  472172
  511743
  511746
  520185
  522590
  487086
  512335
  516161
  487025
  495715
  508881
  512297
  491671
  512239
  448987
  542056
  575806
  603623
  519927
  817122
  823562
  661333
  660523
  812305
  502086
  574758
  574765
  656988
  658646
  655094
  655110
  657352
  656453
  656965
]
3.23 ms
(2.06%)
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
  78307
  156688
  383107
  386514
  396115
  411219
  415858
  418064
  423426
  431488
  433566
  445751
  445946
  448040
  448987
  450219
  456265
  458742
  459593
  459655
  460194
  460691
  461124
  461516
  461545
  465930
  466322
  467617
  472172
  472349
  477467
  478260
  478325
  478526
  478534
  479814
  480831
  481664
  482120
  485996
  487025
  487086
  491535
  491637
  491671
  495715
  500463
  502086
  508881
  511720
  511743
  511746
  512239
  512242
  512297
  512335
  516161
  516270
  517604
  518756
  519927
  520185
  522590
  540530
  542056
  552783
  560464
  560476
  574746
  574758
  574765
  574843
  574871
  575148
  575757
  575806
  576408
  603179
  603623
  605520
  606690
  624650
  630916
  654575
  654583
  655094
  655110
  655715
  656453
  656696
  656965
  656988
  657315
  657352
  657375
  657608
  657697
  658646
  658713
  660523
  661333
  663430
  663456
  663863
  663952
  668440
  678967
  681893
  721219
  731326
  732892
  745844
  747919
  755447
  802067
  807725
  812305
  817122
  819747
  823562
]
2.00 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cuckold licking"
]
1.68 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куколд лиза"
]
1.67 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.