Query Metrics
7
Database Queries
7
Different statements
197.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.51 ms (87.82%) |
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 78976 223551 401537 402551 428111 446537 449596 457586 462061 465252 473823 473854 482420 483495 485470 485854 486005 486562 492567 494215 496709 503989 505298 506428 508257 508775 509836 511018 511319 511328 512876 514057 514250 519979 521249 524036 525806 526589 528562 528603 528760 528761 529122 536745 536756 538175 540711 545154 545522 547575 550809 556868 559290 566310 569796 573367 578801 580302 580347 582163 582743 583288 584428 584438 588129 588715 590977 612846 613358 618268 624425 624462 628192 628582 630411 635719 636705 637512 669270 671462 674330 675607 678793 682850 691046 695353 703827 703828 704122 704981 704998 705008 705009 705024 705025 705031 705112 705647 705830 705853 713197 714850 716726 717387 725533 725551 733210 740153 743548 746345 759909 768656 784069 787262 788125 788437 788755 792731 808304 808309 ] |
||||||||||||||||||||||||||||||
|
14.04 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 704998 682850 691046 588129 624462 792731 808304 784069 759909 538175 569796 705853 678793 695353 703828 705112 713197 636705 788755 725533 746345 743548 78976 446537 449596 473823 511018 514057 525806 505298 514250 528603 494215 519979 521249 529122 566310 580347 547575 580302 674330 613358 637512 590977 486562 402551 482420 506428 536745 485854 550809 582163 582743 675607 717387 704981 705008 705009 705024 714850 716726 671462 705025 705647 628192 588715 612846 635719 788125 808309 740153 787262 788437 725551 733210 768656 703827 705031 705830 223551 428111 485470 473854 492567 465252 503989 512876 526589 528761 508775 511319 511328 508257 509836 528562 528760 486005 545522 559290 578801 584438 573367 584428 624425 628582 630411 618268 483495 401537 457586 496709 524036 540711 536756 462061 556868 583288 545154 669270 704122 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (1.72%) |
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 78976 223551 401537 402551 428111 446537 449596 457586 462061 465252 473823 473854 482420 483495 485470 485854 486005 486562 492567 494215 496709 503989 505298 506428 508257 508775 509836 511018 511319 511328 512876 514057 514250 519979 521249 524036 525806 526589 528562 528603 528760 528761 529122 536745 536756 538175 540711 545154 545522 547575 550809 556868 559290 566310 569796 573367 578801 580302 580347 582163 582743 583288 584428 584438 588129 588715 590977 612846 613358 618268 624425 624462 628192 628582 630411 635719 636705 637512 669270 671462 674330 675607 678793 682850 691046 695353 703827 703828 704122 704981 704998 705008 705009 705024 705025 705031 705112 705647 705830 705853 713197 714850 716726 717387 725533 725551 733210 740153 743548 746345 759909 768656 784069 787262 788125 788437 788755 792731 808304 808309 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беремен"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"беременность-"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.42 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.