Query Metrics
7
Database Queries
7
Different statements
220.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.37 ms (88.72%) |
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 384015 384234 395846 395889 396879 402896 405191 408032 408293 413861 415882 430004 430792 430835 445955 452057 465290 465970 469061 476280 491975 502778 518312 535010 537698 546883 556643 561771 562874 563452 563456 568051 571035 581119 591546 596128 596692 597972 600311 601619 616188 623912 643092 647682 676581 684336 688016 695618 696165 696599 702050 703438 706842 708843 717355 723731 725375 726677 727392 729822 730225 730524 734677 734730 737066 737089 741194 744591 755464 761321 768420 769377 776584 776632 780614 784304 786168 788700 789679 790897 795180 797780 800009 800110 801592 801884 803263 804170 804943 807605 810343 811488 813785 814895 815173 815372 815876 816052 816206 816501 817312 817800 817852 818343 818822 818882 818895 819054 819069 819508 820060 820744 821083 821379 823163 824247 824491 824953 826349 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (6.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 813785 815182 815372 817800 819069 823163 824953 814895 816206 816501 820060 820744 821083 821379 546883 568051 562874 696599 717355 676581 695618 688016 563452 643092 591546 596128 601619 776584 801592 780614 801884 810343 725375 727392 730225 741194 769377 786168 795180 800009 734677 744591 726677 730524 729822 761321 708843 776632 788700 797780 804170 807605 384234 465290 476280 502778 465970 408293 563456 413861 571035 395846 408032 623912 804943 784304 818895 803263 452057 415882 430004 469061 384015 518312 430835 395889 396879 445955 491975 818882 819054 815173 817312 817852 826349 537698 684336 703438 706842 696165 561771 737066 737089 755464 768420 702050 800110 556643 535010 824247 818343 581119 405191 815876 647682 600311 430792 734730 818822 596692 402896 824491 816052 819508 616188 597972 789679 790897 811488 723731 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.30%) |
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 384015 384234 395846 395889 396879 402896 405191 408032 408293 413861 415882 430004 430792 430835 445955 452057 465290 465970 469061 476280 491975 502778 518312 535010 537698 546883 556643 561771 562874 563452 563456 568051 571035 581119 591546 596128 596692 597972 600311 601619 616188 623912 643092 647682 676581 684336 688016 695618 696165 696599 702050 703438 706842 708843 717355 723731 725375 726677 727392 729822 730225 730524 734677 734730 737066 737089 741194 744591 755464 761321 768420 769377 776584 776632 780614 784304 786168 788700 789679 790897 795180 797780 800009 800110 801592 801884 803263 804170 804943 807605 810343 811488 813785 814895 815173 815372 815876 816052 816206 816501 817312 817800 817852 818343 818822 818882 818895 819054 819069 819508 820060 820744 821083 821379 823163 824247 824491 824953 826349 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cunnilingus mom"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куннилингус оральн секс mom"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куннилингус оральн секс mom"
]
|
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.