Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.75 ms
(85.61%)
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
  90979
  190925
  322014
  381776
  385165
  388308
  396173
  396910
  399662
  401100
  402547
  407424
  408383
  417063
  419707
  419768
  420566
  421207
  424401
  424494
  430297
  443799
  444732
  446476
  447458
  448805
  449091
  450833
  451469
  454262
  455241
  456889
  462526
  462531
  466765
  467846
  469069
  469914
  472316
  480372
  480474
  484713
  485270
  485708
  485918
  486670
  486672
  489903
  489906
  490908
  491871
  492276
  492511
  492515
  498030
  498039
  498054
  498163
  498252
  501465
  504405
  506213
  506522
  506659
  506803
  507394
  508780
  508782
  515119
  515122
  515285
  516040
  516445
  519620
  519622
  519942
  520028
  524016
  526025
  531195
  531236
  533844
  541589
  541630
  541639
  541698
  542196
  546767
  548584
  550406
  550432
  553717
  554386
  558904
  560153
  560154
  563489
  565186
  570725
  573315
  576648
  586440
  586468
  586486
  586503
  586506
  592532
  604172
  622317
  622331
  630260
  641931
  698933
  730074
  795437
  803075
  807704
  808108
  814748
  814956
]
11.15 ms
(7.97%)
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
  489903
  560153
  807704
  402547
  533844
  508782
  526025
  498039
  808108
  508780
  322014
  419768
  515285
  498030
  504405
  396910
  90979
  449091
  576648
  190925
  424494
  515122
  401100
  469069
  546767
  586506
  630260
  803075
  385165
  490908
  519620
  622317
  417063
  492276
  524016
  516445
  541639
  466765
  592532
  560154
  467846
  396173
  641931
  480372
  444732
  446476
  586503
  519622
  586486
  480474
  730074
  419707
  507394
  408383
  586440
  506522
  451469
  489906
  554386
  814956
  492511
  565186
  399662
  381776
  455241
  454262
  498163
  407424
  469914
  430297
  795437
  498252
  462531
  541589
  450833
  550406
  456889
  506213
  420566
  486672
  443799
  485918
  550432
  506659
  501465
  814748
  531195
  586468
  563489
  498054
  485708
  462526
  492515
  520028
  421207
  388308
  486670
  573315
  424401
  447458
  604172
  558904
  485270
  531236
  472316
  548584
  506803
  484713
  553717
  622331
  519942
  448805
  515119
  570725
  541630
  516040
  542196
  541698
  491871
  698933
]
2.14 ms
(1.53%)
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
  90979
  190925
  322014
  381776
  385165
  388308
  396173
  396910
  399662
  401100
  402547
  407424
  408383
  417063
  419707
  419768
  420566
  421207
  424401
  424494
  430297
  443799
  444732
  446476
  447458
  448805
  449091
  450833
  451469
  454262
  455241
  456889
  462526
  462531
  466765
  467846
  469069
  469914
  472316
  480372
  480474
  484713
  485270
  485708
  485918
  486670
  486672
  489903
  489906
  490908
  491871
  492276
  492511
  492515
  498030
  498039
  498054
  498163
  498252
  501465
  504405
  506213
  506522
  506659
  506803
  507394
  508780
  508782
  515119
  515122
  515285
  516040
  516445
  519620
  519622
  519942
  520028
  524016
  526025
  531195
  531236
  533844
  541589
  541630
  541639
  541698
  542196
  546767
  548584
  550406
  550432
  553717
  554386
  558904
  560153
  560154
  563489
  565186
  570725
  573315
  576648
  586440
  586468
  586486
  586503
  586506
  592532
  604172
  622317
  622331
  630260
  641931
  698933
  730074
  795437
  803075
  807704
  808108
  814748
  814956
]
2.07 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни в больниц"
]
1.70 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс в медицин"
]
1.54 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс в медицин"
]
1.52 ms
(1.09%)
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.