Query Metrics
7
Database Queries
7
Different statements
248.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.45 ms (87.61%) |
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 285885 395258 397111 397531 407700 409367 410872 417067 423518 430526 443637 454255 456445 457401 462717 466787 467575 470001 470391 470625 470955 472787 475249 490068 492048 495049 495741 501178 501262 504042 508720 517301 517466 517622 524147 525244 526568 528867 530310 530930 531606 533679 534074 534132 536202 536959 536998 542346 543405 543555 544113 544879 545187 545431 546667 548005 550820 552783 553661 559711 560454 578565 583470 584018 585269 590437 590472 590898 590906 596556 600955 604746 606825 610805 618236 621136 632851 635833 645050 649291 653343 653758 653971 654600 654636 676804 686024 686863 690049 693816 693849 698018 698089 703212 708034 712654 715550 715559 720877 726754 729216 729258 748542 748985 753505 757638 760247 761519 766117 773945 775256 790615 793097 805276 807498 807889 809521 813662 824420 826232 ] |
||||||||||||||||||||||||||||||
|
17.65 ms (7.11%) |
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 462717 492048 495741 524147 397531 430526 813662 543555 546667 693849 698089 548005 635833 805276 761519 793097 726754 748542 470001 407700 528867 590906 470391 654636 703212 397111 773945 530930 645050 690049 686024 417067 824420 826232 457401 517466 531606 545431 720877 584018 585269 790615 729258 632851 454255 472787 495049 517622 610805 504042 544113 578565 550820 559711 490068 536998 654600 621136 753505 501262 708034 712654 590898 775256 766117 698018 590437 501178 409367 715550 809521 470955 517301 525244 560454 423518 285885 467575 545187 757638 536202 542346 544879 807498 456445 533679 534132 534074 536959 466787 543405 653343 653758 618236 600955 748985 760247 729216 807889 676804 596556 508720 715559 410872 649291 553661 475249 693816 443637 552783 604746 526568 395258 470625 530310 653971 686863 583470 590472 606825 ] |
||||||||||||||||||||||||||||||
|
6.30 ms (2.54%) |
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 285885 395258 397111 397531 407700 409367 410872 417067 423518 430526 443637 454255 456445 457401 462717 466787 467575 470001 470391 470625 470955 472787 475249 490068 492048 495049 495741 501178 501262 504042 508720 517301 517466 517622 524147 525244 526568 528867 530310 530930 531606 533679 534074 534132 536202 536959 536998 542346 543405 543555 544113 544879 545187 545431 546667 548005 550820 552783 553661 559711 560454 578565 583470 584018 585269 590437 590472 590898 590906 596556 600955 604746 606825 610805 618236 621136 632851 635833 645050 649291 653343 653758 653971 654600 654636 676804 686024 686863 690049 693816 693849 698018 698089 703212 708034 712654 715550 715559 720877 726754 729216 729258 748542 748985 753505 757638 760247 761519 766117 773945 775256 790615 793097 805276 807498 807889 809521 813662 824420 826232 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex wife threesome"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.67%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс жен секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.65%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.