Query Metrics
7
Database Queries
7
Different statements
180.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.04 ms (85.30%) |
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 358596 383211 383558 385171 389208 395137 398484 401640 401919 404175 406322 406381 408306 409408 422342 428412 443334 443761 443777 443786 474629 474648 474654 474659 474678 474680 474685 474686 474689 474693 474694 474696 474702 484387 484389 484392 484563 484693 485541 485703 495759 497537 506051 510750 511780 517743 520753 522610 530010 530912 531175 532804 536584 540263 546993 557162 559060 559061 566252 567907 591314 597018 597963 603243 614407 617652 634812 637650 641413 645891 664305 664963 667017 675006 679457 680142 696213 702677 727449 728191 730107 731775 731805 731814 737521 748210 748212 748216 748231 748234 748236 748238 748239 748240 748242 748243 748244 748254 748389 775962 775985 788289 789711 789764 789998 790019 790029 790248 790382 800700 803459 810760 810828 811945 813759 814072 815737 818777 820762 823695 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (9.41%) |
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 540263 818777 506051 731775 398484 443761 474659 474629 409408 428412 474648 810828 748243 383558 800700 474694 474685 443334 404175 511780 637650 484387 679457 474702 443777 474678 484563 748242 474689 474693 474686 495759 664963 748254 645891 748240 474654 522610 484693 748234 748238 385171 790382 731814 728191 730107 667017 748244 497537 530912 485703 810760 790029 727449 748236 559060 520753 358596 815737 664305 617652 748216 748231 748239 443786 557162 597018 775985 775962 702677 731805 395137 401640 484392 603243 748210 803459 748212 614407 789998 634812 474680 559061 748389 383211 813759 790019 510750 680142 789764 788289 811945 737521 789711 823695 422342 474696 567907 484389 675006 641413 406322 546993 389208 566252 696213 532804 531175 790248 485541 820762 408306 530010 401919 597963 517743 591314 536584 406381 814072 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.54%) |
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 358596 383211 383558 385171 389208 395137 398484 401640 401919 404175 406322 406381 408306 409408 422342 428412 443334 443761 443777 443786 474629 474648 474654 474659 474678 474680 474685 474686 474689 474693 474694 474696 474702 484387 484389 484392 484563 484693 485541 485703 495759 497537 506051 510750 511780 517743 520753 522610 530010 530912 531175 532804 536584 540263 546993 557162 559060 559061 566252 567907 591314 597018 597963 603243 614407 617652 634812 637650 641413 645891 664305 664963 667017 675006 679457 680142 696213 702677 727449 728191 730107 731775 731805 731814 737521 748210 748212 748216 748231 748234 748236 748238 748239 748240 748242 748243 748244 748254 748389 775962 775985 788289 789711 789764 789998 790019 790029 790248 790382 800700 803459 810760 810828 811945 813759 814072 815737 818777 820762 823695 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature gangbang young"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature gangbang young"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature gangbang young"
]
|
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.