Query Metrics
7
Database Queries
7
Different statements
146.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.08 ms (84.76%) |
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 33998 58825 383549 384270 385470 386879 393504 396951 397072 398556 398830 414078 424728 444722 456997 457749 471570 511129 513935 518904 520207 526699 527154 530095 539654 543367 543740 545627 551145 555652 555822 566197 571702 575596 579696 585393 588855 592079 592145 595004 595478 604474 606150 607017 609840 617844 626561 630836 636750 641487 643582 646395 649713 653148 654274 657458 663823 673647 676191 680624 682268 684859 685926 692475 695773 697221 707217 707608 709623 712959 714795 714892 715555 718448 718786 718960 721122 721896 726265 726637 732984 732986 733273 737442 739196 742099 750123 751978 761398 761895 767874 770374 771490 774037 777909 779330 779565 780370 780447 783030 784767 786414 788274 789838 791424 792353 794250 796247 796628 796824 798762 802063 803806 807410 809219 812662 816682 817247 821497 ] |
||||||||||||||||||||||||||||||
|
11.97 ms (8.18%) |
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 393504 456997 539654 513935 530095 545627 579696 649713 692475 697221 707217 707608 657458 718960 630836 798762 807410 780447 732986 732984 750123 58825 444722 385470 398556 511129 520207 526699 575596 555652 695773 718786 721122 571702 585393 588855 595478 779330 796824 786414 761895 726265 773429 761398 770374 771490 774037 604474 714795 383549 398830 684859 396951 414078 816682 527154 551145 714892 718448 721896 685926 709623 682268 617844 626561 636750 788274 803806 742099 791424 751978 726637 739196 715555 777909 471570 543740 767874 386879 796247 784767 33998 384270 817247 653148 663823 780370 783030 397072 821497 543367 676191 654274 673647 555822 592145 641487 595004 643582 592079 802063 812662 737442 789838 733273 609840 796628 424728 457749 518904 566197 680624 646395 712959 607017 606150 792353 794250 809219 779565 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (2.07%) |
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 33998 58825 383549 384270 385470 386879 393504 396951 397072 398556 398830 414078 424728 444722 456997 457749 471570 511129 513935 518904 520207 526699 527154 530095 539654 543367 543740 545627 551145 555652 555822 566197 571702 575596 579696 585393 588855 592079 592145 595004 595478 604474 606150 607017 609840 617844 626561 630836 636750 641487 643582 646395 649713 653148 654274 657458 663823 673647 676191 680624 682268 684859 685926 692475 695773 697221 707217 707608 709623 712959 714795 714892 715555 718448 718786 718960 721122 721896 726265 726637 732984 732986 733273 737442 739196 742099 750123 751978 761398 761895 767874 770374 771490 774037 777909 779330 779565 780370 780447 783030 784767 786414 788274 789838 791424 792353 794250 796247 796628 796824 798762 802063 803806 807410 809219 812662 816682 817247 821497 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex in hotel"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hotel"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hotel"
]
|
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.