Query Metrics
7
Database Queries
7
Different statements
411.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.98 ms (50.73%) |
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 34830 385162 392645 399773 401944 418567 420009 420468 420576 420882 426548 435844 439250 440265 440745 440965 444662 445093 445197 450343 450794 452578 453037 453330 455804 455805 456688 456859 456896 457049 457674 457701 457735 457750 457770 457781 457784 458528 458914 468385 468925 468942 469227 469258 471196 476489 478690 485449 485674 488459 489790 495459 498143 498152 500508 515901 517384 517407 519811 523046 523047 523053 524601 527603 534346 555999 557595 560013 561513 563388 566619 568193 569923 581006 584774 590188 590730 592938 593008 598637 603870 606574 607657 613463 614797 614865 617984 619822 621342 623660 631395 671893 697010 697026 703494 710509 721967 733153 747098 749048 751700 761150 768013 768663 772190 779618 784804 785513 791492 793175 796248 797312 797749 798841 804272 805287 805852 809737 813292 828020 ] |
||||||||||||||||||||||||||||||
|
180.82 ms (43.89%) |
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 34830 385162 392645 399773 401944 418567 420009 420468 420576 420882 426548 435844 439250 440265 440745 440965 444662 445093 445197 450343 450794 452578 453037 453330 455804 455805 456688 456859 456896 457049 457674 457701 457735 457750 457770 457781 457784 458528 458914 468385 468925 468942 469227 469258 471196 476489 478690 485449 485674 488459 489790 495459 498143 498152 500508 515901 517384 517407 519811 523046 523047 523053 524601 527603 534346 555999 557595 560013 561513 563388 566619 568193 569923 581006 584774 590188 590730 592938 593008 598637 603870 606574 607657 613463 614797 614865 617984 619822 621342 623660 631395 671893 697010 697026 703494 710509 721967 733153 747098 749048 751700 761150 768013 768663 772190 779618 784804 785513 791492 793175 796248 797312 797749 798841 804272 805287 805852 809737 813292 828020 ] |
||||||||||||||||||||||||||||||
|
15.25 ms (3.70%) |
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 733153 751700 761150 710509 785513 34830 420468 444662 453330 468925 468942 476489 798841 797312 797749 805287 768013 791492 804272 809737 457049 457701 458528 445197 457735 456896 457784 560013 623660 455804 457750 471196 515901 385162 593008 392645 592938 614865 614797 697010 563388 450794 452578 517384 631395 440745 561513 703494 619822 607657 772190 420882 440965 469258 455805 488459 534346 498143 581006 584774 569923 590188 603870 749048 805852 418567 458914 671893 457781 457674 557595 456688 450343 439250 469227 478690 468385 498152 519811 796248 813292 420009 456859 828020 457770 527603 566619 590730 517407 440265 500508 621342 793175 784804 779618 401944 485674 489790 523053 524601 697026 606574 617984 747098 721967 485449 453037 420576 435844 426548 399773 523047 555999 445093 613463 523046 495459 568193 598637 768663 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur beach"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск пляж природ"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.38%) |
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.