Query Metrics
7
Database Queries
7
Different statements
156.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.75 ms (84.10%) |
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 11870 383523 395867 414940 415836 419104 425891 426117 431323 433582 443699 445398 467904 473920 477482 477883 480134 480429 482090 483212 487026 489516 493818 498290 499041 501892 502290 506581 513824 518956 548675 548779 549326 550505 551017 552245 556423 556485 557812 558274 560192 560360 560381 560476 560619 563524 564080 564452 564461 564787 566013 568560 569422 570204 570400 571557 571890 573676 574496 574614 574792 576732 577369 582371 583591 588716 589134 594607 594826 598176 599934 600894 618725 652910 655124 659042 672878 674620 678574 678662 678996 679037 679091 681053 681699 683584 685955 702163 706912 716367 716374 718581 720786 721310 722585 726120 728902 730715 730788 730987 732080 735985 736345 744562 744901 795443 797592 810987 812305 815826 818282 818299 818776 820047 820766 822295 823165 823173 824395 827045 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (9.28%) |
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 569422 571557 573676 574496 722585 678662 679037 681053 683584 716374 721310 552245 570204 598176 618725 797592 736345 728902 726120 718581 810987 812305 395867 506581 487026 560192 431323 502290 548675 560476 583591 659042 576732 594826 600894 730715 443699 556485 702163 498290 550505 557812 560619 588716 594607 467904 425891 482090 473920 480429 489516 11870 685955 556423 574792 483212 415836 445398 493818 582371 577369 599934 513824 426117 823165 818776 824395 827045 518956 652910 716367 655124 730987 735985 744562 732080 744901 795443 589134 730788 501892 383523 419104 433582 414940 818299 823173 815826 820047 822295 818282 820766 480134 477883 477482 499041 560360 560381 564080 564452 571890 549326 551017 564787 566013 548779 558274 563524 564461 568560 570400 574614 674620 678996 706912 678574 681699 720786 672878 679091 ] |
||||||||||||||||||||||||||||||
|
3.53 ms (2.25%) |
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 11870 383523 395867 414940 415836 419104 425891 426117 431323 433582 443699 445398 467904 473920 477482 477883 480134 480429 482090 483212 487026 489516 493818 498290 499041 501892 502290 506581 513824 518956 548675 548779 549326 550505 551017 552245 556423 556485 557812 558274 560192 560360 560381 560476 560619 563524 564080 564452 564461 564787 566013 568560 569422 570204 570400 571557 571890 573676 574496 574614 574792 576732 577369 582371 583591 588716 589134 594607 594826 598176 599934 600894 618725 652910 655124 659042 672878 674620 678574 678662 678996 679037 679091 681053 681699 683584 685955 702163 706912 716367 716374 718581 720786 721310 722585 726120 728902 730715 730788 730987 732080 735985 736345 744562 744901 795443 797592 810987 812305 815826 818282 818299 818776 820047 820766 822295 823165 823173 824395 827045 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny lick ass"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые лиза жоп"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.