Query Metrics
7
Database Queries
7
Different statements
182.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.22 ms (87.66%) |
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 96463 388422 389451 393531 396482 400005 413125 413805 452204 458238 482615 515270 521860 529623 537593 545218 545251 550595 557630 562998 563691 565902 574964 576511 578166 581275 593919 612098 613435 618600 624989 629169 629472 631884 633435 634585 635073 635325 643612 653319 655163 655683 656363 662474 662522 668105 678572 681663 684823 686148 687040 689857 696058 705067 713683 714808 717955 718134 718143 722408 723522 726263 727589 728887 730052 730362 736987 737049 740181 742674 743157 744726 745434 745513 753189 754401 757987 762748 764290 765909 768301 768826 770069 770423 771418 779918 781368 781748 782401 785984 789487 790407 791475 793245 793797 794901 795016 796074 798345 798920 800729 801372 801616 801947 803435 803953 805334 808240 811087 811965 815677 817020 819137 821187 821388 822848 823750 824913 825249 825708 ] |
||||||||||||||||||||||||||||||
|
12.98 ms (7.10%) |
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 413125 822848 817020 821388 458238 452204 521860 515270 578166 689857 696058 714808 681663 718143 655163 655683 668105 718134 618600 791475 798345 779918 789487 811087 727589 728887 740181 764290 801947 726263 745434 762748 793797 811965 393531 389451 823750 825249 821187 824913 819137 482615 529623 563691 545251 545218 662522 687040 653319 550595 613435 631884 635325 793245 800729 801616 736987 771418 795016 768301 742674 770423 730052 743157 629169 413805 396482 633435 400005 723522 825708 815677 581275 557630 574964 562998 565902 656363 684823 717955 686148 662474 713683 576511 593919 634585 624989 612098 643612 781748 785984 790407 794901 801372 805334 808240 781368 803435 737049 753189 768826 782401 803953 745513 730362 754401 765909 770069 757987 744726 629472 635073 705067 722408 796074 798920 96463 388422 678572 537593 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.71%) |
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 96463 388422 389451 393531 396482 400005 413125 413805 452204 458238 482615 515270 521860 529623 537593 545218 545251 550595 557630 562998 563691 565902 574964 576511 578166 581275 593919 612098 613435 618600 624989 629169 629472 631884 633435 634585 635073 635325 643612 653319 655163 655683 656363 662474 662522 668105 678572 681663 684823 686148 687040 689857 696058 705067 713683 714808 717955 718134 718143 722408 723522 726263 727589 728887 730052 730362 736987 737049 740181 742674 743157 744726 745434 745513 753189 754401 757987 762748 764290 765909 768301 768826 770069 770423 771418 779918 781368 781748 782401 785984 789487 790407 791475 793245 793797 794901 795016 796074 798345 798920 800729 801372 801616 801947 803435 803953 805334 808240 811087 811965 815677 817020 819137 821187 821388 822848 823750 824913 825249 825708 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love fuck"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.27 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love секс"
]
|
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.