Query Metrics
7
Database Queries
7
Different statements
398.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.60 ms (52.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian beautiful girl"
]
|
||||||||||||||||||||||||||||||
|
167.02 ms (41.93%) |
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 225892 351216 384422 385734 386915 398784 412716 420619 427135 427244 442921 444573 445384 445834 447489 447494 447510 449031 454073 455109 455777 457837 460356 461220 461267 461489 461823 461873 462029 463293 466177 469849 471916 472349 472798 473549 473761 473959 474229 475974 476761 480101 483197 483721 485298 485756 485853 487299 493296 494500 501910 509648 510664 511235 512645 519665 519871 521631 521964 523271 524307 525817 525948 526796 526831 537778 538207 545809 547741 548703 548713 552194 552633 558950 562243 562328 570034 571623 572429 572497 572803 573572 573850 573969 578503 588683 590348 591147 595477 595519 597951 597983 598059 598688 600128 621588 623104 652978 653239 654083 655950 658753 659828 715377 720031 722225 733787 742234 743470 754697 754758 760480 770278 778264 778681 780164 780735 782046 791340 819965 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (4.01%) |
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 623104 754697 754758 471916 578503 476761 519871 511235 509648 494500 412716 445834 461823 462029 521964 524307 778264 483721 654083 572429 597983 487299 521631 523271 742234 652978 595477 597951 600128 595519 427244 457837 466177 447510 655950 715377 658753 733787 780164 447489 562243 473959 588683 449031 473761 445384 455777 447494 420619 501910 525817 493296 537778 653239 722225 552194 562328 573572 469849 519665 442921 463293 538207 778681 474229 485756 570034 573850 571623 659828 548713 552633 558950 572497 598688 591147 460356 472798 475974 444573 455109 351216 386915 398784 461267 461489 510664 384422 819965 598059 770278 427135 385734 454073 526796 525948 485853 512645 621588 782046 791340 547741 548703 573969 545809 590348 743470 472349 483197 720031 780735 760480 225892 461873 473549 485298 480101 526831 461220 572803 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (0.82%) |
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 225892 351216 384422 385734 386915 398784 412716 420619 427135 427244 442921 444573 445384 445834 447489 447494 447510 449031 454073 455109 455777 457837 460356 461220 461267 461489 461823 461873 462029 463293 466177 469849 471916 472349 472798 473549 473761 473959 474229 475974 476761 480101 483197 483721 485298 485756 485853 487299 493296 494500 501910 509648 510664 511235 512645 519665 519871 521631 521964 523271 524307 525817 525948 526796 526831 537778 538207 545809 547741 548703 548713 552194 552633 558950 562243 562328 570034 571623 572429 572497 572803 573572 573850 573969 578503 588683 590348 591147 595477 595519 597951 597983 598059 598688 600128 621588 623104 652978 653239 654083 655950 658753 659828 715377 720031 722225 733787 742234 743470 754697 754758 760480 770278 778264 778681 780164 780735 782046 791340 819965 ] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.39%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск красивая девушк"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.