Query Metrics
7
Database Queries
7
Different statements
164.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.62 ms (84.89%) |
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 4306 383323 393641 396797 397087 397970 398354 398693 399300 415658 418060 418357 420078 425157 433619 434899 436343 436953 437417 439417 441425 441427 441467 441595 441808 442475 443865 443897 445355 447090 448483 448496 448573 449144 449541 451133 451277 451406 452636 453820 458448 459863 464655 465233 469421 477702 478841 486135 487567 490171 493618 494635 506616 508104 508876 512297 513921 514845 519840 521050 525942 529879 559535 564118 568807 569623 582549 583279 584305 594897 597213 599653 601587 608311 617590 619192 626002 626725 631334 632541 633036 644738 656607 665435 668942 681208 690618 690886 691180 701535 707450 710620 711328 711375 720197 725971 730305 734964 747461 757630 759321 760471 761144 761801 763445 766191 767682 773853 779753 781210 785600 787739 787868 790119 791060 791074 791834 811279 816606 827977 ] |
||||||||||||||||||||||||||||||
|
12.58 ms (7.65%) |
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 448483 487567 773853 631334 442475 568807 453820 494635 514845 529879 594897 633036 707450 779753 785600 730305 767682 787739 790119 761144 781210 811279 508876 525942 766191 449144 760471 439417 447090 599653 451133 619192 506616 720197 690886 425157 393641 441467 445355 827977 601587 787868 763445 711375 441425 448573 469421 519840 513921 521050 383323 397087 397970 398693 434899 433619 816606 464655 448496 451406 583279 656607 690618 681208 691180 701535 710620 711328 668942 632541 644738 791074 791834 734964 747461 725971 757630 436953 441808 418060 437417 486135 396797 441427 441595 451277 459863 465233 617590 490171 564118 584305 759321 761801 399300 415658 559535 512297 569623 608311 597213 626002 626725 791060 477702 420078 436343 478841 449541 508104 582549 665435 4306 398354 443865 418357 493618 458448 443897 452636 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк жен красивая"
]
|
||||||||||||||||||||||||||||||
|
3.37 ms (2.05%) |
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 4306 383323 393641 396797 397087 397970 398354 398693 399300 415658 418060 418357 420078 425157 433619 434899 436343 436953 437417 439417 441425 441427 441467 441595 441808 442475 443865 443897 445355 447090 448483 448496 448573 449144 449541 451133 451277 451406 452636 453820 458448 459863 464655 465233 469421 477702 478841 486135 487567 490171 493618 494635 506616 508104 508876 512297 513921 514845 519840 521050 525942 529879 559535 564118 568807 569623 582549 583279 584305 594897 597213 599653 601587 608311 617590 619192 626002 626725 631334 632541 633036 644738 656607 665435 668942 681208 690618 690886 691180 701535 707450 710620 711328 711375 720197 725971 730305 734964 747461 757630 759321 760471 761144 761801 763445 766191 767682 773853 779753 781210 785600 787739 787868 790119 791060 791074 791834 811279 816606 827977 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молодая соседка красивая"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.90%) |
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.