Query Metrics
7
Database Queries
7
Different statements
158.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.84 ms (85.04%) |
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 28690 33260 382939 397625 444603 451224 452751 457507 458661 460477 463204 465499 472842 486117 494886 495111 496617 499752 507442 518904 532814 539340 543629 554884 575696 577145 577865 584241 591777 591862 591931 592218 592907 602014 603546 603714 604951 606168 610342 610777 612263 616493 616520 616852 617526 619670 621781 623885 626124 626261 628644 629821 630150 631801 634968 639021 644201 648424 652004 660342 662826 672776 678869 678906 680618 691205 696986 696989 698780 702001 703976 705428 712241 713687 717651 720163 720187 724846 725030 725074 728956 729142 732590 732868 734373 737280 739779 746736 750381 760611 761119 761596 761599 761706 761922 764188 779554 782015 786718 789036 792368 793540 796062 796353 798169 800712 800976 801003 801014 801145 801251 801653 802274 810110 810112 811645 816683 819832 823747 824904 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (8.80%) |
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 616520 610342 617526 623885 789036 792368 800712 798169 801653 729142 761706 793540 796062 796353 810110 737280 764188 760611 761119 713687 801014 444603 819832 824904 712241 720163 631801 451224 458661 495111 629821 696986 702001 717651 779554 746736 761596 577145 612263 397625 823747 472842 518904 507442 543629 554884 648424 703976 660342 672776 678906 639021 591777 591931 602014 610777 619670 591862 606168 801251 810112 786718 811645 725030 734373 761599 724846 761922 616852 626261 720187 782015 802274 463204 486117 494886 604951 644201 621781 628644 732868 603546 452751 33260 532814 584241 592218 457507 691205 725074 626124 728956 732590 739779 630150 382939 816683 28690 465499 460477 496617 499752 539340 575696 577865 705428 662826 678869 680618 696989 652004 698780 592907 616493 634968 603714 800976 801003 801145 750381 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.06%) |
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 28690 33260 382939 397625 444603 451224 452751 457507 458661 460477 463204 465499 472842 486117 494886 495111 496617 499752 507442 518904 532814 539340 543629 554884 575696 577145 577865 584241 591777 591862 591931 592218 592907 602014 603546 603714 604951 606168 610342 610777 612263 616493 616520 616852 617526 619670 621781 623885 626124 626261 628644 629821 630150 631801 634968 639021 644201 648424 652004 660342 662826 672776 678869 678906 680618 691205 696986 696989 698780 702001 703976 705428 712241 713687 717651 720163 720187 724846 725030 725074 728956 729142 732590 732868 734373 737280 739779 746736 750381 760611 761119 761596 761599 761706 761922 764188 779554 782015 786718 789036 792368 793540 796062 796353 798169 800712 800976 801003 801014 801145 801251 801653 802274 810110 810112 811645 816683 819832 823747 824904 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampied wife"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampied жен"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampied жен"
]
|
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.