Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.69 ms
(56.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "love tits"
]
141.75 ms
(38.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
  21221
  386195
  386228
  389657
  413125
  420240
  428360
  429755
  452204
  458238
  499042
  519556
  521860
  526031
  539550
  540535
  543694
  555506
  565902
  586924
  593919
  595645
  598181
  600022
  607414
  628912
  630045
  633340
  633491
  635662
  635721
  640304
  644142
  655005
  656363
  670946
  678131
  681281
  689857
  691479
  696785
  705067
  714808
  723522
  726263
  727589
  730790
  731186
  732226
  732982
  733089
  736465
  740181
  745513
  746452
  750535
  755111
  756256
  757987
  759483
  760120
  762748
  765556
  765909
  765913
  768301
  770423
  771979
  771990
  772388
  772394
  773621
  778058
  778750
  781368
  781748
  781963
  788917
  791262
  791306
  791475
  792618
  792815
  792930
  793550
  793565
  793797
  794299
  794901
  795130
  795637
  801372
  803816
  804593
  804612
  806532
  806700
  806705
  811087
  811965
  811979
  812083
  813702
  813817
  814182
  816744
  816815
  817020
  817105
  817636
  818240
  819160
  822482
  825156
  825708
  825710
  826113
  826545
  827573
  827601
]
13.65 ms
(3.68%)
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
  768301
  772388
  770423
  746452
  771979
  765913
  822482
  825708
  825156
  819160
  458238
  781748
  794901
  801372
  811087
  726263
  745513
  750535
  644142
  793797
  428360
  555506
  519556
  678131
  633491
  600022
  429755
  826545
  818240
  816744
  816815
  781963
  791306
  760120
  812083
  730790
  732226
  635662
  795130
  389657
  817105
  826113
  539550
  543694
  670946
  586924
  607414
  630045
  598181
  792930
  806532
  772394
  791262
  804593
  811979
  731186
  771990
  795637
  21221
  736465
  803816
  540535
  386228
  420240
  723522
  817020
  817636
  813702
  827601
  452204
  521860
  499042
  565902
  656363
  689857
  714808
  655005
  696785
  593919
  595645
  628912
  635721
  791475
  793550
  793565
  778750
  781368
  788917
  727589
  740181
  755111
  765556
  732982
  733089
  765909
  757987
  762748
  633340
  705067
  811965
  413125
  813817
  825710
  640304
  794299
  806700
  759483
  773621
  778058
  804612
  806705
  526031
  792618
  756256
  792815
  386195
  814182
  827573
  681281
  691479
]
2.63 ms
(0.71%)
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
  21221
  386195
  386228
  389657
  413125
  420240
  428360
  429755
  452204
  458238
  499042
  519556
  521860
  526031
  539550
  540535
  543694
  555506
  565902
  586924
  593919
  595645
  598181
  600022
  607414
  628912
  630045
  633340
  633491
  635662
  635721
  640304
  644142
  655005
  656363
  670946
  678131
  681281
  689857
  691479
  696785
  705067
  714808
  723522
  726263
  727589
  730790
  731186
  732226
  732982
  733089
  736465
  740181
  745513
  746452
  750535
  755111
  756256
  757987
  759483
  760120
  762748
  765556
  765909
  765913
  768301
  770423
  771979
  771990
  772388
  772394
  773621
  778058
  778750
  781368
  781748
  781963
  788917
  791262
  791306
  791475
  792618
  792815
  792930
  793550
  793565
  793797
  794299
  794901
  795130
  795637
  801372
  803816
  804593
  804612
  806532
  806700
  806705
  811087
  811965
  811979
  812083
  813702
  813817
  814182
  816744
  816815
  817020
  817105
  817636
  818240
  819160
  822482
  825156
  825708
  825710
  826113
  826545
  827573
  827601
]
1.72 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "love сиськ"
]
1.52 ms
(0.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "love сиськ"
]

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.