Query Metrics
7
Database Queries
7
Different statements
231.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.91 ms (88.90%) |
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 384911 386653 387380 398368 399338 399414 400878 401260 417950 418117 419427 420104 420105 420718 421784 425304 428772 432418 437166 438447 441452 441560 441708 442143 442475 444109 447124 447913 449657 452429 453819 453986 454837 456583 456691 458868 459267 459494 459685 460107 460958 461677 463092 463166 463301 463610 466569 467844 468145 470961 471189 471474 471774 472714 473958 474977 475714 476675 478875 481154 481251 482081 482403 483050 483727 483852 483944 486961 490079 490281 492595 493917 496030 497986 498655 499517 499668 499690 501804 503619 503870 504036 511735 513019 513307 514461 515482 516054 516848 520126 521864 523258 524782 525422 527717 540889 548742 552874 556019 558156 565587 566451 566595 566709 566986 567860 569246 570537 572906 573689 575785 578468 581832 591336 602634 605430 609627 622737 700547 716746 ] |
||||||||||||||||||||||||||||||
|
14.94 ms (6.45%) |
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 418117 442143 386653 449657 498655 384911 419427 428772 420105 442475 452429 460107 463610 463092 483944 497986 514461 463301 566451 569246 566595 716746 420718 470961 425304 459685 481251 459494 476675 438447 461677 441560 466569 483852 499517 525422 499690 486961 556019 558156 483727 399414 387380 399338 444109 421784 441452 490281 456691 459267 565587 602634 609627 432418 441708 453819 398368 471189 496030 578468 400878 401260 463166 523258 540889 458868 570537 566986 482081 503870 521864 492595 575785 513019 420104 437166 447913 572906 581832 700547 567860 475714 478875 468145 471474 454837 520126 493917 516848 490079 524782 504036 566709 605430 481154 447124 503619 482403 453986 473958 471774 552874 573689 548742 622737 591336 417950 467844 474977 456583 501804 513307 483050 499668 515482 511735 516054 527717 472714 460958 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.35%) |
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 384911 386653 387380 398368 399338 399414 400878 401260 417950 418117 419427 420104 420105 420718 421784 425304 428772 432418 437166 438447 441452 441560 441708 442143 442475 444109 447124 447913 449657 452429 453819 453986 454837 456583 456691 458868 459267 459494 459685 460107 460958 461677 463092 463166 463301 463610 466569 467844 468145 470961 471189 471474 471774 472714 473958 474977 475714 476675 478875 481154 481251 482081 482403 483050 483727 483852 483944 486961 490079 490281 492595 493917 496030 497986 498655 499517 499668 499690 501804 503619 503870 504036 511735 513019 513307 514461 515482 516054 516848 520126 521864 523258 524782 525422 527717 540889 548742 552874 556019 558156 565587 566451 566595 566709 566986 567860 569246 570537 572906 573689 575785 578468 581832 591336 602634 605430 609627 622737 700547 716746 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк красивая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.72%) |
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.