Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.58 ms
(58.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мо жен секс"
]
123.14 ms
(34.40%)
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
  503655
  506428
  509678
  513626
  529575
  535405
  536983
  547609
  557707
  564096
  564691
  591851
  593854
  603680
  606555
  606888
  609986
  613853
  616094
  618124
  618668
  621500
  621634
  623822
  628727
  631025
  641293
  641427
  643530
  645381
  655553
  656841
  663539
  677881
  687458
  690697
  693689
  694334
  702155
  702372
  704981
  705079
  709337
  712775
  716452
  719746
  723831
  723950
  724921
  725590
  726522
  726699
  728502
  729136
  729681
  730413
  730923
  730985
  731279
  732906
  733260
  733468
  734318
  735992
  737509
  737882
  744172
  744480
  745901
  747247
  748082
  748430
  751483
  752923
  759019
  760173
  760789
  762282
  762301
  763905
  764798
  764983
  765823
  766616
  767513
  767816
  767829
  768247
  768742
  772355
  773419
  778437
  778650
  780217
  780392
  784481
  787245
  788673
  788674
  790332
  793247
  795338
  795767
  795880
  795973
  796520
  797411
  798405
  800989
  801050
  801551
  802039
  802050
  802336
  803647
  803792
  807899
  809466
  810330
  813083
]
16.17 ms
(4.52%)
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
  557707
  618668
  616094
  536983
  641293
  677881
  591851
  606888
  693689
  747247
  663539
  809466
  778650
  735992
  732906
  535405
  621500
  788673
  656841
  603680
  618124
  744480
  790332
  733468
  764983
  609986
  613853
  726699
  716452
  503655
  784481
  731279
  796520
  694334
  645381
  621634
  631025
  730413
  759019
  767513
  795880
  795973
  762282
  729136
  767816
  712775
  724921
  628727
  787245
  723831
  751483
  506428
  655553
  704981
  643530
  780392
  737509
  745901
  760789
  564691
  766616
  807899
  513626
  730985
  702372
  641427
  795338
  728502
  719746
  803792
  690697
  810330
  798405
  795767
  801551
  729681
  748082
  767829
  723950
  773419
  802050
  705079
  748430
  606555
  793247
  797411
  800989
  802039
  726522
  760173
  764798
  802336
  768247
  709337
  564096
  623822
  593854
  788674
  780217
  725590
  730923
  733260
  734318
  744172
  752923
  509678
  687458
  702155
  768742
  801050
  765823
  737882
  547609
  778437
  762301
  772355
  813083
  529575
  803647
  763905
]
3.11 ms
(0.87%)
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
  503655
  506428
  509678
  513626
  529575
  535405
  536983
  547609
  557707
  564096
  564691
  591851
  593854
  603680
  606555
  606888
  609986
  613853
  616094
  618124
  618668
  621500
  621634
  623822
  628727
  631025
  641293
  641427
  643530
  645381
  655553
  656841
  663539
  677881
  687458
  690697
  693689
  694334
  702155
  702372
  704981
  705079
  709337
  712775
  716452
  719746
  723831
  723950
  724921
  725590
  726522
  726699
  728502
  729136
  729681
  730413
  730923
  730985
  731279
  732906
  733260
  733468
  734318
  735992
  737509
  737882
  744172
  744480
  745901
  747247
  748082
  748430
  751483
  752923
  759019
  760173
  760789
  762282
  762301
  763905
  764798
  764983
  765823
  766616
  767513
  767816
  767829
  768247
  768742
  772355
  773419
  778437
  778650
  780217
  780392
  784481
  787245
  788673
  788674
  790332
  793247
  795338
  795767
  795880
  795973
  796520
  797411
  798405
  800989
  801050
  801551
  802039
  802050
  802336
  803647
  803792
  807899
  809466
  810330
  813083
]
2.27 ms
(0.63%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.99 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мою жену трахает"
]
1.74 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.