Query Metrics
7
Database Queries
7
Different statements
176.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.78 ms (83.66%) |
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 72802 106389 186948 370755 382657 382947 389639 392597 394427 397479 401108 401130 401954 404296 406067 407780 407871 408164 409383 409934 410237 411012 411904 411941 412979 437530 439709 440614 446375 450650 451469 452157 453132 454188 454247 460017 460757 460925 462317 464278 464338 464420 465955 466051 466793 468121 470295 471616 471975 472684 474095 474482 475678 475691 477227 478762 479040 479055 481906 484635 484678 485747 490197 490598 503431 505089 505673 509836 519140 519802 522627 523874 550220 552327 554390 554859 556630 562971 566940 567420 586688 589655 605083 610034 619614 628649 663903 664840 665224 675974 694072 694559 706889 708827 715368 715473 715589 718524 721706 724252 727769 727787 727800 740791 741742 742418 750294 754227 758438 770233 772472 777004 781733 789292 789536 799360 816250 816382 816785 818810 ] |
||||||||||||||||||||||||||||||
|
18.24 ms (10.33%) |
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 460017 562971 706889 741742 718524 477227 406067 721706 389639 401954 404296 408164 472684 478762 450650 475678 409383 789292 382657 522627 816250 818810 554859 708827 605083 740791 481906 484635 392597 519802 464278 471975 505089 475691 464338 468121 665224 407871 474095 503431 464420 619614 397479 401108 411941 552327 664840 410237 440614 465955 470295 479055 479040 394427 663903 589655 186948 407780 409934 566940 556630 550220 789536 724252 727769 799360 466051 454247 474482 437530 451469 460757 523874 490197 412979 471616 454188 462317 554390 586688 628649 567420 816785 715368 694072 781733 754227 727800 727787 439709 382947 370755 401130 452157 505673 460925 453132 519140 484678 485747 715589 675974 715473 411904 466793 446375 490598 509836 72802 106389 411012 816382 694559 610034 777004 750294 758438 742418 770233 772472 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.68%) |
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 72802 106389 186948 370755 382657 382947 389639 392597 394427 397479 401108 401130 401954 404296 406067 407780 407871 408164 409383 409934 410237 411012 411904 411941 412979 437530 439709 440614 446375 450650 451469 452157 453132 454188 454247 460017 460757 460925 462317 464278 464338 464420 465955 466051 466793 468121 470295 471616 471975 472684 474095 474482 475678 475691 477227 478762 479040 479055 481906 484635 484678 485747 490197 490598 503431 505089 505673 509836 519140 519802 522627 523874 550220 552327 554390 554859 556630 562971 566940 567420 586688 589655 605083 610034 619614 628649 663903 664840 665224 675974 694072 694559 706889 708827 715368 715473 715589 718524 721706 724252 727769 727787 727800 740791 741742 742418 750294 754227 758438 770233 772472 777004 781733 789292 789536 799360 816250 816382 816785 818810 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big vagina mature"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие вагин mature"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие вагин 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.