Query Metrics
7
Database Queries
7
Different statements
145.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.75 ms (83.07%) |
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 79031 392213 396150 400816 411561 421813 424182 427196 439546 439687 441507 441563 443634 443874 457461 461814 466247 468386 473783 473784 474069 479369 485274 492355 496072 502843 508887 509223 523542 525559 532765 534480 543571 543703 546057 547419 549825 555088 564100 566393 568936 586219 588357 598036 598905 604320 608174 609343 614881 619070 619330 624148 633870 634950 658461 663224 684376 684404 685449 685483 685491 685525 691171 692817 695799 695892 700001 705359 705362 705451 705464 705471 715654 719544 721609 723236 724086 726164 730928 737277 738296 739531 740009 744386 745448 745457 752647 752744 759397 759759 761302 761698 762118 762449 764161 764277 765099 765940 766598 780060 783794 788181 788592 790466 791601 791681 794900 795702 797358 798823 799911 800569 802136 803526 804335 806789 807304 818832 820159 826167 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (9.51%) |
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 586219 609343 740009 752744 392213 424182 568936 598905 798823 765940 764161 803526 509223 492355 525559 443634 443874 461814 534480 547419 695892 705451 719544 663224 691171 761698 745457 764277 468386 564100 802136 739531 479369 692817 532765 474069 806789 555088 624148 441563 496072 508887 396150 721609 780060 523542 439546 400816 411561 502843 427196 633870 79031 473784 485274 543703 566393 685483 788181 788592 766598 730928 549825 421813 439687 457461 466247 818832 820159 826167 658461 783794 737277 441507 473783 543571 546057 684376 685525 695799 715654 723236 705464 684404 685449 685491 700001 705359 705362 705471 588357 598036 608174 619330 614881 604320 619070 634950 790466 795702 797358 791601 791681 799911 804335 745448 752647 794900 800569 807304 726164 744386 759397 762118 762449 724086 759759 761302 765099 738296 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (2.12%) |
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 79031 392213 396150 400816 411561 421813 424182 427196 439546 439687 441507 441563 443634 443874 457461 461814 466247 468386 473783 473784 474069 479369 485274 492355 496072 502843 508887 509223 523542 525559 532765 534480 543571 543703 546057 547419 549825 555088 564100 566393 568936 586219 588357 598036 598905 604320 608174 609343 614881 619070 619330 624148 633870 634950 658461 663224 684376 684404 685449 685483 685491 685525 691171 692817 695799 695892 700001 705359 705362 705451 705464 705471 715654 719544 721609 723236 724086 726164 730928 737277 738296 739531 740009 744386 745448 745457 752647 752744 759397 759759 761302 761698 762118 762449 764161 764277 765099 765940 766598 780060 783794 788181 788592 790466 791601 791681 794900 795702 797358 798823 799911 800569 802136 803526 804335 806789 807304 818832 820159 826167 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian wife anal"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск жен анал"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.12%) |
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.