Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.32 ms
(87.41%)
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
  233147
  304698
  396768
  397255
  400143
  401103
  403236
  421491
  448362
  450795
  464661
  481734
  521176
  535365
  539117
  539464
  540691
  554967
  556798
  563898
  563920
  568651
  572568
  578291
  580361
  581600
  590067
  590238
  599991
  600241
  601147
  606417
  607149
  610962
  613813
  630233
  635446
  638574
  639801
  642354
  649936
  660745
  663436
  666733
  669206
  677825
  698983
  699313
  705741
  709396
  710368
  714156
  714644
  716279
  716818
  718793
  721167
  721632
  726588
  727015
  727398
  728218
  734688
  737086
  737315
  738508
  742232
  743866
  743904
  751007
  756223
  758512
  758896
  765867
  765884
  766728
  767030
  770841
  771792
  772552
  772605
  775880
  785433
  786002
  787726
  788160
  788798
  790897
  795521
  799071
  799440
  801368
  801438
  801741
  801757
  802316
  803078
  803467
  807134
  808340
  809038
  809297
  811915
  813767
  814660
  814851
  815094
  815123
  815189
  815807
  815819
  815848
  817526
  817904
  817920
  820061
  820417
  821284
  822740
  824011
]
14.28 ms
(7.24%)
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
  795521
  727398
  765884
  772605
  635446
  721632
  785433
  304698
  233147
  705741
  801757
  450795
  601147
  815807
  817904
  815819
  660745
  606417
  613813
  642354
  590067
  610962
  807134
  737086
  770841
  737315
  756223
  758896
  728218
  734688
  751007
  727015
  699313
  709396
  716818
  788160
  710368
  639801
  758512
  815123
  540691
  539117
  535365
  568651
  554967
  563898
  572568
  666733
  721167
  649936
  556798
  599991
  590238
  630233
  775880
  799071
  802316
  809038
  809297
  786002
  790897
  803078
  808340
  801368
  801438
  803467
  765867
  743904
  767030
  766728
  607149
  718793
  787726
  801741
  811915
  397255
  481734
  401103
  400143
  464661
  821284
  822740
  824011
  563920
  714644
  663436
  677825
  714156
  638574
  600241
  799440
  726588
  738508
  742232
  743866
  772552
  771792
  788798
  396768
  521176
  403236
  421491
  814851
  820061
  813767
  815848
  817920
  815094
  815189
  817526
  814660
  820417
  448362
  539464
  578291
  580361
  581600
  669206
  698983
  716279
]
3.02 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
  233147
  304698
  396768
  397255
  400143
  401103
  403236
  421491
  448362
  450795
  464661
  481734
  521176
  535365
  539117
  539464
  540691
  554967
  556798
  563898
  563920
  568651
  572568
  578291
  580361
  581600
  590067
  590238
  599991
  600241
  601147
  606417
  607149
  610962
  613813
  630233
  635446
  638574
  639801
  642354
  649936
  660745
  663436
  666733
  669206
  677825
  698983
  699313
  705741
  709396
  710368
  714156
  714644
  716279
  716818
  718793
  721167
  721632
  726588
  727015
  727398
  728218
  734688
  737086
  737315
  738508
  742232
  743866
  743904
  751007
  756223
  758512
  758896
  765867
  765884
  766728
  767030
  770841
  771792
  772552
  772605
  775880
  785433
  786002
  787726
  788160
  788798
  790897
  795521
  799071
  799440
  801368
  801438
  801741
  801757
  802316
  803078
  803467
  807134
  808340
  809038
  809297
  811915
  813767
  814660
  814851
  815094
  815123
  815189
  815807
  815819
  815848
  817526
  817904
  817920
  820061
  820417
  821284
  822740
  824011
]
2.41 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom hot big"
]
1.78 ms
(0.90%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.85%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom hot большие"
]
1.66 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom hot большие"
]

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.