Query Metrics
7
Database Queries
7
Different statements
218.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.56 ms (85.07%) |
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 414361 417328 418402 419739 431323 443649 443651 444720 445356 447709 454398 456690 461436 462560 465525 467311 468019 470078 471322 472840 477043 481766 487031 487068 487077 487082 487206 489599 490033 490208 491664 508777 509400 510275 512336 513025 517048 517612 519859 519925 520721 522567 524235 524694 529300 533256 533258 533260 533867 534798 539839 540524 545719 546006 548652 548751 552264 554273 555908 558437 558440 558441 558447 560479 561129 565446 566850 567633 574759 574842 575119 575454 575467 575516 576023 576030 576074 576344 577108 577120 578078 581673 590898 592550 592728 599229 604704 605650 606700 611669 612030 639974 644722 644967 653876 654799 655348 656009 656400 656472 657079 660512 663875 663936 697169 699401 709052 712905 712907 720924 734399 742209 744822 745015 781671 781727 803076 808290 823924 824703 ] |
||||||||||||||||||||||||||||||
|
21.60 ms (9.90%) |
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 566850 576344 581673 545719 561129 576030 577120 552264 443649 447709 477043 445356 462560 490208 510275 522567 519859 487206 577108 465525 558441 592728 456690 567633 605650 699401 431323 644967 490033 533256 533260 533867 539839 534798 509400 533258 540524 470078 575119 575516 560479 565446 574759 575454 548652 574842 578078 720924 655348 656400 663936 697169 712905 654799 656472 657079 660512 663875 709052 712907 546006 554273 555908 575467 590898 604704 599229 606700 611669 644722 639974 781727 803076 742209 745015 612030 781671 418402 454398 419739 471322 414361 467311 508777 519925 487068 489599 524694 487077 487082 744822 734399 823924 472840 653876 592550 444720 520721 529300 513025 468019 517612 524235 548751 558437 558447 576074 481766 443651 487031 491664 512336 824703 576023 461436 417328 517048 656009 808290 558440 ] |
||||||||||||||||||||||||||||||
|
4.42 ms (2.02%) |
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 414361 417328 418402 419739 431323 443649 443651 444720 445356 447709 454398 456690 461436 462560 465525 467311 468019 470078 471322 472840 477043 481766 487031 487068 487077 487082 487206 489599 490033 490208 491664 508777 509400 510275 512336 513025 517048 517612 519859 519925 520721 522567 524235 524694 529300 533256 533258 533260 533867 534798 539839 540524 545719 546006 548652 548751 552264 554273 555908 558437 558440 558441 558447 560479 561129 565446 566850 567633 574759 574842 575119 575454 575467 575516 576023 576030 576074 576344 577108 577120 578078 581673 590898 592550 592728 599229 604704 605650 606700 611669 612030 639974 644722 644967 653876 654799 655348 656009 656400 656472 657079 660512 663875 663936 697169 699401 709052 712905 712907 720924 734399 742209 744822 745015 781671 781727 803076 808290 823924 824703 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд лиза pussy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold lick pussy"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд лиза pussy"
]
|
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.