Query Metrics
7
Database Queries
7
Different statements
164.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.26 ms (85.63%) |
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 14216 14578 39719 73280 319314 323045 382429 383512 383916 384139 385241 386959 387455 391672 393457 396067 396921 398281 398504 398632 398985 402733 402887 405707 407182 411943 418152 421116 422483 424932 427129 429750 434470 444666 446625 452710 453693 456121 458056 458425 461233 461323 469289 477369 485337 503512 508919 529535 531694 540451 542687 547950 557899 574468 577887 583643 584233 593151 601763 602563 624192 625743 634503 647955 652529 670449 671166 674485 682923 689160 701280 701380 703673 708876 716648 716671 717227 723151 726326 726356 727511 729255 729664 730281 741013 744903 761435 763292 763335 767525 770026 775478 779586 779958 780003 783162 786576 786646 789246 793349 793456 793476 795030 798144 804500 806325 814281 814318 815575 816110 818222 819699 820632 821276 822259 823392 823504 823927 825223 825244 ] |
||||||||||||||||||||||||||||||
|
13.29 ms (8.06%) |
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 789246 819699 821276 820632 815575 825244 816110 818222 822259 823392 825223 529535 531694 542687 716671 674485 701280 717227 574468 624192 775478 780003 726326 786646 798144 730281 767525 703673 319314 383512 387455 398281 407182 429750 422483 814318 456121 458425 446625 469289 485337 682923 593151 602563 783162 396921 427129 453693 458056 323045 434470 477369 503512 508919 402887 393457 398985 670449 793456 727511 726356 763292 405707 39719 14216 396067 398632 647955 795030 741013 385241 421116 547950 786576 411943 384139 806325 716648 744903 601763 73280 383916 391672 14578 418152 823504 823927 540451 557899 577887 729664 708876 386959 444666 382429 461233 402733 452710 424932 461323 398504 814281 584233 689160 652529 701380 671166 723151 583643 634503 625743 779586 779958 793476 804500 761435 793349 770026 729255 763335 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.83%) |
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 14216 14578 39719 73280 319314 323045 382429 383512 383916 384139 385241 386959 387455 391672 393457 396067 396921 398281 398504 398632 398985 402733 402887 405707 407182 411943 418152 421116 422483 424932 427129 429750 434470 444666 446625 452710 453693 456121 458056 458425 461233 461323 469289 477369 485337 503512 508919 529535 531694 540451 542687 547950 557899 574468 577887 583643 584233 593151 601763 602563 624192 625743 634503 647955 652529 670449 671166 674485 682923 689160 701280 701380 703673 708876 716648 716671 717227 723151 726326 726356 727511 729255 729664 730281 741013 744903 761435 763292 763335 767525 770026 775478 779586 779958 780003 783162 786576 786646 789246 793349 793456 793476 795030 798144 804500 806325 814281 814318 815575 816110 818222 819699 820632 821276 822259 823392 823504 823927 825223 825244 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"глубокая глотка конча…"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.