Query Metrics
7
Database Queries
7
Different statements
147.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.68 ms (84.77%) |
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 73280 136874 382429 383096 387437 390917 397785 402979 408730 411218 418175 430299 455423 472646 482182 517016 521009 521621 529735 531575 533109 533822 539400 540949 543029 561041 575579 591435 593215 595730 601945 610886 612553 615492 620724 631739 638106 647074 668071 671873 686046 692070 699991 702873 705956 706397 715746 717757 732024 752137 756180 756259 763168 763222 763609 767344 768106 771364 777266 777534 777801 777946 779042 779539 780405 780509 781219 781405 783298 783521 783783 783787 783805 785049 786672 787708 787985 788652 789392 790838 791449 791632 793050 793433 794757 796435 797818 797844 798628 798653 799329 799612 803417 803572 803589 810751 811241 812080 814205 815141 817723 818693 819382 819783 820663 821830 822393 822675 822791 823650 823981 825144 825220 825381 825641 827319 ] |
||||||||||||||||||||||||||||||
|
12.55 ms (8.53%) |
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 752137 791632 794757 796435 756259 771364 601945 612553 620724 799329 803589 823981 73280 408730 382429 767344 770345 533822 402979 791449 732024 790838 797818 543029 789392 387437 798653 763168 756180 411218 390917 529735 539400 575579 647074 671873 717757 668071 715746 779042 798628 803417 763222 783783 793050 763609 777266 777801 779539 781219 783805 786672 595730 820663 810751 783787 705956 783298 763224 455423 397785 797844 799612 383096 825641 825381 827319 818693 819783 136874 787985 812080 803572 774503 815141 521009 783521 811241 781405 787708 768106 430299 517016 418175 521621 686046 814205 817723 822751 822791 825144 822393 823650 819382 821830 822675 825220 472646 482182 533109 531575 540949 561041 699991 692070 702873 706397 591435 615492 631739 610886 593215 638106 777534 777946 780405 785049 788652 793433 780509 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.90%) |
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 73280 136874 382429 383096 387437 390917 397785 402979 408730 411218 418175 430299 455423 472646 482182 517016 521009 521621 529735 531575 533109 533822 539400 540949 543029 561041 575579 591435 593215 595730 601945 610886 612553 615492 620724 631739 638106 647074 668071 671873 686046 692070 699991 702873 705956 706397 715746 717757 732024 752137 756180 756259 763168 763222 763609 767344 768106 771364 777266 777534 777801 777946 779042 779539 780405 780509 781219 781405 783298 783521 783783 783787 783805 785049 786672 787708 787985 788652 789392 790838 791449 791632 793050 793433 794757 796435 797818 797844 798628 798653 799329 799612 803417 803572 803589 810751 811241 812080 814205 815141 817723 818693 819382 819783 820663 821830 822393 822675 822791 823650 823981 825144 825220 825381 825641 827319 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov blow job"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.00%) |
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.