Query Metrics
7
Database Queries
7
Different statements
167.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.07 ms (82.43%) |
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 287436 383208 398094 406935 414064 418112 421052 431960 434352 439322 441095 442454 443092 447150 448263 450020 455365 457217 459563 460540 467195 467623 471105 475296 475508 481952 485297 487008 491299 492000 493122 494484 498294 503924 508566 511372 511413 518614 525399 527884 531103 533461 540032 541484 546987 552595 555056 556483 567604 569309 579519 580139 580190 584806 595016 596240 596864 599187 604351 619230 635224 635993 642032 647307 651737 654686 661424 665207 692728 692743 697594 699627 700682 702616 709128 710875 721103 723618 724330 726315 734274 735132 737052 740255 744027 746777 747468 750390 750907 752990 753785 755693 756840 758030 758787 760601 773921 774884 777791 782051 783568 784662 791020 791520 796863 802899 803557 804081 809712 811252 812195 818301 820688 821075 821634 824475 824863 824892 827619 ] |
||||||||||||||||||||||||||||||
|
19.03 ms (11.36%) |
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 459563 450020 455365 398094 820688 821075 821634 824863 824475 827619 818301 654686 651737 692728 702616 710875 774884 782051 777791 783568 744027 750390 752990 755693 791520 740255 760601 734274 746777 773921 796863 811252 812195 556483 635224 406935 457217 467623 447150 467195 546987 569309 580139 665207 580190 596240 604351 475508 511372 533461 518614 647307 642032 493122 418112 441095 414064 439322 723618 448263 471105 475296 527884 531103 540032 508566 487008 492000 555056 552595 541484 579519 699627 721103 692743 661424 567604 584806 595016 635993 599187 596864 796642 803557 737052 802899 747468 750907 726315 724330 735132 756840 758787 709128 784662 791020 421052 434352 443092 460540 431960 481952 442454 491299 498294 511413 485297 494484 525399 824892 503924 697594 700682 619230 809712 804081 758030 753785 383208 287436 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.49%) |
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 287436 383208 398094 406935 414064 418112 421052 431960 434352 439322 441095 442454 443092 447150 448263 450020 455365 457217 459563 460540 467195 467623 471105 475296 475508 481952 485297 487008 491299 492000 493122 494484 498294 503924 508566 511372 511413 518614 525399 527884 531103 533461 540032 541484 546987 552595 555056 556483 567604 569309 579519 580139 580190 584806 595016 596240 596864 599187 604351 619230 635224 635993 642032 647307 651737 654686 661424 665207 692728 692743 697594 699627 700682 702616 709128 710875 721103 723618 724330 726315 734274 735132 737052 740255 744027 746777 747468 750390 750907 752990 753785 755693 756840 758030 758787 760601 773921 774884 777791 782051 783568 784662 791020 791520 796863 802899 803557 804081 809712 811252 812195 818301 820688 821075 821634 824475 824863 824892 827619 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dildo pussy"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"дилд pussy"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
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.