Query Metrics
7
Database Queries
7
Different statements
151.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.30 ms (84.67%) |
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 392981 414929 418139 418832 420295 423708 427027 434286 434364 435008 435550 439531 440710 440833 441742 445401 445443 446028 446386 446709 449323 450343 452637 454518 455991 457764 460338 460860 463384 466772 466960 469830 471081 474425 476887 478597 480197 485321 485527 489868 492714 492958 492959 494815 497030 497667 500335 505480 507503 508209 509861 516362 516889 517493 519686 524047 526372 531635 532778 539857 539875 546042 547534 550777 550920 560264 562973 563613 564901 579499 581163 582574 587506 588532 588569 592702 592862 593812 597884 601529 602631 603286 606601 607879 617082 617803 619396 624480 628685 636471 638190 645418 657136 665094 667257 679909 694637 700947 715022 727486 729265 740850 740895 742919 744019 745484 746480 746939 750701 751572 753953 758780 758881 769096 769495 774399 785614 787813 790544 796034 ] |
||||||||||||||||||||||||||||||
|
13.76 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 547534 460860 597884 446386 517493 427027 435008 500335 516889 497667 455991 758780 729265 560264 617803 745484 746939 526372 440833 790544 420295 476887 469830 497030 508209 532778 617082 742919 679909 564901 463384 524047 519686 494815 492958 562973 457764 449323 434364 392981 418139 452637 454518 509861 582574 657136 785614 434286 446709 435550 440710 539875 581163 485321 489868 774399 787813 746480 753953 588532 740895 769096 740850 744019 638190 607879 474425 602631 418832 445443 466772 606601 619396 579499 769495 546042 750701 423708 441742 796034 531635 445401 446028 539857 478597 587506 751572 492714 550920 516362 485527 439531 460338 471081 603286 715022 758881 507503 700947 628685 645418 665094 592702 636471 624480 480197 466960 593812 492959 550777 667257 694637 450343 588569 414929 727486 592862 563613 601529 505480 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.87%) |
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 392981 414929 418139 418832 420295 423708 427027 434286 434364 435008 435550 439531 440710 440833 441742 445401 445443 446028 446386 446709 449323 450343 452637 454518 455991 457764 460338 460860 463384 466772 466960 469830 471081 474425 476887 478597 480197 485321 485527 489868 492714 492958 492959 494815 497030 497667 500335 505480 507503 508209 509861 516362 516889 517493 519686 524047 526372 531635 532778 539857 539875 546042 547534 550777 550920 560264 562973 563613 564901 579499 581163 582574 587506 588532 588569 592702 592862 593812 597884 601529 602631 603286 606601 607879 617082 617803 619396 624480 628685 636471 638190 645418 657136 665094 667257 679909 694637 700947 715022 727486 729265 740850 740895 742919 744019 745484 746480 746939 750701 751572 753953 758780 758881 769096 769495 774399 785614 787813 790544 796034 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"реальные оргазмы в пизду"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск оргазм в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.01%) |
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.