Query Metrics
7
Database Queries
7
Different statements
144.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.20 ms (84.61%) |
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 391009 391134 398112 402531 418161 423455 427285 455478 455949 457656 465711 490637 505936 517789 534515 535314 539335 540858 550921 553405 555449 557774 585240 588900 590196 595183 595577 603280 605675 612407 614803 617575 617880 618407 619274 628130 628510 629740 629833 632450 635387 640247 644447 653078 660036 660098 666055 666715 692780 695001 696127 696133 703705 703715 703750 703762 707605 709936 710639 712312 712569 714535 715366 715370 723957 724520 725226 725437 726590 726848 728947 728949 728954 728983 729029 730159 730272 732950 737840 739782 740512 742276 742785 745257 746321 749780 750134 753630 758780 759015 760231 768072 768367 775464 788663 791588 793516 794053 794161 795909 800389 800843 801351 802429 803741 804027 804441 810259 819334 819338 819988 824128 824790 824939 824948 825191 825400 827272 827562 827577 ] |
||||||||||||||||||||||||||||||
|
12.12 ms (8.39%) |
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 540858 819988 824948 825191 827562 703750 696127 712569 629740 750134 800389 742785 455478 715370 629833 803741 810259 794161 804441 730159 737840 726590 423455 402531 418161 427285 517789 398112 585240 824939 825400 827272 827577 819338 824128 505936 553405 660036 695001 696133 703762 709936 635387 618407 603280 640247 802429 726848 746321 793516 801351 725226 728947 728949 723957 760231 753630 632450 703715 791588 391009 490637 457656 535314 539335 557774 707605 666055 692780 588900 595577 614803 617575 758780 795909 724520 740512 745257 742276 739782 759015 391134 605675 819334 824790 455949 465711 534515 550921 555449 660098 703705 710639 653078 666715 712312 715366 595183 619274 590196 612407 617880 628510 775464 794053 800843 729029 725437 768367 728983 732950 728954 730272 768072 749780 628130 644447 714535 788663 804027 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (2.05%) |
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 391009 391134 398112 402531 418161 423455 427285 455478 455949 457656 465711 490637 505936 517789 534515 535314 539335 540858 550921 553405 555449 557774 585240 588900 590196 595183 595577 603280 605675 612407 614803 617575 617880 618407 619274 628130 628510 629740 629833 632450 635387 640247 644447 653078 660036 660098 666055 666715 692780 695001 696127 696133 703705 703715 703750 703762 707605 709936 710639 712312 712569 714535 715366 715370 723957 724520 725226 725437 726590 726848 728947 728949 728954 728983 729029 730159 730272 732950 737840 739782 740512 742276 742785 745257 746321 749780 750134 753630 758780 759015 760231 768072 768367 775464 788663 791588 793516 794053 794161 795909 800389 800843 801351 802429 803741 804027 804441 810259 819334 819338 819988 824128 824790 824939 824948 825191 825400 827272 827562 827577 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum hairy"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.