Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.17 ms
(84.18%)
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
  269276
  392579
  396382
  397618
  398865
  399427
  403074
  411435
  413439
  433639
  434623
  438028
  447157
  449853
  454455
  458394
  460005
  473586
  473596
  476405
  492268
  493242
  499000
  509513
  511369
  517020
  521480
  523496
  527243
  532049
  533470
  542736
  547557
  557413
  558187
  560516
  561157
  561163
  563851
  565093
  574184
  579518
  589923
  590619
  597865
  605011
  605065
  605366
  606764
  607985
  608753
  626342
  633225
  645922
  649310
  650087
  650101
  651960
  659345
  671928
  674259
  685916
  700934
  709511
  710135
  714323
  715970
  717433
  721761
  724464
  727081
  729165
  734714
  736918
  743877
  744754
  747735
  751801
  756813
  756865
  759493
  760941
  761895
  761910
  762643
  763640
  763678
  763841
  764138
  765211
  766120
  766488
  767060
  767071
  767223
  769163
  769472
  771168
  778937
  778992
  779377
  779535
  779912
  784029
  784228
  788932
  789286
  794307
  794864
  796564
  798983
  801507
  802024
  809924
  810187
  813124
  813764
  814284
  817326
  827888
]
13.90 ms
(8.92%)
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
  788932
  767223
  784029
  744754
  761895
  769163
  764138
  771168
  763841
  709511
  715970
  779535
  397618
  433639
  827888
  533470
  560516
  563851
  714323
  671928
  685916
  645922
  650101
  659345
  674259
  561157
  579518
  605065
  606764
  607985
  589923
  779377
  794307
  796564
  798983
  801507
  813124
  756865
  766120
  724464
  765211
  767060
  729165
  760941
  727081
  736918
  761910
  763678
  700934
  789286
  476405
  473586
  458394
  447157
  473596
  527243
  565093
  511369
  759493
  547557
  574184
  493242
  509513
  269276
  411435
  813764
  651960
  633225
  794864
  734714
  769472
  767071
  762643
  434623
  398865
  521480
  499000
  558187
  590619
  597865
  778937
  460005
  523496
  403074
  814284
  817326
  717433
  784228
  747735
  743877
  492268
  557413
  710135
  721761
  649310
  626342
  608753
  751801
  756813
  766488
  763640
  605011
  778992
  779912
  438028
  392579
  413439
  396382
  399427
  449853
  454455
  532049
  517020
  561163
  542736
  650087
  605366
  802024
  809924
  810187
]
4.11 ms
(2.63%)
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
  269276
  392579
  396382
  397618
  398865
  399427
  403074
  411435
  413439
  433639
  434623
  438028
  447157
  449853
  454455
  458394
  460005
  473586
  473596
  476405
  492268
  493242
  499000
  509513
  511369
  517020
  521480
  523496
  527243
  532049
  533470
  542736
  547557
  557413
  558187
  560516
  561157
  561163
  563851
  565093
  574184
  579518
  589923
  590619
  597865
  605011
  605065
  605366
  606764
  607985
  608753
  626342
  633225
  645922
  649310
  650087
  650101
  651960
  659345
  671928
  674259
  685916
  700934
  709511
  710135
  714323
  715970
  717433
  721761
  724464
  727081
  729165
  734714
  736918
  743877
  744754
  747735
  751801
  756813
  756865
  759493
  760941
  761895
  761910
  762643
  763640
  763678
  763841
  764138
  765211
  766120
  766488
  767060
  767071
  767223
  769163
  769472
  771168
  778937
  778992
  779377
  779535
  779912
  784029
  784228
  788932
  789286
  794307
  794864
  796564
  798983
  801507
  802024
  809924
  810187
  813124
  813764
  814284
  817326
  827888
]
1.89 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step sex sister"
]
1.78 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step секс sister"
]
1.50 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step секс sister"
]
1.48 ms
(0.95%)
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.