Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
199.72 ms
(87.44%)
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
  401737
  412717
  416470
  422287
  426844
  426869
  430299
  437361
  437759
  437982
  438415
  441197
  441907
  442650
  442705
  445638
  449133
  451502
  452312
  452358
  458082
  460458
  463628
  472940
  474053
  480891
  488519
  488692
  488915
  489787
  495432
  496293
  498111
  506136
  509887
  518105
  528390
  528898
  532042
  534722
  544610
  548076
  552337
  552351
  554248
  555599
  560733
  561613
  562047
  564667
  570155
  574675
  579189
  579209
  579734
  579775
  591830
  596789
  599748
  609833
  613615
  614422
  617489
  619878
  620676
  624016
  633527
  636183
  637456
  639157
  670415
  670534
  693576
  697414
  698374
  699604
  701169
  703505
  711590
  714188
  717116
  717493
  719421
  719912
  723945
  723955
  724045
  724456
  727891
  728487
  735554
  740694
  743431
  744563
  747544
  753148
  763482
  766547
  769536
  770600
  772446
  775270
  777733
  779678
  780620
  788158
  790812
  792604
  793567
  797797
  799619
  799978
  805086
  809260
  812817
  825531
]
18.15 ms
(7.95%)
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
  769530
  698374
  701169
  717116
  780620
  792604
  799619
  805086
  412717
  437759
  441197
  426844
  437982
  452312
  451502
  460458
  472940
  509887
  528898
  488915
  495432
  496293
  534722
  506136
  716936
  719421
  670415
  544610
  609833
  633527
  775270
  788158
  723955
  727891
  772446
  724456
  744563
  769536
  723945
  703505
  441907
  401737
  445638
  488692
  518105
  570155
  422287
  416470
  430299
  437361
  442650
  426869
  438415
  442705
  825531
  449133
  452358
  480891
  458082
  498111
  528390
  532042
  474053
  488519
  489787
  552337
  560733
  564667
  574675
  579209
  548076
  552351
  579734
  579775
  717493
  693576
  697414
  670534
  714188
  554248
  555599
  558081
  561613
  562047
  579189
  591830
  596789
  619878
  624016
  636183
  599748
  617489
  637456
  613615
  620676
  639157
  790812
  809260
  812817
  724045
  740694
  770600
  797797
  743431
  766547
  728487
  753148
  735554
  763482
  747544
  614422
  618229
  699604
  711590
  719912
  777733
  779678
  793567
  799978
  463628
]
3.68 ms
(1.61%)
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
  401737
  412717
  416470
  422287
  426844
  426869
  430299
  437361
  437759
  437982
  438415
  441197
  441907
  442650
  442705
  445638
  449133
  451502
  452312
  452358
  458082
  460458
  463628
  472940
  474053
  480891
  488519
  488692
  488915
  489787
  495432
  496293
  498111
  506136
  509887
  518105
  528390
  528898
  532042
  534722
  544610
  548076
  552337
  552351
  554248
  555599
  560733
  561613
  562047
  564667
  570155
  574675
  579189
  579209
  579734
  579775
  591830
  596789
  599748
  609833
  613615
  614422
  617489
  619878
  620676
  624016
  633527
  636183
  637456
  639157
  670415
  670534
  693576
  697414
  698374
  699604
  701169
  703505
  711590
  714188
  717116
  717493
  719421
  719912
  723945
  723955
  724045
  724456
  727891
  728487
  735554
  740694
  743431
  744563
  747544
  753148
  763482
  766547
  769536
  770600
  772446
  775270
  777733
  779678
  780620
  788158
  790812
  792604
  793567
  797797
  799619
  799978
  805086
  809260
  812817
  825531
]
2.10 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur caught"
]
1.77 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск caught"
]
1.51 ms
(0.66%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.47 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск caught"
]

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.