Query Metrics
7
Database Queries
7
Different statements
208.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.57 ms (85.23%) |
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 27777 161427 185859 274100 383266 391296 398579 407122 407538 411279 415099 416853 424547 430390 440265 440939 443089 446611 452310 453395 457715 458946 459798 462286 463114 463898 464006 465543 469172 469236 471170 473274 475516 479622 480400 489173 489278 492355 499706 504666 504853 508645 510126 512043 513239 521367 521410 521926 522483 526585 527021 527633 532952 534573 534585 534864 536063 537251 538907 539178 539300 542252 542736 542837 544610 546628 547618 559087 559212 560297 561631 568452 569447 570087 571061 580864 584713 588290 592605 596954 598626 601034 602306 606206 608637 609799 613579 614253 615605 620196 621158 623656 628798 636003 637460 644943 647212 655268 664193 670490 702331 719945 739487 759472 761143 768013 793214 799503 801267 801322 802822 806403 814713 817881 819314 820624 821071 823841 826249 828034 ] |
||||||||||||||||||||||||||||||
|
19.99 ms (9.60%) |
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 569447 647212 561631 801267 479622 522483 580864 623656 637460 416853 814713 542736 499706 521367 440265 471170 383266 510126 407122 430390 452310 469236 458946 459798 527021 539178 513239 504666 508645 521410 560297 571061 568452 570087 615605 473274 521926 821071 826249 799503 492355 644943 664193 806403 636003 185859 614253 424547 592605 489173 443089 537251 464006 601034 161427 512043 534573 544610 407538 440939 759472 391296 609799 628798 702331 534585 761143 489278 819314 823841 542252 504853 274100 802822 457715 536063 415099 453395 463114 463898 469172 532952 547618 546628 608637 598626 621158 801322 584713 739487 828034 538907 820624 817881 719945 559212 534864 27777 398579 411279 793214 596954 475516 465543 655268 588290 606206 768013 620196 602306 480400 542837 613579 526585 539300 527633 670490 559087 446611 462286 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (1.60%) |
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 27777 161427 185859 274100 383266 391296 398579 407122 407538 411279 415099 416853 424547 430390 440265 440939 443089 446611 452310 453395 457715 458946 459798 462286 463114 463898 464006 465543 469172 469236 471170 473274 475516 479622 480400 489173 489278 492355 499706 504666 504853 508645 510126 512043 513239 521367 521410 521926 522483 526585 527021 527633 532952 534573 534585 534864 536063 537251 538907 539178 539300 542252 542736 542837 544610 546628 547618 559087 559212 560297 561631 568452 569447 570087 571061 580864 584713 588290 592605 596954 598626 601034 602306 606206 608637 609799 613579 614253 615605 620196 621158 623656 628798 636003 637460 644943 647212 655268 664193 670490 702331 719945 739487 759472 761143 768013 793214 799503 801267 801322 802822 806403 814713 817881 819314 820624 821071 823841 826249 828034 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"трах на попу"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс на жоп"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.79%) |
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.