Query Metrics
7
Database Queries
7
Different statements
179.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.04 ms (85.15%) |
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 7295 382381 390204 391868 391916 391994 393050 395162 396186 396231 410884 422635 423994 426689 428282 429890 431432 432949 441925 442997 453585 454983 458819 460293 467855 471664 475103 495937 496152 503379 505281 505470 508986 509501 511923 512065 512365 514440 516551 517552 518671 519313 519604 519700 523726 526653 528939 534114 534953 535438 540911 542701 544961 548387 555033 556890 556906 556907 561273 571194 571726 582221 582511 590520 591221 595860 600144 602697 605378 608869 620017 621496 626399 630511 653216 666490 672944 677322 677333 684706 685061 695386 706631 718701 718745 719461 723885 725392 741247 742290 742291 742304 742318 742320 742359 744427 745100 745104 747153 751609 752750 755878 757883 761608 777797 782789 782792 782854 788107 788908 791501 791930 792741 794048 797001 801610 804319 805227 827918 827973 ] |
||||||||||||||||||||||||||||||
|
15.78 ms (8.78%) |
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 777797 794048 432949 827918 827973 509501 512365 517552 534114 534953 535438 503379 519700 467855 556906 571194 540911 542701 548387 653216 672944 677322 677333 684706 685061 695386 706631 666490 718701 719461 544961 555033 556890 556907 582221 582511 591221 595860 590520 608869 621496 620017 600144 804319 782789 782792 782854 791501 742320 805227 744427 747153 757883 723885 745100 755878 742304 742318 745104 751609 752750 761608 742290 742291 742359 788107 788908 791930 792741 797001 391994 393050 395162 423994 453585 382381 396186 396231 426689 471664 391868 422635 391916 410884 431432 441925 454983 458819 460293 512065 523726 508986 514440 519313 519604 496152 526653 505281 505470 511923 495937 571726 561273 718745 626399 605378 630511 725392 741247 602697 801610 442997 428282 429890 7295 528939 516551 390204 475103 518671 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.71%) |
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 7295 382381 390204 391868 391916 391994 393050 395162 396186 396231 410884 422635 423994 426689 428282 429890 431432 432949 441925 442997 453585 454983 458819 460293 467855 471664 475103 495937 496152 503379 505281 505470 508986 509501 511923 512065 512365 514440 516551 517552 518671 519313 519604 519700 523726 526653 528939 534114 534953 535438 540911 542701 544961 548387 555033 556890 556906 556907 561273 571194 571726 582221 582511 590520 591221 595860 600144 602697 605378 608869 620017 621496 626399 630511 653216 666490 672944 677322 677333 684706 685061 695386 706631 718701 718745 719461 723885 725392 741247 742290 742291 742304 742318 742320 742359 744427 745100 745104 747153 751609 752750 755878 757883 761608 777797 782789 782792 782854 788107 788908 791501 791930 792741 794048 797001 801610 804319 805227 827918 827973 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское жестко"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск хардкор"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.00%) |
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.