Query Metrics
7
Database Queries
7
Different statements
187.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.18 ms (85.03%) |
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 382115 387672 411627 424407 424421 424423 432884 434091 443402 443628 443743 443761 449084 450108 451464 453550 454177 454193 454247 456731 456788 458000 460752 460757 460923 462305 462317 464131 465349 465399 466015 466051 466212 466405 467034 470768 470779 471981 473332 473400 474478 474479 474480 474674 474822 475656 475688 476262 476284 479053 479674 479765 481914 483375 484586 484625 486345 488370 490514 491360 493127 499345 500467 502023 505388 513785 517021 517527 521468 523164 525355 526832 528362 531377 537826 544475 560910 563166 565082 591197 591781 592988 593184 607597 617383 622980 630064 642243 650524 660436 664504 665484 665835 670514 693208 698528 715016 724260 730357 732165 732203 746686 748478 750306 776217 781967 787874 794893 796771 800671 802328 804750 816158 824165 824280 824632 826705 826789 827185 827395 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (8.50%) |
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 732165 748478 466405 443628 525355 462305 467034 462317 466212 493127 479674 450108 474822 499345 500467 465349 387672 824632 826705 827395 565082 560910 650524 670514 715016 665484 698528 660436 665835 693208 642243 617383 622980 593184 591781 800671 724260 750306 794893 802328 804750 730357 732203 630064 781967 787874 796771 490514 460923 474479 476262 479053 523164 746686 466051 470768 454247 465399 474480 476284 460757 454177 458000 443761 474478 474674 479765 484625 526832 484586 486345 443402 411627 483375 488370 481914 453550 563166 443743 460752 473400 464131 470779 513785 592988 591197 432884 434091 816158 505388 528362 473332 544475 664504 607597 776217 424423 454193 456788 471981 475688 424407 475656 456731 502023 521468 451464 424421 466015 382115 826789 827185 824165 824280 449084 491360 517021 531377 537826 517527 ] |
||||||||||||||||||||||||||||||
|
4.60 ms (2.46%) |
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 382115 387672 411627 424407 424421 424423 432884 434091 443402 443628 443743 443761 449084 450108 451464 453550 454177 454193 454247 456731 456788 458000 460752 460757 460923 462305 462317 464131 465349 465399 466015 466051 466212 466405 467034 470768 470779 471981 473332 473400 474478 474479 474480 474674 474822 475656 475688 476262 476284 479053 479674 479765 481914 483375 484586 484625 486345 488370 490514 491360 493127 499345 500467 502023 505388 513785 517021 517527 521468 523164 525355 526832 528362 531377 537826 544475 560910 563166 565082 591197 591781 592988 593184 607597 617383 622980 630064 642243 650524 660436 664504 665484 665835 670514 693208 698528 715016 724260 730357 732165 732203 746686 748478 750306 776217 781967 787874 794893 796771 800671 802328 804750 816158 824165 824280 824632 826705 826789 827185 827395 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy волосатая mature"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy hairy mature"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy волосатая mature"
]
|
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.