Query Metrics
7
Database Queries
7
Different statements
180.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.59 ms (84.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 188499 387542 391566 407687 422196 422386 433380 435320 435542 435577 437911 440700 447902 448112 451526 453731 455768 457445 458788 459092 459585 461895 463006 473313 474931 475513 476995 478723 486965 490500 494970 498234 498984 500048 500770 501689 505377 509282 509283 511588 513520 513722 514491 515140 515803 517852 519594 521302 521683 522934 523738 523844 524005 526368 527329 535443 540652 544519 547706 548038 552404 555025 561191 565580 567633 571945 571971 580105 584172 584424 585755 593741 594487 600683 602692 605030 605999 607117 607830 614073 633892 636478 644139 657774 670415 671923 672819 678821 680561 685023 690684 700966 703685 713329 716746 726710 728487 731432 732905 736905 748242 749927 764958 765846 770599 773821 777172 777570 779440 781519 783162 785912 788549 790702 791330 791950 806092 806247 809916 815598 ] |
||||||||||||||||||||||||||||||
|
16.60 ms (9.20%) |
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 791950 809916 781519 791330 765846 773821 605030 605999 703685 777570 785912 790702 806092 459092 540652 547706 779440 511588 498234 636478 788549 463006 451526 459585 513722 490500 474931 544519 678821 680561 672819 700966 670415 671923 685023 548038 580105 593741 600683 644139 607117 783162 770599 731432 728487 736905 764958 713329 716746 777172 435542 435577 448112 461895 509283 521302 535443 514491 188499 478723 584424 690684 565580 607830 585755 422386 458788 391566 435320 475513 527329 519594 505377 815598 455768 614073 732905 749927 457445 513520 521683 555025 584172 552404 748242 726710 407687 422196 473313 524005 509282 498984 526368 561191 494970 657774 594487 602692 433380 476995 522934 523738 523844 501689 453731 515140 500048 515803 567633 571945 571971 633892 806247 440700 486965 387542 437911 447902 500770 517852 ] |
||||||||||||||||||||||||||||||
|
3.46 ms (1.92%) |
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 188499 387542 391566 407687 422196 422386 433380 435320 435542 435577 437911 440700 447902 448112 451526 453731 455768 457445 458788 459092 459585 461895 463006 473313 474931 475513 476995 478723 486965 490500 494970 498234 498984 500048 500770 501689 505377 509282 509283 511588 513520 513722 514491 515140 515803 517852 519594 521302 521683 522934 523738 523844 524005 526368 527329 535443 540652 544519 547706 548038 552404 555025 561191 565580 567633 571945 571971 580105 584172 584424 585755 593741 594487 600683 602692 605030 605999 607117 607830 614073 633892 636478 644139 657774 670415 671923 672819 678821 680561 685023 690684 700966 703685 713329 716746 726710 728487 731432 732905 736905 748242 749927 764958 765846 770599 773821 777172 777570 779440 781519 783162 785912 788549 790702 791330 791950 806092 806247 809916 815598 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits sucked"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ sucked"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ sucked"
]
|
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.