Query Metrics
7
Database Queries
7
Different statements
147.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.79 ms (81.48%) |
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 177440 384382 388847 411804 411845 411848 422803 432766 448828 452383 454313 454699 462915 463834 464608 466209 466840 468282 468524 468697 469302 469311 470402 476074 476136 478536 480062 482686 487711 488619 496997 497879 499843 503407 528087 530769 531222 531296 531467 532764 532846 534647 535467 535611 536230 536632 537927 537932 544848 545325 545471 547477 550380 569217 571846 576637 580653 583449 583953 585989 586939 589551 594008 600004 600359 601043 601544 606152 607371 608569 612816 618543 619652 626292 626293 627781 630487 634849 642029 644960 646200 648819 649131 649559 649560 651613 654174 655871 670349 672383 681666 688672 692804 702619 710690 714256 716189 716857 717545 718784 718945 721027 721113 736412 740599 741541 743040 748475 748975 750545 755846 756250 761300 761347 779744 782402 788176 802375 810979 817242 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (11.07%) |
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 736412 743040 750545 714256 802375 630487 469311 532764 649559 422803 432766 411804 452383 488619 534647 600004 463834 503407 482686 462915 476136 466209 487711 817242 530769 536230 476074 569217 681666 716189 601043 619652 448828 496997 468282 478536 177440 531222 531296 535611 535467 536632 532846 537927 550380 580653 583953 702619 710690 718784 648819 545471 606152 608569 612816 585989 601544 607371 642029 748975 741541 626292 469302 388847 654174 618543 454313 454699 531467 670349 721113 649131 646200 688672 692804 717545 600359 627781 788176 810979 755846 740599 756250 761300 761347 721027 672383 537932 716857 466840 470402 468697 571846 384382 644960 499843 544848 545325 576637 583449 547477 649560 655871 651613 718945 586939 589551 594008 626293 634849 779744 748475 782402 411848 497879 411845 464608 528087 480062 468524 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.96%) |
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 177440 384382 388847 411804 411845 411848 422803 432766 448828 452383 454313 454699 462915 463834 464608 466209 466840 468282 468524 468697 469302 469311 470402 476074 476136 478536 480062 482686 487711 488619 496997 497879 499843 503407 528087 530769 531222 531296 531467 532764 532846 534647 535467 535611 536230 536632 537927 537932 544848 545325 545471 547477 550380 569217 571846 576637 580653 583449 583953 585989 586939 589551 594008 600004 600359 601043 601544 606152 607371 608569 612816 618543 619652 626292 626293 627781 630487 634849 642029 644960 646200 648819 649131 649559 649560 651613 654174 655871 670349 672383 681666 688672 692804 702619 710690 714256 716189 716857 717545 718784 718945 721027 721113 736412 740599 741541 743040 748475 748975 750545 755846 756250 761300 761347 779744 782402 788176 802375 810979 817242 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf anal casting"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf анал кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf анал кастинг"
]
|
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.