Query Metrics
7
Database Queries
7
Different statements
387.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.70 ms (54.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum на улиц"
]
|
||||||||||||||||||||||||||||||
|
152.53 ms (39.38%) |
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 382163 385231 393157 402969 414702 417318 420651 421432 421578 422071 423833 424744 428443 428462 432854 433930 437161 443955 449644 456648 456650 456816 456940 457326 457530 457540 457579 460489 460891 461379 461634 464750 474403 479167 480694 486992 490264 490440 497993 499829 503825 504365 505857 506538 511952 515380 523053 526330 526676 529138 529515 534913 535934 540917 544032 545232 552368 555092 555378 557807 561232 564019 568578 569793 571594 572153 573149 573291 574444 574648 574734 578499 580978 583935 586936 594458 603406 604278 609759 612464 622353 623465 630686 632177 639150 643315 644223 673424 676169 680959 693755 699447 705715 705787 721968 724023 725503 725523 746161 746331 749633 750108 761146 763141 764958 767982 769547 774339 779318 790256 793400 799391 800464 804329 805642 807301 807674 809743 810171 827875 ] |
||||||||||||||||||||||||||||||
|
14.44 ms (3.73%) |
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 544032 457326 574444 721968 630686 604278 402969 515380 535934 552368 428462 461634 580978 421432 428443 504365 506538 673424 609759 643315 807301 417318 437161 422071 464750 486992 480694 424744 574648 545232 421578 457540 460489 827875 503825 540917 583935 676169 699447 705715 693755 555092 594458 612464 639150 586936 799391 800464 807674 809743 810171 724023 761146 725523 750108 623465 804329 443955 460891 385231 393157 420651 529515 511952 578499 571594 573149 680959 705787 572153 644223 790256 793400 746161 749633 763141 774339 725503 767982 603406 632177 779318 805642 456650 457579 505857 561232 529138 456648 490440 382163 414702 490264 479167 499829 461379 474403 555378 564019 557807 568578 573291 746331 764958 423833 432854 457530 449644 497993 433930 526330 526676 534913 622353 456816 523053 569793 574734 769547 456940 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.64%) |
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 382163 385231 393157 402969 414702 417318 420651 421432 421578 422071 423833 424744 428443 428462 432854 433930 437161 443955 449644 456648 456650 456816 456940 457326 457530 457540 457579 460489 460891 461379 461634 464750 474403 479167 480694 486992 490264 490440 497993 499829 503825 504365 505857 506538 511952 515380 523053 526330 526676 529138 529515 534913 535934 540917 544032 545232 552368 555092 555378 557807 561232 564019 568578 569793 571594 572153 573149 573291 574444 574648 574734 578499 580978 583935 586936 594458 603406 604278 609759 612464 622353 623465 630686 632177 639150 643315 644223 673424 676169 680959 693755 699447 705715 705787 721968 724023 725503 725523 746161 746331 749633 750108 761146 763141 764958 767982 769547 774339 779318 790256 793400 799391 800464 804329 805642 807301 807674 809743 810171 827875 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.46%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in public"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum на улиц"
]
|
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.