Query Metrics
7
Database Queries
7
Different statements
661.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
266.81 ms (40.35%) |
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 809505 726372 729002 735442 747083 731830 750143 750280 767078 768198 770321 771344 776662 778259 784281 787351 546274 715899 441785 471086 479843 468272 513511 495443 530692 536299 468322 554086 554100 780630 790133 808819 794481 800479 732212 740681 788011 791627 799011 729281 726294 764143 726240 738640 760609 720209 775686 788170 640390 710647 628506 442088 493669 493626 493733 584145 659989 664094 670832 657565 717817 655902 656593 656625 680230 594569 616397 602682 640149 620974 639552 725120 615911 708752 506125 610517 613981 544125 669923 707446 669237 547516 626842 731038 390563 824028 490618 473783 462982 482866 558189 660597 690296 719927 550917 562587 573275 575949 639363 775219 777083 726300 732179 733282 734626 748653 749057 758624 759011 761759 769041 788147 800500 761723 762972 723838 726966 734400 739960 758269 ] |
||||||||||||||||||||||||||||||
|
208.38 ms (31.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade asshole"
]
|
||||||||||||||||||||||||||||||
|
177.28 ms (26.81%) |
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 390563 441785 442088 462982 468272 468322 471086 473783 479843 482866 490618 493626 493669 493733 495443 506125 513511 530692 536299 544125 546274 547516 550917 554086 554100 558189 562587 573275 575949 584145 594569 602682 610517 613981 615911 616397 620974 626842 628506 639363 639552 640149 640390 655902 656593 656625 657565 659989 660597 664094 669237 669923 670832 680230 690296 707446 708752 710647 715899 717817 719927 720209 723838 725120 726240 726294 726300 726372 726966 729002 729281 731038 731830 732179 732212 733282 734400 734626 735442 738640 739960 740681 747083 748653 749057 750143 750280 758269 758624 759011 760609 761723 761759 762972 764143 767078 768198 769041 770321 771344 775219 775686 776662 777083 778259 780630 784281 787351 788011 788147 788170 790133 791627 794481 799011 800479 800500 808819 809505 824028 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (0.50%) |
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 390563 441785 442088 462982 468272 468322 471086 473783 479843 482866 490618 493626 493669 493733 495443 506125 513511 530692 536299 544125 546274 547516 550917 554086 554100 558189 562587 573275 575949 584145 594569 602682 610517 613981 615911 616397 620974 626842 628506 639363 639552 640149 640390 655902 656593 656625 657565 659989 660597 664094 669237 669923 670832 680230 690296 707446 708752 710647 715899 717817 719927 720209 723838 725120 726240 726294 726300 726372 726966 729002 729281 731038 731830 732179 732212 733282 734400 734626 735442 738640 739960 740681 747083 748653 749057 750143 750280 758269 758624 759011 760609 761723 761759 762972 764143 767078 768198 769041 770321 771344 775219 775686 776662 777083 778259 780630 784281 787351 788011 788147 788170 790133 791627 794481 799011 800479 800500 808819 809505 824028 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск asshole"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск asshole"
]
|
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.