Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.27 ms
(89.41%)
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
  41912
  110884
  117844
  118002
  384121
  390159
  393047
  396120
  398919
  401508
  411643
  416032
  419891
  428224
  429957
  439038
  439138
  439981
  441110
  447159
  450484
  452637
  453585
  454981
  456239
  459429
  460716
  465497
  478904
  483704
  483772
  486767
  487293
  488752
  492181
  496168
  502457
  505590
  507284
  509422
  511251
  511343
  512072
  512935
  514415
  514876
  515435
  521814
  530310
  531887
  534119
  534550
  534555
  536475
  543726
  545467
  547236
  547466
  547468
  547474
  547488
  547853
  547855
  550144
  550938
  550949
  556876
  556887
  561040
  571809
  572654
  573204
  574951
  575418
  575601
  576899
  576989
  581477
  597163
  605026
  605133
  605219
  615693
  615921
  619109
  630732
  633887
  639960
  641997
  652758
  656916
  656933
  660373
  660412
  664149
  668688
  669038
  669080
  671052
  672950
  709693
  710709
  725629
  735194
  736302
  742279
  742353
  743890
  744405
  745125
  752667
  770260
  770265
  782842
  788953
  791012
  800282
  820083
  824340
  825514
]
14.41 ms
(6.16%)
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
  770265
  752667
  725629
  745125
  615693
  454981
  505590
  452637
  668688
  117844
  118002
  820083
  547855
  744405
  736302
  396120
  550949
  439038
  428224
  439981
  465497
  447159
  512072
  512935
  530310
  660412
  660373
  672950
  581477
  597163
  633887
  641997
  770260
  791012
  478904
  483704
  511343
  502457
  496168
  509422
  575601
  393047
  41912
  576989
  782842
  800282
  486767
  515435
  507284
  514876
  521814
  571809
  619109
  511251
  514415
  574951
  652758
  709693
  450484
  110884
  390159
  398919
  429957
  547853
  576899
  543726
  550144
  550938
  630732
  483772
  556887
  656933
  639960
  441110
  419891
  411643
  492181
  534550
  536475
  547466
  547488
  556876
  573204
  547468
  547474
  669038
  671052
  664149
  669080
  561040
  605133
  605219
  615921
  605026
  788953
  743890
  742279
  439138
  460716
  456239
  416032
  488752
  401508
  710709
  534555
  575418
  572654
  735194
  742353
  384121
  453585
  534119
  824340
  825514
  459429
  487293
  531887
  545467
  547236
  656916
]
4.32 ms
(1.85%)
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
  41912
  110884
  117844
  118002
  384121
  390159
  393047
  396120
  398919
  401508
  411643
  416032
  419891
  428224
  429957
  439038
  439138
  439981
  441110
  447159
  450484
  452637
  453585
  454981
  456239
  459429
  460716
  465497
  478904
  483704
  483772
  486767
  487293
  488752
  492181
  496168
  502457
  505590
  507284
  509422
  511251
  511343
  512072
  512935
  514415
  514876
  515435
  521814
  530310
  531887
  534119
  534550
  534555
  536475
  543726
  545467
  547236
  547466
  547468
  547474
  547488
  547853
  547855
  550144
  550938
  550949
  556876
  556887
  561040
  571809
  572654
  573204
  574951
  575418
  575601
  576899
  576989
  581477
  597163
  605026
  605133
  605219
  615693
  615921
  619109
  630732
  633887
  639960
  641997
  652758
  656916
  656933
  660373
  660412
  664149
  668688
  669038
  669080
  671052
  672950
  709693
  710709
  725629
  735194
  736302
  742279
  742353
  743890
  744405
  745125
  752667
  770260
  770265
  782842
  788953
  791012
  800282
  820083
  824340
  825514
]
1.61 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "фистинг дом"
]
1.54 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фистинг домашн любительск"
]
1.36 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.