Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.25 ms
(83.59%)
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
  387946
  441255
  445426
  445599
  448596
  449014
  453081
  459508
  463180
  463604
  465624
  472579
  475228
  477678
  479200
  488872
  496287
  505045
  508460
  516161
  517692
  522156
  541675
  546730
  548710
  550404
  551278
  551589
  552159
  557445
  558654
  559388
  561649
  566514
  566819
  567531
  568462
  569220
  569772
  570266
  570609
  571854
  571895
  572126
  572387
  572519
  572746
  574158
  574490
  576297
  577117
  580291
  580678
  581630
  581669
  586500
  587434
  593921
  597113
  597268
  597494
  597798
  599501
  599602
  601675
  603304
  605178
  605312
  605547
  610161
  623265
  635967
  645268
  652911
  654765
  655395
  656064
  656434
  658008
  658682
  665615
  671419
  671498
  677951
  686058
  690530
  690628
  691838
  693186
  696164
  705547
  708790
  716036
  716485
  720441
  721364
  726459
  731762
  736058
  739614
  745754
  747092
  747636
  753651
  753716
  764349
  770148
  772660
  783131
  790724
  795911
  799756
  800426
  800610
  803632
  806294
  807521
  810206
  811085
  811338
]
14.22 ms
(9.97%)
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
  566819
  567531
  568462
  569220
  569772
  570609
  574158
  665615
  690530
  645268
  658682
  677951
  656064
  658008
  690628
  693186
  708790
  572746
  605547
  610161
  795911
  799756
  806294
  790724
  807521
  747092
  772660
  800426
  810206
  811085
  811338
  731762
  726459
  745754
  753716
  764349
  753651
  736058
  747636
  716485
  803632
  496287
  739614
  558654
  570266
  580291
  581630
  566514
  572387
  577117
  581669
  548710
  561649
  572519
  551278
  572126
  574490
  580678
  593921
  597268
  586500
  597113
  599501
  597494
  601675
  800610
  550404
  546730
  603304
  587434
  783131
  387946
  477678
  479200
  557445
  720441
  770148
  445599
  453081
  463180
  475228
  459508
  505045
  516161
  517692
  488872
  441255
  445426
  448596
  465624
  449014
  472579
  522156
  508460
  463604
  541675
  552159
  571854
  576297
  551589
  671419
  721364
  652911
  671498
  654765
  655395
  656434
  686058
  691838
  696164
  705547
  716036
  559388
  571895
  597798
  605312
  635967
  599602
  605178
  623265
]
2.35 ms
(1.65%)
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
  387946
  441255
  445426
  445599
  448596
  449014
  453081
  459508
  463180
  463604
  465624
  472579
  475228
  477678
  479200
  488872
  496287
  505045
  508460
  516161
  517692
  522156
  541675
  546730
  548710
  550404
  551278
  551589
  552159
  557445
  558654
  559388
  561649
  566514
  566819
  567531
  568462
  569220
  569772
  570266
  570609
  571854
  571895
  572126
  572387
  572519
  572746
  574158
  574490
  576297
  577117
  580291
  580678
  581630
  581669
  586500
  587434
  593921
  597113
  597268
  597494
  597798
  599501
  599602
  601675
  603304
  605178
  605312
  605547
  610161
  623265
  635967
  645268
  652911
  654765
  655395
  656064
  656434
  658008
  658682
  665615
  671419
  671498
  677951
  686058
  690530
  690628
  691838
  693186
  696164
  705547
  708790
  716036
  716485
  720441
  721364
  726459
  731762
  736058
  739614
  745754
  747092
  747636
  753651
  753716
  764349
  770148
  772660
  783131
  790724
  795911
  799756
  800426
  800610
  803632
  806294
  807521
  810206
  811085
  811338
]
1.93 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small babe"
]
1.73 ms
(1.21%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая babe"
]
1.66 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.52 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая babe"
]

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.