Query Metrics
7
Database Queries
7
Different statements
177.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.94 ms (86.26%) |
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 386862 389612 395780 396075 403434 415815 418043 419955 421144 422418 424247 424520 426011 426495 429792 432887 433954 438005 438044 438056 438495 442003 442551 443949 450149 451279 452872 456350 461809 461969 465692 466983 468033 469710 472362 472383 475571 477094 478212 480629 486881 488017 491096 494096 496472 496586 497021 498670 499616 500994 501079 502706 509250 516963 519791 521722 526398 526809 527467 527845 528756 531364 532614 533331 534991 537159 539375 544423 547228 549490 551604 551645 553239 557901 557922 560784 562732 564125 564304 593557 593754 594167 594534 606298 607481 613848 615963 624600 631691 634861 636574 638000 638181 644345 645258 662118 678469 683301 687144 689606 708082 708148 708450 710805 715680 718980 727055 744088 752677 759085 765266 766628 767769 777482 780936 782557 804804 805292 810531 813621 ] |
||||||||||||||||||||||||||||||
|
14.73 ms (8.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 415815 421144 426011 395780 419955 813621 450149 500994 521722 501079 531364 532614 557901 549490 564304 689606 708450 645258 710805 553239 593557 607481 613848 594167 615963 810531 767769 766628 777482 451279 461809 442003 478212 432887 456350 472383 475571 472362 498670 496472 396075 465692 469710 452872 534991 527845 533331 466983 544423 562732 557922 564125 593754 606298 636574 638181 624600 594534 805292 752677 744088 727055 765266 638000 480629 389612 418043 426495 422418 438044 438056 443949 424247 486881 526398 528756 527467 496586 547228 438495 488017 461969 502706 537159 494096 516963 539375 551604 678469 708082 687144 715680 718980 551645 631691 634861 782557 804804 759085 708148 780936 433954 477094 424520 438005 509250 526809 499616 497021 491096 519791 386862 662118 644345 429792 560784 403434 442551 468033 683301 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.39%) |
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 386862 389612 395780 396075 403434 415815 418043 419955 421144 422418 424247 424520 426011 426495 429792 432887 433954 438005 438044 438056 438495 442003 442551 443949 450149 451279 452872 456350 461809 461969 465692 466983 468033 469710 472362 472383 475571 477094 478212 480629 486881 488017 491096 494096 496472 496586 497021 498670 499616 500994 501079 502706 509250 516963 519791 521722 526398 526809 527467 527845 528756 531364 532614 533331 534991 537159 539375 544423 547228 549490 551604 551645 553239 557901 557922 560784 562732 564125 564304 593557 593754 594167 594534 606298 607481 613848 615963 624600 631691 634861 636574 638000 638181 644345 645258 662118 678469 683301 687144 689606 708082 708148 708450 710805 715680 718980 727055 744088 752677 759085 765266 766628 767769 777482 780936 782557 804804 805292 810531 813621 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck and swallow"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс глота"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс глота"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
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.