Query Metrics
7
Database Queries
7
Different statements
488.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
269.14 ms (55.15%) |
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 563474 570348 573901 578159 706790 660821 697161 698773 703501 670620 695348 713794 722332 552233 552443 556713 558691 565419 569570 570513 571614 571700 573876 574280 576229 576309 583669 598815 596657 619873 586506 598599 613320 615579 786635 808685 809453 806421 728944 736368 756877 783211 797563 807890 813473 741920 749294 766306 770716 773758 759447 769077 705554 711037 712220 777498 791759 805086 429486 429527 456650 464677 472795 479478 482028 61635 385380 394006 395635 404230 428242 461823 462941 465090 476765 479986 246488 443766 453267 459700 459821 469094 387010 390080 390175 403393 426596 432493 466662 471865 415835 469765 502299 515790 483394 485912 489902 490839 491374 498734 501799 518962 527491 488103 488697 504581 521202 490790 492788 493878 507341 514198 517846 520412 529058 383281 384864 162000 173107 308783 ] |
||||||||||||||||||||||||||||||
|
208.33 ms (42.69%) |
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 61635 162000 173107 246488 308783 383281 384864 385380 387010 390080 390175 394006 395635 403393 404230 415835 426596 428242 429486 429527 432493 443766 453267 456650 459700 459821 461823 462941 464677 465090 466662 469094 469765 471865 472795 476765 479478 479986 482028 483394 485912 488103 488697 489902 490790 490839 491374 492788 493878 498734 501799 502299 504581 507341 514198 515790 517846 518962 520412 521202 527491 529058 552233 552443 556713 558691 563474 565419 569570 570348 570513 571614 571700 573876 573901 574280 576229 576309 578159 583669 586506 596657 598599 598815 613320 615579 619873 660821 670620 695348 697161 698773 703501 705554 706790 711037 712220 713794 722332 728944 736368 741920 749294 756877 759447 766306 769077 770716 773758 777498 783211 786635 791759 797563 805086 806421 807890 808685 809453 813473 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (0.61%) |
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 61635 162000 173107 246488 308783 383281 384864 385380 387010 390080 390175 394006 395635 403393 404230 415835 426596 428242 429486 429527 432493 443766 453267 456650 459700 459821 461823 462941 464677 465090 466662 469094 469765 471865 472795 476765 479478 479986 482028 483394 485912 488103 488697 489902 490790 490839 491374 492788 493878 498734 501799 502299 504581 507341 514198 515790 517846 518962 520412 521202 527491 529058 552233 552443 556713 558691 563474 565419 569570 570348 570513 571614 571700 573876 573901 574280 576229 576309 578159 583669 586506 596657 598599 598815 613320 615579 619873 660821 670620 695348 697161 698773 703501 705554 706790 711037 712220 713794 722332 728944 736368 741920 749294 756877 759447 766306 769077 770716 773758 777498 783211 786635 791759 797563 805086 806421 807890 808685 809453 813473 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пришл"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пришло"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пришл"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.35%) |
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.