Query Metrics
7
Database Queries
7
Different statements
157.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.28 ms (84.44%) |
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 531986 533491 561520 563083 565648 571132 587310 601468 606911 612955 615339 618181 629612 659446 659938 672792 680619 682276 682612 691376 693087 696745 697489 698253 700611 701243 702638 708259 709304 709346 709368 712620 712685 712688 713416 713992 715466 717150 717437 720065 720845 722125 722308 724090 724632 725159 725179 726735 727009 727152 730635 735925 736184 736861 739164 741736 742529 743011 744377 747827 749363 749760 753732 754278 754990 755509 761579 763219 763614 767070 768885 769481 769834 781758 782122 782358 782522 782707 784278 793495 794215 794603 794616 795001 795043 795299 795337 795358 795359 796066 796213 799894 801044 801451 802010 802092 802201 803364 803711 803725 804741 805280 806166 809531 809820 810266 810360 817737 819929 823705 824772 825081 825433 825435 825757 826095 826166 826194 827594 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (8.85%) |
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 720065 782522 782707 795337 801044 802201 804741 782358 794603 802092 803364 806166 809820 743011 763219 784278 795001 795358 796213 805280 736184 739164 744377 754278 747827 763614 767070 727009 727152 768885 769481 715466 793495 801451 802010 712685 712688 533491 531986 565648 571132 672792 698253 708259 713992 722308 680619 682276 682612 693087 696745 709368 713416 659446 659938 691376 702293 587310 615339 629612 601468 606911 618181 795359 726735 749363 742529 749760 612955 697489 700611 701243 702638 709304 709346 712620 722125 825757 795043 782122 803711 810360 736861 824772 825081 825435 826095 826166 819929 825433 827594 817737 823705 826194 561520 563083 717150 717437 720845 781758 799894 809531 810266 794215 794616 796066 803725 725159 735925 741736 753732 754990 755509 761579 769834 795299 724090 724632 725179 730635 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.11%) |
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 531986 533491 561520 563083 565648 571132 587310 601468 606911 612955 615339 618181 629612 659446 659938 672792 680619 682276 682612 691376 693087 696745 697489 698253 700611 701243 702638 708259 709304 709346 709368 712620 712685 712688 713416 713992 715466 717150 717437 720065 720845 722125 722308 724090 724632 725159 725179 726735 727009 727152 730635 735925 736184 736861 739164 741736 742529 743011 744377 747827 749363 749760 753732 754278 754990 755509 761579 763219 763614 767070 768885 769481 769834 781758 782122 782358 782522 782707 784278 793495 794215 794603 794616 795001 795043 795299 795337 795358 795359 796066 796213 799894 801044 801451 802010 802092 802201 803364 803711 803725 804741 805280 806166 809531 809820 810266 810360 817737 819929 823705 824772 825081 825433 825435 825757 826095 826166 826194 827594 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepmom homemade"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepmom домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepmom домашн любительск"
]
|
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.