Query Metrics
7
Database Queries
7
Different statements
163.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.64 ms (81.72%) |
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 382934 383785 391923 391992 398965 408694 420140 429881 432348 438543 438880 442114 443432 449014 449930 450262 452363 454282 457248 457480 458504 460208 463782 464283 468298 468678 468946 469737 473366 475296 478437 479722 485280 488820 494325 497691 497792 505326 505356 510906 510923 511856 520034 521800 526504 527122 527508 534546 534963 543061 546431 550925 555257 555300 555988 558261 559412 560403 562159 564475 566545 579559 581130 584337 594136 599354 607716 608505 609885 615283 623268 626807 628698 629602 639736 642022 648716 653069 657489 666704 669581 680788 681231 681312 700468 700975 715420 717195 719385 725742 733458 733549 740586 743241 744985 748431 748510 752643 756487 772651 781786 782094 788624 796660 797089 800330 800391 801625 804432 804435 806000 812553 813202 817185 817199 823009 824633 824733 824766 824837 ] |
||||||||||||||||||||||||||||||
|
20.09 ms (12.29%) |
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 452363 383785 432348 628698 824766 408694 527122 505326 438880 469737 505356 648716 391992 442114 382934 824733 485280 546431 653069 391923 543061 715420 804432 733549 748431 813202 756487 740586 804435 562159 564475 550925 579559 700468 657489 629602 594136 781786 812553 752643 639736 782094 801625 479722 475296 555988 642022 817199 824633 457248 681312 733458 463782 468678 460208 494325 558261 454282 560403 666704 559412 599354 607716 468298 398965 420140 468946 473366 478437 449930 457480 526504 527508 497691 700975 608505 429881 488820 817185 823009 497792 534963 555300 680788 719385 669581 681231 615283 623268 626807 788624 800391 796660 800330 772651 806000 743241 748510 725742 717195 797089 510906 510923 581130 744985 824837 449014 566545 555257 443432 511856 609885 584337 438543 521800 458504 450262 464283 534546 520034 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.84%) |
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 382934 383785 391923 391992 398965 408694 420140 429881 432348 438543 438880 442114 443432 449014 449930 450262 452363 454282 457248 457480 458504 460208 463782 464283 468298 468678 468946 469737 473366 475296 478437 479722 485280 488820 494325 497691 497792 505326 505356 510906 510923 511856 520034 521800 526504 527122 527508 534546 534963 543061 546431 550925 555257 555300 555988 558261 559412 560403 562159 564475 566545 579559 581130 584337 594136 599354 607716 608505 609885 615283 623268 626807 628698 629602 639736 642022 648716 653069 657489 666704 669581 680788 681231 681312 700468 700975 715420 717195 719385 725742 733458 733549 740586 743241 744985 748431 748510 752643 756487 772651 781786 782094 788624 796660 797089 800330 800391 801625 804432 804435 806000 812553 813202 817185 817199 823009 824633 824733 824766 824837 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation hairy dildo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац волосатая дилд"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.91%) |
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.