Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.05 ms
(88.33%)
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
  113322
  182689
  188335
  223010
  336058
  381757
  381941
  382130
  382402
  382906
  383237
  385933
  391696
  391989
  392489
  394120
  396353
  398229
  398615
  398932
  400855
  401003
  403426
  405146
  405446
  405847
  413335
  421883
  422193
  428580
  433353
  440781
  441063
  441774
  441782
  441785
  442057
  447022
  448670
  453091
  459638
  460672
  466312
  468357
  471179
  474498
  478611
  488947
  490707
  508807
  517696
  547032
  557612
  558288
  561992
  562599
  584056
  585434
  597099
  609083
  643689
  650969
  660061
  664318
  665100
  665289
  666094
  666121
  666778
  667597
  680297
  706232
  712622
  713422
  713426
  713429
  713448
  724489
  724592
  725620
  726650
  730109
  733169
  735944
  736472
  739935
  740238
  755601
  759759
  761072
  765476
  769491
  770125
  771477
  782001
  794853
  794855
  794867
  794872
  794873
  795921
  795927
  795947
  795951
  795974
  796679
  797521
  798773
  807033
  808045
  817961
  819411
  824747
  824961
  826287
  827329
  828036
  828200
  828201
  828334
]
13.49 ms
(6.66%)
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
  736472
  733169
  726650
  807033
  468357
  396353
  398615
  401003
  448670
  490707
  561992
  665100
  666778
  794867
  770125
  453091
  474498
  517696
  405446
  712622
  713429
  713426
  713422
  724592
  730109
  725620
  740238
  713448
  385933
  223010
  405146
  667597
  664318
  557612
  794872
  724489
  782001
  381941
  828201
  383237
  398229
  413335
  441782
  488947
  794853
  759759
  442057
  478611
  558288
  466312
  405847
  428580
  460672
  447022
  188335
  609083
  113322
  403426
  471179
  808045
  382906
  182689
  441774
  459638
  660061
  597099
  508807
  562599
  394120
  391696
  382402
  400855
  827329
  819411
  824961
  826287
  650969
  706232
  680297
  585434
  643689
  794873
  795947
  797521
  735944
  755601
  765476
  771477
  794855
  795927
  796679
  739935
  761072
  795921
  795951
  795974
  798773
  828036
  828200
  828334
  422193
  391989
  769491
  440781
  441063
  421883
  398932
  381757
  441785
  392489
  433353
  336058
  382130
  824747
  817961
  584056
  547032
  665289
  666121
  666094
]
2.78 ms
(1.37%)
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
  113322
  182689
  188335
  223010
  336058
  381757
  381941
  382130
  382402
  382906
  383237
  385933
  391696
  391989
  392489
  394120
  396353
  398229
  398615
  398932
  400855
  401003
  403426
  405146
  405446
  405847
  413335
  421883
  422193
  428580
  433353
  440781
  441063
  441774
  441782
  441785
  442057
  447022
  448670
  453091
  459638
  460672
  466312
  468357
  471179
  474498
  478611
  488947
  490707
  508807
  517696
  547032
  557612
  558288
  561992
  562599
  584056
  585434
  597099
  609083
  643689
  650969
  660061
  664318
  665100
  665289
  666094
  666121
  666778
  667597
  680297
  706232
  712622
  713422
  713426
  713429
  713448
  724489
  724592
  725620
  726650
  730109
  733169
  735944
  736472
  739935
  740238
  755601
  759759
  761072
  765476
  769491
  770125
  771477
  782001
  794853
  794855
  794867
  794872
  794873
  795921
  795927
  795947
  795951
  795974
  796679
  797521
  798773
  807033
  808045
  817961
  819411
  824747
  824961
  826287
  827329
  828036
  828200
  828201
  828334
]
2.10 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother chubby"
]
1.83 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.77 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин chubby"
]
1.67 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин chubby"
]

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.