Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.78 ms
(84.73%)
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
  154257
  391920
  411015
  424234
  424411
  427487
  441829
  441841
  442080
  442107
  442132
  449094
  453135
  455539
  456697
  460741
  460752
  461186
  461619
  463204
  464853
  464878
  468654
  468675
  469106
  470404
  477975
  478776
  481445
  482499
  483425
  487381
  487396
  489398
  490098
  491116
  491769
  493543
  494870
  497206
  498585
  499617
  504214
  510775
  515003
  518192
  518358
  520514
  530247
  530318
  535384
  536421
  536440
  541317
  542093
  547849
  549193
  549799
  554235
  554554
  555024
  555134
  559298
  563023
  563690
  566488
  579207
  583547
  583686
  584385
  593014
  596766
  597149
  599550
  604313
  604343
  605274
  605742
  616849
  620211
  632123
  653330
  680441
  680459
  686185
  710396
  710424
  714036
  717244
  724552
  727743
  727745
  728255
  728415
  741687
  742402
  742415
  744970
  752984
  756535
  757445
  759891
  759902
  766623
  775228
  784592
  787488
  792540
  793182
  793187
  795313
  796139
  800429
  801063
  804022
  804417
  804434
  806184
  809811
  814022
]
16.97 ms
(9.35%)
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
  804417
  463204
  583686
  728255
  441841
  461186
  549799
  453135
  489398
  491769
  555024
  680441
  579207
  741687
  411015
  477975
  391920
  497206
  510775
  752984
  555134
  530318
  536440
  535384
  549193
  680459
  727745
  759891
  756535
  801063
  456697
  424411
  441829
  442107
  814022
  461619
  468654
  515003
  554554
  584385
  541317
  620211
  795313
  800429
  759902
  724552
  742402
  757445
  792540
  469106
  424234
  483425
  504214
  468675
  520514
  597149
  530247
  547849
  804022
  455539
  498585
  482499
  442080
  563023
  464853
  493543
  464878
  470404
  481445
  518358
  494870
  518192
  536421
  491116
  583547
  542093
  710424
  653330
  714036
  717244
  559298
  563690
  566488
  596766
  604343
  593014
  632123
  604313
  605274
  616849
  775228
  787488
  793187
  727743
  796139
  809811
  744970
  728415
  742415
  784592
  793182
  804434
  806184
  449094
  154257
  427487
  442132
  478776
  499617
  487381
  487396
  766623
  710396
  460741
  490098
  554235
  686185
  599550
  605742
  460752
]
3.50 ms
(1.93%)
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
  154257
  391920
  411015
  424234
  424411
  427487
  441829
  441841
  442080
  442107
  442132
  449094
  453135
  455539
  456697
  460741
  460752
  461186
  461619
  463204
  464853
  464878
  468654
  468675
  469106
  470404
  477975
  478776
  481445
  482499
  483425
  487381
  487396
  489398
  490098
  491116
  491769
  493543
  494870
  497206
  498585
  499617
  504214
  510775
  515003
  518192
  518358
  520514
  530247
  530318
  535384
  536421
  536440
  541317
  542093
  547849
  549193
  549799
  554235
  554554
  555024
  555134
  559298
  563023
  563690
  566488
  579207
  583547
  583686
  584385
  593014
  596766
  597149
  599550
  604313
  604343
  605274
  605742
  616849
  620211
  632123
  653330
  680441
  680459
  686185
  710396
  710424
  714036
  717244
  724552
  727743
  727745
  728255
  728415
  741687
  742402
  742415
  744970
  752984
  756535
  757445
  759891
  759902
  766623
  775228
  784592
  787488
  792540
  793182
  793187
  795313
  796139
  800429
  801063
  804022
  804417
  804434
  806184
  809811
  814022
]
2.04 ms
(1.13%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.04 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature wife slut"
]
1.71 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature жен slut"
]
1.44 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature жен slut"
]

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.