Query Metrics
7
Database Queries
7
Different statements
256.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
232.00 ms (90.28%) |
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 453818 496239 496243 505837 509465 519847 534425 540655 542741 544275 546912 550961 551639 553632 557922 561281 562772 563434 564326 564960 568578 585552 585627 588323 588825 589011 593151 596868 600358 612247 612971 619909 621220 623948 629315 630507 633135 634229 645258 648517 653952 658903 666457 669514 672307 675410 678180 678901 680572 680579 682300 686224 698154 698873 701875 706136 707059 710968 711555 712325 718394 720607 721487 722124 722341 723874 724766 726177 726523 726715 726958 729402 733498 736797 739978 740115 740531 741060 741760 742359 744436 745980 746331 748416 750813 756273 756804 759958 760476 760973 761294 763303 763626 769160 771068 777172 777846 777914 779877 782065 782978 784272 788301 790079 790844 791425 794090 794760 795988 796723 797001 800562 800565 801063 801148 802762 804524 807360 808447 811079 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (5.62%) |
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 453818 505837 509465 519847 540655 496239 496243 534425 544275 553632 562772 542741 550961 551639 564326 546912 557922 561281 648517 653952 675410 678180 680579 682300 686224 698873 711555 645258 658903 669514 672307 678901 680572 701875 706136 712325 718394 722341 666457 707059 721487 722124 563434 564960 568578 588323 612247 612971 629315 630507 585552 588825 623948 634229 589011 596868 600358 585627 593151 777914 790844 794090 795988 800562 800565 801148 807360 777846 782978 788301 726523 726715 729402 740115 741060 741760 744436 745980 750813 759958 769160 790079 794760 796723 808447 724766 740531 746331 760476 723874 726958 736797 756273 760973 761294 763303 771068 726177 733498 739978 742359 748416 756804 763626 619909 621220 633135 698154 710968 720607 777172 779877 782065 784272 791425 797001 801063 802762 804524 811079 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.08%) |
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 453818 496239 496243 505837 509465 519847 534425 540655 542741 544275 546912 550961 551639 553632 557922 561281 562772 563434 564326 564960 568578 585552 585627 588323 588825 589011 593151 596868 600358 612247 612971 619909 621220 623948 629315 630507 633135 634229 645258 648517 653952 658903 666457 669514 672307 675410 678180 678901 680572 680579 682300 686224 698154 698873 701875 706136 707059 710968 711555 712325 718394 720607 721487 722124 722341 723874 724766 726177 726523 726715 726958 729402 733498 736797 739978 740115 740531 741060 741760 742359 744436 745980 746331 748416 750813 756273 756804 759958 760476 760973 761294 763303 763626 769160 771068 777172 777846 777914 779877 782065 782978 784272 788301 790079 790844 791425 794090 794760 795988 796723 797001 800562 800565 801063 801148 802762 804524 807360 808447 811079 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass-to-mouth"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп mouth"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.62%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп mouth"
]
|
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.