Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.18 ms
(83.97%)
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
  38953
  53510
  123955
  143085
  213057
  281927
  282481
  282494
  286475
  365938
  383495
  385304
  385505
  386514
  386846
  387186
  387922
  390601
  390701
  392609
  398458
  400056
  401522
  401588
  403028
  403216
  407058
  410753
  410855
  415109
  422000
  423329
  428353
  430661
  433339
  448811
  462535
  463777
  466787
  466989
  473102
  474663
  477744
  484542
  486540
  489443
  489646
  489831
  495198
  495741
  502326
  503194
  504161
  510360
  511925
  514841
  515257
  522381
  523538
  527653
  534219
  541751
  541919
  548519
  552008
  556852
  563014
  565571
  568997
  576678
  585961
  590894
  591437
  592391
  593992
  596550
  598111
  623912
  632314
  640688
  640695
  640700
  647933
  650421
  651870
  663502
  672099
  672184
  686021
  696598
  708919
  716298
  729223
  731777
  733347
  742906
  748741
  749873
  760834
  767957
  770902
  775028
  775995
  775998
  783790
  786039
  787912
  790802
  791571
  792486
  793406
  797445
  800260
  807192
  807715
  812510
  816773
  820152
  823282
  827419
]
18.10 ms
(9.80%)
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
  489831
  522381
  504161
  385505
  576678
  800260
  716298
  400056
  282481
  650421
  590894
  503194
  812510
  563014
  387922
  511925
  568997
  632314
  53510
  552008
  749873
  462535
  495741
  647933
  733347
  477744
  466989
  640700
  797445
  428353
  591437
  281927
  143085
  640688
  433339
  729223
  123955
  401588
  823282
  696598
  541751
  791571
  484542
  775995
  422000
  463777
  390601
  430661
  38953
  593992
  514841
  565571
  748741
  663502
  392609
  386514
  585961
  770902
  775028
  596550
  790802
  489443
  556852
  807715
  523538
  510360
  448811
  474663
  708919
  403028
  515257
  548519
  398458
  816773
  651870
  592391
  401522
  489646
  473102
  423329
  495198
  534219
  466787
  640695
  415109
  541919
  386846
  282494
  410855
  213057
  390701
  672184
  686021
  807192
  731777
  387186
  672099
  598111
  792486
  793406
  365938
  286475
  385304
  783790
  786039
  787912
  742906
  760834
  767957
  820152
  775998
  403216
  502326
  410753
  827419
  486540
  527653
  407058
  623912
  383495
]
3.70 ms
(2.00%)
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
  38953
  53510
  123955
  143085
  213057
  281927
  282481
  282494
  286475
  365938
  383495
  385304
  385505
  386514
  386846
  387186
  387922
  390601
  390701
  392609
  398458
  400056
  401522
  401588
  403028
  403216
  407058
  410753
  410855
  415109
  422000
  423329
  428353
  430661
  433339
  448811
  462535
  463777
  466787
  466989
  473102
  474663
  477744
  484542
  486540
  489443
  489646
  489831
  495198
  495741
  502326
  503194
  504161
  510360
  511925
  514841
  515257
  522381
  523538
  527653
  534219
  541751
  541919
  548519
  552008
  556852
  563014
  565571
  568997
  576678
  585961
  590894
  591437
  592391
  593992
  596550
  598111
  623912
  632314
  640688
  640695
  640700
  647933
  650421
  651870
  663502
  672099
  672184
  686021
  696598
  708919
  716298
  729223
  731777
  733347
  742906
  748741
  749873
  760834
  767957
  770902
  775028
  775995
  775998
  783790
  786039
  787912
  790802
  791571
  792486
  793406
  797445
  800260
  807192
  807715
  812510
  816773
  820152
  823282
  827419
]
2.15 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.13 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сборник куни жмж"
]
1.83 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "подборк куннилингус оральн секс жмж секс втро"
]
1.71 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.