Query Metrics
7
Database Queries
7
Different statements
161.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.39 ms (83.99%) |
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 2658 34452 132583 188266 234067 263917 311393 373803 391511 397837 401751 403293 404777 413522 415505 419421 422348 427033 438033 439733 446011 453666 456276 459156 461188 462286 462958 462968 465071 470226 472094 473980 474006 475772 476535 483971 484409 488459 490766 490768 491742 493337 493858 495425 497974 498936 499526 502110 503768 504745 505166 506112 506143 506807 509005 512202 512821 515806 517528 519993 521779 523653 524457 525650 525963 526925 528400 529138 535255 535510 536865 540638 555812 556072 558829 561033 565348 568096 569253 569419 570196 570491 570666 573007 573910 576725 577409 578026 581188 581705 586424 588896 593068 594036 600487 601677 603029 605984 606518 620786 621438 624762 636434 637438 643315 644345 644356 662594 666509 675795 676911 703370 719756 723234 745980 762632 773324 789114 798877 813901 ] |
||||||||||||||||||||||||||||||
|
15.98 ms (9.91%) |
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 465071 556072 573007 568096 569419 588896 600487 505166 498936 403293 666509 723234 703370 719756 789114 762632 132583 391511 263917 813901 397837 234067 506143 577409 676911 540638 524457 570666 570491 621438 603029 636434 419421 462958 438033 495425 512821 499526 586424 509005 523653 526925 606518 188266 373803 483971 578026 593068 525963 415505 570196 462968 504745 675795 561033 745980 798877 773324 413522 476535 506112 506807 528400 535255 439733 473980 404777 422348 475772 470226 497974 573910 643315 644356 459156 472094 474006 502110 490768 490766 601677 519993 620786 503768 521779 536865 517528 569253 662594 555812 605984 637438 594036 484409 515806 558829 34452 529138 446011 581188 2658 401751 461188 493858 624762 456276 453666 525650 576725 462286 488459 535510 565348 581705 644345 493337 491742 311393 512202 427033 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.83%) |
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 2658 34452 132583 188266 234067 263917 311393 373803 391511 397837 401751 403293 404777 413522 415505 419421 422348 427033 438033 439733 446011 453666 456276 459156 461188 462286 462958 462968 465071 470226 472094 473980 474006 475772 476535 483971 484409 488459 490766 490768 491742 493337 493858 495425 497974 498936 499526 502110 503768 504745 505166 506112 506143 506807 509005 512202 512821 515806 517528 519993 521779 523653 524457 525650 525963 526925 528400 529138 535255 535510 536865 540638 555812 556072 558829 561033 565348 568096 569253 569419 570196 570491 570666 573007 573910 576725 577409 578026 581188 581705 586424 588896 593068 594036 600487 601677 603029 605984 606518 620786 621438 624762 636434 637438 643315 644345 644356 662594 666509 675795 676911 703370 719756 723234 745980 762632 773324 789114 798877 813901 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"публично в рот"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на в улиц рот"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.90%) |
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.