Query Metrics
7
Database Queries
7
Different statements
221.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
193.54 ms (87.52%) |
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 413997 417259 417332 417368 417789 417790 420629 422417 425578 425745 438411 441694 442336 444971 446960 448928 449700 451382 451791 452367 453025 456136 456491 457896 458262 459798 460090 460671 461288 461631 466471 467027 469543 472052 476477 479248 479955 482067 482850 486266 488205 488483 493583 495532 505899 506182 509594 509948 510690 515409 519459 519465 520680 521083 522038 524837 525160 526636 531069 531635 541295 544095 549149 551673 553016 553102 554330 554908 556104 556314 557557 558598 559047 559048 559833 559847 560793 568087 571373 575196 580511 583773 587386 593485 596565 601894 602553 605455 609669 617012 630142 639139 639152 650453 666068 690683 736982 744853 749974 750820 772975 775015 783476 785233 788887 793938 794224 795222 797007 797119 797880 802810 809309 810916 811175 812661 812831 818088 819634 827950 ] |
||||||||||||||||||||||||||||||
|
17.74 ms (8.02%) |
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 466471 476477 460090 479248 506182 519459 488205 521083 531069 509594 522038 525160 541295 797007 783476 809309 772975 750820 515409 650453 666068 810916 785233 794224 795222 736982 749974 417789 448928 452367 553102 601894 417332 425578 442336 482067 482850 495532 510690 593485 596565 819634 425745 444971 420629 818088 827950 457896 460671 461288 459798 461631 472052 488483 493583 451791 486266 505899 509948 520680 519465 524837 531635 526636 549149 553016 554908 556104 559048 568087 580511 583773 554330 556314 571373 544095 551673 557557 558598 559833 560793 575196 690683 559047 559847 639139 605455 609669 617012 587386 602553 793938 797119 811175 812661 812831 797880 802810 744853 630142 639152 775015 788887 417368 438411 453025 413997 417790 451382 456136 469543 456491 479955 417259 422417 446960 458262 467027 441694 449700 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.27%) |
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 413997 417259 417332 417368 417789 417790 420629 422417 425578 425745 438411 441694 442336 444971 446960 448928 449700 451382 451791 452367 453025 456136 456491 457896 458262 459798 460090 460671 461288 461631 466471 467027 469543 472052 476477 479248 479955 482067 482850 486266 488205 488483 493583 495532 505899 506182 509594 509948 510690 515409 519459 519465 520680 521083 522038 524837 525160 526636 531069 531635 541295 544095 549149 551673 553016 553102 554330 554908 556104 556314 557557 558598 559047 559048 559833 559847 560793 568087 571373 575196 580511 583773 587386 593485 596565 601894 602553 605455 609669 617012 630142 639139 639152 650453 666068 690683 736982 744853 749974 750820 772975 775015 783476 785233 788887 793938 794224 795222 797007 797119 797880 802810 809309 810916 811175 812661 812831 818088 819634 827950 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"on you pov"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"you пов"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"you пов"
]
|
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.