Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
247.59 ms
(91.31%)
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
  7178
  157194
  233135
  304572
  398800
  398811
  401014
  401114
  401666
  402375
  405188
  407970
  413183
  414643
  426378
  435700
  445740
  457943
  461402
  468581
  468884
  473921
  482519
  504211
  510132
  511869
  513114
  513817
  516012
  517074
  522614
  524755
  526828
  530788
  531137
  534641
  535611
  536230
  536335
  536554
  544747
  554752
  563864
  564731
  568560
  573320
  586456
  590302
  591353
  593605
  601553
  604313
  608569
  612816
  613122
  619652
  621315
  625523
  637755
  640771
  656206
  664087
  670753
  671758
  681686
  683003
  683826
  687211
  694479
  698554
  699590
  704928
  715807
  718701
  718746
  718784
  723643
  725581
  725974
  735774
  740617
  741291
  741607
  744654
  747310
  750545
  751510
  751611
  756426
  756499
  759982
  767175
  770402
  775848
  777544
  778774
  784569
  785847
  786195
  793951
  795538
  798929
  800288
  801261
  801267
  805222
  805431
  805706
  805735
  806686
  808401
  809131
  812715
  814178
  815053
  815480
  815508
  816545
  823593
  824500
]
13.09 ms
(4.83%)
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
  715807
  401114
  656206
  784569
  770402
  815053
  699590
  808401
  785847
  805735
  759982
  814178
  457943
  524755
  535611
  536554
  511869
  516012
  531137
  513817
  461402
  563864
  564731
  573320
  544747
  568560
  683003
  718784
  683826
  704928
  718701
  554752
  608569
  612816
  613122
  604313
  586456
  601553
  795538
  805222
  805431
  800288
  806686
  751611
  741607
  767175
  747310
  725581
  741291
  744654
  751510
  777544
  468581
  7178
  398800
  401666
  413183
  402375
  473921
  233135
  401014
  414643
  522614
  510132
  513114
  698554
  687211
  805706
  398811
  815480
  816545
  823593
  824500
  671758
  718746
  670753
  694479
  786195
  801261
  756426
  750545
  725974
  637755
  778774
  812715
  304572
  591353
  798929
  482519
  536335
  530788
  681686
  640771
  435700
  405188
  445740
  526828
  504211
  534641
  809131
  775848
  157194
  407970
  426378
  468884
  517074
  815508
  723643
  536230
  664087
  619652
  621315
  801267
  756499
  793951
  590302
  593605
  740617
  735774
  625523
]
2.78 ms
(1.02%)
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
  7178
  157194
  233135
  304572
  398800
  398811
  401014
  401114
  401666
  402375
  405188
  407970
  413183
  414643
  426378
  435700
  445740
  457943
  461402
  468581
  468884
  473921
  482519
  504211
  510132
  511869
  513114
  513817
  516012
  517074
  522614
  524755
  526828
  530788
  531137
  534641
  535611
  536230
  536335
  536554
  544747
  554752
  563864
  564731
  568560
  573320
  586456
  590302
  591353
  593605
  601553
  604313
  608569
  612816
  613122
  619652
  621315
  625523
  637755
  640771
  656206
  664087
  670753
  671758
  681686
  683003
  683826
  687211
  694479
  698554
  699590
  704928
  715807
  718701
  718746
  718784
  723643
  725581
  725974
  735774
  740617
  741291
  741607
  744654
  747310
  750545
  751510
  751611
  756426
  756499
  759982
  767175
  770402
  775848
  777544
  778774
  784569
  785847
  786195
  793951
  795538
  798929
  800288
  801261
  801267
  805222
  805431
  805706
  805735
  806686
  808401
  809131
  812715
  814178
  815053
  815480
  815508
  816545
  823593
  824500
]
2.05 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty milf анал"
]
1.95 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty milf anal"
]
1.89 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty milf анал"
]

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.