Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.65 ms
(85.82%)
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
  233102
  386719
  404209
  422233
  425003
  426818
  432404
  447357
  451748
  456179
  476397
  481166
  482079
  484355
  489958
  490184
  498867
  500120
  506629
  513540
  516039
  517663
  518091
  519848
  521915
  525208
  548601
  551553
  552232
  554764
  561356
  561667
  561686
  574328
  575797
  575823
  576285
  578843
  599451
  600403
  605961
  612574
  613850
  614729
  618943
  623834
  652855
  652901
  653238
  653260
  653561
  654151
  654390
  655418
  660959
  669858
  672511
  672534
  675359
  676491
  676499
  676517
  676538
  676953
  677039
  679706
  695051
  699571
  701487
  706668
  709372
  709769
  710998
  716033
  718967
  720822
  722799
  722889
  722901
  726398
  728171
  728681
  735410
  736260
  738432
  738889
  738910
  740587
  741596
  743079
  744507
  745682
  746207
  750922
  755587
  758033
  760919
  760942
  763953
  764137
  764158
  765261
  766115
  768163
  770438
  772991
  773187
  781583
  782524
  789240
  789450
  789753
  799726
  799727
  800587
  808761
  809802
  813880
  824806
  825715
]
15.43 ms
(8.14%)
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
  612574
  768163
  726398
  764137
  741596
  740587
  554764
  613850
  525208
  660959
  675359
  718967
  755587
  386719
  552232
  701487
  677039
  422233
  519848
  600403
  425003
  716033
  578843
  655418
  561667
  799726
  781583
  728681
  782524
  451748
  506629
  484355
  736260
  654390
  498867
  676499
  706668
  709769
  808761
  738432
  517663
  521915
  561356
  575797
  722889
  482079
  750922
  679706
  809802
  561686
  513540
  653260
  669858
  789450
  789240
  764158
  770438
  490184
  676953
  605961
  789753
  722901
  722799
  432404
  618943
  672534
  735410
  744507
  825715
  654151
  699571
  760919
  447357
  476397
  233102
  404209
  824806
  813880
  710998
  773187
  728171
  746207
  758033
  765261
  709372
  548601
  426818
  575823
  766115
  599451
  456179
  516039
  574328
  672511
  653561
  738889
  763953
  743079
  800587
  695051
  653238
  623834
  500120
  614729
  720822
  799727
  745682
  551553
  576285
  518091
  676517
  652855
  489958
  652901
  676491
  676538
  738910
  760942
  481166
  772991
]
3.28 ms
(1.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "massage sex russian"
]
3.11 ms
(1.64%)
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
  233102
  386719
  404209
  422233
  425003
  426818
  432404
  447357
  451748
  456179
  476397
  481166
  482079
  484355
  489958
  490184
  498867
  500120
  506629
  513540
  516039
  517663
  518091
  519848
  521915
  525208
  548601
  551553
  552232
  554764
  561356
  561667
  561686
  574328
  575797
  575823
  576285
  578843
  599451
  600403
  605961
  612574
  613850
  614729
  618943
  623834
  652855
  652901
  653238
  653260
  653561
  654151
  654390
  655418
  660959
  669858
  672511
  672534
  675359
  676491
  676499
  676517
  676538
  676953
  677039
  679706
  695051
  699571
  701487
  706668
  709372
  709769
  710998
  716033
  718967
  720822
  722799
  722889
  722901
  726398
  728171
  728681
  735410
  736260
  738432
  738889
  738910
  740587
  741596
  743079
  744507
  745682
  746207
  750922
  755587
  758033
  760919
  760942
  763953
  764137
  764158
  765261
  766115
  768163
  770438
  772991
  773187
  781583
  782524
  789240
  789450
  789753
  799726
  799727
  800587
  808761
  809802
  813880
  824806
  825715
]
1.88 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "массаж секс русск"
]
1.59 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.