Query Metrics
7
Database Queries
7
Different statements
160.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.68 ms (83.15%) |
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 388940 390980 401904 413406 420291 436690 440682 443103 443323 445737 446709 450889 451852 454954 456035 459561 460027 462850 464887 465606 469756 469758 471691 474349 481142 483543 488734 500740 502796 503310 505606 508200 511838 516684 518403 519497 522142 522307 530018 530024 530382 530501 530912 531135 532360 532965 533065 535039 536638 537204 537648 537660 537890 540348 544816 544838 544840 564066 566786 597257 600175 600329 600337 601609 612399 623205 628334 628371 628383 630297 630493 630522 630869 631202 631209 631962 632283 632586 632618 633454 634790 635277 637049 637087 637100 637147 639335 639718 641956 642043 644913 646427 646782 647340 647854 647936 647972 648809 648825 648840 648841 650198 650316 651647 666867 666895 674968 674988 674995 676090 677296 677781 677783 678504 679772 696214 696582 716901 719104 773833 ] |
||||||||||||||||||||||||||||||
|
17.30 ms (10.76%) |
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 676090 677781 648841 647340 648809 648825 630297 630522 623205 632618 634790 637100 639718 642043 450889 522142 530018 650316 630869 465606 651647 464887 462850 469756 454954 481142 536638 518403 532360 537204 537660 530501 531135 471691 544816 544838 647936 678504 696582 716901 650198 674988 628334 612399 600337 631202 641956 631209 632283 445737 483543 488734 519497 388940 413406 436690 451852 459561 456035 469758 535039 500740 533065 537890 540348 532965 646782 648840 679772 719104 666867 696214 564066 639335 597257 600329 601609 633454 600175 630493 631962 632586 635277 637087 637147 773833 390980 401904 440682 446709 505606 502796 508200 530024 530382 674995 677296 637049 628383 628371 503310 516684 566786 443103 474349 522307 511838 460027 420291 443323 644913 530912 537648 544840 647854 666895 674968 677783 646427 647972 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.77%) |
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 388940 390980 401904 413406 420291 436690 440682 443103 443323 445737 446709 450889 451852 454954 456035 459561 460027 462850 464887 465606 469756 469758 471691 474349 481142 483543 488734 500740 502796 503310 505606 508200 511838 516684 518403 519497 522142 522307 530018 530024 530382 530501 530912 531135 532360 532965 533065 535039 536638 537204 537648 537660 537890 540348 544816 544838 544840 564066 566786 597257 600175 600329 600337 601609 612399 623205 628334 628371 628383 630297 630493 630522 630869 631202 631209 631962 632283 632586 632618 633454 634790 635277 637049 637087 637100 637147 639335 639718 641956 642043 644913 646427 646782 647340 647854 647936 647972 648809 648825 648840 648841 650198 650316 651647 666867 666895 674968 674988 674995 676090 677296 677781 677783 678504 679772 696214 696582 716901 719104 773833 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double дилд teen"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double dildo teen"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double дилд teen"
]
|
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.