Query Metrics
7
Database Queries
7
Different statements
380.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.54 ms (56.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red анал"
]
|
||||||||||||||||||||||||||||||
|
144.74 ms (38.01%) |
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 17037 229361 233386 325983 386212 388364 388734 395710 397647 397652 397917 398665 398885 404188 447970 475317 512502 531882 534193 542209 547469 564222 569266 572331 579616 585094 605155 612832 623176 631984 639755 642048 644499 647344 651716 654405 655151 657527 660994 665714 668996 671609 672913 674327 674531 680186 691472 694324 694345 697339 699400 699587 701001 706572 717913 722599 723266 724086 725176 726897 729228 731827 732450 732804 735964 740604 741573 742424 743044 753445 756104 756237 760913 761061 762187 764868 764879 765229 765391 765441 765456 765507 765939 766632 768870 769735 769742 769760 769802 769805 770310 777139 781609 782470 782628 787486 790203 791623 793893 794852 797389 797558 797969 800589 802552 803526 805509 805848 810354 811478 813703 813947 815650 817257 817311 819035 820071 823649 824883 827464 ] |
||||||||||||||||||||||||||||||
|
13.58 ms (3.57%) |
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 729228 741573 397647 398665 813947 817311 699400 668996 706572 699587 723266 639755 782470 793893 753445 765441 760913 764868 740604 765391 742424 761061 717913 722599 386212 512502 631984 815650 827464 813703 820071 823649 765229 794852 768870 777139 810354 395710 765456 726897 17037 404188 388364 764879 579616 697339 325983 585094 657527 701001 671609 674531 547469 623176 605155 782628 781609 731827 732804 756104 756237 769802 800589 805509 805848 724086 732450 735964 765507 762187 642048 791623 802552 397652 824883 694345 644499 787486 765939 743044 770310 447970 769742 769735 769760 769805 797389 398885 680186 534193 819035 817257 569266 694324 654405 672913 612832 797558 797969 811478 725176 766632 790203 397917 803526 647344 229361 233386 388734 475317 531882 542209 564222 572331 655151 665714 660994 674327 691472 651716 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (0.84%) |
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 17037 229361 233386 325983 386212 388364 388734 395710 397647 397652 397917 398665 398885 404188 447970 475317 512502 531882 534193 542209 547469 564222 569266 572331 579616 585094 605155 612832 623176 631984 639755 642048 644499 647344 651716 654405 655151 657527 660994 665714 668996 671609 672913 674327 674531 680186 691472 694324 694345 697339 699400 699587 701001 706572 717913 722599 723266 724086 725176 726897 729228 731827 732450 732804 735964 740604 741573 742424 743044 753445 756104 756237 760913 761061 762187 764868 764879 765229 765391 765441 765456 765507 765939 766632 768870 769735 769742 769760 769802 769805 770310 777139 781609 782470 782628 787486 790203 791623 793893 794852 797389 797558 797969 800589 802552 803526 805509 805848 810354 811478 813703 813947 815650 817257 817311 819035 820071 823649 824883 827464 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red anal"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.45%) |
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.