Query Metrics
7
Database Queries
7
Different statements
152.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.92 ms (80.35%) |
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 387347 404122 408170 415577 418134 429938 440900 441280 444776 445948 447694 449099 449262 451761 451827 452364 452387 456977 458612 460015 463782 464874 468026 468459 474569 475815 475864 476058 477243 478388 486613 490187 490594 492318 492753 494255 496396 496890 499356 505530 505665 509598 510457 510904 510947 511080 515092 515634 516475 517848 519262 519450 520940 520949 522180 522624 523914 524545 525415 525733 525769 526986 527472 529542 536884 541734 546566 551386 551828 552282 553253 555959 556192 557582 558611 560060 560927 565290 568823 570459 573676 573724 576487 576647 581702 582740 584304 586262 591661 591866 597101 597803 601808 603722 612772 616503 618796 626457 632114 634810 636558 642861 649368 650741 662011 668465 684997 691693 726434 729567 733403 742067 761299 764153 768675 777079 797775 800338 800429 803700 ] |
||||||||||||||||||||||||||||||
|
19.60 ms (12.81%) |
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 404122 387347 510904 490594 476058 415577 618796 463782 478388 452364 525733 510947 527472 523914 552282 568823 546566 553253 556192 570459 573676 573724 576487 584304 560060 565290 581702 650741 691693 649368 662011 668465 684997 551386 551828 555959 557582 558611 560927 576647 582740 591866 616503 636558 591661 601808 626457 586262 597101 597803 642861 800338 777079 803700 729567 797775 800429 742067 764153 768675 726434 761299 733403 603722 612772 632114 634810 449262 460015 445948 499356 511080 541734 496890 408170 418134 429938 440900 441280 444776 451761 456977 458612 468459 474569 492753 451827 475815 477243 486613 490187 447694 449099 452387 464874 468026 475864 492318 494255 505530 510457 516475 517848 519262 520940 520949 522180 522624 524545 525415 536884 505665 509598 515092 515634 519450 525769 526986 529542 496396 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.99%) |
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 387347 404122 408170 415577 418134 429938 440900 441280 444776 445948 447694 449099 449262 451761 451827 452364 452387 456977 458612 460015 463782 464874 468026 468459 474569 475815 475864 476058 477243 478388 486613 490187 490594 492318 492753 494255 496396 496890 499356 505530 505665 509598 510457 510904 510947 511080 515092 515634 516475 517848 519262 519450 520940 520949 522180 522624 523914 524545 525415 525733 525769 526986 527472 529542 536884 541734 546566 551386 551828 552282 553253 555959 556192 557582 558611 560060 560927 565290 568823 570459 573676 573724 576487 576647 581702 582740 584304 586262 591661 591866 597101 597803 601808 603722 612772 616503 618796 626457 632114 634810 636558 642861 649368 650741 662011 668465 684997 691693 726434 729567 733403 742067 761299 764153 768675 777079 797775 800338 800429 803700 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"клитор крупный"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"клитор большой большие"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.93%) |
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.