Query Metrics
7
Database Queries
7
Different statements
156.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.84 ms (82.43%) |
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 95673 188395 193666 341729 378046 383160 384809 395970 404791 411747 412925 415081 419123 419517 419529 419854 420438 433475 441004 443903 448368 448832 453349 455085 455919 463073 464596 467700 469599 473832 473871 474557 477060 478074 478252 478453 479087 482534 483005 483375 484529 484664 484727 490261 491398 506908 509875 514582 514601 514940 530854 530940 531070 531195 531511 532783 532959 536292 537899 538360 540239 542565 543609 544665 545430 552266 556774 556785 563536 565165 565273 568480 580940 585630 587605 590865 596168 598513 598918 599844 600002 601887 603386 603662 606164 607398 610734 627703 630553 633875 634793 637718 660747 670286 672122 678128 678967 681313 689702 692237 695201 706658 707306 714003 720237 724268 724559 724906 751589 770824 775946 781277 797541 808472 809514 814760 815019 815119 816882 817507 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (11.09%) |
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 420438 815119 532959 565273 587605 633875 580940 193666 816882 531195 467700 479087 474557 537899 781277 443903 483375 448368 637718 598918 531070 188395 341729 815019 483005 464596 536292 473832 543609 692237 720237 601887 610734 634793 809514 751589 419517 491398 484664 455919 482534 660747 556785 478074 473871 817507 542565 419123 814760 490261 707306 775946 724559 95673 411747 419854 415081 509875 565165 678967 670286 724268 770824 797541 478453 433475 568480 596168 538360 552266 599844 607398 506908 463073 469599 532783 530854 540239 681313 808472 724906 378046 606164 484529 395970 598513 603386 545430 477060 695201 714003 455085 531511 627703 630553 448832 514601 600002 478252 678128 514940 556774 585630 419529 530940 563536 590865 514582 544665 672122 689702 706658 603662 441004 412925 453349 384809 404791 484727 383160 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (1.97%) |
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 95673 188395 193666 341729 378046 383160 384809 395970 404791 411747 412925 415081 419123 419517 419529 419854 420438 433475 441004 443903 448368 448832 453349 455085 455919 463073 464596 467700 469599 473832 473871 474557 477060 478074 478252 478453 479087 482534 483005 483375 484529 484664 484727 490261 491398 506908 509875 514582 514601 514940 530854 530940 531070 531195 531511 532783 532959 536292 537899 538360 540239 542565 543609 544665 545430 552266 556774 556785 563536 565165 565273 568480 580940 585630 587605 590865 596168 598513 598918 599844 600002 601887 603386 603662 606164 607398 610734 627703 630553 633875 634793 637718 660747 670286 672122 678128 678967 681313 689702 692237 695201 706658 707306 714003 720237 724268 724559 724906 751589 770824 775946 781277 797541 808472 809514 814760 815019 815119 816882 817507 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome anal milf"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.96%) |
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.