Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.25 ms
(90.32%)
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
  2939
  25461
  130089
  153402
  155175
  190903
  312831
  370794
  382731
  383558
  383590
  384364
  385489
  385519
  386804
  386816
  387227
  387490
  390049
  391054
  391884
  392031
  393435
  394514
  397172
  397892
  399164
  399252
  400265
  400496
  405806
  406363
  406896
  407492
  408380
  411190
  411300
  413089
  415548
  418566
  418968
  418969
  421065
  423823
  425653
  425691
  426414
  428556
  434193
  438570
  440867
  442526
  443941
  444709
  446741
  448459
  449153
  451235
  451713
  452313
  453922
  454008
  454290
  454382
  454888
  454901
  455298
  457222
  460461
  460556
  461338
  461950
  462814
  463334
  463509
  464382
  464426
  465119
  465426
  465593
  470347
  471850
  472805
  472811
  472816
  472897
  475282
  482230
  485909
  489389
  490406
  491923
  499839
  501306
  513532
  520633
  527156
  536786
  553433
  562466
  568410
  569993
  611305
  659360
  718984
  744178
  757539
  793294
  798943
  801107
  804073
  804527
  804552
  804557
  804829
  806132
  806181
  808679
  809372
  814428
]
11.42 ms
(5.39%)
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
  465593
  385489
  804557
  411190
  814428
  454008
  464382
  499839
  808679
  406363
  405806
  482230
  418969
  460556
  491923
  386816
  397172
  411300
  421065
  418968
  454382
  463334
  460461
  489389
  453922
  461338
  312831
  527156
  475282
  461950
  407492
  562466
  718984
  804073
  383590
  440867
  444709
  434193
  464426
  568410
  793294
  408380
  397892
  472811
  370794
  392031
  553433
  659360
  801107
  744178
  153402
  385519
  415548
  465119
  471850
  472805
  462814
  155175
  390049
  454290
  804829
  394514
  391054
  406896
  442526
  387227
  387490
  130089
  806132
  386804
  501306
  465426
  190903
  428556
  451713
  399164
  457222
  485909
  423823
  520633
  425653
  490406
  25461
  413089
  446741
  455298
  454888
  472897
  569993
  611305
  804552
  809372
  806181
  400496
  2939
  383558
  470347
  400265
  426414
  513532
  393435
  804527
  757539
  384364
  391884
  425691
  438570
  443941
  451235
  449153
  454901
  452313
  536786
  463509
  798943
  448459
  472816
  399252
  418566
  382731
]
2.46 ms
(1.16%)
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
  2939
  25461
  130089
  153402
  155175
  190903
  312831
  370794
  382731
  383558
  383590
  384364
  385489
  385519
  386804
  386816
  387227
  387490
  390049
  391054
  391884
  392031
  393435
  394514
  397172
  397892
  399164
  399252
  400265
  400496
  405806
  406363
  406896
  407492
  408380
  411190
  411300
  413089
  415548
  418566
  418968
  418969
  421065
  423823
  425653
  425691
  426414
  428556
  434193
  438570
  440867
  442526
  443941
  444709
  446741
  448459
  449153
  451235
  451713
  452313
  453922
  454008
  454290
  454382
  454888
  454901
  455298
  457222
  460461
  460556
  461338
  461950
  462814
  463334
  463509
  464382
  464426
  465119
  465426
  465593
  470347
  471850
  472805
  472811
  472816
  472897
  475282
  482230
  485909
  489389
  490406
  491923
  499839
  501306
  513532
  520633
  527156
  536786
  553433
  562466
  568410
  569993
  611305
  659360
  718984
  744178
  757539
  793294
  798943
  801107
  804073
  804527
  804552
  804557
  804829
  806132
  806181
  808679
  809372
  814428
]
1.93 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "женщины с большими те%…"
]
1.77 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "женщин большие"
]
1.47 ms
(0.69%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.68%)
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.