Query Metrics
7
Database Queries
7
Different statements
201.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.36 ms (86.69%) |
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 21255 383774 385830 388784 389116 395839 397918 416649 418084 420136 421054 422593 423368 427433 430808 434874 437726 445340 446897 447588 451670 454085 454139 455374 457089 459061 461938 462806 462862 468946 469487 474778 476266 480135 480712 480920 482338 483567 485811 491609 496756 501324 511391 517848 518506 527882 529087 542895 552628 552998 555360 560958 562791 564091 568122 568471 572707 573405 578545 578566 623411 624220 626338 630937 632983 651893 651923 666723 672490 676473 677055 679656 680313 693278 695348 700470 700492 700989 708476 710833 711900 712959 713067 717903 718040 722931 723287 724281 729957 730928 735197 737465 738531 738636 738812 741076 744381 744842 747250 750227 752632 752787 756509 756810 763887 769308 776988 777250 784592 793900 795554 797339 801742 806797 806883 813189 814835 815853 815999 816201 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (7.60%) |
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 420136 816201 451670 578545 542895 700492 700989 710833 712959 777250 729957 730928 744381 747250 738812 756810 763887 722931 476266 738531 421054 572707 395839 427433 437726 430808 552998 801742 756509 806797 418084 480920 480135 385830 434874 485811 562791 462806 496756 718040 651893 695348 713067 750227 741076 813189 552628 422593 445340 454139 459061 483567 446897 491609 517848 700470 717903 578566 626338 752632 623411 469487 480712 447588 383774 388784 461938 529087 518506 454085 501324 679656 457089 389116 21255 815853 815999 527882 672490 676473 677055 693278 708476 711900 568471 632983 776988 793900 806883 769308 738636 724281 737465 744842 624220 630937 784592 795554 797339 735197 752787 423368 482338 568122 573405 680313 462862 397918 416649 814835 455374 468946 474778 511391 564091 560958 555360 651923 666723 723287 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (1.93%) |
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 21255 383774 385830 388784 389116 395839 397918 416649 418084 420136 421054 422593 423368 427433 430808 434874 437726 445340 446897 447588 451670 454085 454139 455374 457089 459061 461938 462806 462862 468946 469487 474778 476266 480135 480712 480920 482338 483567 485811 491609 496756 501324 511391 517848 518506 527882 529087 542895 552628 552998 555360 560958 562791 564091 568122 568471 572707 573405 578545 578566 623411 624220 626338 630937 632983 651893 651923 666723 672490 676473 677055 679656 680313 693278 695348 700470 700492 700989 708476 710833 711900 712959 713067 717903 718040 722931 723287 724281 729957 730928 735197 737465 738531 738636 738812 741076 744381 744842 747250 750227 752632 752787 756509 756810 763887 769308 776988 777250 784592 793900 795554 797339 801742 806797 806883 813189 814835 815853 815999 816201 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best of anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best анал"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.90%) |
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.