Query Metrics
7
Database Queries
7
Different statements
132.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
111.36 ms (83.84%) |
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 388312 413029 423637 425195 449502 483771 507929 511462 541347 543538 543600 555471 556079 567734 570134 570962 571110 581192 590525 612787 620581 622159 625743 634961 635782 640392 647192 651220 653065 653844 656252 661901 675167 675185 680378 682612 684863 684893 685935 689054 689930 691761 693669 698249 698252 699304 702993 705435 712201 713002 714389 715070 715604 716950 718113 720852 726899 727729 727985 728568 729197 730442 730972 734537 735281 735925 736686 737532 737841 738320 738522 741073 741524 744416 747245 750703 753158 757174 760266 760621 761011 765942 767449 767878 768331 768641 772662 773430 773798 775290 777276 777675 778122 780585 780977 782418 782433 785692 786534 787690 788233 788560 791874 792245 793588 795059 795824 796348 796765 798527 800159 800729 800734 802051 802329 808316 809903 814433 818465 824498 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (9.88%) |
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 792245 782418 423637 507929 675167 800159 753158 388312 413029 824498 818465 449502 715070 741073 425195 814433 483771 511462 541347 543600 570134 570962 581192 567734 543538 556079 680378 684863 684893 685935 691761 693669 699304 702993 651220 653844 656252 675185 682612 689930 705435 712201 713002 714389 716950 647192 653065 661901 689054 698249 698252 715604 718113 720852 555471 571110 620581 622159 634961 590525 612787 635782 625743 640392 777276 777675 778122 780977 786534 793588 795059 795824 796348 800729 802329 775290 780585 782433 787690 788560 791874 796765 800734 809903 727729 727985 728568 729197 735925 747245 757174 760621 761011 767449 768641 772662 785692 788233 798527 802051 808316 730972 734537 736686 737532 737841 741524 744416 750703 760266 765942 767878 768331 773430 773798 726899 730442 735281 738320 738522 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.57%) |
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 388312 413029 423637 425195 449502 483771 507929 511462 541347 543538 543600 555471 556079 567734 570134 570962 571110 581192 590525 612787 620581 622159 625743 634961 635782 640392 647192 651220 653065 653844 656252 661901 675167 675185 680378 682612 684863 684893 685935 689054 689930 691761 693669 698249 698252 699304 702993 705435 712201 713002 714389 715070 715604 716950 718113 720852 726899 727729 727985 728568 729197 730442 730972 734537 735281 735925 736686 737532 737841 738320 738522 741073 741524 744416 747245 750703 753158 757174 760266 760621 761011 765942 767449 767878 768331 768641 772662 773430 773798 775290 777276 777675 778122 780585 780977 782418 782433 785692 786534 787690 788233 788560 791874 792245 793588 795059 795824 796348 796765 798527 800159 800729 800734 802051 802329 808316 809903 814433 818465 824498 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм pussy cum"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм pussy cum"
]
|
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.