Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
341.80 ms
(91.60%)
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
  381783
  386813
  402088
  407136
  407687
  412875
  415286
  418272
  419625
  426944
  427971
  431523
  436776
  438363
  438364
  439617
  442441
  443017
  443107
  443801
  444041
  444399
  445324
  445475
  448255
  450172
  454052
  454649
  454917
  454992
  457045
  459248
  463663
  466342
  467552
  468186
  470443
  473627
  474077
  474821
  475183
  476714
  484836
  486532
  486862
  488541
  488809
  489197
  489388
  494496
  495138
  495682
  498405
  498457
  498511
  500175
  501713
  503418
  506436
  507797
  509726
  510079
  511085
  516713
  517831
  518975
  519845
  521152
  531197
  531935
  532351
  532915
  533807
  539147
  539662
  542275
  546419
  550689
  551559
  556502
  558804
  559884
  561338
  561345
  565077
  565720
  575441
  579470
  580398
  580642
  581450
  592921
  598667
  607454
  620057
  620093
  622063
  630639
  633818
  635577
  639253
  647305
  660582
  661286
  684704
  686207
  697006
  699611
  726475
  747195
  747228
  747231
  747236
  756212
  756585
  762400
  766616
  785421
  792555
  813250
]
20.49 ms
(5.49%)
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
  792555
  486532
  476714
  474077
  532915
  558804
  542275
  620093
  747195
  747228
  762400
  756212
  438364
  454052
  466342
  445475
  489197
  488809
  445324
  474821
  495138
  498405
  531197
  509726
  519845
  533807
  539662
  531935
  546419
  559884
  660582
  699611
  661286
  607454
  785421
  747231
  756585
  407687
  419625
  426944
  444041
  468186
  444399
  454917
  511085
  418272
  486862
  427971
  498457
  503418
  518975
  473627
  489388
  579470
  686207
  551559
  580642
  592921
  635577
  622063
  813250
  448255
  402088
  412875
  439617
  443801
  470443
  498511
  488541
  386813
  415286
  561345
  581450
  726475
  620057
  475183
  521152
  647305
  436776
  442441
  501713
  484836
  495682
  454649
  457045
  454992
  516713
  556502
  639253
  747236
  438363
  463663
  506436
  517831
  494496
  381783
  407136
  459248
  467552
  500175
  539147
  575441
  580398
  550689
  565077
  697006
  630639
  633818
  443017
  510079
  450172
  507797
  532351
  565720
  561338
  684704
  598667
  766616
  431523
  443107
]
2.81 ms
(0.75%)
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
  381783
  386813
  402088
  407136
  407687
  412875
  415286
  418272
  419625
  426944
  427971
  431523
  436776
  438363
  438364
  439617
  442441
  443017
  443107
  443801
  444041
  444399
  445324
  445475
  448255
  450172
  454052
  454649
  454917
  454992
  457045
  459248
  463663
  466342
  467552
  468186
  470443
  473627
  474077
  474821
  475183
  476714
  484836
  486532
  486862
  488541
  488809
  489197
  489388
  494496
  495138
  495682
  498405
  498457
  498511
  500175
  501713
  503418
  506436
  507797
  509726
  510079
  511085
  516713
  517831
  518975
  519845
  521152
  531197
  531935
  532351
  532915
  533807
  539147
  539662
  542275
  546419
  550689
  551559
  556502
  558804
  559884
  561338
  561345
  565077
  565720
  575441
  579470
  580398
  580642
  581450
  592921
  598667
  607454
  620057
  620093
  622063
  630639
  633818
  635577
  639253
  647305
  660582
  661286
  684704
  686207
  697006
  699611
  726475
  747195
  747228
  747231
  747236
  756212
  756585
  762400
  766616
  785421
  792555
  813250
]
2.53 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sucking big boobs"
]
2.05 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "sucking большие boobs"
]
1.76 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "sucking большие boobs"
]
1.69 ms
(0.45%)
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.