Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.47 ms
(33.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая большие cock"
]
208.76 ms
(33.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
184.26 ms
(29.26%)
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
  78620
  388673
  548610
  550418
  552187
  552251
  552691
  553154
  554746
  556328
  557632
  558911
  559179
  559721
  560653
  562779
  563336
  563834
  566845
  568517
  569849
  570041
  570289
  570380
  570384
  571092
  571546
  571592
  571894
  572488
  572522
  572538
  572801
  573385
  573544
  573616
  573792
  573848
  573895
  575075
  575344
  576836
  580271
  581699
  582980
  584723
  585263
  586562
  589712
  590378
  591652
  595424
  595478
  595907
  600311
  604145
  606764
  607053
  608765
  616346
  618532
  621081
  621967
  622400
  622510
  623004
  624296
  630527
  632860
  633687
  645934
  645944
  650126
  651875
  652949
  654094
  654481
  654490
  654574
  655346
  655628
  655994
  656677
  657370
  657571
  657649
  657674
  657729
  657996
  658035
  658335
  658616
  659329
  659504
  659584
  659589
  659605
  660316
  660515
  660942
  670064
  671665
  681343
  682211
  690032
  695515
  699678
  714472
  714478
  714532
  716559
  717719
  720339
  720822
  721600
  721736
  723604
  746155
  761459
  820471
]
20.48 ms
(3.25%)
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
  746155
  580271
  622400
  630527
  608765
  595907
  552251
  761459
  78620
  388673
  723604
  820471
  548610
  552691
  570380
  571894
  572488
  572538
  573385
  573792
  575344
  552187
  556328
  557632
  559179
  560653
  563834
  570289
  572801
  584723
  550418
  566845
  568517
  570384
  571546
  571592
  573616
  573848
  576836
  581699
  582980
  645934
  650126
  651875
  652949
  654094
  654481
  654574
  655628
  655994
  657571
  658616
  659589
  660515
  660942
  671665
  699678
  714472
  720822
  721736
  645944
  654490
  657370
  657649
  657729
  657996
  658035
  658335
  659504
  659605
  660316
  670064
  695515
  714478
  716559
  720339
  721600
  655346
  656677
  657674
  659329
  659584
  681343
  682211
  690032
  714532
  717719
  553154
  554746
  558911
  559721
  562779
  563336
  569849
  570041
  571092
  572522
  573544
  573895
  575075
  589712
  606764
  607053
  616346
  618532
  623004
  585263
  590378
  595424
  595478
  600311
  621967
  624296
  586562
  591652
  604145
  621081
  622510
  632860
  633687
]
2.71 ms
(0.43%)
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
  78620
  388673
  548610
  550418
  552187
  552251
  552691
  553154
  554746
  556328
  557632
  558911
  559179
  559721
  560653
  562779
  563336
  563834
  566845
  568517
  569849
  570041
  570289
  570380
  570384
  571092
  571546
  571592
  571894
  572488
  572522
  572538
  572801
  573385
  573544
  573616
  573792
  573848
  573895
  575075
  575344
  576836
  580271
  581699
  582980
  584723
  585263
  586562
  589712
  590378
  591652
  595424
  595478
  595907
  600311
  604145
  606764
  607053
  608765
  616346
  618532
  621081
  621967
  622400
  622510
  623004
  624296
  630527
  632860
  633687
  645934
  645944
  650126
  651875
  652949
  654094
  654481
  654490
  654574
  655346
  655628
  655994
  656677
  657370
  657571
  657649
  657674
  657729
  657996
  658035
  658335
  658616
  659329
  659504
  659584
  659589
  659605
  660316
  660515
  660942
  670064
  671665
  681343
  682211
  690032
  695515
  699678
  714472
  714478
  714532
  716559
  717719
  720339
  720822
  721600
  721736
  723604
  746155
  761459
  820471
]
2.37 ms
(0.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small big cock"
]
1.66 ms
(0.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая большие cock"
]

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.