Query Metrics
7
Database Queries
7
Different statements
159.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.24 ms (83.75%) |
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 72889 413653 441289 441659 441664 446674 457898 457926 459560 464022 465291 466365 468426 468978 468991 473825 474226 476893 480334 481757 483683 484231 486139 486827 487539 490074 494552 496963 497684 499759 504197 504665 507833 511516 512143 521404 521599 522947 524102 525944 526272 526684 526694 528315 534428 547881 565883 576560 576942 577608 581104 584036 584456 584955 585749 587609 589678 591858 593163 596796 597258 600856 601728 602753 603313 603836 604106 605683 606549 609078 613375 616510 616793 618384 620566 625435 630673 644490 645669 647430 648618 652683 666374 672261 683028 695146 696593 698124 700470 715089 718091 721640 725720 727532 729337 730315 738786 741185 750072 756626 756634 757277 759127 762817 767236 776310 784042 784655 787511 795812 796339 797264 797857 801119 803776 806695 807835 808796 811152 814272 ] |
||||||||||||||||||||||||||||||
|
16.13 ms (10.14%) |
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 465291 473825 525944 604106 796339 762817 483683 468426 486139 494552 526694 648618 672261 696593 587609 803776 787511 797857 808796 497684 507833 565883 584456 666374 645669 585749 600856 603836 616793 630673 591858 496963 581104 620566 625435 606549 756634 526684 504665 521404 413653 487539 464022 521599 584955 721640 576560 618384 589678 596796 776310 725720 727532 741185 759127 767236 729337 750072 730315 756626 784042 784655 801119 446674 457926 459560 474226 480334 457898 524102 522947 72889 602753 466365 698124 441289 441664 441659 814272 484231 468978 499759 526272 528315 468991 476893 547881 715089 718091 584036 613375 807835 806695 757277 795812 797264 811152 481757 512143 511516 738786 577608 700470 534428 647430 683028 695146 652683 593163 601728 597258 603313 605683 644490 616510 504197 486827 490074 576942 609078 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.86%) |
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 72889 413653 441289 441659 441664 446674 457898 457926 459560 464022 465291 466365 468426 468978 468991 473825 474226 476893 480334 481757 483683 484231 486139 486827 487539 490074 494552 496963 497684 499759 504197 504665 507833 511516 512143 521404 521599 522947 524102 525944 526272 526684 526694 528315 534428 547881 565883 576560 576942 577608 581104 584036 584456 584955 585749 587609 589678 591858 593163 596796 597258 600856 601728 602753 603313 603836 604106 605683 606549 609078 613375 616510 616793 618384 620566 625435 630673 644490 645669 647430 648618 652683 666374 672261 683028 695146 696593 698124 700470 715089 718091 721640 725720 727532 729337 730315 738786 741185 750072 756626 756634 757277 759127 762817 767236 776310 784042 784655 787511 795812 796339 797264 797857 801119 803776 806695 807835 808796 811152 814272 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding hard homemade"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding hard домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding hard домашн любительск"
]
|
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.