Query Metrics
7
Database Queries
7
Different statements
219.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.26 ms (86.70%) |
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 79479 96452 123002 381950 382567 384878 384963 385077 385359 387012 388687 389124 391904 392109 392675 394579 396732 397899 398803 401579 401583 411333 419623 420478 422252 424213 424654 425913 425952 425954 426872 427515 429446 439365 440898 443045 444123 451566 453653 453865 454555 461941 462181 462713 464962 467772 468004 469101 469874 470562 470603 470618 470691 471541 471771 472399 475564 476274 478353 479117 479995 483883 490648 496065 499266 501992 506216 509518 510641 516143 516360 520860 523302 524438 524710 526577 533648 534132 535246 543623 543677 545901 548740 551821 552308 557109 563203 563209 568679 568717 579083 585524 587107 591180 593858 597195 601425 621977 649087 678569 689949 694533 696865 712346 722655 724678 731950 739012 755741 761141 762169 767399 777913 784732 792493 806754 808577 809779 813260 825644 ] |
||||||||||||||||||||||||||||||
|
19.93 ms (9.08%) |
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 731950 767399 429446 462713 79479 382567 401579 461941 451566 524438 389124 678569 475564 543623 552308 563209 579083 587107 593858 621977 469101 123002 391904 392675 453865 468004 471541 384878 385359 424654 425913 425954 439365 422252 453653 479117 470691 516360 499266 509518 496065 523302 526577 470603 476274 388687 381950 479995 396732 443045 427515 454555 470618 471771 470562 392109 387012 398803 825644 483883 534132 535246 543677 649087 689949 712346 545901 585524 755741 724678 762169 739012 761141 784732 792493 806754 808577 401583 419623 462181 464962 524710 516143 501992 520860 424213 533648 506216 548740 694533 696865 722655 551821 591180 777913 809779 813260 397899 478353 440898 467772 384963 394579 425952 426872 469874 490648 510641 385077 444123 472399 557109 568679 568717 563203 601425 597195 96452 411333 420478 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.29%) |
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 79479 96452 123002 381950 382567 384878 384963 385077 385359 387012 388687 389124 391904 392109 392675 394579 396732 397899 398803 401579 401583 411333 419623 420478 422252 424213 424654 425913 425952 425954 426872 427515 429446 439365 440898 443045 444123 451566 453653 453865 454555 461941 462181 462713 464962 467772 468004 469101 469874 470562 470603 470618 470691 471541 471771 472399 475564 476274 478353 479117 479995 483883 490648 496065 499266 501992 506216 509518 510641 516143 516360 520860 523302 524438 524710 526577 533648 534132 535246 543623 543677 545901 548740 551821 552308 557109 563203 563209 568679 568717 579083 585524 587107 591180 593858 597195 601425 621977 649087 678569 689949 694533 696865 712346 722655 724678 731950 739012 755741 761141 762169 767399 777913 784732 792493 806754 808577 809779 813260 825644 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"двоих русских"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.70%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два русск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.67%) |
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.