Query Metrics
7
Database Queries
7
Different statements
175.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.44 ms (83.27%) |
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 74135 154463 182036 340635 381812 382960 386858 391563 394648 412814 412852 413376 414116 415992 416000 416525 416531 416583 416611 416626 416649 416659 416677 416682 416690 416708 418989 426511 429699 430353 434443 437859 439031 439688 440723 441925 444018 444533 445416 446612 447144 447158 448063 448257 451336 453996 455918 460765 462845 465148 467893 469221 470479 473213 474266 475189 476054 477506 477761 479818 480206 486775 493825 493839 494156 494495 497693 502242 505386 508686 508882 510783 514876 517816 520419 522142 527409 528938 531103 531844 534777 539185 542711 544829 545455 547468 550925 553646 567127 569302 595847 597029 601668 607296 632887 633455 639736 640270 656200 657505 660375 668526 669025 722384 722392 731862 738515 742716 744047 752602 758806 777051 782351 786874 788953 792078 796314 803628 806788 825878 ] |
||||||||||||||||||||||||||||||
|
18.62 ms (10.59%) |
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 494156 453996 474266 742716 479818 508686 154463 460765 477761 569302 493825 493839 394648 412852 473213 531844 497693 544829 553646 416677 825878 722384 601668 777051 786874 444533 382960 440723 74135 607296 429699 446612 413376 475189 510783 414116 462845 656200 597029 738515 182036 391563 528938 782351 444018 508882 416531 416690 744047 416626 467893 430353 439688 758806 731862 418989 531103 722392 416000 447158 448257 539185 550925 632887 633455 803628 639736 806788 669025 381812 412814 416611 416659 416649 439031 416682 470479 534777 545455 416708 476054 386858 451336 668526 480206 340635 595847 447144 486775 520419 660375 640270 426511 527409 502242 514876 796314 494495 441925 416583 505386 547468 788953 416525 477506 415992 437859 517816 455918 752602 445416 542711 792078 657505 434443 522142 469221 567127 465148 448063 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.77%) |
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 74135 154463 182036 340635 381812 382960 386858 391563 394648 412814 412852 413376 414116 415992 416000 416525 416531 416583 416611 416626 416649 416659 416677 416682 416690 416708 418989 426511 429699 430353 434443 437859 439031 439688 440723 441925 444018 444533 445416 446612 447144 447158 448063 448257 451336 453996 455918 460765 462845 465148 467893 469221 470479 473213 474266 475189 476054 477506 477761 479818 480206 486775 493825 493839 494156 494495 497693 502242 505386 508686 508882 510783 514876 517816 520419 522142 527409 528938 531103 531844 534777 539185 542711 544829 545455 547468 550925 553646 567127 569302 595847 597029 601668 607296 632887 633455 639736 640270 656200 657505 660375 668526 669025 722384 722392 731862 738515 742716 744047 752602 758806 777051 782351 786874 788953 792078 796314 803628 806788 825878 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal gape dildo"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал большая большие дырк дилд"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.94%) |
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.