Query Metrics
7
Database Queries
7
Different statements
176.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.96 ms (82.79%) |
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 150495 239112 389893 400539 416859 416894 423978 427490 427591 434781 438533 439899 440347 440701 440992 444403 444601 446833 453422 455179 455377 456581 456954 456964 459530 461174 462022 463051 463070 463360 463379 466907 468858 472042 474041 474910 479128 482583 482774 482951 483346 489178 493528 495433 495844 496686 498763 499720 501518 502454 504171 507189 507456 509545 518479 518537 520921 521364 522963 523069 524540 524888 525544 526352 526362 529512 532384 533665 537449 537815 544021 545848 552697 553923 553931 558582 560447 564372 578126 579974 588037 588277 589110 590306 592114 593664 593840 594500 595114 595806 598227 598466 599536 604254 608037 610666 619630 622856 625294 631503 632308 635050 642525 644397 670062 679657 680422 691724 712281 720438 722996 741756 741762 742670 743564 750904 752170 753058 770606 814987 ] |
||||||||||||||||||||||||||||||
|
18.92 ms (10.73%) |
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 482774 622856 455377 498763 592114 770606 722996 389893 239112 416894 456954 518479 518537 525544 691724 598227 741756 741762 752170 750904 644397 502454 489178 456964 466907 670062 753058 608037 439899 520921 537815 590306 742670 479128 529512 400539 427490 427591 440701 444403 416859 438533 444601 440992 440347 814987 456581 463051 482583 459530 463070 482951 446833 455179 472042 493528 504171 507456 521364 532384 533665 495433 499720 507189 522963 523069 495844 501518 509545 524888 526352 496686 524540 526362 537449 461174 483346 545848 553931 558582 560447 564372 544021 578126 579974 679657 680422 720438 552697 553923 593840 588277 593664 594500 595806 599536 604254 642525 595114 619630 631503 632308 588037 589110 598466 625294 743564 610666 635050 712281 150495 462022 463360 463379 474041 474910 434781 468858 423978 453422 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.65%) |
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 150495 239112 389893 400539 416859 416894 423978 427490 427591 434781 438533 439899 440347 440701 440992 444403 444601 446833 453422 455179 455377 456581 456954 456964 459530 461174 462022 463051 463070 463360 463379 466907 468858 472042 474041 474910 479128 482583 482774 482951 483346 489178 493528 495433 495844 496686 498763 499720 501518 502454 504171 507189 507456 509545 518479 518537 520921 521364 522963 523069 524540 524888 525544 526352 526362 529512 532384 533665 537449 537815 544021 545848 552697 553923 553931 558582 560447 564372 578126 579974 588037 588277 589110 590306 592114 593664 593840 594500 595114 595806 598227 598466 599536 604254 608037 610666 619630 622856 625294 631503 632308 635050 642525 644397 670062 679657 680422 691724 712281 720438 722996 741756 741762 742670 743564 750904 752170 753058 770606 814987 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple wife"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple жен"
]
|
||||||||||||||||||||||||||||||
|
2.10 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple жен"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.11%) |
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.