Query Metrics
7
Database Queries
7
Different statements
478.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
251.18 ms (52.51%) |
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 392238 396797 401244 417173 417403 421734 424213 435412 436149 437260 437441 441452 448304 451667 453890 456388 458469 459641 464252 465989 469666 469826 470188 471427 471865 480083 481001 481338 482139 484178 486371 486518 487329 487987 490351 504339 505061 510041 513801 517387 522196 523717 523979 525510 526192 527520 541320 547572 549662 551457 554674 566356 566364 584094 585203 604585 613038 614018 616503 618021 624961 649814 658924 666967 672345 672683 673874 676528 676914 679662 679909 681490 685832 689558 692127 692733 693753 693788 693937 698259 701360 701771 706454 707250 709848 713308 716087 716364 718703 721872 721875 721903 722984 736862 740860 743964 744493 744952 745964 747569 749581 749686 754145 755478 756273 756609 756658 758731 760901 763493 764023 764071 764213 779239 791761 812384 813206 813961 827326 ] |
||||||||||||||||||||||||||||||
|
207.46 ms (43.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
11.81 ms (2.47%) |
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 813961 469666 523979 480083 547572 673874 676528 679909 681490 692733 693788 698259 679662 693753 701360 718703 721903 722984 676914 685832 689558 706454 716364 566364 624961 614018 585203 604585 744952 747569 755478 813206 744493 749686 754145 758731 760901 743545 743964 763493 764071 736862 740860 745964 707250 721872 392238 486371 756609 458469 525510 527520 658924 616503 618021 812384 764213 417403 465989 504339 453890 436149 441452 510041 649814 693937 551457 756658 672683 692127 435412 421734 526192 701771 827326 451667 469826 482139 505061 549662 584094 713308 666967 791761 756273 716087 437441 401244 396797 424213 448304 459641 486518 487987 522196 513801 517387 464252 470188 541320 566356 709848 672345 554674 613038 779239 749581 764023 721875 481001 471427 456388 481338 417173 471865 437260 523717 487329 484178 490351 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.63%) |
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 392238 396797 401244 417173 417403 421734 424213 435412 436149 437260 437441 441452 448304 451667 453890 456388 458469 459641 464252 465989 469666 469826 470188 471427 471865 480083 481001 481338 482139 484178 486371 486518 487329 487987 490351 504339 505061 510041 513801 517387 522196 523717 523979 525510 526192 527520 541320 547572 549662 551457 554674 566356 566364 584094 585203 604585 613038 614018 616503 618021 624961 649814 658924 666967 672345 672683 673874 676528 676914 679662 679909 681490 685832 689558 692127 692733 693753 693788 693937 698259 701360 701771 706454 707250 709848 713308 716087 716364 718703 721872 721875 721903 722984 736862 740860 743964 744493 744952 745964 747569 749581 749686 754145 755478 756273 756609 756658 758731 760901 763493 764023 764071 764213 779239 791761 812384 813206 813961 827326 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие cock orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие cock orgasm"
]
|
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.