Query Metrics
7
Database Queries
7
Different statements
169.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.81 ms (84.13%) |
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 3392 386673 389587 390746 393483 394165 398195 398665 402473 413739 417821 419383 441479 442851 444338 447912 461586 464903 467970 473774 482526 491504 492171 521182 552629 559212 564223 566873 575665 576324 589185 591841 592544 592587 594531 595497 595512 596995 597584 597798 597815 597968 598539 598544 598754 600146 604222 604245 615005 619780 620174 624170 629171 633737 634162 635064 647275 649121 650118 650167 650230 652955 657143 659329 662148 680230 682320 692047 693487 694492 698841 699587 715338 715566 715710 717235 717812 719214 719937 720223 722628 722649 724193 725405 727827 729937 731485 742837 746979 747113 747576 750316 753262 753307 753333 753395 753411 753418 753818 753854 753908 756319 760919 762568 769075 777056 778962 779737 782940 788550 795859 798183 805668 807519 811128 811634 814228 818828 819198 823721 ] |
||||||||||||||||||||||||||||||
|
16.72 ms (9.85%) |
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 762568 635064 390746 398195 398665 402473 413739 823721 819198 650118 650167 692047 715710 649121 698841 719214 693487 699587 717812 591841 596995 779737 778962 747576 753307 753908 788550 811634 727827 746979 753411 753854 747113 760919 724193 742837 753262 753333 753395 753418 769075 731485 615005 389587 386673 3392 467970 575665 682320 564223 620174 592544 604245 394165 444338 492171 442851 447912 473774 521182 464903 566873 715338 597584 629171 633737 589185 595512 598539 604222 592587 594531 597815 798183 782940 756319 634162 715566 719937 811128 393483 461586 491504 419383 576324 417821 441479 814228 818828 482526 559212 552629 650230 657143 722628 652955 662148 694492 720223 647275 659329 680230 717235 722649 597798 597968 595497 600146 619780 598544 598754 624170 795859 807519 777056 725405 750316 753818 805668 729937 ] |
||||||||||||||||||||||||||||||
|
3.34 ms (1.97%) |
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 3392 386673 389587 390746 393483 394165 398195 398665 402473 413739 417821 419383 441479 442851 444338 447912 461586 464903 467970 473774 482526 491504 492171 521182 552629 559212 564223 566873 575665 576324 589185 591841 592544 592587 594531 595497 595512 596995 597584 597798 597815 597968 598539 598544 598754 600146 604222 604245 615005 619780 620174 624170 629171 633737 634162 635064 647275 649121 650118 650167 650230 652955 657143 659329 662148 680230 682320 692047 693487 694492 698841 699587 715338 715566 715710 717235 717812 719214 719937 720223 722628 722649 724193 725405 727827 729937 731485 742837 746979 747113 747576 750316 753262 753307 753333 753395 753411 753418 753818 753854 753908 756319 760919 762568 769075 777056 778962 779737 782940 788550 795859 798183 805668 807519 811128 811634 814228 818828 819198 823721 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm teen"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм teen"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм teen"
]
|
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.