Query Metrics
7
Database Queries
7
Different statements
177.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.09 ms (84.75%) |
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 191398 383565 384233 393742 394187 396517 397208 401921 402257 405810 412099 412949 413087 413471 413484 419497 419947 421536 423015 427935 432786 439488 453062 457148 457267 462292 464941 467340 469846 470847 471618 476233 481839 481959 482179 482785 485648 486691 491406 491831 494112 497700 510758 511725 512044 515125 515130 518826 518933 525686 527513 528899 543720 546430 549335 551960 552126 558469 559195 562362 562371 562804 566516 569082 569673 569908 571926 573105 576340 581706 591132 593973 604732 606615 622371 623483 623840 624694 624789 624858 624874 628329 644292 646779 649836 650350 650570 650793 663288 665284 665295 665317 665448 667878 670112 670490 677075 678777 689622 697797 702866 704533 707280 712826 712828 714428 719104 720800 725112 730072 730250 740596 746006 759563 761005 775788 790885 797634 804373 808756 ] |
||||||||||||||||||||||||||||||
|
16.93 ms (9.56%) |
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 412099 576340 562371 569082 604732 419947 515130 419497 482179 562804 569673 571926 746006 402257 512044 421536 467340 551960 623840 624694 464941 622371 804373 383565 397208 405810 413471 471618 494112 650350 665317 665448 667878 678777 650793 665284 623483 624789 606615 730072 697797 797634 401921 481959 439488 497700 566516 543720 714428 720800 775788 725112 740596 702866 457148 527513 511725 510758 476233 518826 591132 191398 413087 453062 462292 394187 396517 423015 457267 559195 569908 665295 712826 712828 808756 481839 413484 432786 485648 469846 491831 552126 558469 649836 650570 646779 689622 624858 644292 628329 730250 759563 704533 427935 562362 663288 581706 470847 393742 384233 593973 486691 515125 525686 412949 573105 670490 624874 790885 707280 719104 670112 677075 761005 491406 518933 549335 546430 528899 482785 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (1.89%) |
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 191398 383565 384233 393742 394187 396517 397208 401921 402257 405810 412099 412949 413087 413471 413484 419497 419947 421536 423015 427935 432786 439488 453062 457148 457267 462292 464941 467340 469846 470847 471618 476233 481839 481959 482179 482785 485648 486691 491406 491831 494112 497700 510758 511725 512044 515125 515130 518826 518933 525686 527513 528899 543720 546430 549335 551960 552126 558469 559195 562362 562371 562804 566516 569082 569673 569908 571926 573105 576340 581706 591132 593973 604732 606615 622371 623483 623840 624694 624789 624858 624874 628329 644292 646779 649836 650350 650570 650793 663288 665284 665295 665317 665448 667878 670112 670490 677075 678777 689622 697797 702866 704533 707280 712826 712828 714428 719104 720800 725112 730072 730250 740596 746006 759563 761005 775788 790885 797634 804373 808756 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 ная"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 на"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 на"
]
|
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.