Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.42 ms
(86.95%)
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
  387868
  412616
  459735
  506564
  533162
  540934
  543995
  544113
  552247
  562453
  562544
  567454
  574223
  578690
  579752
  586011
  587947
  596986
  597429
  600855
  603368
  604616
  610124
  618069
  620410
  630672
  635737
  639073
  649776
  656296
  669328
  671901
  680852
  680853
  685259
  691148
  691997
  692021
  695367
  698220
  705418
  706439
  708855
  710294
  714576
  715468
  718240
  720666
  721677
  723831
  723878
  725620
  728525
  728653
  730785
  732491
  734621
  735186
  737943
  742271
  742665
  743926
  745883
  745889
  745899
  748879
  749537
  753757
  754871
  757651
  757698
  759024
  762063
  763824
  764388
  765838
  766210
  777949
  778519
  779130
  779875
  779897
  789348
  789396
  789611
  794181
  794332
  794747
  795197
  796000
  798793
  799823
  800916
  801926
  802915
  803814
  805018
  810151
  812133
  812777
  813715
  814101
  817429
  817691
  818043
  819201
  819206
  819266
  819527
  823885
  823970
  825302
  826735
  826992
  827260
  827481
  828316
  828591
]
9.40 ms
(6.08%)
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
  803814
  812777
  544113
  691148
  763824
  649776
  387868
  817429
  748879
  798793
  819266
  825302
  618069
  552247
  567454
  828591
  824605
  827260
  728525
  698220
  794332
  692021
  635737
  737943
  789396
  749537
  823970
  828316
  777949
  604616
  723831
  826735
  720666
  779130
  757698
  779897
  587947
  579752
  603368
  610124
  796000
  814101
  812133
  540934
  562544
  708855
  671901
  562453
  620410
  735186
  714576
  795197
  754871
  819201
  764388
  794181
  799823
  745889
  745883
  574223
  669328
  706439
  680853
  710294
  639073
  596986
  600855
  597429
  805018
  730785
  745899
  753757
  705418
  801926
  721677
  800916
  823885
  506564
  732491
  826992
  827481
  543995
  715468
  718240
  656296
  586011
  778519
  728653
  742271
  759024
  742665
  725620
  762131
  743926
  757651
  630672
  794747
  685259
  412616
  813715
  818043
  817691
  819206
  819527
  459735
  810151
  779875
  789348
  723878
  734621
  765838
  762063
  766210
  789611
  802915
  533162
  578690
  680852
  691997
  695367
]
3.26 ms
(2.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск hotel"
]
2.69 ms
(1.74%)
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
  387868
  412616
  459735
  506564
  533162
  540934
  543995
  544113
  552247
  562453
  562544
  567454
  574223
  578690
  579752
  586011
  587947
  596986
  597429
  600855
  603368
  604616
  610124
  618069
  620410
  630672
  635737
  639073
  649776
  656296
  669328
  671901
  680852
  680853
  685259
  691148
  691997
  692021
  695367
  698220
  705418
  706439
  708855
  710294
  714576
  715468
  718240
  720666
  721677
  723831
  723878
  725620
  728525
  728653
  730785
  732491
  734621
  735186
  737943
  742271
  742665
  743926
  745883
  745889
  745899
  748879
  749537
  753757
  754871
  757651
  757698
  759024
  762063
  763824
  764388
  765838
  766210
  777949
  778519
  779130
  779875
  779897
  789348
  789396
  789611
  794181
  794332
  794747
  795197
  796000
  798793
  799823
  800916
  801926
  802915
  803814
  805018
  810151
  812133
  812777
  813715
  814101
  817429
  817691
  818043
  819201
  819206
  819266
  819527
  823885
  823970
  825302
  826735
  826992
  827260
  827481
  828316
  828591
]
1.83 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur hotel"
]
1.52 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск hotel"
]
1.48 ms
(0.96%)
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.