Query Metrics
7
Database Queries
7
Different statements
157.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.11 ms (83.88%) |
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 395166 395273 402887 403434 411635 412332 418043 422150 422418 423155 424247 424520 426495 427985 429792 433954 435232 438005 438044 438056 438334 438495 442551 443949 444676 450754 455536 460109 461969 463805 466489 466587 466983 477094 477673 478207 480629 486753 486757 486881 488017 489030 491096 492022 493433 494096 496586 497021 497459 499616 501916 502706 509250 510672 516606 516613 516963 519791 524205 526398 526809 527467 527845 528756 533331 534991 537240 539375 544423 547228 551604 551645 557922 562732 564065 564125 585569 591935 594534 600094 606298 608645 622353 624600 631691 634861 636574 638000 638181 647330 662118 676776 678469 682508 683301 687144 694139 708082 708148 715680 718980 720726 722913 727055 729629 744088 752677 759085 765266 766882 780936 782557 797551 802691 804804 805292 815347 818071 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (9.97%) |
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 534991 527845 533331 466983 544423 562732 557922 564125 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 494096 516963 539375 551604 676776 678469 708082 687144 715680 718980 551645 631691 634861 782557 804804 759085 708148 780936 433954 477094 424520 438005 509250 526809 499616 497021 491096 519791 608645 386862 662118 423155 402887 429792 403434 442551 683301 766882 412332 815347 460109 516613 682508 722913 600094 802691 622353 466587 395166 486757 510672 435232 427985 492022 486753 455536 466489 537240 564065 647330 694139 720726 585569 591935 797551 729629 438334 463805 478207 450754 493433 497459 501916 516606 524205 395273 422150 411635 444676 818071 477673 489030 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.81%) |
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 395166 395273 402887 403434 411635 412332 418043 422150 422418 423155 424247 424520 426495 427985 429792 433954 435232 438005 438044 438056 438334 438495 442551 443949 444676 450754 455536 460109 461969 463805 466489 466587 466983 477094 477673 478207 480629 486753 486757 486881 488017 489030 491096 492022 493433 494096 496586 497021 497459 499616 501916 502706 509250 510672 516606 516613 516963 519791 524205 526398 526809 527467 527845 528756 533331 534991 537240 539375 544423 547228 551604 551645 557922 562732 564065 564125 585569 591935 594534 600094 606298 608645 622353 624600 631691 634861 636574 638000 638181 647330 662118 676776 678469 682508 683301 687144 694139 708082 708148 715680 718980 720726 722913 727055 729629 744088 752677 759085 765266 766882 780936 782557 797551 802691 804804 805292 815347 818071 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"swallow fuck"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глота секс"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.97%) |
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.