Query Metrics
7
Database Queries
7
Different statements
215.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.84 ms (86.26%) |
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 330478 335472 395759 402530 402592 404695 423368 425222 425988 426540 428876 434822 437589 441018 444288 446897 447102 447709 448434 453501 455972 458785 464486 481798 482161 487140 492732 492740 493311 494508 498352 501477 502554 504897 504929 507129 510047 512738 516546 518920 519610 521257 523017 523345 523421 523428 525713 528719 534308 534389 537807 540490 543180 546532 547931 550463 550796 552359 554294 554525 558992 559711 560746 561594 563013 564805 567355 568139 568317 575037 578150 578767 578784 578803 581734 585746 587253 588196 591973 592817 597079 601035 602492 604955 606771 606916 607007 608172 615311 621582 623035 638552 648634 665399 666049 667199 687960 689014 702509 702867 714142 715397 715402 723629 725633 727076 731888 742656 746489 751903 751920 763313 763810 771918 776503 788562 791745 799042 802868 808946 ] |
||||||||||||||||||||||||||||||
|
17.96 ms (8.34%) |
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 578784 648634 623035 521257 587253 492740 575037 588196 523017 715397 458785 552359 567355 523428 425222 534308 554525 714142 751920 763810 751903 601035 455972 561594 437589 602492 519610 453501 504929 666049 501477 482161 578803 808946 447102 554294 563013 534389 802868 591973 621582 578150 606771 441018 493311 568139 581734 607007 788562 510047 560746 550796 444288 512738 492732 428876 702509 667199 776503 330478 528719 426540 559711 540490 494508 523345 771918 543180 558992 423368 665399 715402 725633 742656 608172 702867 727076 402530 606916 763313 638552 604955 464486 791745 448434 525713 550463 516546 585746 502554 592817 547931 504897 434822 481798 404695 578767 523421 689014 597079 731888 799042 487140 546532 564805 425988 335472 446897 507129 402592 518920 537807 447709 568317 498352 395759 723629 687960 615311 746489 ] |
||||||||||||||||||||||||||||||
|
4.64 ms (2.16%) |
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 330478 335472 395759 402530 402592 404695 423368 425222 425988 426540 428876 434822 437589 441018 444288 446897 447102 447709 448434 453501 455972 458785 464486 481798 482161 487140 492732 492740 493311 494508 498352 501477 502554 504897 504929 507129 510047 512738 516546 518920 519610 521257 523017 523345 523421 523428 525713 528719 534308 534389 537807 540490 543180 546532 547931 550463 550796 552359 554294 554525 558992 559711 560746 561594 563013 564805 567355 568139 568317 575037 578150 578767 578784 578803 581734 585746 587253 588196 591973 592817 597079 601035 602492 604955 606771 606916 607007 608172 615311 621582 623035 638552 648634 665399 666049 667199 687960 689014 702509 702867 714142 715397 715402 723629 725633 727076 731888 742656 746489 751903 751920 763313 763810 771918 776503 788562 791745 799042 802868 808946 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cheating wife blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cheating жен минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cheating жен минет оральн секс"
]
|
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.