Query Metrics
7
Database Queries
7
Different statements
171.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.74 ms (84.89%) |
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 357499 382502 391959 400483 415319 423516 429902 432323 434350 441107 441124 443095 446949 447145 448082 452810 455918 457476 459204 464853 464951 468269 468366 469617 470052 471685 471696 473439 473446 473450 476152 476166 477128 480656 485281 491925 493749 497906 499927 509976 510807 512935 513672 515441 531866 534529 534540 534544 534552 534559 539741 544163 545342 545438 547464 547471 547476 547809 550925 555337 559781 561002 576503 583882 589408 593274 602283 604213 605033 620769 624837 638991 639736 656895 658819 664226 669016 670356 670360 670364 671002 671458 672944 690050 692714 694142 695603 710877 714607 715593 726281 726942 726986 731328 733332 737185 738824 739558 742318 748979 749672 750301 751627 751773 752598 752656 757372 757435 757445 757596 766860 767111 777742 781332 787516 794755 795731 800854 811102 814386 ] |
||||||||||||||||||||||||||||||
|
16.38 ms (9.54%) |
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 434350 480656 468269 455918 512935 547809 429902 476152 382502 400483 446949 448082 452810 491925 485281 513672 497906 726986 638991 794755 726281 509976 473439 811102 441107 415319 423516 443095 464853 457476 473450 469617 539741 534552 464951 468366 476166 576503 583882 544163 555337 561002 672944 670356 670360 690050 714607 547471 604213 620769 624837 726942 751773 742318 757596 731328 752598 800854 391959 357499 471685 477128 510807 432323 441124 814386 447145 471696 459204 493749 470052 473446 499927 515441 531866 534529 534540 534544 534559 545342 547464 547476 545438 550925 670364 671002 671458 692714 695603 715593 656895 658819 664226 669016 694142 559781 593274 602283 589408 777742 781332 757372 787516 795731 748979 766860 737185 751627 767111 733332 739558 750301 757445 738824 749672 752656 757435 605033 639736 710877 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.52%) |
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 357499 382502 391959 400483 415319 423516 429902 432323 434350 441107 441124 443095 446949 447145 448082 452810 455918 457476 459204 464853 464951 468269 468366 469617 470052 471685 471696 473439 473446 473450 476152 476166 477128 480656 485281 491925 493749 497906 499927 509976 510807 512935 513672 515441 531866 534529 534540 534544 534552 534559 539741 544163 545342 545438 547464 547471 547476 547809 550925 555337 559781 561002 576503 583882 589408 593274 602283 604213 605033 620769 624837 638991 639736 656895 658819 664226 669016 670356 670360 670364 671002 671458 672944 690050 692714 694142 695603 710877 714607 715593 726281 726942 726986 731328 733332 737185 738824 739558 742318 748979 749672 750301 751627 751773 752598 752656 757372 757435 757445 757596 766860 767111 777742 781332 787516 794755 795731 800854 811102 814386 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал мастурбац"
]
|
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.