Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.70 ms
(85.93%)
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
  398747
  417154
  420405
  458781
  459368
  487466
  499578
  511615
  513570
  518152
  528371
  534515
  547608
  552287
  557833
  559318
  559326
  562984
  570131
  577446
  579368
  585256
  608609
  612285
  616509
  623293
  623918
  624232
  626579
  626791
  630136
  630140
  632089
  637311
  644171
  649066
  654691
  660098
  665995
  667187
  674502
  676652
  677586
  678214
  678219
  693009
  693511
  695764
  697188
  699233
  699543
  703765
  706379
  707485
  708743
  709458
  711710
  713601
  714953
  715362
  715442
  715489
  716956
  717219
  717546
  718648
  718913
  724889
  725219
  727283
  729694
  734296
  734569
  736981
  738127
  744184
  745610
  747240
  747981
  748000
  753210
  753281
  758747
  760440
  761384
  762024
  764005
  768072
  770373
  771935
  778481
  779150
  787775
  790815
  791267
  791672
  792775
  793084
  793521
  793827
  794109
  794110
  794394
  794418
  794442
  794460
  794511
  794532
  794712
  794871
  794893
  795038
  795381
  796490
  802043
  802310
  803614
  805259
  807245
  811875
]
12.91 ms
(7.88%)
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
  729694
  753281
  758747
  770373
  734569
  707485
  715489
  807245
  398747
  699543
  420405
  511615
  499578
  487466
  559326
  649066
  693511
  708743
  718913
  667187
  674502
  695764
  717219
  608609
  623293
  644171
  623918
  778481
  779150
  791672
  794418
  794511
  793084
  794109
  794712
  724889
  734296
  794110
  794893
  796490
  803614
  725219
  747240
  748000
  745610
  753210
  747981
  727283
  736981
  624232
  697188
  715362
  718648
  793521
  794460
  794871
  802310
  811875
  791267
  738127
  709458
  579368
  711710
  717546
  795038
  762024
  458781
  562984
  714953
  585256
  616509
  794394
  790815
  794442
  794532
  761384
  632089
  805259
  630136
  518152
  654691
  744184
  792775
  793827
  764005
  534515
  513570
  547608
  660098
  665995
  678214
  678219
  676652
  637311
  626791
  787775
  795381
  760440
  768072
  771935
  630140
  715442
  557833
  559318
  577446
  459368
  417154
  528371
  552287
  570131
  677586
  703765
  716956
  693009
  699233
  706379
  713601
  612285
  626579
  802043
]
3.02 ms
(1.84%)
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
  398747
  417154
  420405
  458781
  459368
  487466
  499578
  511615
  513570
  518152
  528371
  534515
  547608
  552287
  557833
  559318
  559326
  562984
  570131
  577446
  579368
  585256
  608609
  612285
  616509
  623293
  623918
  624232
  626579
  626791
  630136
  630140
  632089
  637311
  644171
  649066
  654691
  660098
  665995
  667187
  674502
  676652
  677586
  678214
  678219
  693009
  693511
  695764
  697188
  699233
  699543
  703765
  706379
  707485
  708743
  709458
  711710
  713601
  714953
  715362
  715442
  715489
  716956
  717219
  717546
  718648
  718913
  724889
  725219
  727283
  729694
  734296
  734569
  736981
  738127
  744184
  745610
  747240
  747981
  748000
  753210
  753281
  758747
  760440
  761384
  762024
  764005
  768072
  770373
  771935
  778481
  779150
  787775
  790815
  791267
  791672
  792775
  793084
  793521
  793827
  794109
  794110
  794394
  794418
  794442
  794460
  794511
  794532
  794712
  794871
  794893
  795038
  795381
  796490
  802043
  802310
  803614
  805259
  807245
  811875
]
1.88 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm inside pussy"
]
1.81 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм inside pussy"
]
1.77 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм inside pussy"
]

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.