Query Metrics
7
Database Queries
7
Different statements
183.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.93 ms (85.53%) |
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 257723 388718 397129 397477 403230 403904 404278 404358 405727 406690 415554 418844 419139 420230 421310 422566 422629 422653 423247 429379 430977 433745 439174 446348 451890 451999 453302 456494 456623 456635 456636 459149 459229 459234 459521 461487 462573 472959 473752 473754 473758 475250 475450 481376 483560 495666 497663 497664 499041 503248 506139 512193 512210 515749 516811 517905 523916 524178 525762 526789 539524 540176 540200 540451 542621 542642 554094 554764 557237 559160 564738 567835 572737 575351 577064 590747 595705 602691 604600 618318 618528 619491 622639 641069 645559 658556 665908 671837 673094 673144 673971 674352 692389 694468 694610 709577 711841 717281 719179 720306 730549 734492 735002 737356 739451 740831 741935 741961 742142 747942 748748 757130 760216 784464 786454 793630 793657 802533 807641 810242 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (8.08%) |
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 658556 734492 554094 674352 671837 711841 717281 590747 602691 397477 257723 397129 419139 459234 451890 512193 572737 473758 422653 430977 446348 503248 483560 497663 524178 497664 784464 523916 740831 720306 757130 405727 456635 456636 456494 540451 741935 406690 439174 554764 739451 415554 557237 645559 622639 542621 404358 433745 567835 473752 619491 526789 456623 421310 422566 516811 515749 459149 475250 453302 475450 540176 540200 481376 604600 459229 665908 673144 618528 575351 618318 641069 741961 742142 760216 730549 709577 719179 564738 673971 793630 802533 748748 737356 420230 542642 577064 694468 595705 793657 747942 451999 673094 735002 403904 462573 459521 495666 539524 506139 499041 473754 559160 694610 692389 807641 810242 388718 404278 422629 472959 512210 517905 525762 403230 429379 461487 786454 423247 418844 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.50%) |
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 257723 388718 397129 397477 403230 403904 404278 404358 405727 406690 415554 418844 419139 420230 421310 422566 422629 422653 423247 429379 430977 433745 439174 446348 451890 451999 453302 456494 456623 456635 456636 459149 459229 459234 459521 461487 462573 472959 473752 473754 473758 475250 475450 481376 483560 495666 497663 497664 499041 503248 506139 512193 512210 515749 516811 517905 523916 524178 525762 526789 539524 540176 540200 540451 542621 542642 554094 554764 557237 559160 564738 567835 572737 575351 577064 590747 595705 602691 604600 618318 618528 619491 622639 641069 645559 658556 665908 671837 673094 673144 673971 674352 692389 694468 694610 709577 711841 717281 719179 720306 730549 734492 735002 737356 739451 740831 741935 741961 742142 747942 748748 757130 760216 784464 786454 793630 793657 802533 807641 810242 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большой большие член азиатк"
]
|
||||||||||||||||||||||||||||||
|
2.27 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dick asian"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.