Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.63 ms
(82.52%)
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
  393046
  400096
  400955
  408833
  412535
  418513
  420359
  421390
  425565
  427045
  428976
  429259
  435372
  437557
  437800
  438486
  441936
  444193
  451717
  457134
  463321
  466320
  473095
  473687
  475754
  475765
  475913
  495171
  496419
  505220
  514164
  518353
  520365
  520385
  527165
  532628
  539707
  540412
  543657
  549087
  549091
  554114
  556060
  558327
  558382
  558395
  558655
  559472
  574125
  574225
  582214
  586730
  593903
  594615
  597735
  601222
  602113
  602415
  602662
  603278
  603491
  603913
  605900
  608088
  609293
  615651
  618782
  622334
  628909
  628957
  642679
  649263
  650267
  659459
  661436
  661709
  662070
  668613
  673860
  677109
  696194
  700681
  700711
  704638
  708350
  709020
  709661
  710391
  712931
  714254
  714579
  717812
  719375
  722964
  727921
  732090
  740145
  743455
  747952
  748399
  749688
  751361
  752180
  755576
  757003
  759223
  761359
  765352
  773534
  780485
  781631
  785441
  792441
  795247
  796230
  805650
  805652
  808097
  814091
]
20.21 ms
(11.45%)
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
  755576
  761359
  757003
  780485
  418513
  437557
  574225
  740145
  451717
  466320
  677109
  710391
  618782
  602415
  444193
  556060
  428976
  602662
  514164
  475913
  505220
  796230
  393046
  792441
  805650
  539707
  520385
  543657
  554114
  582214
  661709
  668613
  649263
  712931
  659459
  704638
  709020
  714254
  586730
  628909
  628957
  597735
  622334
  642679
  601222
  608088
  603913
  609293
  615651
  709661
  400955
  719375
  795247
  748399
  752180
  762399
  751361
  408833
  473687
  425565
  473095
  420359
  558382
  722964
  603491
  495171
  708350
  814091
  574125
  717812
  805652
  781631
  773534
  808097
  732090
  727921
  759223
  429259
  438486
  527165
  540412
  549091
  696194
  605900
  785441
  747952
  749688
  673860
  400096
  412535
  765352
  463321
  700681
  427045
  441936
  457134
  532628
  549087
  558327
  650267
  662070
  714579
  700711
  594615
  602113
  603278
  593903
  421390
  520365
  496419
  558655
  558395
  518353
  661436
  559472
  743455
  435372
  437800
  475765
  475754
]
3.01 ms
(1.71%)
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
  393046
  400096
  400955
  408833
  412535
  418513
  420359
  421390
  425565
  427045
  428976
  429259
  435372
  437557
  437800
  438486
  441936
  444193
  451717
  457134
  463321
  466320
  473095
  473687
  475754
  475765
  475913
  495171
  496419
  505220
  514164
  518353
  520365
  520385
  527165
  532628
  539707
  540412
  543657
  549087
  549091
  554114
  556060
  558327
  558382
  558395
  558655
  559472
  574125
  574225
  582214
  586730
  593903
  594615
  597735
  601222
  602113
  602415
  602662
  603278
  603491
  603913
  605900
  608088
  609293
  615651
  618782
  622334
  628909
  628957
  642679
  649263
  650267
  659459
  661436
  661709
  662070
  668613
  673860
  677109
  696194
  700681
  700711
  704638
  708350
  709020
  709661
  710391
  712931
  714254
  714579
  717812
  719375
  722964
  727921
  732090
  740145
  743455
  747952
  748399
  749688
  751361
  752180
  755576
  757003
  759223
  761359
  765352
  773534
  780485
  781631
  785441
  792441
  795247
  796230
  805650
  805652
  808097
  814091
]
2.30 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашнее 18-летние"
]
1.89 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск 18 19 лет"
]
1.82 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск 18 19 лет"
]

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.