Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.02 ms
(85.20%)
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
  7456
  308582
  330565
  393347
  393538
  401553
  442452
  442649
  454023
  454342
  505174
  506771
  530173
  530546
  538057
  546674
  546751
  554017
  558726
  563497
  565123
  585677
  593317
  598307
  600199
  623633
  626883
  628703
  629565
  630011
  632232
  638186
  640293
  641627
  643458
  650524
  663358
  663863
  665103
  671097
  671127
  671136
  672829
  673752
  684865
  687118
  688721
  688938
  694568
  695390
  705117
  708543
  708612
  714252
  714408
  715478
  718489
  724503
  730822
  732821
  733081
  736159
  736183
  738147
  738520
  743119
  743235
  744062
  745616
  749050
  752239
  752429
  755942
  760961
  761259
  768570
  768630
  772105
  773437
  777835
  778158
  780109
  783247
  786222
  786485
  790604
  790991
  797177
  803773
  804724
  805986
  806540
  807088
  807625
  808642
  810280
  812441
  812516
  812801
  816215
  817333
  817575
  817775
  818858
  818949
  819531
  820358
  821988
  823257
  823430
  823464
  823772
  824366
  824674
  826714
  826990
  827537
  828306
  828547
]
10.37 ms
(7.30%)
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
  308582
  673752
  714252
  752429
  786485
  824674
  817575
  565123
  665103
  688938
  641627
  593317
  643458
  623633
  632232
  808642
  804724
  797177
  730822
  733081
  738520
  803773
  330565
  506771
  724503
  393347
  828306
  687118
  598307
  773437
  807625
  818949
  823464
  824366
  817775
  821988
  454023
  530546
  554017
  585677
  638186
  790604
  812801
  783247
  755942
  786222
  806540
  810280
  732821
  736159
  736183
  744062
  749050
  768570
  780109
  790991
  812516
  454342
  393538
  7456
  820358
  823257
  826990
  827537
  823430
  816215
  818858
  819531
  828547
  505174
  563497
  546674
  663863
  671127
  708612
  671136
  688721
  671097
  694568
  708543
  626883
  600199
  777835
  778158
  805986
  812441
  738147
  743119
  743235
  772105
  745616
  761259
  752239
  768442
  768630
  760961
  630011
  705117
  718489
  807088
  715478
  401553
  442649
  442452
  826714
  823772
  817333
  530173
  538057
  546751
  558726
  650524
  672829
  695390
  714408
  663358
  684865
  629565
  640293
  628703
]
3.09 ms
(2.17%)
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
  7456
  308582
  330565
  393347
  393538
  401553
  442452
  442649
  454023
  454342
  505174
  506771
  530173
  530546
  538057
  546674
  546751
  554017
  558726
  563497
  565123
  585677
  593317
  598307
  600199
  623633
  626883
  628703
  629565
  630011
  632232
  638186
  640293
  641627
  643458
  650524
  663358
  663863
  665103
  671097
  671127
  671136
  672829
  673752
  684865
  687118
  688721
  688938
  694568
  695390
  705117
  708543
  708612
  714252
  714408
  715478
  718489
  724503
  730822
  732821
  733081
  736159
  736183
  738147
  738520
  743119
  743235
  744062
  745616
  749050
  752239
  752429
  755942
  760961
  761259
  768570
  768630
  772105
  773437
  777835
  778158
  780109
  783247
  786222
  786485
  790604
  790991
  797177
  803773
  804724
  805986
  806540
  807088
  807625
  808642
  810280
  812441
  812516
  812801
  816215
  817333
  817575
  817775
  818858
  818949
  819531
  820358
  821988
  823257
  823430
  823464
  823772
  824366
  824674
  826714
  826990
  827537
  828306
  828547
]
2.08 ms
(1.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sexy сиськ"
]
1.96 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sexy tits"
]
1.95 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sexy сиськ"
]

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.