Query Metrics
7
Database Queries
7
Different statements
196.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.95 ms (87.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 97047 373798 386460 391715 395706 400426 400662 400941 400954 403255 408439 413446 423609 423654 432745 439931 446108 471117 475848 477553 508564 524196 527386 530697 533369 536262 540559 564392 564528 565283 566031 566786 575566 576981 583472 586294 587761 589042 598067 604553 606405 615717 620785 621029 623204 626021 628407 632601 632674 633895 637025 637047 637120 637129 640523 641977 644274 644275 644330 644952 650187 656924 659410 662022 676022 679445 680130 680188 685013 686615 689442 689949 695278 695878 697987 699201 703037 703095 705829 705906 710056 714556 715176 716027 717805 719335 720481 721325 721412 733246 733857 738812 739012 740392 741213 742363 748539 748816 750154 752785 759485 760772 761582 766830 767283 767287 769418 770413 775798 775931 775934 775962 784391 784732 785503 788580 791101 791772 791844 810701 ] |
||||||||||||||||||||||||||||||
|
14.96 ms (7.62%) |
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 685013 686615 662022 679445 689949 695278 710056 721412 587761 626021 589042 621029 633895 775798 750154 767283 769418 791101 742363 752785 741213 759485 738812 739012 620785 640523 644274 644275 697987 703037 703095 705829 715176 717805 775931 784732 791772 373798 403255 530697 650187 680130 680188 716027 637120 810701 775962 740392 760772 721325 386460 408439 395706 446108 540559 566786 97047 413446 423609 432745 644952 477553 527386 508564 564392 575566 583472 564528 576981 714556 699201 656924 689442 695878 719335 720481 586294 637129 632674 606405 775934 788580 748539 748816 767287 784391 785503 791844 733246 733857 766830 761582 770413 604553 644330 705906 533369 676022 615717 632601 536262 400426 659410 598067 391715 400662 400941 400954 439931 471117 524196 475848 565283 566031 637047 637025 623204 628407 641977 423654 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (1.72%) |
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 97047 373798 386460 391715 395706 400426 400662 400941 400954 403255 408439 413446 423609 423654 432745 439931 446108 471117 475848 477553 508564 524196 527386 530697 533369 536262 540559 564392 564528 565283 566031 566786 575566 576981 583472 586294 587761 589042 598067 604553 606405 615717 620785 621029 623204 626021 628407 632601 632674 633895 637025 637047 637120 637129 640523 641977 644274 644275 644330 644952 650187 656924 659410 662022 676022 679445 680130 680188 685013 686615 689442 689949 695278 695878 697987 699201 703037 703095 705829 705906 710056 714556 715176 716027 717805 719335 720481 721325 721412 733246 733857 738812 739012 740392 741213 742363 748539 748816 750154 752785 759485 760772 761582 766830 767283 767287 769418 770413 775798 775931 775934 775962 784391 784732 785503 788580 791101 791772 791844 810701 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double teen anal"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double teen анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.74%) |
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.