Query Metrics
7
Database Queries
7
Different statements
149.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.01 ms (85.49%) |
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 383707 389142 389875 395550 396765 397080 407313 413007 417077 438017 453037 458208 459514 462964 472814 478549 489648 493260 493684 494233 519243 529609 530280 534368 534723 535053 535413 536079 536941 539751 539752 542722 543660 544458 549299 552497 553807 554703 555319 560164 561511 563333 566695 568475 570941 577002 582461 586351 589329 600778 601220 604494 606640 608047 617242 619646 637462 639231 643031 644143 649105 650510 664189 674452 710429 710890 712785 714453 714602 716146 717900 718029 718764 719314 719907 726886 726922 730656 730665 732795 737280 738004 739718 740614 744810 746118 751490 752622 755059 757558 760751 764419 765802 766668 767116 768591 768606 768681 772435 780943 786588 787623 792769 802913 804471 808303 809772 811857 812226 812242 812249 813589 813946 814163 818950 820186 822274 822890 828138 828425 ] |
||||||||||||||||||||||||||||||
|
11.79 ms (7.87%) |
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 608047 619646 786588 739718 768591 617242 383707 396765 818950 820186 822274 822890 828425 828138 530280 536079 549299 561511 542722 714602 718764 555319 570941 600778 589329 802913 760751 804471 812249 752622 764419 765802 768606 726886 730665 744810 751490 792769 811857 812242 458208 494233 519243 529609 649105 664189 674452 710890 717900 766668 726922 719314 489648 493260 563333 650510 417077 813589 814163 459514 535413 539752 534368 534723 539751 543660 553807 554703 577002 718029 716146 586351 601220 637462 639231 643031 787623 808303 738004 768681 757558 772435 730656 732795 740614 710429 812226 712785 604494 453037 566695 714453 568475 552497 560164 582461 719907 389875 493684 767116 407313 478549 389142 536941 780943 813946 395550 397080 535053 472814 438017 413007 462964 544458 644143 606640 755059 809772 737280 746118 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.72%) |
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 383707 389142 389875 395550 396765 397080 407313 413007 417077 438017 453037 458208 459514 462964 472814 478549 489648 493260 493684 494233 519243 529609 530280 534368 534723 535053 535413 536079 536941 539751 539752 542722 543660 544458 549299 552497 553807 554703 555319 560164 561511 563333 566695 568475 570941 577002 582461 586351 589329 600778 601220 604494 606640 608047 617242 619646 637462 639231 643031 644143 649105 650510 664189 674452 710429 710890 712785 714453 714602 716146 717900 718029 718764 719314 719907 726886 726922 730656 730665 732795 737280 738004 739718 740614 744810 746118 751490 752622 755059 757558 760751 764419 765802 766668 767116 768591 768606 768681 772435 780943 786588 787623 792769 802913 804471 808303 809772 811857 812226 812242 812249 813589 813946 814163 818950 820186 822274 822890 828138 828425 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf public anal"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf на улиц анал"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf на улиц анал"
]
|
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.