Query Metrics
7
Database Queries
7
Different statements
184.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.22 ms (85.96%) |
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 396677 397329 405531 421288 423015 424675 424809 429086 431471 431953 434275 435658 436691 443729 447631 447926 449012 459873 466772 474240 475824 485161 488239 489114 494694 497915 501290 505905 515015 518090 524526 525915 533471 534787 535006 539288 541673 543422 545615 548092 549278 555885 558126 558421 559184 560112 563210 563872 564867 565527 567095 568580 570398 573909 574184 575803 576062 579083 581095 581137 581666 586014 589876 590469 590924 591319 594956 595515 596054 596739 597528 597572 598887 601317 601857 604548 608938 610350 617651 623555 623924 624864 658273 659311 662033 669947 676924 679354 681692 699599 714436 716414 717066 720450 720686 720803 721317 722494 722498 722542 722805 731994 739685 740616 754505 758186 759344 761464 761567 770436 775621 778380 786113 798977 804230 814506 816260 817597 821200 826663 ] |
||||||||||||||||||||||||||||||
|
16.18 ms (8.79%) |
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 739685 754505 617651 623555 717066 721317 722498 775621 778380 798977 533471 581095 596739 423015 485161 570398 575803 581137 548092 560112 576062 597528 624864 601317 759344 722805 505905 524526 558126 563872 574184 714436 466772 405531 541673 597572 494694 396677 436691 821200 515015 558421 549278 565527 563210 658273 699599 716414 720450 722494 722542 669947 681692 659311 662033 679354 586014 608938 595515 740616 758186 731994 770436 567095 596054 539288 598887 590469 435658 579083 676924 720803 590924 604548 591319 589876 594956 610350 601857 761464 761567 720686 786113 804230 397329 424809 488239 424675 447926 535006 545615 559184 543422 564867 568580 573909 623924 434275 429086 431471 431953 443729 421288 814506 826663 817597 816260 447631 449012 459873 497915 501290 525915 518090 534787 474240 475824 489114 555885 581666 ] |
||||||||||||||||||||||||||||||
|
2.58 ms (1.40%) |
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 396677 397329 405531 421288 423015 424675 424809 429086 431471 431953 434275 435658 436691 443729 447631 447926 449012 459873 466772 474240 475824 485161 488239 489114 494694 497915 501290 505905 515015 518090 524526 525915 533471 534787 535006 539288 541673 543422 545615 548092 549278 555885 558126 558421 559184 560112 563210 563872 564867 565527 567095 568580 570398 573909 574184 575803 576062 579083 581095 581137 581666 586014 589876 590469 590924 591319 594956 595515 596054 596739 597528 597572 598887 601317 601857 604548 608938 610350 617651 623555 623924 624864 658273 659311 662033 669947 676924 679354 681692 699599 714436 716414 717066 720450 720686 720803 721317 722494 722498 722542 722805 731994 739685 740616 754505 758186 759344 761464 761567 770436 775621 778380 786113 798977 804230 814506 816260 817597 821200 826663 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny licking ass"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые лиза жоп"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
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.