Query Metrics
7
Database Queries
7
Different statements
156.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.30 ms (84.60%) |
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 384478 384491 385279 385323 386017 387667 389819 391447 408685 415762 418132 418269 420636 427112 429211 429879 432884 434355 435607 442100 445787 446772 446776 454910 456788 462843 463781 466402 467024 469791 471030 471981 472755 475639 477500 479106 479351 479920 485296 490599 492406 493283 499531 499714 509762 515472 522978 527503 531379 533108 535324 540208 541422 546368 547520 555227 557878 558729 559973 560692 562418 567508 576483 577814 578169 581551 583464 583523 588759 590089 595548 595591 596983 602366 605535 609657 618071 628562 629495 652162 652321 653388 660397 661007 661539 664498 667463 674493 710402 712279 736045 751396 768791 776796 780262 785340 789559 796404 796939 802278 803404 803479 805743 807212 812467 812472 814097 817172 817964 819244 819418 820940 821964 824553 824735 824868 825396 826597 826599 827100 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (9.27%) |
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 789559 796939 408685 479351 527503 509762 490599 485296 661539 628562 596983 776796 803404 805743 385323 415762 472755 477500 712279 710402 557878 602366 629495 595591 618071 595548 605535 812472 780262 785340 796404 803479 736045 768791 751396 609657 807212 812467 802278 562418 386017 420636 384491 391447 432884 442100 463781 445787 492406 493283 560692 578169 588759 456788 471981 429879 462843 469791 427112 429211 471030 479920 435607 466402 541422 577814 559973 546368 434355 479106 522978 384478 389819 387667 418269 418132 824868 824735 825396 475639 446772 446776 467024 499714 664498 661007 583464 590089 454910 499531 385279 814097 817964 824553 826597 826599 821964 827100 819244 819418 817172 820940 531379 533108 540208 515472 535324 567508 576483 547520 581551 555227 558729 583523 652162 652321 653388 660397 667463 674493 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.93%) |
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 384478 384491 385279 385323 386017 387667 389819 391447 408685 415762 418132 418269 420636 427112 429211 429879 432884 434355 435607 442100 445787 446772 446776 454910 456788 462843 463781 466402 467024 469791 471030 471981 472755 475639 477500 479106 479351 479920 485296 490599 492406 493283 499531 499714 509762 515472 522978 527503 531379 533108 535324 540208 541422 546368 547520 555227 557878 558729 559973 560692 562418 567508 576483 577814 578169 581551 583464 583523 588759 590089 595548 595591 596983 602366 605535 609657 618071 628562 629495 652162 652321 653388 660397 661007 661539 664498 667463 674493 710402 712279 736045 751396 768791 776796 780262 785340 789559 796404 796939 802278 803404 803479 805743 807212 812467 812472 814097 817172 817964 819244 819418 820940 821964 824553 824735 824868 825396 826597 826599 827100 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo masturbation hairy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.93%) |
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.