Query Metrics
7
Database Queries
7
Different statements
249.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
228.22 ms (91.56%) |
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 314552 384419 389144 391944 419454 422162 423651 429879 432939 435421 435512 451220 452818 453822 468255 475947 478427 488757 499084 517633 529609 529621 529793 530698 531821 531871 531882 531887 532872 534534 534564 536124 536971 541377 542217 545294 545449 547454 547458 547479 547857 548834 550896 552697 553130 555009 555359 555407 556043 564567 568261 576590 576925 577284 594340 603772 604418 604967 607228 617711 620260 628518 630793 656801 658784 660400 664094 664189 666529 666736 668663 673503 681746 685843 687325 695879 702268 722379 722428 728775 729073 734413 736519 739294 742298 742342 742353 745462 749129 749271 750294 752615 757716 757867 760901 765657 765683 765725 767593 770610 770963 777581 786519 787521 790575 793587 794124 794777 795461 796194 796343 796875 798734 799695 799696 804417 806180 806928 811480 819334 ] |
||||||||||||||||||||||||||||||
|
10.74 ms (4.31%) |
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 517633 529609 531882 531887 532872 534534 529621 529793 545294 547458 550896 577284 547454 541377 548834 556043 576925 658784 664189 666529 660400 722428 673503 681746 685843 553130 564567 568261 628518 603772 604418 604967 620260 617711 777581 798734 799695 799696 786519 796194 796343 806928 757867 767593 752615 770610 770963 742298 739294 749271 765657 765683 765725 630793 722379 804417 806180 422162 530698 534564 536971 547857 555407 542217 666736 668663 594340 790575 552697 499084 435421 423651 432939 452818 453822 555009 468255 475947 429879 451220 488757 419454 819334 478427 531821 536124 531871 545449 555359 547479 664094 656801 687325 695879 576590 607228 794777 729073 736519 749129 750294 794124 796875 734413 742342 742353 760901 728775 745462 757716 702268 787521 793587 795461 811480 314552 384419 391944 389144 435512 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.38%) |
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 314552 384419 389144 391944 419454 422162 423651 429879 432939 435421 435512 451220 452818 453822 468255 475947 478427 488757 499084 517633 529609 529621 529793 530698 531821 531871 531882 531887 532872 534534 534564 536124 536971 541377 542217 545294 545449 547454 547458 547479 547857 548834 550896 552697 553130 555009 555359 555407 556043 564567 568261 576590 576925 577284 594340 603772 604418 604967 607228 617711 620260 628518 630793 656801 658784 660400 664094 664189 666529 666736 668663 673503 681746 685843 687325 695879 702268 722379 722428 728775 729073 734413 736519 739294 742298 742342 742353 745462 749129 749271 750294 752615 757716 757867 760901 765657 765683 765725 767593 770610 770963 777581 786519 787521 790575 793587 794124 794777 795461 796194 796343 796875 798734 799695 799696 804417 806180 806928 811480 819334 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.71%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf мастурбац анал"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf masturbation anal"
]
|
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.