Query Metrics
7
Database Queries
7
Different statements
184.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.65 ms (88.21%) |
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 81588 261088 384503 384881 386653 386876 387857 387895 392393 393754 393759 396473 396805 398231 398731 400440 400449 400452 401975 401996 416303 417220 443381 443967 453621 463170 464317 470840 470846 491796 511415 519976 530358 530392 539519 541912 544301 545529 548732 549912 551557 568576 569690 569959 570071 571210 571218 574589 583872 603304 612861 613465 617759 618422 621620 622111 624239 628330 635897 641439 655685 655691 656381 656474 657730 657949 658066 658419 659601 665128 665271 665431 665883 673260 673985 675737 681213 682180 683546 684205 685587 686073 697307 703105 706912 708082 712825 714428 716078 716264 717887 720487 720491 721434 722651 722687 722738 722897 723492 730556 732078 732116 732120 732402 738256 744293 755512 759574 774158 775816 788582 788963 789433 789886 794517 810939 816797 817335 819550 825119 ] |
||||||||||||||||||||||||||||||
|
12.31 ms (6.67%) |
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 401996 545529 706912 665128 665431 683546 708082 665271 720487 583872 622111 613465 624239 810939 774158 716264 720491 384881 393759 396805 511415 416303 697307 571210 714428 603304 612861 443967 732116 401975 722897 568576 464317 519976 717887 817335 386876 398231 617759 794517 744293 775816 400449 470846 398731 665883 682180 685587 656474 621620 387857 384503 530358 541912 684205 712825 628330 641439 738256 789433 393754 569690 551557 722738 463170 400440 470840 400452 816797 569959 574589 673260 686073 681213 716078 722687 732402 732078 732120 759574 703105 722651 387895 261088 386653 392393 396473 417220 825119 571218 788582 723492 453621 81588 819550 539519 530392 549912 544301 657730 658066 655691 657949 658419 673985 655685 656381 659601 675737 721434 635897 788963 789886 755512 730556 618422 443381 491796 570071 548732 ] |
||||||||||||||||||||||||||||||
|
2.48 ms (1.34%) |
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 81588 261088 384503 384881 386653 386876 387857 387895 392393 393754 393759 396473 396805 398231 398731 400440 400449 400452 401975 401996 416303 417220 443381 443967 453621 463170 464317 470840 470846 491796 511415 519976 530358 530392 539519 541912 544301 545529 548732 549912 551557 568576 569690 569959 570071 571210 571218 574589 583872 603304 612861 613465 617759 618422 621620 622111 624239 628330 635897 641439 655685 655691 656381 656474 657730 657949 658066 658419 659601 665128 665271 665431 665883 673260 673985 675737 681213 682180 683546 684205 685587 686073 697307 703105 706912 708082 712825 714428 716078 716264 717887 720487 720491 721434 722651 722687 722738 722897 723492 730556 732078 732116 732120 732402 738256 744293 755512 759574 774158 775816 788582 788963 789433 789886 794517 810939 816797 817335 819550 825119 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl 18"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк 18"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк 18"
]
|
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.