Query Metrics
7
Database Queries
7
Different statements
183.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.45 ms (85.40%) |
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 388546 395144 410267 415109 417787 418009 423424 423645 424523 428409 438615 443855 443871 446112 446364 448687 452606 456441 457789 470441 472286 476563 478065 482350 485633 489489 491391 491664 492097 492098 497921 507666 509100 511336 511749 514115 516938 524165 524992 525702 525704 528146 535028 535056 535808 538234 541588 541886 541888 542954 542971 544288 544455 553070 553273 559719 559754 559886 562269 566243 567145 571806 574538 574776 574792 575486 576082 576113 576343 576399 576412 576713 577371 579647 581350 581401 582227 582291 590469 590667 598513 599577 604868 605345 614017 619539 620674 620686 621698 622832 623818 625001 625359 625378 625696 637094 640690 645898 645918 646001 647933 653567 718798 727191 727812 733886 750064 762213 786552 810976 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (9.08%) |
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 762213 428409 645898 576343 457789 446364 576399 576412 582227 423645 576082 574776 598513 424523 423424 472286 535028 733886 446112 646001 786552 491664 525702 410267 553273 559886 718798 574792 625378 614017 810976 456441 582291 448687 562269 581350 605345 559754 750064 485633 511336 647933 452606 443871 418009 528146 637094 559719 524992 395144 492098 535056 576713 566243 511749 567145 577371 544288 514115 538234 507666 542971 417787 625696 415109 544455 492097 579647 581401 727812 482350 621698 443855 620686 478065 541886 535808 516938 470441 590469 524165 645918 623818 727191 388546 653567 542954 541888 619539 571806 497921 620674 509100 625359 622832 553070 489489 541588 576113 590667 599577 491391 476563 625001 438615 575486 525704 574538 604868 640690 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.60%) |
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 388546 395144 410267 415109 417787 418009 423424 423645 424523 428409 438615 443855 443871 446112 446364 448687 452606 456441 457789 470441 472286 476563 478065 482350 485633 489489 491391 491664 492097 492098 497921 507666 509100 511336 511749 514115 516938 524165 524992 525702 525704 528146 535028 535056 535808 538234 541588 541886 541888 542954 542971 544288 544455 553070 553273 559719 559754 559886 562269 566243 567145 571806 574538 574776 574792 575486 576082 576113 576343 576399 576412 576713 577371 579647 581350 581401 582227 582291 590469 590667 598513 599577 604868 605345 614017 619539 620674 620686 621698 622832 623818 625001 625359 625378 625696 637094 640690 645898 645918 646001 647933 653567 718798 727191 727812 733886 750064 762213 786552 810976 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"threesome porn"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро porn"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро porn"
]
|
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.