Query Metrics
7
Database Queries
7
Different statements
243.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
218.29 ms (89.72%) |
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 75896 153440 183343 203927 310683 390059 402772 444525 459314 506819 530118 530585 533817 537273 539573 545627 556223 557492 558301 559670 567560 575688 575958 577491 579239 580730 580933 581004 581452 589579 592169 611342 620273 620764 622033 630068 632718 647745 648569 650150 657739 664235 665429 668519 671473 672419 674373 676151 678761 682611 687880 688095 693250 696138 696937 698885 699349 699479 700178 705770 706320 706983 709629 712306 714191 714253 715536 717683 720100 720610 720644 721002 721416 724020 726119 726149 726910 728150 731767 732109 736596 737171 744797 747350 749719 750484 752754 754341 754583 756309 760118 769995 773901 774002 774782 776474 784445 788237 788751 793085 793780 797794 799638 800877 800913 802808 805992 808552 810925 812918 814405 814772 815604 820702 821307 823349 823400 823438 827009 ] |
||||||||||||||||||||||||||||||
|
14.06 ms (5.78%) |
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 814405 815604 823349 823400 827009 506819 533817 539573 530585 580933 575688 581004 545627 567560 650150 657739 664235 682611 693250 698885 700178 705770 712306 717683 720644 665429 676151 714253 720610 647745 648569 668519 671473 674373 678761 688095 696138 706983 714191 720100 558301 575958 622033 620764 611342 620273 630068 592169 774782 784445 799638 800877 802808 726119 744797 750484 773901 788237 788751 793780 797794 808552 726910 728150 752754 760118 769995 754341 756309 732109 736596 747350 754583 726149 731767 632718 696937 699349 706320 707498 709629 715536 721002 812918 530118 557492 577491 390059 687880 805992 793085 820702 559670 589579 810925 774002 749719 776474 537273 581452 800913 724020 737171 203927 183343 310683 75896 153440 402772 444525 823438 814772 821307 459314 556223 579239 580730 672419 699479 721416 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.28%) |
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 75896 153440 183343 203927 310683 390059 402772 444525 459314 506819 530118 530585 533817 537273 539573 545627 556223 557492 558301 559670 567560 575688 575958 577491 579239 580730 580933 581004 581452 589579 592169 611342 620273 620764 622033 630068 632718 647745 648569 650150 657739 664235 665429 668519 671473 672419 674373 676151 678761 682611 687880 688095 693250 696138 696937 698885 699349 699479 700178 705770 706320 706983 709629 712306 714191 714253 715536 717683 720100 720610 720644 721002 721416 724020 726119 726149 726910 728150 731767 732109 736596 737171 744797 747350 749719 750484 752754 754341 754583 756309 760118 769995 773901 774002 774782 776474 784445 788237 788751 793085 793780 797794 799638 800877 800913 802808 805992 808552 810925 812918 814405 814772 815604 820702 821307 823349 823400 823438 827009 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопы сиськи"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.66%) |
1 |
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.