Query Metrics
7
Database Queries
7
Different statements
141.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.82 ms (83.02%) |
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 391861 392021 423867 426893 432379 433054 433435 436423 436791 438016 438979 439543 439899 440696 451420 457837 458909 461984 462023 462737 467878 474931 475851 480876 480912 482258 485646 486368 489047 493448 494242 496196 498303 510979 511596 512596 513344 513670 513939 514483 518883 521639 522956 524562 535332 536217 551896 552338 565880 569935 579426 581514 590538 592528 594339 594421 595447 606571 610078 612483 616798 616936 616989 619874 619947 622878 626364 626609 631625 643250 657514 661062 671195 672807 674618 678823 685843 689145 690648 695543 696148 699892 701531 702301 703969 704066 704072 705019 713240 719544 722216 735974 736702 741699 746748 756371 760901 764711 767722 778781 780328 783391 785225 787373 789251 789930 790514 791283 795062 797709 798265 800954 806398 810532 812447 813138 813369 813582 813595 813921 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (10.24%) |
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 480912 451420 498303 496196 594421 606571 467878 439543 622878 552338 480876 433054 522956 494242 426893 514483 565880 671195 689145 695543 701531 705019 672807 690648 616798 610078 616936 612483 619947 592528 438016 813595 813582 813921 512596 536217 657514 678823 696148 699892 643250 785225 789251 790514 806398 810532 813138 813369 778781 791283 798265 800954 812447 787373 789930 795062 736702 756371 764711 767722 760901 735974 746748 783391 797709 462023 392021 513670 489047 513939 581514 440696 474931 485646 579426 551896 674618 619874 433435 436791 438979 439899 432379 461984 462737 475851 482258 458909 518883 521639 510979 486368 524562 535332 713240 661062 685843 594339 595447 626609 702301 513344 436423 741699 423867 457837 493448 511596 626364 391861 569935 703969 704072 719544 704066 722216 616989 631625 590538 780328 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.91%) |
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 391861 392021 423867 426893 432379 433054 433435 436423 436791 438016 438979 439543 439899 440696 451420 457837 458909 461984 462023 462737 467878 474931 475851 480876 480912 482258 485646 486368 489047 493448 494242 496196 498303 510979 511596 512596 513344 513670 513939 514483 518883 521639 522956 524562 535332 536217 551896 552338 565880 569935 579426 581514 590538 592528 594339 594421 595447 606571 610078 612483 616798 616936 616989 619874 619947 622878 626364 626609 631625 643250 657514 661062 671195 672807 674618 678823 685843 689145 690648 695543 696148 699892 701531 702301 703969 704066 704072 705019 713240 719544 722216 735974 736702 741699 746748 756371 760901 764711 767722 778781 780328 783391 785225 787373 789251 789930 790514 791283 795062 797709 798265 800954 806398 810532 812447 813138 813369 813582 813595 813921 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"оргазмы русское домашние"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"оргазм русск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"оргазм русск домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.09%) |
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.