Query Metrics
7
Database Queries
7
Different statements
164.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.19 ms (87.17%) |
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 3699 263548 388378 411682 413534 420464 423978 434583 437562 444343 455770 456481 459222 459996 460507 471602 475122 475371 477629 478712 479319 484374 485236 486134 486565 487475 491379 492275 492965 493921 497816 498757 504584 506529 507138 516723 516883 518057 523512 525471 531127 531652 535102 537644 538176 539169 539798 544636 546351 546920 548634 553127 561181 563650 564139 564773 570714 572255 572306 573874 579945 580963 587259 590860 591385 594784 595610 596766 599409 599410 599746 602969 606890 617780 619724 635189 636487 638045 648046 665063 667097 667427 673318 673339 673415 679916 682502 683527 687126 701864 703601 706900 731442 734387 744148 754338 763886 768945 773247 780901 785508 786813 792608 793687 795363 798219 798824 800791 802725 817474 817681 818752 819153 825558 825919 826882 827242 827974 828023 828242 ] |
||||||||||||||||||||||||||||||
|
11.51 ms (7.01%) |
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 423978 493921 525471 544636 636487 763886 460507 485236 828023 456481 487475 563650 798824 800791 795363 773247 572306 828242 507138 497816 479319 548634 596766 595610 786813 734387 455770 491379 819153 561181 687126 535102 570714 539169 602969 477629 818752 825558 531652 667097 498757 516883 546351 553127 648046 619724 606890 459222 475371 478712 817474 579945 3699 667427 599746 780901 617780 516723 679916 802725 792608 388378 437562 665063 635189 459996 531127 523512 798219 731442 475122 486134 827242 706900 785508 744148 827974 825919 538176 683527 703601 673318 673339 793687 754338 768945 263548 682502 546920 594784 518057 413534 506529 591385 590860 471602 444343 411682 504584 564773 564139 673415 573874 599409 599410 434583 420464 484374 486565 492275 492965 817681 826882 539798 537644 572255 580963 701864 587259 638045 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.58%) |
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 3699 263548 388378 411682 413534 420464 423978 434583 437562 444343 455770 456481 459222 459996 460507 471602 475122 475371 477629 478712 479319 484374 485236 486134 486565 487475 491379 492275 492965 493921 497816 498757 504584 506529 507138 516723 516883 518057 523512 525471 531127 531652 535102 537644 538176 539169 539798 544636 546351 546920 548634 553127 561181 563650 564139 564773 570714 572255 572306 573874 579945 580963 587259 590860 591385 594784 595610 596766 599409 599410 599746 602969 606890 617780 619724 635189 636487 638045 648046 665063 667097 667427 673318 673339 673415 679916 682502 683527 687126 701864 703601 706900 731442 734387 744148 754338 763886 768945 773247 780901 785508 786813 792608 793687 795363 798219 798824 800791 802725 817474 817681 818752 819153 825558 825919 826882 827242 827974 828023 828242 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy вмашин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy car"
]
|
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.