Query Metrics
7
Database Queries
7
Different statements
190.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.27 ms (85.63%) |
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 14578 28690 33431 336072 383089 383107 393049 395400 397805 399310 405147 417895 425083 430283 442632 460261 465031 471140 472614 475706 481668 482711 483038 496378 496380 496721 497681 497687 501480 501488 505094 513746 516667 519810 525923 532487 535841 536757 537009 538031 539518 540068 545785 545802 545835 548102 558434 563277 574117 575335 579448 590794 591936 595279 595969 599122 599863 600495 601527 602070 604466 604625 604681 606503 606538 606858 608083 616402 630955 633428 633899 633972 635490 636574 636576 636666 644059 644789 653392 653728 654273 655832 656808 677189 687881 694632 700169 708176 708923 713332 715089 715556 719832 720116 720287 722478 728436 732549 733570 736440 747745 749032 750042 752713 769448 776861 781815 785548 785660 785676 787738 788304 788402 798309 798403 802181 803463 807142 808072 823562 ] |
||||||||||||||||||||||||||||||
|
15.44 ms (8.10%) |
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 644789 781815 802181 785676 733570 749032 752713 608083 776861 785548 395400 336072 798403 694632 732549 747745 606858 630955 513746 383107 537009 483038 715556 481668 545785 383089 33431 14578 442632 823562 472614 575335 545835 656808 653392 653728 677189 601527 616402 636666 798309 807142 769448 604625 808072 465031 722478 471140 525923 558434 720287 633899 728436 785660 397805 405147 425083 482711 497687 505094 497681 540068 496378 536757 538031 539518 519810 532487 535841 460261 548102 574117 579448 715089 655832 687881 700169 708923 720116 719832 590794 604466 604681 606503 636574 591936 602070 636576 606538 595279 595969 788304 787738 633428 713332 788402 496721 501480 501488 599863 417895 475706 516667 654273 708176 563277 644059 803463 496380 399310 28690 599122 750042 736440 600495 633972 635490 545802 393049 430283 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.78%) |
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 14578 28690 33431 336072 383089 383107 393049 395400 397805 399310 405147 417895 425083 430283 442632 460261 465031 471140 472614 475706 481668 482711 483038 496378 496380 496721 497681 497687 501480 501488 505094 513746 516667 519810 525923 532487 535841 536757 537009 538031 539518 540068 545785 545802 545835 548102 558434 563277 574117 575335 579448 590794 591936 595279 595969 599122 599863 600495 601527 602070 604466 604625 604681 606503 606538 606858 608083 616402 630955 633428 633899 633972 635490 636574 636576 636666 644059 644789 653392 653728 654273 655832 656808 677189 687881 694632 700169 708176 708923 713332 715089 715556 719832 720116 720287 722478 728436 732549 733570 736440 747745 749032 750042 752713 769448 776861 781815 785548 785660 785676 787738 788304 788402 798309 798403 802181 803463 807142 808072 823562 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife and bbc"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен bbc"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен bbc"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.06%) |
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.