Query Metrics
7
Database Queries
7
Different statements
142.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.40 ms (86.15%) |
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 10665 13703 190735 381873 385291 394161 396389 397168 398263 400465 402119 415554 427656 427658 446135 448373 449910 453333 460172 463722 464095 464687 464955 465588 465620 466408 466658 467986 472238 481669 485699 486553 491874 497652 499688 511683 513188 515748 515860 519754 527505 530183 530922 532431 533255 534346 534354 534359 535012 536478 539800 542779 543589 549818 552055 556989 562993 566623 567726 572929 574257 574996 578150 578161 579608 580866 581500 582792 582793 584057 589503 597464 610570 617630 624940 650408 664798 665210 667498 685579 688148 694615 700327 709552 716493 728046 738088 738105 738244 744217 745554 746103 746692 752223 752448 754212 755405 757257 760673 768384 770508 770792 772078 772652 776728 776850 787341 787565 790003 794099 797383 797463 797867 800493 800861 801412 805356 808081 814912 817291 ] |
||||||||||||||||||||||||||||||
|
11.38 ms (8.01%) |
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 610570 776850 801412 385291 190735 394161 381873 10665 402119 817291 464095 465588 466408 533255 499688 530922 532431 543589 574996 694615 709552 650408 716493 549818 589503 617630 624940 597464 794099 797383 805356 790003 746103 754212 770792 772078 787341 797463 797867 800493 808081 738105 752223 757257 728046 738088 745554 746692 752448 738244 744217 768384 770508 755405 760673 772652 700327 776728 787565 800861 466658 13703 584057 396389 397168 398263 400465 415554 427656 427658 814912 448373 463722 464955 472238 446135 449910 453333 460172 467986 481669 485699 486553 497652 515860 530183 534346 534359 535012 536478 539800 511683 513188 519754 515748 527505 534354 464687 465620 491874 542779 552055 566623 567726 572929 578150 578161 556989 579608 580866 581500 582792 582793 562993 574257 665210 667498 685579 688148 664798 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.62%) |
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 10665 13703 190735 381873 385291 394161 396389 397168 398263 400465 402119 415554 427656 427658 446135 448373 449910 453333 460172 463722 464095 464687 464955 465588 465620 466408 466658 467986 472238 481669 485699 486553 491874 497652 499688 511683 513188 515748 515860 519754 527505 530183 530922 532431 533255 534346 534354 534359 535012 536478 539800 542779 543589 549818 552055 556989 562993 566623 567726 572929 574257 574996 578150 578161 579608 580866 581500 582792 582793 584057 589503 597464 610570 617630 624940 650408 664798 665210 667498 685579 688148 694615 700327 709552 716493 728046 738088 738105 738244 744217 745554 746103 746692 752223 752448 754212 755405 757257 760673 768384 770508 770792 772078 772652 776728 776850 787341 787565 790003 794099 797383 797463 797867 800493 800861 801412 805356 808081 814912 817291 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs ass"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.09 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs жоп"
]
|
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.