Query Metrics
7
Database Queries
7
Different statements
143.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.39 ms (85.83%) |
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 7178 13118 13229 172068 232973 276696 379559 393102 397863 398811 401383 401666 403321 404664 406734 408969 409316 410683 411326 411408 411468 413183 415988 421740 426434 428846 434425 439643 440851 443738 448363 448802 457463 460673 466196 468043 468167 469447 470148 475319 477128 479856 480212 481328 481937 482339 482527 486192 493149 495990 498081 498614 500806 508684 509267 511375 512513 513114 514833 520904 521121 521137 522510 522614 523838 526456 536433 537267 547492 557512 557814 561042 562967 564655 570783 571806 580712 582335 586583 590373 592548 592857 596488 619096 621536 634849 639788 709654 718496 719929 726612 727789 733371 740826 746621 758509 761323 761600 777727 777734 782593 782626 787155 788610 788946 788980 789537 790874 792936 795750 795988 797728 798453 801173 802151 803306 807352 807353 807452 811923 ] |
||||||||||||||||||||||||||||||
|
10.90 ms (7.58%) |
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 557814 562967 580712 592857 634849 787155 795988 802151 807352 807353 777727 788980 733371 758509 761323 761600 798453 726612 727789 740826 709654 719929 777734 788946 792936 795750 379559 409316 410683 428846 481328 7178 401666 413183 434425 440851 475319 13118 477128 415988 421740 466196 500806 522614 536433 508684 513114 522510 486192 526456 514833 520904 398811 621536 789537 807452 797728 746621 811923 232973 13229 460673 482527 571806 397863 426434 439643 411468 401383 404664 408969 457463 468043 512513 480212 482339 564655 547492 718496 557512 582335 586583 619096 596488 639788 590373 592548 782593 782626 803306 788610 790874 801173 172068 393102 403321 481937 468167 469447 479856 406734 411408 470148 411326 443738 509267 537267 493149 521121 521137 495990 523838 498081 498614 511375 276696 448802 448363 561042 570783 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.64%) |
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 7178 13118 13229 172068 232973 276696 379559 393102 397863 398811 401383 401666 403321 404664 406734 408969 409316 410683 411326 411408 411468 413183 415988 421740 426434 428846 434425 439643 440851 443738 448363 448802 457463 460673 466196 468043 468167 469447 470148 475319 477128 479856 480212 481328 481937 482339 482527 486192 493149 495990 498081 498614 500806 508684 509267 511375 512513 513114 514833 520904 521121 521137 522510 522614 523838 526456 536433 537267 547492 557512 557814 561042 562967 564655 570783 571806 580712 582335 586583 590373 592548 592857 596488 619096 621536 634849 639788 709654 718496 719929 726612 727789 733371 740826 746621 758509 761323 761600 777727 777734 782593 782626 787155 788610 788946 788980 789537 790874 792936 795750 795988 797728 798453 801173 802151 803306 807352 807353 807452 811923 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелые тетки бесплатн…"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин мам женщин бесплатн"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.97%) |
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.