Query Metrics
7
Database Queries
7
Different statements
144.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.77 ms (85.44%) |
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 152479 385470 386621 388226 395317 398747 427798 427912 444722 499348 511129 513935 517280 526699 530559 533162 539654 553188 553831 555652 557794 562453 585550 587025 587837 587978 588483 590214 590223 591184 592680 594581 596983 602137 617914 623372 625617 626561 632441 633030 634948 661647 669277 681343 684886 689477 692475 697221 697245 697597 705211 706439 708280 710294 710489 711625 715468 716111 717307 718733 721896 723807 725620 726755 728525 728712 731304 732986 737286 737538 739196 740906 742271 742665 745553 748879 748880 749662 751978 757654 761676 762499 771437 771490 773928 777217 778484 779804 779875 780345 785824 786477 789611 791424 793113 793308 794181 795197 795985 796103 796492 798793 799983 800935 802577 807410 809242 812269 812438 813477 813715 816682 818135 819724 820736 824488 825797 827260 827877 827914 ] |
||||||||||||||||||||||||||||||
|
12.30 ms (8.49%) |
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 590223 590214 499348 585550 827260 798793 748879 728525 539654 795197 562453 715468 794181 779875 813715 706439 710294 742271 742665 725620 789611 745553 825797 533162 591184 632441 761676 726755 780345 386621 594581 427912 697245 634948 819724 818135 820736 827877 827914 530559 587837 592680 778484 796492 812269 749662 731304 748880 737538 757654 771437 625617 812438 398747 689477 717307 793308 388226 427798 824488 553831 661647 684886 705211 587978 617914 623372 793113 762499 737286 728712 633030 710489 786477 697597 152479 517280 513935 557794 711625 669277 692475 697221 553188 587025 588483 602137 596983 779804 807410 723807 813477 732986 796103 809242 444722 511129 816682 739196 395317 740906 385470 526699 555652 718733 721896 708280 681343 716111 626561 802577 777217 795985 800935 773928 791424 751978 771490 785824 799983 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.76%) |
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 152479 385470 386621 388226 395317 398747 427798 427912 444722 499348 511129 513935 517280 526699 530559 533162 539654 553188 553831 555652 557794 562453 585550 587025 587837 587978 588483 590214 590223 591184 592680 594581 596983 602137 617914 623372 625617 626561 632441 633030 634948 661647 669277 681343 684886 689477 692475 697221 697245 697597 705211 706439 708280 710294 710489 711625 715468 716111 717307 718733 721896 723807 725620 726755 728525 728712 731304 732986 737286 737538 739196 740906 742271 742665 745553 748879 748880 749662 751978 757654 761676 762499 771437 771490 773928 777217 778484 779804 779875 780345 785824 786477 789611 791424 793113 793308 794181 795197 795985 796103 796492 798793 799983 800935 802577 807410 809242 812269 812438 813477 813715 816682 818135 819724 820736 824488 825797 827260 827877 827914 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife hotel room"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен hotel room"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен hotel room"
]
|
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.