Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
211.39 ms
(57.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член массаж"
]
135.62 ms
(36.87%)
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
  185123
  185125
  185212
  185595
  205147
  322773
  357806
  386331
  387777
  389135
  389517
  389543
  390282
  390804
  406191
  406235
  406404
  406578
  408043
  408085
  408172
  413465
  413943
  437448
  447488
  456184
  456579
  461091
  464195
  481087
  487346
  507133
  507171
  511294
  521918
  531725
  545814
  549583
  551316
  551358
  551428
  560102
  560136
  568363
  569820
  572012
  575135
  575549
  578493
  584200
  593671
  600596
  604497
  607286
  610580
  620105
  623950
  625036
  626152
  628342
  628346
  630478
  633118
  636032
  648491
  651936
  651941
  653240
  653241
  653243
  653250
  654065
  654154
  661768
  662033
  662711
  662966
  662989
  672536
  676929
  676976
  677158
  677376
  679702
  687138
  697489
  699542
  703877
  705689
  711057
  716318
  722855
  723077
  724712
  726467
  735417
  743129
  744469
  746498
  747366
  748674
  749284
  759772
  760507
  765482
  772484
  773071
  773084
  792833
  795376
  797697
  799522
  799623
  800009
  800296
  804671
  810789
  811662
  811760
  814793
]
13.16 ms
(3.58%)
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
  551358
  797697
  810789
  795376
  811662
  773071
  799623
  772484
  322773
  387777
  408172
  551428
  386331
  560102
  575135
  676976
  653240
  185595
  814793
  654065
  662711
  705689
  661768
  677158
  551316
  628342
  626152
  804671
  749284
  743129
  747366
  748674
  697489
  699542
  716318
  722855
  389517
  390282
  357806
  389135
  578493
  569820
  653250
  679702
  560136
  584200
  620105
  185125
  703877
  185123
  408085
  413465
  545814
  568363
  406578
  511294
  390804
  406191
  406404
  408043
  711057
  723077
  662033
  604497
  456184
  507171
  531725
  464195
  487346
  549583
  651936
  636032
  800296
  799522
  744469
  773084
  185212
  507133
  572012
  653243
  593671
  628346
  765482
  760507
  625036
  406235
  205147
  461091
  456579
  447488
  521918
  437448
  575549
  651941
  653241
  654154
  662966
  676929
  648491
  672536
  687138
  662989
  677376
  600596
  630478
  633118
  607286
  623950
  811760
  792833
  800009
  726467
  759772
  735417
  746498
  724712
  610580
  389543
  481087
  413943
]
2.57 ms
(0.70%)
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
  185123
  185125
  185212
  185595
  205147
  322773
  357806
  386331
  387777
  389135
  389517
  389543
  390282
  390804
  406191
  406235
  406404
  406578
  408043
  408085
  408172
  413465
  413943
  437448
  447488
  456184
  456579
  461091
  464195
  481087
  487346
  507133
  507171
  511294
  521918
  531725
  545814
  549583
  551316
  551358
  551428
  560102
  560136
  568363
  569820
  572012
  575135
  575549
  578493
  584200
  593671
  600596
  604497
  607286
  610580
  620105
  623950
  625036
  626152
  628342
  628346
  630478
  633118
  636032
  648491
  651936
  651941
  653240
  653241
  653243
  653250
  654065
  654154
  661768
  662033
  662711
  662966
  662989
  672536
  676929
  676976
  677158
  677376
  679702
  687138
  697489
  699542
  703877
  705689
  711057
  716318
  722855
  723077
  724712
  726467
  735417
  743129
  744469
  746498
  747366
  748674
  749284
  759772
  760507
  765482
  772484
  773071
  773084
  792833
  795376
  797697
  799522
  799623
  800009
  800296
  804671
  810789
  811662
  811760
  814793
]
1.87 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick massage"
]
1.67 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член массаж"
]
1.57 ms
(0.43%)
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.