Query Metrics
7
Database Queries
7
Different statements
698.49 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 209.42 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.99 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo masturbation girls"
]
|
||||||||||||||||||||||||||||||
| 3 | 12.62 ms |
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 786367 757908 782724 506626 666089 605142 774783 743228 754245 805472 806675 760704 787601 820424 740517 771092 213317 647230 747579 759044 768458 751016 758449 743230 482459 808729 744214 669000 643078 813724 530981 752573 398213 681242 652268 710494 610268 748289 726210 734860 777292 778524 376219 825660 565517 455709 817645 506070 755095 738291 760750 821747 385473 783248 803146 760536 809650 619674 596038 785683 760657 812423 450683 563371 612965 774484 783373 784895 801658 805488 747594 713118 742305 507323 554728 811881 786200 444514 813734 554679 550928 553342 543057 684839 687379 703571 650670 670737 687375 713294 684850 687786 556745 626092 616837 617068 617585 607931 618930 777665 785069 785221 803119 783183 793921 741660 748511 766158 774118 753778 754643 739316 739439 747592 751030 764354 749054 696961 703255 777339 ] |
||||||||||||||||||||||||||||||
| 4 | 2.97 ms |
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 213317 376219 385473 398213 444514 450683 455709 482459 506070 506626 507323 530981 543057 550928 553342 554679 554728 556745 563371 565517 596038 605142 607931 610268 612965 616837 617068 617585 618930 619674 626092 643078 647230 650670 652268 666089 669000 670737 681242 684839 684850 687375 687379 687786 696961 703255 703571 710494 713118 713294 726210 734860 738291 739316 739439 740517 741660 742305 743228 743230 744214 747579 747592 747594 748289 748511 749054 751016 751030 752573 753778 754245 754643 755095 757908 758449 759044 760536 760657 760704 760750 764354 766158 768458 771092 774118 774484 774783 777292 777339 777665 778524 782724 783183 783248 783373 784895 785069 785221 785683 786200 786367 787601 793921 801658 803119 803146 805472 805488 806675 808729 809650 811881 812423 813724 813734 817645 820424 821747 825660 ] |
||||||||||||||||||||||||||||||
| 5 | 254.26 ms |
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 213317 376219 385473 398213 444514 450683 455709 482459 506070 506626 507323 530981 543057 550928 553342 554679 554728 556745 563371 565517 596038 605142 607931 610268 612965 616837 617068 617585 618930 619674 626092 643078 647230 650670 652268 666089 669000 670737 681242 684839 684850 687375 687379 687786 696961 703255 703571 710494 713118 713294 726210 734860 738291 739316 739439 740517 741660 742305 743228 743230 744214 747579 747592 747594 748289 748511 749054 751016 751030 752573 753778 754245 754643 755095 757908 758449 759044 760536 760657 760704 760750 764354 766158 768458 771092 774118 774484 774783 777292 777339 777665 778524 782724 783183 783248 783373 784895 785069 785221 785683 786200 786367 787601 793921 801658 803119 803146 805472 805488 806675 808729 809650 811881 812423 813724 813734 817645 820424 821747 825660 ] |
||||||||||||||||||||||||||||||
| 6 | 215.92 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац девушк"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.29 ms |
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.