Query Metrics
7
Database Queries
7
Different statements
138.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.12 ms (84.35%) |
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 6806 12845 47284 107348 129955 136203 379619 381873 382242 382254 383932 389451 391044 396928 424870 430560 430564 445240 448666 460407 462921 464817 466327 474413 482246 483310 487982 489246 490267 495206 500450 504060 506238 507793 510822 520230 521200 521213 521567 521693 524401 530431 530523 530570 532057 532632 532718 532722 533183 533692 538035 538931 542396 543052 543094 543211 543250 543566 543666 543738 544341 546218 547861 548089 548513 549262 549269 550561 552056 557435 560089 566711 569697 569699 569709 569777 569781 570902 581718 583823 585619 586126 600808 605313 607556 617782 622916 623273 630393 640494 668406 714121 716135 722465 725474 729917 729919 729943 734370 735385 740614 744835 756493 765168 778655 782762 782773 796748 796853 803456 810045 814639 817012 817082 817113 817182 819552 820715 823259 827954 ] |
||||||||||||||||||||||||||||||
|
13.50 ms (9.72%) |
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 506238 532632 533692 538035 521567 521693 543250 543566 569709 581718 583823 543094 550561 557435 543738 547861 552056 566711 569699 570902 668406 546218 549269 585619 617782 623273 796748 810045 607556 640494 500450 532057 495206 6806 391044 383932 107348 381873 12845 389451 430564 430560 823259 817082 817012 817113 474413 482246 507793 532718 533183 538931 520230 532722 521213 524401 530431 530570 543052 548513 542396 543211 543666 548089 569697 569777 544341 714121 716135 722465 549262 560089 569781 586126 622916 630393 600808 778655 782762 782773 725474 729917 729919 734370 796853 729943 735385 744835 740614 803456 382254 47284 448666 490267 504060 530523 510822 756493 521200 483310 379619 396928 820715 462921 605313 765168 445240 464817 129955 136203 382242 424870 814639 817182 819552 827954 460407 487982 489246 466327 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.70%) |
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 6806 12845 47284 107348 129955 136203 379619 381873 382242 382254 383932 389451 391044 396928 424870 430560 430564 445240 448666 460407 462921 464817 466327 474413 482246 483310 487982 489246 490267 495206 500450 504060 506238 507793 510822 520230 521200 521213 521567 521693 524401 530431 530523 530570 532057 532632 532718 532722 533183 533692 538035 538931 542396 543052 543094 543211 543250 543566 543666 543738 544341 546218 547861 548089 548513 549262 549269 550561 552056 557435 560089 566711 569697 569699 569709 569777 569781 570902 581718 583823 585619 586126 600808 605313 607556 617782 622916 623273 630393 640494 668406 714121 716135 722465 725474 729917 729919 729943 734370 735385 740614 744835 756493 765168 778655 782762 782773 796748 796853 803456 810045 814639 817012 817082 817113 817182 819552 820715 823259 827954 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.14 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination 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.