Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.39 ms
(85.08%)
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
  149158
  188064
  233683
  387271
  391704
  392790
  417846
  425560
  427004
  428475
  432390
  432625
  439441
  439485
  440372
  440817
  440902
  440918
  443159
  443186
  449901
  450647
  450654
  450827
  452175
  454370
  457859
  457976
  460318
  460551
  462455
  464274
  464456
  465545
  466935
  469523
  473227
  474465
  477984
  477985
  484363
  485595
  489102
  514458
  517280
  518954
  522510
  522857
  532131
  537064
  543970
  550216
  555223
  555254
  556818
  560504
  563428
  563916
  563925
  565679
  566701
  568539
  570175
  571194
  576641
  577718
  582222
  585130
  587989
  589649
  592799
  596704
  606498
  626366
  647602
  670749
  688335
  693396
  697231
  709545
  713853
  718547
  724294
  728479
  728513
  734716
  737925
  740129
  741904
  742497
  744277
  745751
  753510
  755243
  755611
  756361
  756614
  759105
  772775
  777734
  788277
  789659
  793165
  793526
  793530
  793770
  794766
  795908
  800449
  807352
  808096
  810819
  811712
  813226
  813920
  815458
  823265
  823857
  824229
  826645
]
11.58 ms
(8.26%)
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
  670749
  697231
  566701
  592799
  793165
  808096
  793526
  793530
  810819
  724294
  755611
  759105
  800449
  728513
  756361
  728479
  753510
  755243
  734716
  742497
  795908
  811712
  149158
  387271
  565679
  563916
  543970
  626366
  449901
  439441
  428475
  440902
  443159
  813920
  823857
  466935
  450654
  462455
  450827
  522857
  532131
  582222
  570175
  647602
  688335
  568539
  606498
  789659
  794766
  813226
  745751
  425560
  450647
  188064
  440817
  454370
  460318
  464456
  474465
  571194
  556818
  807352
  793770
  709545
  777734
  788277
  465545
  233683
  473227
  391704
  514458
  522510
  392790
  440372
  432625
  439485
  457859
  464274
  469523
  452175
  537064
  484363
  555254
  563925
  577718
  560504
  563428
  576641
  555223
  718547
  693396
  713853
  550216
  589649
  596704
  587989
  772775
  740129
  741904
  737925
  744277
  756614
  457976
  477984
  477985
  427004
  460551
  485595
  417846
  432390
  443186
  440918
  815458
  585130
  826645
  823265
  824229
  489102
  517280
  518954
]
2.49 ms
(1.77%)
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
  149158
  188064
  233683
  387271
  391704
  392790
  417846
  425560
  427004
  428475
  432390
  432625
  439441
  439485
  440372
  440817
  440902
  440918
  443159
  443186
  449901
  450647
  450654
  450827
  452175
  454370
  457859
  457976
  460318
  460551
  462455
  464274
  464456
  465545
  466935
  469523
  473227
  474465
  477984
  477985
  484363
  485595
  489102
  514458
  517280
  518954
  522510
  522857
  532131
  537064
  543970
  550216
  555223
  555254
  556818
  560504
  563428
  563916
  563925
  565679
  566701
  568539
  570175
  571194
  576641
  577718
  582222
  585130
  587989
  589649
  592799
  596704
  606498
  626366
  647602
  670749
  688335
  693396
  697231
  709545
  713853
  718547
  724294
  728479
  728513
  734716
  737925
  740129
  741904
  742497
  744277
  745751
  753510
  755243
  755611
  756361
  756614
  759105
  772775
  777734
  788277
  789659
  793165
  793526
  793530
  793770
  794766
  795908
  800449
  807352
  808096
  810819
  811712
  813226
  813920
  815458
  823265
  823857
  824229
  826645
]
2.01 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины спящие"
]
1.71 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "женщин спящ"
]
1.61 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин спящ"
]
1.53 ms
(1.09%)
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.