Query Metrics
7
Database Queries
7
Different statements
146.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.27 ms (82.74%) |
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 6670 393572 393659 395572 395756 395876 395923 395929 400878 401282 401655 401989 404753 416172 422572 422922 422923 422929 423033 423042 432802 434201 445903 447688 447809 461620 473733 476075 481719 495148 495792 510687 511268 519725 530632 533471 543720 544206 544368 548537 556334 559507 565160 565254 566789 569677 574870 576021 583592 592459 595458 597226 598444 598657 604147 605324 605347 607215 609884 614244 624231 627810 628362 637520 642779 643396 644657 649180 656575 670250 671585 673976 679378 701010 701498 702163 702166 703101 706899 706946 709588 710933 714463 714473 719141 720033 721445 722823 722846 725112 725409 730728 731869 732055 732312 733890 735524 736042 741584 747976 754017 759329 766269 766874 775941 785337 787931 788805 790990 791181 791362 805039 805347 809687 809899 811128 814119 814223 819530 820385 ] |
||||||||||||||||||||||||||||||
|
15.96 ms (10.89%) |
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 614244 643396 597226 775941 787931 788805 766269 735524 754017 607215 706899 811128 566789 404753 422572 814223 510687 544206 393659 395756 447688 401282 519725 393572 423042 476075 671585 673976 605324 785337 733890 741584 732312 730728 624231 642779 709588 722823 395572 395876 423033 395923 395929 432802 701010 701498 495148 569677 820385 791181 401989 401655 416172 434201 814119 495792 530632 576021 556334 559507 565160 543720 544368 670250 656575 714473 574870 583592 595458 598444 637520 725409 725112 759329 722846 400878 481719 6670 422923 445903 533471 565254 702166 511268 702163 473733 461620 598657 447809 422922 422929 819530 548537 706946 719141 649180 720033 679378 714463 721445 592459 604147 609884 627810 605347 628362 805347 805039 809899 790990 791362 809687 731869 736042 747976 766874 732055 644657 703101 710933 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.81%) |
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 6670 393572 393659 395572 395756 395876 395923 395929 400878 401282 401655 401989 404753 416172 422572 422922 422923 422929 423033 423042 432802 434201 445903 447688 447809 461620 473733 476075 481719 495148 495792 510687 511268 519725 530632 533471 543720 544206 544368 548537 556334 559507 565160 565254 566789 569677 574870 576021 583592 592459 595458 597226 598444 598657 604147 605324 605347 607215 609884 614244 624231 627810 628362 637520 642779 643396 644657 649180 656575 670250 671585 673976 679378 701010 701498 702163 702166 703101 706899 706946 709588 710933 714463 714473 719141 720033 721445 722823 722846 725112 725409 730728 731869 732055 732312 733890 735524 736042 741584 747976 754017 759329 766269 766874 775941 785337 787931 788805 790990 791181 791362 805039 805347 809687 809899 811128 814119 814223 819530 820385 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young худые анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young skinny anal"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young худые анал"
]
|
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.