Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.63 ms
(85.85%)
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
  7748
  31134
  388098
  392750
  394582
  395292
  416277
  423129
  432366
  432556
  433384
  437974
  439668
  440871
  448096
  451629
  452312
  453295
  453300
  455278
  459241
  460627
  469418
  470652
  472016
  472134
  477168
  480833
  489634
  489776
  489791
  490514
  493299
  494703
  497197
  504964
  506552
  509651
  514116
  515592
  520201
  524955
  527739
  528088
  528187
  531268
  531945
  532706
  547409
  552367
  553359
  555900
  564113
  567076
  573381
  577718
  579300
  580022
  580653
  596234
  596704
  603847
  623650
  626231
  628459
  629409
  645387
  650011
  666991
  672903
  688254
  693396
  716267
  718909
  727017
  735834
  735840
  735868
  735875
  735959
  737178
  739700
  741009
  741084
  742545
  746461
  756058
  760534
  761858
  762670
  765557
  769094
  773000
  775054
  775690
  775818
  775857
  778034
  784857
  785062
  793496
  796959
  798600
  799522
  800620
  800623
  801430
  803906
  803910
  807367
  810479
  811246
  815117
  816959
  817080
  817348
  817371
  817416
  817889
  828337
]
14.73 ms
(7.54%)
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
  784857
  531268
  531945
  762670
  528088
  552367
  453295
  392750
  815117
  453300
  524955
  580653
  547409
  564113
  718909
  650011
  567076
  737178
  775818
  480833
  470652
  416277
  553359
  580022
  628459
  432556
  515592
  716267
  472134
  506552
  497197
  493299
  448096
  494703
  437974
  504964
  440871
  459241
  672903
  773000
  528187
  490514
  596234
  439668
  520201
  489791
  395292
  451629
  469418
  455278
  514116
  735840
  472016
  433384
  828337
  688254
  489776
  742545
  394582
  666991
  746461
  739700
  489634
  532706
  579300
  756058
  810479
  452312
  388098
  423129
  817371
  817416
  817080
  817889
  816959
  460627
  555900
  577718
  573381
  693396
  626231
  629409
  596704
  623650
  775690
  798600
  741009
  741084
  761858
  765557
  760534
  603847
  432366
  527739
  31134
  817348
  477168
  645387
  775054
  793496
  775857
  796959
  799522
  800623
  801430
  735959
  769094
  785062
  735875
  727017
  735834
  735868
  778034
  800620
  803906
  803910
  807367
  811246
  7748
  509651
]
4.93 ms
(2.52%)
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
  7748
  31134
  388098
  392750
  394582
  395292
  416277
  423129
  432366
  432556
  433384
  437974
  439668
  440871
  448096
  451629
  452312
  453295
  453300
  455278
  459241
  460627
  469418
  470652
  472016
  472134
  477168
  480833
  489634
  489776
  489791
  490514
  493299
  494703
  497197
  504964
  506552
  509651
  514116
  515592
  520201
  524955
  527739
  528088
  528187
  531268
  531945
  532706
  547409
  552367
  553359
  555900
  564113
  567076
  573381
  577718
  579300
  580022
  580653
  596234
  596704
  603847
  623650
  626231
  628459
  629409
  645387
  650011
  666991
  672903
  688254
  693396
  716267
  718909
  727017
  735834
  735840
  735868
  735875
  735959
  737178
  739700
  741009
  741084
  742545
  746461
  756058
  760534
  761858
  762670
  765557
  769094
  773000
  775054
  775690
  775818
  775857
  778034
  784857
  785062
  793496
  796959
  798600
  799522
  800620
  800623
  801430
  803906
  803910
  807367
  810479
  811246
  815117
  816959
  817080
  817348
  817371
  817416
  817889
  828337
]
2.18 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамки дрочит член"
]
2.07 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин дрочк член"
]
1.89 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин дрочк член"
]
1.84 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.