Query Metrics
7
Database Queries
7
Different statements
197.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.53 ms (86.95%) |
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 7108 14806 32874 32937 33260 154516 155198 161318 327981 387295 401517 401809 402350 405508 405954 406363 407562 411052 413788 414088 415739 417495 417865 417884 419600 420116 420499 425627 428535 430285 445730 458597 463838 464344 465483 465484 468371 472263 472553 485170 487010 489347 496279 517181 519182 525678 536930 537832 538725 539917 540393 543894 544694 551980 560292 578208 578786 580757 583948 587081 589238 601710 604500 604515 604526 604571 609673 613015 618036 624828 629901 638533 643920 647641 649863 673767 674100 683593 690884 693220 701309 708667 710266 711337 720176 721060 722187 724483 725676 726665 729181 732468 744668 751309 779774 785679 787215 788364 789790 792817 793151 795515 800474 800475 805424 808580 810122 811270 813074 813799 814661 818281 821162 822189 822419 822559 824787 824900 828758 ] |
||||||||||||||||||||||||||||||
|
15.29 ms (7.75%) |
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 538725 539917 472553 551980 578208 647641 580757 604571 613015 638533 604515 808580 811270 793151 800475 805424 726665 729181 604500 604526 720176 792817 430285 425627 406363 413788 419600 487010 155198 161318 33260 402350 401517 401809 405954 411052 417865 407562 415739 822419 821926 465483 465484 485170 445730 458597 489347 540393 536930 537832 583948 560292 683593 674100 690884 710266 711337 649863 701309 708667 587081 589238 787215 789790 813074 744668 795515 751309 725676 732468 721060 810122 417495 420499 14806 405508 420116 472263 463838 525678 468371 800474 724483 601710 618036 428535 154516 327981 32937 32874 7108 387295 414088 417884 821162 822189 822559 824787 813799 814661 818281 824900 828758 517181 519182 496279 464344 544694 543894 673767 693220 722187 578786 643920 609673 624828 629901 779774 785679 788364 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.46%) |
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 7108 14806 32874 32937 33260 154516 155198 161318 327981 387295 401517 401809 402350 405508 405954 406363 407562 411052 413788 414088 415739 417495 417865 417884 419600 420116 420499 425627 428535 430285 445730 458597 463838 464344 465483 465484 468371 472263 472553 485170 487010 489347 496279 517181 519182 525678 536930 537832 538725 539917 540393 543894 544694 551980 560292 578208 578786 580757 583948 587081 589238 601710 604500 604515 604526 604571 609673 613015 618036 624828 629901 638533 643920 647641 649863 673767 674100 683593 690884 693220 701309 708667 710266 711337 720176 721060 722187 724483 725676 726665 729181 732468 744668 751309 779774 785679 787215 788364 789790 792817 793151 795515 800474 800475 805424 808580 810122 811270 813074 813799 814661 818281 821162 822189 822419 822559 824787 824900 828758 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black tits"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.97%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black сиськ"
]
|
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.