Query Metrics
7
Database Queries
7
Different statements
173.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.91 ms (83.56%) |
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 287540 382960 391349 391594 396353 396687 398704 399303 402375 405243 406176 414759 425687 432129 436149 437717 438006 439175 444803 478254 480353 483010 484003 489118 490523 494278 495685 496325 499868 500873 504119 505144 506094 507568 512337 512504 516426 524755 528331 529482 530065 532259 535116 540272 548280 550946 558812 561581 562946 566199 572008 582399 584171 586456 588024 588422 599072 599139 599527 603081 605369 610517 610867 611932 612829 613753 614880 631863 640948 655924 657752 662575 663305 679713 688322 696832 698028 705780 706656 717820 720145 720796 721744 725714 729548 733554 733847 733856 733873 733902 740800 747153 747694 755329 760439 761776 763769 769531 771591 774214 775346 777265 780067 782610 785603 786763 788817 788856 788864 790575 798681 798729 800232 801709 809842 810035 813382 814252 814417 826672 ] |
||||||||||||||||||||||||||||||
|
17.17 ms (9.90%) |
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 786763 801709 396353 733902 733847 720796 414759 507568 391594 611932 603081 777265 810035 398704 663305 688322 706656 657752 631863 610867 798729 747694 755329 761776 763769 396687 382960 505144 721744 788864 740800 733873 771591 780067 561581 662575 705780 614880 775346 788817 566199 391349 399303 532259 747153 774214 444803 826672 494278 540272 584171 696832 599139 729548 733554 717820 287540 512337 483010 588024 588422 599527 612829 432129 402375 478254 480353 496325 698028 720145 610517 800232 785603 788856 425687 512504 484003 524755 529482 558812 760439 733856 769531 439175 405243 438006 489118 516426 506094 406176 814417 490523 499868 548280 572008 550946 582399 599072 613753 605369 798681 813382 640948 504119 500873 495685 436149 814252 530065 528331 535116 562946 655924 586456 725714 790575 809842 437717 679713 782610 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.33%) |
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 287540 382960 391349 391594 396353 396687 398704 399303 402375 405243 406176 414759 425687 432129 436149 437717 438006 439175 444803 478254 480353 483010 484003 489118 490523 494278 495685 496325 499868 500873 504119 505144 506094 507568 512337 512504 516426 524755 528331 529482 530065 532259 535116 540272 548280 550946 558812 561581 562946 566199 572008 582399 584171 586456 588024 588422 599072 599139 599527 603081 605369 610517 610867 611932 612829 613753 614880 631863 640948 655924 657752 662575 663305 679713 688322 696832 698028 705780 706656 717820 720145 720796 721744 725714 729548 733554 733847 733856 733873 733902 740800 747153 747694 755329 760439 761776 763769 769531 771591 774214 775346 777265 780067 782610 785603 786763 788817 788856 788864 790575 798681 798729 800232 801709 809842 810035 813382 814252 814417 826672 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"only секс"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"only секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"only fuck"
]
|
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.