Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
218.29 ms
(89.72%)
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
  75896
  153440
  183343
  203927
  310683
  390059
  402772
  444525
  459314
  506819
  530118
  530585
  533817
  537273
  539573
  545627
  556223
  557492
  558301
  559670
  567560
  575688
  575958
  577491
  579239
  580730
  580933
  581004
  581452
  589579
  592169
  611342
  620273
  620764
  622033
  630068
  632718
  647745
  648569
  650150
  657739
  664235
  665429
  668519
  671473
  672419
  674373
  676151
  678761
  682611
  687880
  688095
  693250
  696138
  696937
  698885
  699349
  699479
  700178
  705770
  706320
  706983
  709629
  712306
  714191
  714253
  715536
  717683
  720100
  720610
  720644
  721002
  721416
  724020
  726119
  726149
  726910
  728150
  731767
  732109
  736596
  737171
  744797
  747350
  749719
  750484
  752754
  754341
  754583
  756309
  760118
  769995
  773901
  774002
  774782
  776474
  784445
  788237
  788751
  793085
  793780
  797794
  799638
  800877
  800913
  802808
  805992
  808552
  810925
  812918
  814405
  814772
  815604
  820702
  821307
  823349
  823400
  823438
  827009
]
14.06 ms
(5.78%)
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
  814405
  815604
  823349
  823400
  827009
  506819
  533817
  539573
  530585
  580933
  575688
  581004
  545627
  567560
  650150
  657739
  664235
  682611
  693250
  698885
  700178
  705770
  712306
  717683
  720644
  665429
  676151
  714253
  720610
  647745
  648569
  668519
  671473
  674373
  678761
  688095
  696138
  706983
  714191
  720100
  558301
  575958
  622033
  620764
  611342
  620273
  630068
  592169
  774782
  784445
  799638
  800877
  802808
  726119
  744797
  750484
  773901
  788237
  788751
  793780
  797794
  808552
  726910
  728150
  752754
  760118
  769995
  754341
  756309
  732109
  736596
  747350
  754583
  726149
  731767
  632718
  696937
  699349
  706320
  707498
  709629
  715536
  721002
  812918
  530118
  557492
  577491
  390059
  687880
  805992
  793085
  820702
  559670
  589579
  810925
  774002
  749719
  776474
  537273
  581452
  800913
  724020
  737171
  203927
  183343
  310683
  75896
  153440
  402772
  444525
  823438
  814772
  821307
  459314
  556223
  579239
  580730
  672419
  699479
  721416
]
3.11 ms
(1.28%)
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
  75896
  153440
  183343
  203927
  310683
  390059
  402772
  444525
  459314
  506819
  530118
  530585
  533817
  537273
  539573
  545627
  556223
  557492
  558301
  559670
  567560
  575688
  575958
  577491
  579239
  580730
  580933
  581004
  581452
  589579
  592169
  611342
  620273
  620764
  622033
  630068
  632718
  647745
  648569
  650150
  657739
  664235
  665429
  668519
  671473
  672419
  674373
  676151
  678761
  682611
  687880
  688095
  693250
  696138
  696937
  698885
  699349
  699479
  700178
  705770
  706320
  706983
  709629
  712306
  714191
  714253
  715536
  717683
  720100
  720610
  720644
  721002
  721416
  724020
  726119
  726149
  726910
  728150
  731767
  732109
  736596
  737171
  744797
  747350
  749719
  750484
  752754
  754341
  754583
  756309
  760118
  769995
  773901
  774002
  774782
  776474
  784445
  788237
  788751
  793085
  793780
  797794
  799638
  800877
  800913
  802808
  805992
  808552
  810925
  812918
  814405
  814772
  815604
  820702
  821307
  823349
  823400
  823438
  827009
]
2.52 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопы сиськи"
]
1.96 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп сиськ"
]
1.77 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.66%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.