Query Metrics
7
Database Queries
7
Different statements
359.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.60 ms (58.09%) |
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 4252 205011 381958 388805 396782 398340 416152 427656 449337 454061 456721 456872 464955 475593 476768 491877 497924 501441 512450 516051 517678 528844 532273 533128 534359 536718 536815 541136 544353 554884 555613 556604 574257 575989 579608 588232 591994 602210 614504 614601 619530 626340 630567 631610 631642 634713 649669 652052 656263 666139 666180 668488 669452 669703 672825 680573 698381 707591 709651 709790 710105 712056 712415 712423 713919 715275 715420 717449 731609 742659 746098 750454 751425 751427 751520 759107 768412 769985 774108 780417 784143 787748 787980 788940 790339 790809 791134 793610 794188 796026 796463 797790 798535 798827 798951 800913 802288 802318 802897 803741 803827 804495 804660 805295 805321 806405 808018 808434 812765 814379 814980 815358 817959 818096 824180 824735 828218 828441 828599 ] |
||||||||||||||||||||||||||||||
|
128.54 ms (35.80%) |
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 4252 205011 381958 388805 396782 398340 416152 427656 449337 454061 456721 456872 464955 475593 476768 491877 497924 501441 512450 516051 517678 528844 532273 533128 534359 536718 536815 541136 544353 554884 555613 556604 574257 575989 579608 588232 591994 602210 614504 614601 619530 626340 630567 631610 631642 634713 649669 652052 656263 666139 666180 668488 669452 669703 672825 680573 698381 707591 709651 709790 710105 712056 712415 712423 713919 715275 715420 717449 731609 742659 746098 750454 751425 751427 751520 759107 768412 769985 774108 780417 784143 787748 787980 788940 790339 790809 791134 793610 794188 796026 796463 797790 798535 798827 798951 800913 802288 802318 802897 803741 803827 804495 804660 805295 805321 806405 808018 808434 812765 814379 814980 815358 817959 818096 824180 824735 828218 828441 828599 ] |
||||||||||||||||||||||||||||||
|
14.38 ms (4.00%) |
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 626340 456721 454061 824794 824180 828218 828599 802288 427656 464955 476768 491877 534359 579608 574257 456872 475593 544353 416152 449337 501441 512450 497924 528844 532273 541136 652052 656263 666180 713919 712423 614601 634713 619530 787748 790809 791134 803741 787980 788940 796026 796463 806405 759107 797790 802318 802897 803827 751425 709651 784143 798535 812765 381958 398340 817959 815358 818096 828441 709790 533128 536815 555613 556604 712415 715275 669703 710105 698381 712056 717449 575989 602210 591994 631642 631610 804495 804660 805321 808434 769985 774108 707591 780417 794188 798951 668488 516051 205011 4252 388805 396782 814980 824735 814379 536718 554884 649669 669452 672825 666139 715420 680573 614504 588232 630567 790339 798827 800913 805295 742659 808018 768412 750454 751427 751520 731609 746098 793610 517678 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные большие boobs"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural big boobs"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные большие boobs"
]
|
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.