Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.13 ms
(84.60%)
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
  70131
  191315
  381752
  385386
  388179
  396887
  398544
  401638
  411817
  458126
  460724
  462315
  466885
  469453
  480077
  485700
  488311
  491790
  498217
  516053
  518911
  525481
  533459
  534580
  537484
  546132
  546137
  546138
  546141
  546145
  551926
  554350
  554352
  557171
  558657
  563779
  563960
  578823
  593023
  614378
  622527
  624466
  624469
  636438
  636557
  663901
  677971
  678779
  681609
  682414
  696729
  698765
  701444
  704265
  705054
  705058
  705069
  717121
  719900
  722434
  726271
  727915
  729781
  730118
  731193
  731445
  732986
  733497
  733946
  734173
  734270
  736000
  738296
  738314
  738316
  738331
  738333
  738342
  738343
  738350
  738358
  739686
  743967
  744223
  744363
  745252
  747070
  748017
  749232
  770121
  770201
  772881
  772885
  773884
  780663
  780682
  780691
  781754
  788822
  788981
  794743
  796016
  796019
  796028
  799358
  802326
  802966
  804057
  804130
  804590
  807603
  817544
  817689
  823770
  825038
  825140
  825461
  826990
  827278
  827308
]
10.78 ms
(7.47%)
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
  826990
  518911
  537484
  563779
  546137
  554350
  546141
  624466
  781754
  773884
  799358
  743967
  770201
  731193
  719900
  796028
  802326
  705058
  748017
  736000
  491790
  678779
  462315
  381752
  485700
  705069
  533459
  498217
  546145
  557171
  636438
  624469
  796019
  738358
  458126
  705054
  738350
  70131
  191315
  396887
  398544
  823770
  817689
  825038
  825461
  460724
  558657
  701444
  677971
  682414
  722434
  796016
  738342
  804130
  747070
  734270
  772885
  730118
  731445
  734173
  717121
  788981
  794743
  411817
  578823
  802966
  772881
  807603
  738343
  744223
  704265
  466885
  516053
  480077
  546138
  546132
  681609
  727915
  733946
  732986
  738314
  739686
  388179
  401638
  817544
  827278
  827308
  825140
  525481
  534580
  563960
  663901
  696729
  593023
  614378
  780663
  780682
  780691
  788822
  726271
  738331
  749232
  770121
  745252
  698765
  744363
  804590
  804057
  469453
  488311
  551926
  622527
  729781
  733497
  738333
  738296
  738316
  636557
  385386
  554352
]
3.64 ms
(2.52%)
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
  70131
  191315
  381752
  385386
  388179
  396887
  398544
  401638
  411817
  458126
  460724
  462315
  466885
  469453
  480077
  485700
  488311
  491790
  498217
  516053
  518911
  525481
  533459
  534580
  537484
  546132
  546137
  546138
  546141
  546145
  551926
  554350
  554352
  557171
  558657
  563779
  563960
  578823
  593023
  614378
  622527
  624466
  624469
  636438
  636557
  663901
  677971
  678779
  681609
  682414
  696729
  698765
  701444
  704265
  705054
  705058
  705069
  717121
  719900
  722434
  726271
  727915
  729781
  730118
  731193
  731445
  732986
  733497
  733946
  734173
  734270
  736000
  738296
  738314
  738316
  738331
  738333
  738342
  738343
  738350
  738358
  739686
  743967
  744223
  744363
  745252
  747070
  748017
  749232
  770121
  770201
  772881
  772885
  773884
  780663
  780682
  780691
  781754
  788822
  788981
  794743
  796016
  796019
  796028
  799358
  802326
  802966
  804057
  804130
  804590
  807603
  817544
  817689
  823770
  825038
  825140
  825461
  826990
  827278
  827308
]
2.05 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "сперма у старушки"
]
2.00 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сперм бабушк"
]
1.98 ms
(1.37%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм бабушк"
]
1.77 ms
(1.23%)
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.