Query Metrics
7
Database Queries
7
Different statements
166.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.99 ms (85.21%) |
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 13258 191575 260041 322815 331119 341546 388492 389487 390378 396568 396720 399628 400787 403519 406363 410687 416063 417390 417895 418448 420762 421556 424895 430493 430696 445043 447740 448350 452391 452872 459249 461048 464426 468498 468708 468829 469187 469586 474872 475489 477448 478445 479698 483038 483576 486233 495444 519085 524755 524955 525923 532497 534387 536210 540070 540513 545532 546785 551082 568560 576980 580653 583080 589551 593582 600946 601544 601599 603737 604444 604575 604905 605007 606530 607687 611261 613122 614426 630592 630916 631572 633899 635490 638533 640798 645284 647308 650011 650509 656559 663254 665930 708176 716750 719841 731888 732382 733208 733364 737173 737178 737709 744374 744654 778055 785093 788924 800288 805424 805498 807641 813770 814664 815201 815396 815525 816441 817781 819757 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (9.65%) |
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 534387 645284 461048 469586 576980 551082 630592 603737 630916 635490 420762 417390 430493 389487 417895 418448 421556 430696 486233 483038 525923 532497 540070 545532 719841 708176 583080 606530 600946 604444 631572 633899 605007 733364 607687 403519 824404 819757 656559 650509 614426 737709 733208 322815 331119 388492 390378 396568 416063 424895 474872 479698 448350 447740 468708 475489 495444 477448 611261 400787 191575 341546 396720 13258 813770 260041 445043 483576 647308 744374 468829 519085 399628 410687 815201 815525 816441 817781 814664 815396 452391 469187 452872 464426 478445 524755 524955 536210 468498 580653 568560 663254 665930 650011 546785 593582 604905 589551 604575 613122 640798 601599 638533 601544 788924 778055 800288 805424 785093 807641 731888 737173 732382 737178 744654 716750 805498 406363 459249 540513 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.55%) |
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 13258 191575 260041 322815 331119 341546 388492 389487 390378 396568 396720 399628 400787 403519 406363 410687 416063 417390 417895 418448 420762 421556 424895 430493 430696 445043 447740 448350 452391 452872 459249 461048 464426 468498 468708 468829 469187 469586 474872 475489 477448 478445 479698 483038 483576 486233 495444 519085 524755 524955 525923 532497 534387 536210 540070 540513 545532 546785 551082 568560 576980 580653 583080 589551 593582 600946 601544 601599 603737 604444 604575 604905 605007 606530 607687 611261 613122 614426 630592 630916 631572 633899 635490 638533 640798 645284 647308 650011 650509 656559 663254 665930 708176 716750 719841 731888 732382 733208 733364 737173 737178 737709 744374 744654 778055 785093 788924 800288 805424 805498 807641 813770 814664 815201 815396 815525 816441 817781 819757 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother bbc"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин bbc"
]
|
||||||||||||||||||||||||||||||
|
1.21 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин bbc"
]
|
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.