Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.69 ms
(82.63%)
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
  21575
  395933
  397396
  405243
  417062
  424067
  426840
  433420
  433925
  436001
  437730
  438421
  443701
  443897
  458153
  458547
  460484
  461532
  461584
  461949
  461987
  462132
  465120
  465361
  465375
  465815
  467862
  469901
  470170
  471914
  472115
  477094
  478205
  478208
  478330
  478387
  478399
  478766
  479417
  481318
  481597
  483829
  484007
  484098
  484852
  485534
  485851
  487225
  491391
  492230
  503175
  503470
  503713
  504299
  508022
  508107
  508230
  509658
  510521
  510894
  511075
  511096
  511104
  512678
  515668
  516440
  517102
  520379
  522810
  522811
  522816
  523708
  545490
  546076
  546938
  547577
  547614
  548764
  552086
  560626
  562395
  563439
  564409
  564932
  565602
  567710
  567890
  570257
  570628
  570672
  571497
  572048
  572361
  572988
  573090
  573100
  573119
  573341
  573371
  573568
  573699
  573816
  573891
  574006
  574558
  574611
  574784
  575263
  577728
  578910
  579446
  601401
  601402
  616238
  650627
  697009
  793497
  798967
  802291
  807469
]
15.02 ms
(10.37%)
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
  563439
  564932
  567710
  567890
  570257
  570628
  570672
  572048
  572361
  573090
  573119
  573568
  573699
  574784
  575263
  579446
  697009
  650627
  545490
  546076
  546938
  547577
  547614
  548764
  552086
  560626
  562395
  564409
  565602
  571497
  572988
  573100
  573341
  573371
  573816
  573891
  574006
  574558
  574611
  577728
  578910
  601401
  601402
  616238
  793497
  802291
  798967
  807469
  395933
  424067
  438421
  443701
  465815
  478387
  478399
  481318
  481597
  397396
  433925
  437730
  460484
  461532
  461987
  465120
  467862
  477094
  21575
  405243
  426840
  443897
  458153
  462132
  469901
  470170
  478205
  478330
  478766
  417062
  458547
  461949
  465361
  465375
  471914
  472115
  479417
  433420
  436001
  461584
  478208
  503470
  503713
  508022
  508230
  510521
  511104
  517102
  520379
  522810
  522811
  522816
  523708
  483829
  484007
  484098
  484852
  485534
  485851
  487225
  491391
  492230
  503175
  504299
  508107
  509658
  510894
  511075
  511096
  512678
  515668
  516440
]
3.49 ms
(2.41%)
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
  21575
  395933
  397396
  405243
  417062
  424067
  426840
  433420
  433925
  436001
  437730
  438421
  443701
  443897
  458153
  458547
  460484
  461532
  461584
  461949
  461987
  462132
  465120
  465361
  465375
  465815
  467862
  469901
  470170
  471914
  472115
  477094
  478205
  478208
  478330
  478387
  478399
  478766
  479417
  481318
  481597
  483829
  484007
  484098
  484852
  485534
  485851
  487225
  491391
  492230
  503175
  503470
  503713
  504299
  508022
  508107
  508230
  509658
  510521
  510894
  511075
  511096
  511104
  512678
  515668
  516440
  517102
  520379
  522810
  522811
  522816
  523708
  545490
  546076
  546938
  547577
  547614
  548764
  552086
  560626
  562395
  563439
  564409
  564932
  565602
  567710
  567890
  570257
  570628
  570672
  571497
  572048
  572361
  572988
  573090
  573100
  573119
  573341
  573371
  573568
  573699
  573816
  573891
  574006
  574558
  574611
  574784
  575263
  577728
  578910
  579446
  601401
  601402
  616238
  650627
  697009
  793497
  798967
  802291
  807469
]
1.77 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск презерват"
]
1.76 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русское презик"
]
1.68 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(1.00%)
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.