Query Metrics
7
Database Queries
7
Different statements
181.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.18 ms (85.73%) |
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 415197 416522 417258 418714 418966 426384 435027 455778 461894 463688 463897 464014 465645 465651 469351 469575 471764 477274 490513 490866 493807 497225 497401 499477 500289 503670 506677 508353 508757 509448 510304 512781 512961 513472 514955 514984 515416 515440 515482 515551 515862 516933 517727 517745 518482 520654 520694 521556 521910 521924 522260 524096 528567 529043 531196 532263 533998 534301 535010 542084 542993 543399 547462 550672 556041 556747 563703 564856 565496 569559 574036 574721 576036 577351 579031 579394 580359 580855 582377 584351 585959 586676 588592 595016 600009 600339 601141 601358 601996 602194 604803 616094 619792 621055 624739 625673 626911 629287 632970 633892 635920 636108 636987 637689 641395 644569 646429 647944 675275 679785 691030 718788 760649 786178 787121 801280 805120 810299 813391 814810 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (8.99%) |
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 644569 600009 625673 641395 515862 520654 522260 521910 535010 415197 508757 531196 534301 469575 647944 675275 580855 786178 477274 417258 814810 465645 577351 646429 679785 718788 691030 588592 636108 586676 632970 636987 787121 521924 517727 426384 469351 503670 510304 532263 542084 542993 576036 595016 600339 619792 801280 813391 465651 463897 455778 516933 490513 490866 515416 515482 464014 524096 497225 520694 506677 418966 512781 514984 543399 579031 556041 582377 556747 574721 629287 635920 637689 810299 509448 497401 529043 518482 533998 461894 579394 563703 601141 604803 626911 805120 760649 624739 463688 521556 528567 517745 493807 514955 574036 435027 515440 416522 471764 512961 515551 499477 580359 584351 547462 550672 565496 569559 564856 601358 633892 585959 602194 621055 601996 616094 418714 513472 508353 500289 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.57%) |
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 415197 416522 417258 418714 418966 426384 435027 455778 461894 463688 463897 464014 465645 465651 469351 469575 471764 477274 490513 490866 493807 497225 497401 499477 500289 503670 506677 508353 508757 509448 510304 512781 512961 513472 514955 514984 515416 515440 515482 515551 515862 516933 517727 517745 518482 520654 520694 521556 521910 521924 522260 524096 528567 529043 531196 532263 533998 534301 535010 542084 542993 543399 547462 550672 556041 556747 563703 564856 565496 569559 574036 574721 576036 577351 579031 579394 580359 580855 582377 584351 585959 586676 588592 595016 600009 600339 601141 601358 601996 602194 604803 616094 619792 621055 624739 625673 626911 629287 632970 633892 635920 636108 636987 637689 641395 644569 646429 647944 675275 679785 691030 718788 760649 786178 787121 801280 805120 810299 813391 814810 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sport sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.75%) |
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.