Query Metrics
7
Database Queries
7
Different statements
197.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.58 ms (88.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 233410 338316 411422 423793 424416 426713 427169 429814 434655 437152 438056 438069 440571 443669 443849 444002 445829 446216 446218 446336 452410 454038 456911 457800 463996 465341 466282 466645 467578 469085 469884 470007 474265 474884 475894 478339 484981 486856 487273 491466 491729 491736 491742 495296 496795 497291 499879 499995 500067 503104 503111 505257 505762 506425 508409 509303 509324 516488 517374 518506 521355 521913 522645 525139 527197 527360 527697 529339 534154 541994 542512 545848 551260 556704 557115 559239 560453 564060 565011 565558 565559 565574 596181 602653 608773 614687 615823 616822 616947 617267 619953 619982 620818 621457 625035 628515 629580 629663 666427 673518 686234 689798 708219 733661 745136 761517 763544 778724 785470 790933 791067 794273 798071 805259 810359 819695 819791 824647 825711 826306 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (6.92%) |
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 509324 465341 437152 545848 686234 666427 708219 565011 616822 619982 629663 625035 798071 790933 805259 745136 761517 629580 785470 794273 810359 445829 452410 466282 454038 499995 495296 487273 496795 497291 503104 484981 486856 491736 491742 508409 518506 763544 446216 551260 424416 443849 444002 411422 438056 463996 466645 443669 457800 474884 509303 525139 505762 824647 819695 778724 791067 446218 534154 614687 429814 467578 338316 825711 826306 819791 499879 557115 673518 689798 619953 616947 426713 469884 438069 470007 474265 506425 527697 521913 527197 733661 233410 423793 529339 565558 541994 565559 542512 560453 564060 565574 556704 617267 602653 621457 628515 608773 615823 620818 440571 500067 527360 491729 503111 521355 516488 517374 522645 491466 505257 596181 559239 427169 446336 456911 475894 434655 469085 478339 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.35%) |
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 233410 338316 411422 423793 424416 426713 427169 429814 434655 437152 438056 438069 440571 443669 443849 444002 445829 446216 446218 446336 452410 454038 456911 457800 463996 465341 466282 466645 467578 469085 469884 470007 474265 474884 475894 478339 484981 486856 487273 491466 491729 491736 491742 495296 496795 497291 499879 499995 500067 503104 503111 505257 505762 506425 508409 509303 509324 516488 517374 518506 521355 521913 522645 525139 527197 527360 527697 529339 534154 541994 542512 545848 551260 556704 557115 559239 560453 564060 565011 565558 565559 565574 596181 602653 608773 614687 615823 616822 616947 617267 619953 619982 620818 621457 625035 628515 629580 629663 666427 673518 686234 689798 708219 733661 745136 761517 763544 778724 785470 790933 791067 794273 798071 805259 810359 819695 819791 824647 825711 826306 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation russian"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк русск"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.66%) |
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.