Query Metrics
7
Database Queries
7
Different statements
207.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.06 ms (84.49%) |
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 406085 412043 414339 415546 419128 420178 425588 426043 428124 428238 428883 429801 445367 450099 452300 454518 457422 460079 461048 461848 463877 467957 470022 476082 476128 476260 476783 478038 480645 500914 501643 514884 517405 527780 530001 532852 532855 532989 533870 534293 534961 536628 541642 541647 544834 549223 549314 549977 550230 554309 554468 555716 558714 559291 561040 561415 562190 562830 562842 564385 565165 566788 567421 568061 568532 569526 570954 571035 571444 571670 572031 572189 573105 581618 586940 589543 590150 590241 590404 590872 592444 592675 598169 599659 599868 599908 599957 600017 600280 600295 600302 600344 600985 601653 601938 603210 603686 603693 605470 606587 606608 607071 614065 630420 641708 643376 644244 645920 646152 655927 660399 660416 666113 668645 669074 695870 725036 760794 775848 775985 ] |
||||||||||||||||||||||||||||||
|
20.48 ms (9.89%) |
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 599659 550230 454518 500914 514884 534961 668645 669074 695870 660416 666113 561040 630420 725036 463877 420178 457422 476783 544834 428883 461048 478038 480645 460079 554468 775848 426043 425588 476260 534293 558714 607071 641708 599908 644244 415546 419128 428124 467957 532989 559291 564385 566788 565165 646152 571035 571444 601938 461848 450099 517405 562190 562830 562842 561415 567421 568532 570954 573105 581618 645920 655927 549223 549314 549977 590241 606587 586940 592675 598169 600280 601653 606608 614065 600302 600344 603686 600017 775985 541642 568061 541647 590872 428238 533870 555716 569526 660399 603210 592444 452300 470022 530001 532855 590404 406085 536628 476128 501643 532852 554309 572031 590150 599868 643376 414339 429801 445367 527780 476082 572189 571670 600985 605470 589543 599957 600295 603693 760794 412043 ] |
||||||||||||||||||||||||||||||
|
3.88 ms (1.87%) |
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 406085 412043 414339 415546 419128 420178 425588 426043 428124 428238 428883 429801 445367 450099 452300 454518 457422 460079 461048 461848 463877 467957 470022 476082 476128 476260 476783 478038 480645 500914 501643 514884 517405 527780 530001 532852 532855 532989 533870 534293 534961 536628 541642 541647 544834 549223 549314 549977 550230 554309 554468 555716 558714 559291 561040 561415 562190 562830 562842 564385 565165 566788 567421 568061 568532 569526 570954 571035 571444 571670 572031 572189 573105 581618 586940 589543 590150 590241 590404 590872 592444 592675 598169 599659 599868 599908 599957 600017 600280 600295 600302 600344 600985 601653 601938 603210 603686 603693 605470 606587 606608 607071 614065 630420 641708 643376 644244 645920 646152 655927 660399 660416 666113 668645 669074 695870 725036 760794 775848 775985 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big butt mature"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие butt mature"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие butt 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.