Query Metrics
7
Database Queries
7
Different statements
163.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.80 ms (84.40%) |
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 73218 183517 263727 357595 382456 382535 383715 384889 386658 389798 392270 398351 402043 402897 403458 407698 431476 434754 443301 447535 453016 457051 459854 462455 464011 466903 470221 470964 472920 479954 480764 482782 486380 487648 491914 503838 509727 510117 512570 514572 515911 519387 520968 522404 522895 524751 529154 533499 533740 534811 545718 552256 553937 554600 556867 557851 558411 559072 559711 561079 564738 565773 566323 566880 568454 576686 578661 578664 578670 585362 585363 585388 591208 593666 594960 596816 596882 596900 596904 596907 596915 598676 602829 603713 609610 610044 627319 634683 636333 642275 642928 643004 643018 643233 643350 650038 677963 678221 696067 699548 700724 700834 708263 711685 712309 715768 723075 729951 731092 747055 761577 773399 773998 781674 783003 787713 792603 792825 803703 807504 ] |
||||||||||||||||||||||||||||||
|
14.65 ms (8.97%) |
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 596900 559711 576686 578664 487648 578670 384889 263727 457051 642275 466903 559072 678221 585362 593666 642928 787713 634683 643004 565773 392270 382456 403458 520968 715768 708263 402043 594960 383715 389798 73218 566323 522404 803703 557851 596816 747055 568454 552256 561079 578661 431476 510117 609610 398351 459854 534811 643233 585388 596907 773998 610044 512570 480764 515911 470964 729951 486380 533499 514572 382535 407698 650038 712309 522895 464011 677963 443301 479954 596882 596915 603713 602829 447535 519387 524751 509727 529154 472920 533740 554600 556867 700724 553937 636333 643018 807504 773399 470221 503838 564738 783003 482782 696067 781674 699548 761577 558411 434754 792603 731092 792825 596904 711685 643350 585363 566880 700834 453016 723075 402897 545718 491914 183517 598676 591208 627319 357595 462455 386658 ] |
||||||||||||||||||||||||||||||
|
3.70 ms (2.27%) |
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 73218 183517 263727 357595 382456 382535 383715 384889 386658 389798 392270 398351 402043 402897 403458 407698 431476 434754 443301 447535 453016 457051 459854 462455 464011 466903 470221 470964 472920 479954 480764 482782 486380 487648 491914 503838 509727 510117 512570 514572 515911 519387 520968 522404 522895 524751 529154 533499 533740 534811 545718 552256 553937 554600 556867 557851 558411 559072 559711 561079 564738 565773 566323 566880 568454 576686 578661 578664 578670 585362 585363 585388 591208 593666 594960 596816 596882 596900 596904 596907 596915 598676 602829 603713 609610 610044 627319 634683 636333 642275 642928 643004 643018 643233 643350 650038 677963 678221 696067 699548 700724 700834 708263 711685 712309 715768 723075 729951 731092 747055 761577 773399 773998 781674 783003 787713 792603 792825 803703 807504 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"maid blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горничн минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.89%) |
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.