Query Metrics
7
Database Queries
7
Different statements
199.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.33 ms (86.89%) |
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 108018 382793 386300 391941 422438 422512 428681 428979 434136 447308 449012 450038 456095 458253 461616 463912 467344 476505 477773 478462 482782 484519 488246 489678 491964 499163 499174 507133 508162 508199 509649 511234 512307 515540 517300 519862 522015 522335 524169 529079 529803 532153 533261 541454 542493 553556 555693 558645 564827 566791 570072 572653 575762 575792 576058 576291 576990 582429 591684 598083 598568 600073 600344 600510 601137 611500 615386 623205 631948 644923 646895 651896 651945 655431 655636 656575 656768 657282 659300 668996 672492 684594 688520 688997 690117 693075 693308 694400 699599 702173 708674 715719 722825 727844 729593 730595 743933 744025 744877 747384 749317 753446 755424 762169 769735 772991 775997 777306 793896 798982 807649 807669 807681 812351 815075 816890 818068 824090 827518 827858 ] |
||||||||||||||||||||||||||||||
|
16.80 ms (8.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 572653 508162 458253 524169 644923 499163 575762 576291 576058 576990 575792 659300 715719 656575 693075 558645 600073 600344 600510 598083 631948 722825 668996 775997 827518 582429 655636 434136 484519 824090 816890 827858 515540 555693 688520 699599 651896 657282 672492 708674 684594 690117 615386 591684 793896 807649 798982 812351 727844 753446 772991 807669 807681 730595 755424 762169 729593 743933 744025 744877 769735 747384 749317 108018 522335 623205 598568 391941 646895 570072 564827 777306 422512 508199 655431 656768 488246 522015 601137 477773 693308 428681 449012 478462 422438 461616 476505 456095 467344 529079 499174 491964 386300 382793 507133 519862 553556 428979 447308 509649 611500 815075 818068 482782 450038 463912 529803 533261 512307 517300 532153 511234 489678 541454 542493 566791 651945 688997 694400 702173 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.31%) |
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 108018 382793 386300 391941 422438 422512 428681 428979 434136 447308 449012 450038 456095 458253 461616 463912 467344 476505 477773 478462 482782 484519 488246 489678 491964 499163 499174 507133 508162 508199 509649 511234 512307 515540 517300 519862 522015 522335 524169 529079 529803 532153 533261 541454 542493 553556 555693 558645 564827 566791 570072 572653 575762 575792 576058 576291 576990 582429 591684 598083 598568 600073 600344 600510 601137 611500 615386 623205 631948 644923 646895 651896 651945 655431 655636 656575 656768 657282 659300 668996 672492 684594 688520 688997 690117 693075 693308 694400 699599 702173 708674 715719 722825 727844 729593 730595 743933 744025 744877 747384 749317 753446 755424 762169 769735 772991 775997 777306 793896 798982 807649 807669 807681 812351 815075 816890 818068 824090 827518 827858 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small tits redhead"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая сиськ рыжая"
]
|
||||||||||||||||||||||||||||||
|
1.29 ms (0.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.