Query Metrics
7
Database Queries
7
Different statements
163.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.14 ms (82.42%) |
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 4387 6965 7219 13767 81214 225519 382846 385909 387543 389424 393039 397080 397939 398902 400428 401946 405777 409249 417716 439439 440890 441499 441518 443117 445038 445545 445828 447912 451590 456530 457776 460325 466284 469644 472337 474969 476225 477590 478256 479549 481140 495459 497686 511492 513492 514598 528437 529995 532271 534585 534801 536884 545267 550899 553472 555099 561306 563969 564297 571155 573202 593207 598493 598513 602102 613013 614192 614354 620234 620249 626295 628709 629696 663769 665789 670826 685479 686002 690153 696004 705404 708462 712546 712786 714050 715087 719266 719315 720506 724169 725618 738630 738674 739445 740982 744099 747497 751510 752987 758803 760912 766814 767166 769091 773324 773614 774021 779010 793182 793185 793901 798819 799683 802412 805366 807994 810402 817378 817496 820946 ] |
||||||||||||||||||||||||||||||
|
16.89 ms (10.30%) |
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 445038 514598 472337 620249 820946 665789 626295 614354 774021 393039 739445 445545 663769 798819 725618 685479 720506 451590 793901 719315 712546 719266 613013 760912 773614 817378 817496 715087 629696 766814 534585 513492 769091 738630 670826 602102 511492 545267 397080 441518 573202 740982 799683 382846 714050 628709 767166 747497 724169 744099 398902 401946 478256 553472 686002 779010 758803 477590 532271 555099 805366 443117 445828 466284 479549 528437 387543 409249 712786 13767 598513 481140 441499 6965 400428 225519 417716 561306 385909 81214 447912 593207 7219 4387 690153 439439 752987 405777 738674 397939 696004 476225 614192 705404 598493 460325 495459 571155 389424 497686 536884 529995 534801 550899 563969 564297 802412 793185 810402 773324 751510 620234 708462 793182 807994 456530 474969 440890 469644 457776 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.23%) |
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 4387 6965 7219 13767 81214 225519 382846 385909 387543 389424 393039 397080 397939 398902 400428 401946 405777 409249 417716 439439 440890 441499 441518 443117 445038 445545 445828 447912 451590 456530 457776 460325 466284 469644 472337 474969 476225 477590 478256 479549 481140 495459 497686 511492 513492 514598 528437 529995 532271 534585 534801 536884 545267 550899 553472 555099 561306 563969 564297 571155 573202 593207 598493 598513 602102 613013 614192 614354 620234 620249 626295 628709 629696 663769 665789 670826 685479 686002 690153 696004 705404 708462 712546 712786 714050 715087 719266 719315 720506 724169 725618 738630 738674 739445 740982 744099 747497 751510 752987 758803 760912 766814 767166 769091 773324 773614 774021 779010 793182 793185 793901 798819 799683 802412 805366 807994 810402 817378 817496 820946 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал на улиц жен"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal public wife"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.01%) |
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.