Query Metrics
7
Database Queries
7
Different statements
140.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.52 ms (83.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 91510 184943 186790 317166 326081 340613 382240 382720 382820 383903 386408 388350 388555 389891 390362 395841 395932 396540 397740 404349 404388 404413 405020 405048 405288 414139 414759 414866 415435 415451 416131 417887 419032 420050 420067 420474 420499 421147 422484 425163 428858 430264 432794 433558 434271 435874 444366 447386 449097 452538 457250 457516 460211 463209 463747 464465 466646 468015 470143 470218 471860 472698 473025 473087 475140 481506 489820 490646 494040 496008 496644 502259 503924 506092 510571 510938 515734 516435 517846 521631 521752 525345 529507 541626 545913 546618 546786 547548 564650 571594 572621 573596 581360 583852 585210 585780 593086 593107 598783 614820 614835 614836 626431 639310 646081 661034 670949 675382 690410 704280 711600 770514 800976 815813 818441 819130 819230 820738 826844 ] |
||||||||||||||||||||||||||||||
|
13.25 ms (9.45%) |
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 711600 572621 585780 614820 626431 614835 593086 704280 470143 404388 457250 444366 396540 404413 405048 452538 468015 502259 516435 515734 541626 529507 510571 546786 585210 466646 496644 670949 415435 404349 432794 395841 405020 425163 475140 460211 489820 494040 382820 389891 510938 472698 690410 421147 405288 395932 471860 490646 382720 422484 447386 473025 503924 573596 581360 564650 546618 340613 449097 433558 388350 416131 430264 463747 435874 506092 397740 417887 414139 415451 434271 470218 521752 496008 547548 583852 545913 571594 675382 646081 661034 593107 598783 599432 614836 639310 800976 770514 91510 414866 419032 420067 420499 428858 464465 481506 326081 390362 463209 420050 317166 457516 473087 414759 521631 525345 517846 386408 383903 186790 184943 382240 388555 420474 818441 819230 820738 826844 815813 819130 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.82%) |
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 91510 184943 186790 317166 326081 340613 382240 382720 382820 383903 386408 388350 388555 389891 390362 395841 395932 396540 397740 404349 404388 404413 405020 405048 405288 414139 414759 414866 415435 415451 416131 417887 419032 420050 420067 420474 420499 421147 422484 425163 428858 430264 432794 433558 434271 435874 444366 447386 449097 452538 457250 457516 460211 463209 463747 464465 466646 468015 470143 470218 471860 472698 473025 473087 475140 481506 489820 490646 494040 496008 496644 502259 503924 506092 510571 510938 515734 516435 517846 521631 521752 525345 529507 541626 545913 546618 546786 547548 564650 571594 572621 573596 581360 583852 585210 585780 593086 593107 598783 614820 614835 614836 626431 639310 646081 661034 670949 675382 690410 704280 711600 770514 800976 815813 818441 819130 819230 820738 826844 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая красивая"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.