Query Metrics
7
Database Queries
7
Different statements
158.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.74 ms (82.50%) |
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 37730 105333 152883 153376 177651 282666 309223 316911 326297 341753 382513 382650 383036 383564 384022 385373 385677 387221 389352 389473 390910 391086 391322 396597 397644 399156 403160 415094 420622 420769 428922 443457 445433 452279 453747 461044 463953 467120 468470 472877 475706 496399 497725 505466 508271 508428 511688 514139 528305 530547 530666 531298 532347 533523 533619 534677 534860 534864 535849 537609 537941 538030 539661 540383 547101 550186 553812 555857 568019 569160 578549 579696 581237 581960 582026 585913 587723 592217 592292 602059 604295 605617 605625 606294 606502 617214 629201 630259 631479 633897 637869 639394 649079 653811 656544 658826 660531 669397 669563 671408 676608 683877 694908 694914 700678 716004 716017 720061 720351 796232 803477 813848 814967 815363 822410 824096 826135 826230 827827 ] |
||||||||||||||||||||||||||||||
|
16.34 ms (10.31%) |
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 629201 630259 700678 796232 803477 37730 396597 399156 384022 309223 383564 326297 316911 341753 389473 443457 475706 497725 508428 387221 428922 445433 382513 385677 391086 468470 604295 605617 568019 452279 555857 606294 617214 420769 383036 385373 105333 153376 152883 177651 282666 382650 389352 390910 391322 397644 403160 420622 415094 813848 815363 822410 824096 826230 814967 826135 827827 463953 467120 461044 453747 505466 511688 514139 531298 533523 533619 535849 528305 530666 532347 534864 538030 530547 534677 534860 540383 496399 508271 537609 537941 539661 472877 581237 550186 553812 569160 579696 581960 582026 649079 656544 660531 669563 694914 720061 663879 676608 694908 653811 658826 669397 671408 683877 716004 716017 720351 547101 578549 592217 606502 631479 633897 637869 639394 585913 587723 592292 602059 605625 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.99%) |
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 37730 105333 152883 153376 177651 282666 309223 316911 326297 341753 382513 382650 383036 383564 384022 385373 385677 387221 389352 389473 390910 391086 391322 396597 397644 399156 403160 415094 420622 420769 428922 443457 445433 452279 453747 461044 463953 467120 468470 472877 475706 496399 497725 505466 508271 508428 511688 514139 528305 530547 530666 531298 532347 533523 533619 534677 534860 534864 535849 537609 537941 538030 539661 540383 547101 550186 553812 555857 568019 569160 578549 579696 581237 581960 582026 585913 587723 592217 592292 602059 604295 605617 605625 606294 606502 617214 629201 630259 631479 633897 637869 639394 649079 653811 656544 658826 660531 669397 669563 671408 676608 683877 694908 694914 700678 716004 716017 720061 720351 796232 803477 813848 814967 815363 822410 824096 826135 826230 827827 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак межрасов"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy interracial"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.