Query Metrics
7
Database Queries
7
Different statements
137.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
114.55 ms (83.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 390929 393531 393742 397473 399853 400672 400982 401989 416172 418484 451595 464280 473955 480420 492649 495158 514470 515158 515193 515290 518933 522695 524312 527610 545357 550602 552599 563961 569427 569674 575636 578498 580237 583696 590328 595538 597997 604417 604467 620333 620801 622303 624238 628851 636405 646343 655062 657434 664794 670762 675514 675742 678763 683536 683774 684187 684211 685562 685612 687187 687461 698610 699009 702087 702461 706321 706343 708955 709703 715326 716468 719129 720328 720376 720505 726284 731098 732094 737413 737417 738274 738320 739934 744316 750344 750352 750638 751500 752435 755100 755553 756090 759660 760466 760481 765442 766858 770061 775709 779014 780881 786491 788963 800119 800761 801281 803181 805591 807537 808266 810316 810667 814490 817410 817630 817702 817713 819605 820086 820205 ] |
||||||||||||||||||||||||||||||
|
12.92 ms (9.42%) |
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 786491 788963 751500 752435 800761 801281 803181 805591 726284 750638 755100 760466 766858 731098 738274 738320 750352 756090 760481 770061 702461 708955 393742 418484 492649 524312 518933 515193 550602 569427 569674 578498 580237 684211 664794 687461 583696 597997 604467 620801 744316 604417 480420 390929 473955 451595 464280 515290 515158 495158 397473 400672 814490 817410 817713 819605 820205 817630 817702 820086 522695 527610 514470 552599 563961 575636 545357 655062 657434 675514 683536 683774 685612 699009 715326 716468 720376 720505 646343 670762 675742 678763 684187 685562 706321 687187 702087 709703 719129 720328 590328 622303 624238 628851 595538 620333 636405 800119 779014 737417 750344 765442 810667 732094 739934 755553 759660 737413 698610 706343 775709 780881 807537 808266 810316 393531 399853 400982 401989 416172 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.72%) |
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 390929 393531 393742 397473 399853 400672 400982 401989 416172 418484 451595 464280 473955 480420 492649 495158 514470 515158 515193 515290 518933 522695 524312 527610 545357 550602 552599 563961 569427 569674 575636 578498 580237 583696 590328 595538 597997 604417 604467 620333 620801 622303 624238 628851 636405 646343 655062 657434 664794 670762 675514 675742 678763 683536 683774 684187 684211 685562 685612 687187 687461 698610 699009 702087 702461 706321 706343 708955 709703 715326 716468 719129 720328 720376 720505 726284 731098 732094 737413 737417 738274 738320 739934 744316 750344 750352 750638 751500 752435 755100 755553 756090 759660 760466 760481 765442 766858 770061 775709 779014 780881 786491 788963 800119 800761 801281 803181 805591 807537 808266 810316 810667 814490 817410 817630 817702 817713 819605 820086 820205 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen old"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen old"
]
|
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.