Query Metrics
7
Database Queries
7
Different statements
366.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.44 ms (57.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд соло анал"
]
|
||||||||||||||||||||||||||||||
|
131.53 ms (35.86%) |
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 182036 188561 392004 392843 407415 414077 416539 416644 416653 416683 416722 422101 429601 429886 430262 434367 436639 439195 446949 452810 453223 456190 467715 467939 469636 470471 471122 477021 477759 488817 511893 512079 521145 523358 529296 534764 544404 544831 545379 547474 547476 550925 553732 561015 561040 564227 564500 573204 577520 587292 588436 597029 597534 601789 602283 605026 605133 605208 605219 607296 615921 624751 627446 628095 630420 632887 632920 633455 634100 640312 642149 643080 656200 656891 658819 660416 661008 661653 662072 664149 669018 669038 669080 671044 672304 682397 695870 696593 709693 735308 738515 739132 740931 741557 745087 749084 751309 751571 752603 752661 752706 752712 758780 765684 781326 782836 783043 783709 784217 785580 785868 792078 795731 799759 802925 803628 804939 806788 806924 813195 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (4.14%) |
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 605208 607296 782836 752603 752712 749084 751571 765684 547476 553732 564500 550925 656891 658819 662072 696593 602283 632887 633455 634100 803628 795731 751309 739132 783709 802925 806788 587292 416653 511893 545379 573204 564227 544831 547474 669038 671044 669018 695870 660416 661008 664149 669080 561015 561040 577520 605133 605219 615921 605026 630420 752706 627446 709693 471122 416683 416722 416539 512079 477759 188561 752661 477021 813195 672304 434367 469636 643080 785580 792078 758780 785868 407415 529296 656200 682397 640312 642149 597029 784217 799759 781326 806924 804939 741557 738515 740931 745087 735308 783043 182036 439195 470471 544404 632920 588436 597534 456190 429886 392004 416644 446949 452810 436639 422101 661653 628095 521145 601789 624751 467939 523358 430262 534764 488817 414077 392843 429601 453223 467715 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.76%) |
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 182036 188561 392004 392843 407415 414077 416539 416644 416653 416683 416722 422101 429601 429886 430262 434367 436639 439195 446949 452810 453223 456190 467715 467939 469636 470471 471122 477021 477759 488817 511893 512079 521145 523358 529296 534764 544404 544831 545379 547474 547476 550925 553732 561015 561040 564227 564500 573204 577520 587292 588436 597029 597534 601789 602283 605026 605133 605208 605219 607296 615921 624751 627446 628095 630420 632887 632920 633455 634100 640312 642149 643080 656200 656891 658819 660416 661008 661653 662072 664149 669018 669038 669080 671044 672304 682397 695870 696593 709693 735308 738515 739132 740931 741557 745087 749084 751309 751571 752603 752661 752706 752712 758780 765684 781326 782836 783043 783709 784217 785580 785868 792078 795731 799759 802925 803628 804939 806788 806924 813195 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo solo anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.46%) |
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.