Query Metrics
7
Database Queries
7
Different statements
162.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.15 ms (84.46%) |
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 384998 397349 399926 405178 414126 415004 420352 421043 425046 426384 427289 427363 432574 432644 432799 433047 433131 433391 433494 435225 441833 442128 442973 444815 445590 445687 446026 446501 446811 447104 447722 449180 451040 451430 454777 454913 469560 473871 475410 475752 476128 476138 477210 479018 481584 481878 482223 482227 482254 482775 484086 487344 495686 496615 503274 506009 511562 511895 514106 516509 519318 520767 520986 521723 522681 526054 527091 528690 530836 531840 532166 533014 534961 537653 550902 556830 560664 568289 575890 583238 589069 589074 597753 598513 602259 604386 620160 622335 624815 628641 631199 633175 634475 637085 647328 647901 664212 682107 698579 714003 720291 724921 761366 784257 792558 801327 802826 809506 813101 814392 814429 814798 814892 814901 815374 815473 815545 816249 821434 824049 ] |
||||||||||||||||||||||||||||||
|
15.33 ms (9.44%) |
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 602259 622335 714003 397349 415004 441833 479018 482254 446501 511895 821434 427363 473871 405178 426384 432644 442128 814798 815473 816249 815545 454913 532166 534961 475752 476138 664212 620160 637085 628641 634475 597753 631199 809506 802826 720291 813101 444815 482223 399926 568289 433131 435225 814429 445687 454777 451040 520767 522681 526054 520986 560664 598513 442973 761366 384998 432799 427289 447722 482775 451430 484086 527091 506009 511562 528690 469560 647901 589074 589069 633175 414126 421043 556830 814901 487344 519318 531840 550902 477210 433391 814892 481878 449180 446026 476128 503274 495686 496615 514106 481584 433047 447104 475410 445590 446811 420352 824049 575890 784257 698579 801327 516509 433494 432574 814392 815374 482227 530836 537653 583238 682107 647328 604386 724921 792558 425046 521723 624815 533014 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.68%) |
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 384998 397349 399926 405178 414126 415004 420352 421043 425046 426384 427289 427363 432574 432644 432799 433047 433131 433391 433494 435225 441833 442128 442973 444815 445590 445687 446026 446501 446811 447104 447722 449180 451040 451430 454777 454913 469560 473871 475410 475752 476128 476138 477210 479018 481584 481878 482223 482227 482254 482775 484086 487344 495686 496615 503274 506009 511562 511895 514106 516509 519318 520767 520986 521723 522681 526054 527091 528690 530836 531840 532166 533014 534961 537653 550902 556830 560664 568289 575890 583238 589069 589074 597753 598513 602259 604386 620160 622335 624815 628641 631199 633175 634475 637085 647328 647901 664212 682107 698579 714003 720291 724921 761366 784257 792558 801327 802826 809506 813101 814392 814429 814798 814892 814901 815374 815473 815545 816249 821434 824049 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina anal mature"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.24%) |
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:
[
"латинская анал mature"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская анал mature"
]
|
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.