Query Metrics
8
Database Queries
8
Different statements
146.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.74 ms (81.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 187516 233112 358437 382959 383241 390582 390918 390945 392679 392756 394194 395465 395914 395925 396956 398514 403279 407707 407708 409931 409940 411390 411773 411929 411942 411960 417863 424985 451488 452856 457991 460015 465390 465949 466231 469489 471012 482182 487351 493098 554390 555074 561777 589691 590724 615862 620199 624466 673791 677971 685864 698914 710531 717651 720482 724274 724302 724702 726512 726537 726707 726861 728348 729124 729814 730076 730822 731482 731766 732171 733119 733293 735987 739160 740169 742722 744183 744767 746638 755357 757933 761326 766597 773543 780706 781019 781648 781670 781734 782279 784307 788523 788823 788873 788981 789527 789528 789535 789556 794629 797220 797266 797271 803918 807376 808040 808691 816769 817211 817536 818638 818770 818949 818991 823637 823693 823909 824906 825260 827314 ] |
||||||||||||||||||||||||||||||
|
14.09 ms (9.61%) |
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 390918 396956 411773 411960 818638 789528 807376 724702 728348 724302 730076 766597 742722 761326 773543 710531 780706 781019 781648 808040 383241 392679 395914 411390 187516 452856 411929 460015 824906 825260 482182 624466 589691 733293 735987 789556 803918 398514 818949 818991 816769 817211 823637 823693 827314 817536 818770 823909 561777 720482 677971 717651 620199 781670 781734 788523 788873 789535 797220 789527 794629 731482 733119 744183 744767 788823 797266 797271 730822 731766 724274 726861 729124 729814 739160 757933 732171 740169 755357 746638 698914 782279 788981 395925 390945 403279 233112 394194 417863 487351 493098 471012 555074 673791 685864 554390 590724 808691 726707 726512 726537 784307 411942 392756 457991 390582 451488 465390 466231 465949 469489 615862 382959 395465 358437 407707 409940 407708 409931 424985 ] |
||||||||||||||||||||||||||||||
|
3.49 ms (2.38%) |
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 187516 233112 358437 382959 383241 390582 390918 390945 392679 392756 394194 395465 395914 395925 396956 398514 403279 407707 407708 409931 409940 411390 411773 411929 411942 411960 417863 424985 451488 452856 457991 460015 465390 465949 466231 469489 471012 482182 487351 493098 554390 555074 561777 589691 590724 615862 620199 624466 673791 677971 685864 698914 710531 717651 720482 724274 724302 724702 726512 726537 726707 726861 728348 729124 729814 730076 730822 731482 731766 732171 733119 733293 735987 739160 740169 742722 744183 744767 746638 755357 757933 761326 766597 773543 780706 781019 781648 781670 781734 782279 784307 788523 788823 788873 788981 789527 789528 789535 789556 794629 797220 797266 797271 803918 807376 808040 808691 816769 817211 817536 818638 818770 818949 818991 823637 823693 823909 824906 825260 827314 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01”M@%}q±¾Þ$Fq…\x1Fq"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy mature"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.