Query Metrics
7
Database Queries
7
Different statements
158.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.28 ms (84.77%) |
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 105845 203811 229566 366283 383244 389332 398325 401584 402919 403049 435520 443859 450762 464780 470387 473891 482328 485958 502025 502681 510637 521228 523008 527737 538191 546730 548648 557052 560397 561333 566327 567150 570478 573544 590533 600210 601190 601629 605083 606768 619363 624961 635172 637679 679108 679373 681140 688560 688578 701296 704534 704870 708752 714590 716115 719085 719827 721741 721792 721851 722437 722537 722839 723961 724472 724499 726492 726599 726684 726768 727398 727770 730301 731091 732938 733416 737169 738778 739948 741295 742928 744766 744887 747568 748322 748384 752910 753340 753473 755991 759679 765306 765895 768983 769755 769829 771723 772463 775470 776006 780901 783584 785770 788729 794744 795117 795372 795536 797274 798815 800199 800887 801883 803176 804502 807192 807769 810666 810812 811832 ] |
||||||||||||||||||||||||||||||
|
14.30 ms (9.03%) |
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 679108 681140 688560 688578 701296 704870 716115 719827 721741 722437 722537 548648 560397 561333 570478 573544 601190 619363 624961 635172 590533 600210 605083 775470 780901 810812 811832 776006 783584 800887 723961 731091 742928 748322 765306 788729 797274 807192 807769 724472 724499 727398 730301 744766 753473 759679 726492 726599 726684 738778 739948 744887 752910 755991 765895 768983 769755 769829 726768 727770 747568 772463 732938 733416 737169 741295 748384 753340 771723 601629 606768 704534 708752 714590 719085 721792 721851 722839 785770 794744 795117 795372 795536 798815 800199 801883 803176 804502 810666 105845 366283 383244 401584 464780 398325 482328 203811 403049 229566 402919 435520 470387 502681 485958 521228 527737 510637 538191 389332 443859 450762 473891 502025 523008 567150 679373 546730 557052 566327 637679 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (1.60%) |
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 105845 203811 229566 366283 383244 389332 398325 401584 402919 403049 435520 443859 450762 464780 470387 473891 482328 485958 502025 502681 510637 521228 523008 527737 538191 546730 548648 557052 560397 561333 566327 567150 570478 573544 590533 600210 601190 601629 605083 606768 619363 624961 635172 637679 679108 679373 681140 688560 688578 701296 704534 704870 708752 714590 716115 719085 719827 721741 721792 721851 722437 722537 722839 723961 724472 724499 726492 726599 726684 726768 727398 727770 730301 731091 732938 733416 737169 738778 739948 741295 742928 744766 744887 747568 748322 748384 752910 753340 753473 755991 759679 765306 765895 768983 769755 769829 771723 772463 775470 776006 780901 783584 785770 788729 794744 795117 795372 795536 797274 798815 800199 800887 801883 803176 804502 807192 807769 810666 810812 811832 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy kissing"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy kissing"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy kissing"
]
|
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.