Query Metrics
7
Database Queries
7
Different statements
182.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.44 ms (87.00%) |
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 102026 148028 382094 386658 403066 403633 406907 414058 419849 420481 430326 437870 443671 445072 445776 454680 457095 459223 459368 464374 465535 467030 470888 472600 473328 477397 477645 481254 482648 483394 483675 485484 489166 494750 505319 513891 531395 549197 556674 557883 557973 559609 560477 564370 566780 566859 570423 572092 574591 576785 581323 585734 590348 596391 597128 603948 604952 605680 606923 607041 608714 612030 618774 620669 631595 632568 645959 648517 649971 652853 661954 666778 667546 667566 667829 668801 679700 681936 684226 697416 698880 701566 704971 705118 705196 708034 709492 715387 715397 716225 718552 719899 720616 726144 732825 733231 737070 738770 741452 751597 754097 757175 775974 776307 781648 788589 789666 791706 792356 796545 800571 801475 801889 804876 805268 809663 810183 812794 816755 818779 ] |
||||||||||||||||||||||||||||||
|
13.82 ms (7.59%) |
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 445072 467030 470888 459223 494750 472600 549197 574591 667546 667566 701566 649971 704971 715397 661954 667829 705196 572092 607041 590348 620669 800571 810183 804876 741452 751597 737070 738770 632568 698880 719899 720616 781648 465535 459368 473328 477645 406907 420481 443671 483394 513891 505319 386658 102026 652853 489166 556674 557973 570423 716225 796545 805268 732825 776307 792356 403066 403633 566780 603948 596391 789666 809663 775974 445776 482648 483675 564370 668801 709492 681936 605680 597128 604952 606923 608714 757175 788589 481254 816755 457095 581323 576785 648517 679700 708034 645959 585734 791706 726144 718552 148028 382094 414058 419849 437870 430326 818779 454680 464374 477397 485484 531395 560477 557883 559609 566859 715387 666778 684226 697416 618774 631595 801475 801889 812794 754097 733231 612030 705118 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.40%) |
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 102026 148028 382094 386658 403066 403633 406907 414058 419849 420481 430326 437870 443671 445072 445776 454680 457095 459223 459368 464374 465535 467030 470888 472600 473328 477397 477645 481254 482648 483394 483675 485484 489166 494750 505319 513891 531395 549197 556674 557883 557973 559609 560477 564370 566780 566859 570423 572092 574591 576785 581323 585734 590348 596391 597128 603948 604952 605680 606923 607041 608714 612030 618774 620669 631595 632568 645959 648517 649971 652853 661954 666778 667546 667566 667829 668801 679700 681936 684226 697416 698880 701566 704971 705118 705196 708034 709492 715387 715397 716225 718552 719899 720616 726144 732825 733231 737070 738770 741452 751597 754097 757175 775974 776307 781648 788589 789666 791706 792356 796545 800571 801475 801889 804876 805268 809663 810183 812794 816755 818779 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"guy sex"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"guy секс"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"guy секс"
]
|
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.