Query Metrics
7
Database Queries
7
Different statements
165.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.60 ms (81.79%) |
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 407993 417046 419224 421992 423056 428328 434728 434792 437462 439800 440946 441843 443599 446050 446940 448149 451428 451779 451847 452367 453914 455730 455752 455972 456705 456708 457012 457649 458645 458983 461613 463248 463657 466557 466702 467684 468106 471341 471754 474301 478307 479007 480008 488051 488077 488081 489812 490467 493842 497026 498919 499043 501706 504863 506264 506478 508512 508519 508521 508524 508678 509728 511489 511603 511840 513782 514908 515610 515619 516030 517968 518110 521048 521152 522205 522470 523014 523134 526637 527101 527377 527656 527660 527738 529267 529530 551216 552415 559617 561303 561338 566637 569526 571775 572296 576128 579935 585751 588090 592776 593279 599299 599531 602199 602631 603610 606590 606997 615851 620261 621270 621566 643489 677097 687006 721133 755176 774799 805224 825001 ] |
||||||||||||||||||||||||||||||
|
19.00 ms (11.46%) |
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 440946 452367 466702 458645 508524 511840 501706 508512 559617 561303 721133 602199 593279 643489 774799 805224 463248 468106 471754 467684 515610 515619 489812 518110 506264 508521 526637 457012 527656 527101 687006 621566 606590 421992 451779 499043 529530 498919 521152 561338 576128 551216 615851 592776 602631 588090 599531 620261 463657 446940 455752 451428 461613 511603 497026 521048 527377 527660 455730 457649 606997 417046 517968 441843 456705 458983 466557 514908 508519 509728 522470 572296 569526 571775 677097 579935 621270 755176 423056 451847 453914 428328 434728 474301 437462 480008 419224 434792 439800 456708 448149 478307 479007 488051 488081 490467 493842 508678 513782 523014 488077 516030 527738 504863 529267 603610 443599 407993 825001 523134 511489 522205 566637 552415 585751 599299 446050 455972 471341 506478 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (2.39%) |
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 407993 417046 419224 421992 423056 428328 434728 434792 437462 439800 440946 441843 443599 446050 446940 448149 451428 451779 451847 452367 453914 455730 455752 455972 456705 456708 457012 457649 458645 458983 461613 463248 463657 466557 466702 467684 468106 471341 471754 474301 478307 479007 480008 488051 488077 488081 489812 490467 493842 497026 498919 499043 501706 504863 506264 506478 508512 508519 508521 508524 508678 509728 511489 511603 511840 513782 514908 515610 515619 516030 517968 518110 521048 521152 522205 522470 523014 523134 526637 527101 527377 527656 527660 527738 529267 529530 551216 552415 559617 561303 561338 566637 569526 571775 572296 576128 579935 585751 588090 592776 593279 599299 599531 602199 602631 603610 606590 606997 615851 620261 621270 621566 643489 677097 687006 721133 755176 774799 805224 825001 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade facial"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск facial"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск facial"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.98%) |
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.