Query Metrics
7
Database Queries
7
Different statements
205.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.17 ms (83.97%) |
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 131512 385162 391427 397942 419854 420005 420013 422107 432724 456530 459666 468914 471184 474968 474969 495459 495603 500092 500598 503695 511492 519102 529731 529995 534619 534801 537003 541783 543297 543946 544807 545267 545759 550674 550899 554717 554794 555076 558095 558717 559345 563969 564242 564297 567001 575028 593028 599785 602102 604849 611232 617697 618222 620234 620238 621230 626351 628448 630672 633182 634391 635617 635636 648905 655585 656827 656852 662864 663769 664091 668592 670826 688741 692112 695419 704704 708010 708462 716522 719883 720956 723078 723968 747538 751510 751700 753780 758176 760838 761156 761604 762099 765577 766406 769019 773324 777327 790423 790434 793182 793185 797199 801782 802412 803695 805703 807994 810402 810940 811987 818983 819099 824800 825665 827454 827555 827994 828199 828215 828295 ] |
||||||||||||||||||||||||||||||
|
22.17 ms (10.81%) |
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 769019 765577 758176 621230 633182 708010 777327 811987 468914 723968 618222 655585 719883 503695 824800 825665 819099 827454 828199 828295 827555 695419 656827 688741 634391 762099 500092 626351 420013 575028 803695 704704 554794 391427 827994 541783 543297 558717 397942 495459 663769 761604 500598 529731 545759 558095 611232 753780 766406 420005 818983 810940 668592 747538 617697 559345 419854 805703 529995 534801 550899 563969 564297 802412 793185 810402 773324 751510 620234 708462 793182 807994 456530 474969 550674 554717 564242 801782 630672 797199 459666 670826 602102 385162 471184 543946 544807 723078 648905 662864 692112 593028 599785 790434 635636 432724 474968 495603 511492 545267 422107 828215 790423 760838 567001 537003 656852 635617 628448 534619 604849 519102 720956 716522 664091 555076 761156 751700 131512 620238 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (1.58%) |
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 131512 385162 391427 397942 419854 420005 420013 422107 432724 456530 459666 468914 471184 474968 474969 495459 495603 500092 500598 503695 511492 519102 529731 529995 534619 534801 537003 541783 543297 543946 544807 545267 545759 550674 550899 554717 554794 555076 558095 558717 559345 563969 564242 564297 567001 575028 593028 599785 602102 604849 611232 617697 618222 620234 620238 621230 626351 628448 630672 633182 634391 635617 635636 648905 655585 656827 656852 662864 663769 664091 668592 670826 688741 692112 695419 704704 708010 708462 716522 719883 720956 723078 723968 747538 751510 751700 753780 758176 760838 761156 761604 762099 765577 766406 769019 773324 777327 790423 790434 793182 793185 797199 801782 802412 803695 805703 807994 810402 810940 811987 818983 819099 824800 825665 827454 827555 827994 828199 828215 828295 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife public anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен на улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.81%) |
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.