Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.03 ms
(86.53%)
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
  382862
  382971
  389863
  406954
  407522
  419492
  421520
  422512
  422515
  422619
  422688
  422694
  422866
  422996
  423129
  424780
  434553
  445596
  448547
  450822
  452513
  454147
  457396
  471667
  473109
  474465
  480378
  484363
  497876
  510258
  512174
  512212
  512217
  516099
  519169
  520540
  529129
  529184
  529602
  530017
  530670
  532161
  535259
  538485
  539192
  544366
  544804
  545610
  550589
  550641
  551012
  554905
  555819
  556369
  556415
  557209
  557503
  558335
  558389
  559942
  565101
  565259
  565982
  565994
  566002
  566074
  566076
  573566
  581797
  582201
  591599
  596323
  596820
  597142
  597246
  601828
  603294
  606864
  609842
  614401
  614538
  619199
  619446
  623617
  623618
  628054
  628388
  630215
  633165
  635190
  663537
  666968
  684211
  702164
  706945
  713551
  714848
  717860
  720056
  724477
  730406
  733598
  741631
  766625
  769337
  775584
  790754
  804776
  807688
  813226
  815275
  815454
  815852
  816935
  818442
  821370
  821605
  824316
  826182
  827918
]
23.93 ms
(9.33%)
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
  684211
  706945
  597246
  422694
  422619
  407522
  457396
  582201
  535259
  473109
  623617
  419492
  663537
  769337
  581797
  454147
  452513
  406954
  421520
  530017
  530670
  565259
  717860
  666968
  597142
  766625
  538485
  714848
  775584
  448547
  573566
  565982
  566002
  566074
  566076
  445596
  480378
  544804
  724477
  422512
  596820
  532161
  565101
  713551
  558335
  804776
  807688
  550641
  389863
  529129
  559942
  702164
  628388
  790754
  450822
  382862
  512217
  619199
  551012
  423129
  815454
  565994
  741631
  733598
  529184
  516099
  555819
  556415
  591599
  596323
  510258
  554905
  826182
  512174
  422866
  529602
  606864
  619446
  614401
  422515
  422688
  520540
  614538
  382971
  512212
  557209
  557503
  471667
  815275
  821370
  821605
  539192
  601828
  623618
  630215
  813226
  434553
  815852
  827918
  558389
  635190
  603294
  497876
  609842
  422996
  545610
  720056
  424780
  484363
  556369
  550589
  628054
  730406
  544366
  633165
  519169
  816935
  818442
  824316
  474465
]
3.61 ms
(1.41%)
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
  382862
  382971
  389863
  406954
  407522
  419492
  421520
  422512
  422515
  422619
  422688
  422694
  422866
  422996
  423129
  424780
  434553
  445596
  448547
  450822
  452513
  454147
  457396
  471667
  473109
  474465
  480378
  484363
  497876
  510258
  512174
  512212
  512217
  516099
  519169
  520540
  529129
  529184
  529602
  530017
  530670
  532161
  535259
  538485
  539192
  544366
  544804
  545610
  550589
  550641
  551012
  554905
  555819
  556369
  556415
  557209
  557503
  558335
  558389
  559942
  565101
  565259
  565982
  565994
  566002
  566074
  566076
  573566
  581797
  582201
  591599
  596323
  596820
  597142
  597246
  601828
  603294
  606864
  609842
  614401
  614538
  619199
  619446
  623617
  623618
  628054
  628388
  630215
  633165
  635190
  663537
  666968
  684211
  702164
  706945
  713551
  714848
  717860
  720056
  724477
  730406
  733598
  741631
  766625
  769337
  775584
  790754
  804776
  807688
  813226
  815275
  815454
  815852
  816935
  818442
  821370
  821605
  824316
  826182
  827918
]
1.84 ms
(0.72%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.84 ms
(0.72%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 young азиатк"
]
1.82 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 young asian"
]
1.53 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 young азиатк"
]

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.