Query Metrics
7
Database Queries
7
Different statements
568.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
419.86 ms (73.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal creampie"
]
|
||||||||||||||||||||||||||||||
|
128.91 ms (22.66%) |
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 95668 384147 392213 397867 413731 415287 418057 418072 426940 432618 432625 432641 432647 432688 437486 437670 441395 441413 441496 441583 441609 450371 450684 452862 460873 467930 470355 470373 492714 494060 501622 510064 512711 530703 533384 534748 552687 558342 564382 585450 586897 589487 589647 591355 591727 591860 592644 593599 604658 612219 623608 624895 626400 635450 636242 651636 655186 656487 656548 658773 659052 666052 666736 680301 680441 693359 695745 700760 701470 710890 712555 715561 715593 721885 725136 726960 737079 744061 756535 756990 757276 758141 759870 760912 761029 761134 761137 761469 761531 761583 761600 761696 765400 765489 766523 766637 766668 766777 775054 775202 776204 778949 788856 791366 791403 791406 792100 794185 794892 797396 798725 798734 800891 804568 804935 805271 809656 810274 824455 828665 ] |
||||||||||||||||||||||||||||||
|
12.26 ms (2.16%) |
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 761029 791406 759870 761134 761137 95668 432641 441609 418072 441413 512711 651636 701470 659052 680301 695745 710890 626400 794185 798725 798734 810274 757276 761531 791366 797396 725136 766668 765489 737079 700760 721885 800891 809656 441496 467930 418057 450684 756535 744061 384147 534748 558342 564382 655186 693359 775202 776204 792100 804568 766777 761469 441395 432688 397867 592644 432618 432647 470355 680441 589647 591727 586897 761583 712555 492714 824455 656487 585450 828665 530703 437486 533384 510064 552687 658773 666736 666052 589487 593599 612219 604658 624895 591860 778949 761600 766637 726960 756990 452862 460873 413731 441583 432625 392213 450371 591355 805271 426940 494060 635450 775054 791403 415287 437670 501622 470373 715593 656548 715561 623608 636242 794892 760912 761696 766523 788856 804935 758141 765400 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.53%) |
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 95668 384147 392213 397867 413731 415287 418057 418072 426940 432618 432625 432641 432647 432688 437486 437670 441395 441413 441496 441583 441609 450371 450684 452862 460873 467930 470355 470373 492714 494060 501622 510064 512711 530703 533384 534748 552687 558342 564382 585450 586897 589487 589647 591355 591727 591860 592644 593599 604658 612219 623608 624895 626400 635450 636242 651636 655186 656487 656548 658773 659052 666052 666736 680301 680441 693359 695745 700760 701470 710890 712555 715561 715593 721885 725136 726960 737079 744061 756535 756990 757276 758141 759870 760912 761029 761134 761137 761469 761531 761583 761600 761696 765400 765489 766523 766637 766668 766777 775054 775202 776204 778949 788856 791366 791403 791406 792100 794185 794892 797396 798725 798734 800891 804568 804935 805271 809656 810274 824455 828665 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал creampie"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал creampie"
]
|
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.