Query Metrics
7
Database Queries
7
Different statements
368.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.57 ms (56.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
136.00 ms (36.92%) |
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 381869 388847 419847 419860 419896 421249 423968 424527 426413 433697 435400 440968 441566 441822 442280 443224 444807 446143 448043 452178 453788 455096 456364 459520 460976 460980 463756 464121 464817 465476 465602 465731 466105 476180 477069 477149 477413 479681 480053 481259 487850 489863 490684 491442 491611 493352 494917 500083 500375 500489 501937 505888 508856 510368 510557 512586 512860 512867 513869 513978 513979 515371 518608 522367 523634 524712 526728 527215 529496 529548 530328 535076 543844 545214 546800 548568 555264 560871 568477 576008 585954 589081 597113 599472 605198 612765 615016 620210 623135 624159 624788 626096 628724 637589 639803 640321 667772 669584 683012 698008 709804 719046 719537 722464 729904 732806 747137 753696 755960 764020 781714 782154 789407 790047 793080 797724 798775 802345 803472 812988 ] |
||||||||||||||||||||||||||||||
|
13.80 ms (3.75%) |
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 669584 719537 667772 683012 709804 719046 722464 560871 585954 612765 615016 624159 639803 640321 605198 626096 812988 781714 793080 729904 782154 789407 797724 732806 753696 764020 790047 802345 481259 433697 491611 597113 463756 510557 535076 500489 529548 576008 546800 455096 505888 512867 518608 508856 524712 419860 515371 500375 513869 527215 419896 448043 446143 548568 568477 452178 543844 513978 444807 442280 424527 453788 513979 620210 624788 755960 493352 494917 441822 443224 456364 477413 500083 510368 522367 465602 476180 479681 637589 747137 423968 466105 464817 501937 529496 489863 491442 381869 623135 426413 441566 465476 460980 460976 512586 512860 530328 480053 628724 599472 589081 698008 798775 803472 465731 435400 459520 487850 526728 388847 421249 419847 477069 555264 545214 440968 477149 464121 490684 523634 ] |
||||||||||||||||||||||||||||||
|
3.33 ms (0.90%) |
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 381869 388847 419847 419860 419896 421249 423968 424527 426413 433697 435400 440968 441566 441822 442280 443224 444807 446143 448043 452178 453788 455096 456364 459520 460976 460980 463756 464121 464817 465476 465602 465731 466105 476180 477069 477149 477413 479681 480053 481259 487850 489863 490684 491442 491611 493352 494917 500083 500375 500489 501937 505888 508856 510368 510557 512586 512860 512867 513869 513978 513979 515371 518608 522367 523634 524712 526728 527215 529496 529548 530328 535076 543844 545214 546800 548568 555264 560871 568477 576008 585954 589081 597113 599472 605198 612765 615016 620210 623135 624159 624788 626096 628724 637589 639803 640321 667772 669584 683012 698008 709804 719046 719537 722464 729904 732806 747137 753696 755960 764020 781714 782154 789407 790047 793080 797724 798775 802345 803472 812988 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass bondage"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
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.