Query Metrics
7
Database Queries
7
Different statements
197.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.07 ms (84.65%) |
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 6710 12887 95586 383565 383650 386709 387915 395746 397782 404194 407007 410688 421148 424480 440852 443142 448064 451509 456902 457010 462371 464125 465607 466434 466939 468031 469300 470625 474030 475277 480755 481965 482306 482553 482664 482755 483109 485051 496778 505100 509635 526250 532270 532352 532782 532808 533040 554796 555335 555356 557190 563235 563415 567754 569423 578701 581833 584705 592596 594896 596000 596477 604383 609991 610228 613117 613495 619645 623643 629818 648890 660748 665182 665862 668537 679457 694484 697210 702077 714864 715556 716405 717523 724133 724328 728169 728931 728933 737521 742965 750063 750461 757364 758617 766624 774613 786460 789968 790784 794800 796014 801975 807993 809421 810286 813442 814124 815057 815449 816261 816507 817024 817298 817855 818214 820335 821069 821449 825116 826278 ] |
||||||||||||||||||||||||||||||
|
19.16 ms (9.71%) |
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 424480 386709 95586 383565 383650 395746 12887 6710 387915 397782 404194 410688 440852 407007 443142 421148 816507 816261 817024 817298 817855 818214 815057 815449 820335 821449 825116 826278 814124 821069 456902 457010 466434 466939 469300 474030 482306 482664 483109 451509 468031 470625 475277 480755 448064 481965 482553 482755 485051 505100 532808 496778 532270 526250 532782 533040 509635 532352 462371 464125 465607 563235 578701 584705 554796 557190 567754 569423 581833 648890 665182 694484 702077 714864 716405 697210 717523 660748 665862 668537 679457 715556 555335 555356 563415 592596 596477 619645 629818 594896 596000 610228 623643 609991 786460 790784 794800 796014 774613 801975 809421 813442 789968 807993 810286 728931 737521 750063 724133 724328 728169 742965 757364 728933 750461 758617 766624 604383 613117 613495 ] |
||||||||||||||||||||||||||||||
|
3.83 ms (1.94%) |
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 6710 12887 95586 383565 383650 386709 387915 395746 397782 404194 407007 410688 421148 424480 440852 443142 448064 451509 456902 457010 462371 464125 465607 466434 466939 468031 469300 470625 474030 475277 480755 481965 482306 482553 482664 482755 483109 485051 496778 505100 509635 526250 532270 532352 532782 532808 533040 554796 555335 555356 557190 563235 563415 567754 569423 578701 581833 584705 592596 594896 596000 596477 604383 609991 610228 613117 613495 619645 623643 629818 648890 660748 665182 665862 668537 679457 694484 697210 702077 714864 715556 716405 717523 724133 724328 728169 728931 728933 737521 742965 750063 750461 757364 758617 766624 774613 786460 789968 790784 794800 796014 801975 807993 809421 810286 813442 814124 815057 815449 816261 816507 817024 817298 817855 818214 820335 821069 821449 825116 826278 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"facesitting mature"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фейсситтинг mature"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фейсситтинг mature"
]
|
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.