Query Metrics
7
Database Queries
7
Different statements
561.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
415.46 ms (74.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sleep young"
]
|
||||||||||||||||||||||||||||||
|
119.86 ms (21.36%) |
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 233340 383565 386189 389639 390794 395752 397901 402906 403906 410908 415580 424646 428840 429449 430287 432663 432732 432821 434182 443428 443594 443760 443814 444087 444104 445914 446087 447749 453039 457654 457682 458005 458011 459143 459366 461388 467149 468125 470477 471054 473182 478762 482314 484485 484591 489516 490167 491160 491993 492138 492279 492572 493407 497363 503144 506052 510503 510759 513334 515889 515891 516644 517367 520691 523472 526016 526477 526478 526775 529249 529386 531148 544057 546687 546942 547928 549153 550336 552319 552650 552758 555180 557194 557512 560195 562858 563141 563906 565625 569967 569970 569972 576112 582789 584713 586671 611241 626873 629296 664289 665386 668676 668949 679826 697892 714864 721795 726706 726777 726846 742871 772126 780724 788300 789692 795041 796135 800936 804215 807944 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (3.19%) |
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 492279 492572 503144 506052 531148 584713 552319 560195 562858 576112 582789 679826 550336 629296 626873 611241 473182 489516 526775 403906 484485 569967 429449 383565 402906 432732 415580 444104 432663 459366 478762 446087 493407 458011 468125 482314 515889 529386 497363 516644 526016 523472 471054 492138 546942 547928 549153 569972 544057 555180 557194 563906 664289 668676 697892 714864 665386 668949 546687 552650 552758 557512 563141 565625 569970 586671 780724 788300 807944 742871 795041 800936 726706 726846 772126 726777 721795 789692 796135 804215 386189 395752 424646 443594 447749 459143 389639 397901 410908 434182 443428 445914 458005 467149 428840 432821 444087 453039 457654 457682 233340 390794 461388 470477 443760 443814 484591 490167 491993 510759 520691 526477 491160 510503 517367 526478 529249 513334 430287 515891 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (0.44%) |
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 233340 383565 386189 389639 390794 395752 397901 402906 403906 410908 415580 424646 428840 429449 430287 432663 432732 432821 434182 443428 443594 443760 443814 444087 444104 445914 446087 447749 453039 457654 457682 458005 458011 459143 459366 461388 467149 468125 470477 471054 473182 478762 482314 484485 484591 489516 490167 491160 491993 492138 492279 492572 493407 497363 503144 506052 510503 510759 513334 515889 515891 516644 517367 520691 523472 526016 526477 526478 526775 529249 529386 531148 544057 546687 546942 547928 549153 550336 552319 552650 552758 555180 557194 557512 560195 562858 563141 563906 565625 569967 569970 569972 576112 582789 584713 586671 611241 626873 629296 664289 665386 668676 668949 679826 697892 714864 721795 726706 726777 726846 742871 772126 780724 788300 789692 795041 796135 800936 804215 807944 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.36%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спящ young"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"спящ young"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.31%) |
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.