Query Metrics
7
Database Queries
7
Different statements
161.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.76 ms (86.09%) |
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 13166 235010 384223 385358 389553 390041 399515 403216 405690 420364 421161 429528 432272 437791 439055 441109 445702 453267 454174 454888 455204 459277 459766 462734 464149 465088 472795 474053 474452 475106 477344 478353 478577 489813 494698 497664 497843 505604 505866 508107 508770 509159 510995 512063 512130 514193 514198 521235 522721 525814 527230 528107 532980 533550 537063 537927 544708 545052 547859 558042 566403 569846 570447 570500 570617 571931 572154 572159 575219 575487 577939 583711 583821 588323 588581 590553 591383 592294 594570 601260 611669 618001 618231 622929 628901 629972 635185 645232 647372 648762 652240 654026 667054 678922 687527 688423 694046 697004 705780 715553 723494 727864 729731 729821 738058 739479 746318 756918 759133 772017 778471 785109 785564 797771 807103 807855 808242 810887 811729 814151 ] |
||||||||||||||||||||||||||||||
|
13.49 ms (8.37%) |
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 389553 403216 694046 647372 687527 611669 618001 235010 441109 497843 533550 583711 547859 678922 723494 588581 592294 622929 601260 727864 618231 807103 475106 505604 508770 528107 432272 645232 652240 629972 635185 797771 399515 445702 454174 459277 478577 545052 570500 570447 654026 571931 572154 575487 583821 588323 778471 746318 729821 756918 459766 439055 462734 384223 420364 489813 508107 512130 405690 814151 477344 497664 510995 537063 509159 522721 544708 667054 697004 705780 648762 688423 566403 570617 577939 590553 594570 628901 591383 810887 811729 759133 808242 772017 729731 738058 739479 715553 785109 785564 807855 472795 478353 421161 453267 437791 455204 525814 505866 512063 514193 514198 385358 13166 390041 429528 464149 474452 454888 527230 532980 521235 494698 537927 465088 474053 558042 572159 575219 569846 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.60%) |
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 13166 235010 384223 385358 389553 390041 399515 403216 405690 420364 421161 429528 432272 437791 439055 441109 445702 453267 454174 454888 455204 459277 459766 462734 464149 465088 472795 474053 474452 475106 477344 478353 478577 489813 494698 497664 497843 505604 505866 508107 508770 509159 510995 512063 512130 514193 514198 521235 522721 525814 527230 528107 532980 533550 537063 537927 544708 545052 547859 558042 566403 569846 570447 570500 570617 571931 572154 572159 575219 575487 577939 583711 583821 588323 588581 590553 591383 592294 594570 601260 611669 618001 618231 622929 628901 629972 635185 645232 647372 648762 652240 654026 667054 678922 687527 688423 694046 697004 705780 715553 723494 727864 729731 729821 738058 739479 746318 756918 759133 772017 778471 785109 785564 797771 807103 807855 808242 810887 811729 814151 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нови sex 2022"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нов секс"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.88%) |
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.