Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.89 ms
(85.52%)
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
  385042
  391718
  393731
  393741
  393745
  393751
  393780
  395221
  396757
  400418
  400458
  400903
  418484
  429257
  445040
  452490
  455180
  459811
  460036
  462781
  462961
  464145
  465805
  467320
  470733
  473928
  475918
  480006
  512869
  514787
  515108
  515165
  515189
  515220
  519973
  520730
  523172
  525605
  550227
  552014
  556379
  557270
  560372
  561734
  566517
  566524
  566526
  567149
  567934
  569659
  569672
  577515
  578465
  593138
  593440
  594014
  597259
  599548
  603126
  612296
  614094
  618887
  618970
  622888
  624276
  625490
  644654
  663940
  664287
  664958
  665399
  666141
  669430
  669443
  670513
  672767
  676930
  676978
  681813
  684187
  684995
  688579
  696969
  700541
  700945
  708823
  721006
  732421
  735820
  736022
  736980
  740610
  741646
  741650
  743116
  743142
  744443
  748632
  748989
  754216
  757973
  759578
  759581
  775258
  775578
  775825
  778419
  780713
  788647
  794702
  798897
  805346
  805847
  810775
  817622
  817630
  818920
  823700
  824824
  828053
]
16.34 ms
(8.96%)
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
  452490
  577515
  741650
  567934
  612296
  552014
  664958
  614094
  599548
  775258
  743142
  759581
  569659
  569672
  465805
  519973
  462781
  560372
  663940
  669430
  670513
  696969
  684995
  561734
  780713
  736022
  794702
  721006
  778419
  385042
  622888
  473928
  828053
  391718
  700541
  557270
  744443
  393745
  462961
  464145
  556379
  676930
  665399
  666141
  681813
  566517
  566526
  593440
  597259
  594014
  775825
  805847
  805346
  748989
  732421
  788647
  393731
  429257
  480006
  550227
  567149
  566524
  475918
  470733
  455180
  512869
  515189
  523172
  515165
  810775
  817630
  817622
  684187
  603126
  798897
  393741
  393780
  400418
  400458
  459811
  467320
  515220
  515108
  525605
  514787
  460036
  578465
  672767
  664287
  669443
  688579
  700945
  708823
  593138
  618970
  624276
  736980
  740610
  741646
  754216
  757973
  748632
  759578
  735820
  743116
  644654
  445040
  400903
  395221
  396757
  818920
  824824
  823700
  625490
  775578
  393751
  418484
  520730
  676978
  618887
]
2.85 ms
(1.56%)
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
  385042
  391718
  393731
  393741
  393745
  393751
  393780
  395221
  396757
  400418
  400458
  400903
  418484
  429257
  445040
  452490
  455180
  459811
  460036
  462781
  462961
  464145
  465805
  467320
  470733
  473928
  475918
  480006
  512869
  514787
  515108
  515165
  515189
  515220
  519973
  520730
  523172
  525605
  550227
  552014
  556379
  557270
  560372
  561734
  566517
  566524
  566526
  567149
  567934
  569659
  569672
  577515
  578465
  593138
  593440
  594014
  597259
  599548
  603126
  612296
  614094
  618887
  618970
  622888
  624276
  625490
  644654
  663940
  664287
  664958
  665399
  666141
  669430
  669443
  670513
  672767
  676930
  676978
  681813
  684187
  684995
  688579
  696969
  700541
  700945
  708823
  721006
  732421
  735820
  736022
  736980
  740610
  741646
  741650
  743116
  743142
  744443
  748632
  748989
  754216
  757973
  759578
  759581
  775258
  775578
  775825
  778419
  780713
  788647
  794702
  798897
  805346
  805847
  810775
  817622
  817630
  818920
  823700
  824824
  828053
]
2.01 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "young girl old"
]
1.96 ms
(1.07%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "young девушк old"
]
1.42 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "young девушк old"
]

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.