Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
206.21 ms
(52.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cute solo"
]
158.03 ms
(40.27%)
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
  384082
  401414
  415937
  419633
  420902
  421759
  422069
  425687
  427095
  428932
  429566
  431224
  432335
  434306
  437926
  438455
  438646
  445968
  446008
  453170
  454745
  458642
  461209
  464492
  465918
  468163
  470818
  473038
  477255
  483465
  483480
  484960
  484962
  489034
  494302
  494482
  495170
  499013
  500308
  502559
  523271
  524473
  524602
  527801
  528451
  528520
  528945
  530936
  541136
  541517
  547787
  550165
  551586
  553843
  556193
  558098
  560364
  561738
  561756
  562405
  564215
  570409
  572782
  576615
  580519
  580629
  582018
  583185
  583606
  584084
  584284
  585835
  590409
  590713
  592593
  594283
  594606
  595577
  595581
  595609
  598504
  598616
  600172
  600512
  600700
  602444
  603351
  604033
  607685
  607926
  616026
  660253
  664579
  666490
  666925
  669296
  675378
  677854
  679697
  681261
  684731
  687318
  695339
  695872
  697242
  701292
  712433
  740709
  745111
  751110
  759133
  769158
  772579
  782094
  783709
  794030
  796463
  806635
  806683
  814477
]
18.22 ms
(4.64%)
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
  465918
  524473
  528945
  594606
  602444
  434306
  437926
  401414
  431224
  415937
  422069
  432335
  445968
  464492
  461209
  470818
  477255
  494482
  541517
  582018
  583606
  541136
  580629
  547787
  570409
  580519
  679697
  681261
  695339
  695872
  664579
  669296
  697242
  550165
  551586
  564215
  572782
  583185
  604033
  590409
  603351
  594283
  600172
  600512
  794030
  796463
  740709
  759133
  769158
  772579
  806683
  745111
  751110
  782094
  783709
  806635
  428932
  438646
  468163
  384082
  425687
  427095
  454745
  420902
  438455
  528451
  484960
  494302
  500308
  495170
  499013
  523271
  524602
  484962
  502559
  421759
  419633
  429566
  814477
  446008
  458642
  483465
  489034
  453170
  473038
  527801
  528520
  530936
  483480
  556193
  560364
  562405
  558098
  576615
  584084
  584284
  675378
  712433
  660253
  666490
  666925
  677854
  684731
  701292
  687318
  553843
  561738
  561756
  595581
  595609
  585835
  590713
  598504
  600700
  592593
  595577
  598616
  607685
  616026
  607926
]
4.44 ms
(1.13%)
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
  384082
  401414
  415937
  419633
  420902
  421759
  422069
  425687
  427095
  428932
  429566
  431224
  432335
  434306
  437926
  438455
  438646
  445968
  446008
  453170
  454745
  458642
  461209
  464492
  465918
  468163
  470818
  473038
  477255
  483465
  483480
  484960
  484962
  489034
  494302
  494482
  495170
  499013
  500308
  502559
  523271
  524473
  524602
  527801
  528451
  528520
  528945
  530936
  541136
  541517
  547787
  550165
  551586
  553843
  556193
  558098
  560364
  561738
  561756
  562405
  564215
  570409
  572782
  576615
  580519
  580629
  582018
  583185
  583606
  584084
  584284
  585835
  590409
  590713
  592593
  594283
  594606
  595577
  595581
  595609
  598504
  598616
  600172
  600512
  600700
  602444
  603351
  604033
  607685
  607926
  616026
  660253
  664579
  666490
  666925
  669296
  675378
  677854
  679697
  681261
  684731
  687318
  695339
  695872
  697242
  701292
  712433
  740709
  745111
  751110
  759133
  769158
  772579
  782094
  783709
  794030
  796463
  806635
  806683
  814477
]
2.13 ms
(0.54%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cute соло"
]
1.91 ms
(0.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cute соло"
]
1.52 ms
(0.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.