Query Metrics
7
Database Queries
7
Different statements
151.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.77 ms (83.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 147400 312466 314541 383311 390623 395407 395491 395536 396585 396605 397965 398047 399237 399267 399332 399395 400815 402574 403988 406488 406853 409015 409484 410867 416048 417887 420250 425358 429970 433549 433566 446870 451872 456114 456880 459668 462222 463092 465114 468471 469001 473064 482958 494997 502705 512122 516206 516426 528173 529385 530696 530744 530763 531614 533370 534831 536248 537661 543889 545802 547078 580290 584215 599836 599863 601039 601347 604479 604510 604682 605449 610817 621436 628126 629260 632579 633451 634008 636290 636666 638932 647608 648793 648817 649187 652699 688675 694930 697311 698959 703435 704179 712064 719797 720827 721016 723509 723539 732287 732354 736440 737470 744601 744612 747469 763934 787738 788234 792056 798686 798969 804483 804763 805877 809284 817049 818530 823566 824096 ] |
||||||||||||||||||||||||||||||
|
15.67 ms (10.35%) |
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 425358 636290 629260 396585 409015 314541 744612 396605 410867 530696 383311 469001 399267 398047 547078 647608 697311 732354 604682 420250 395407 649187 818530 395491 400815 652699 634008 537661 824096 712064 809284 798969 763934 399395 406853 736440 804763 468471 621436 744601 416048 403988 451872 787738 462222 723539 482958 788234 395536 512122 545802 817049 528173 543889 688675 719797 147400 533370 465114 397965 446870 417887 456880 720827 723509 604479 433549 632579 605449 399332 463092 473064 604510 406488 399237 459668 456114 516426 312466 648793 792056 601347 530744 694930 704179 638932 732287 529385 599863 633451 390623 823566 531192 534831 531614 584215 698959 610817 804483 805877 580290 599836 429970 703435 601039 747469 721016 433566 516206 636666 798686 628126 737470 530763 536248 648817 402574 409484 502705 494997 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.85%) |
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 147400 312466 314541 383311 390623 395407 395491 395536 396585 396605 397965 398047 399237 399267 399332 399395 400815 402574 403988 406488 406853 409015 409484 410867 416048 417887 420250 425358 429970 433549 433566 446870 451872 456114 456880 459668 462222 463092 465114 468471 469001 473064 482958 494997 502705 512122 516206 516426 528173 529385 530696 530744 530763 531614 533370 534831 536248 537661 543889 545802 547078 580290 584215 599836 599863 601039 601347 604479 604510 604682 605449 610817 621436 628126 629260 632579 633451 634008 636290 636666 638932 647608 648793 648817 649187 652699 688675 694930 697311 698959 703435 704179 712064 719797 720827 721016 723509 723539 732287 732354 736440 737470 744601 744612 747469 763934 787738 788234 792056 798686 798969 804483 804763 805877 809284 817049 818530 823566 824096 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc fuck girl"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc секс девушк"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc секс девушк"
]
|
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.