Query Metrics
7
Database Queries
7
Different statements
192.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.70 ms (84.96%) |
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 109176 387047 389596 392021 392025 415354 416022 417396 419584 424165 427338 431090 435962 436080 438973 439264 439268 439300 439365 444536 445212 447734 448013 448571 448582 448588 448609 452262 452899 453394 454133 454808 455570 455940 458772 459203 460056 460291 461860 461956 461957 462231 462536 465754 466645 466868 467064 469101 469661 469845 470410 471331 471693 475597 475641 476434 476837 477140 477146 478519 479665 481340 489376 489848 490397 490619 491104 494486 494547 499513 506119 508995 509019 509304 510561 513472 513938 517315 522270 524031 528143 535332 541122 542926 547890 549804 552094 553004 554215 554488 556590 558179 560409 562384 564486 564742 566907 582576 661062 662842 666436 667033 673838 674220 677907 679051 700671 703574 703969 704063 716551 778731 780547 783043 784704 800736 803880 814355 824668 825514 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (8.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 700671 716551 778731 780547 783043 784704 800736 803880 389596 392025 392021 415354 499513 417396 387047 476837 489376 560409 558179 564486 547890 479665 517315 528143 513472 506119 431090 489848 447734 466868 494547 469845 542926 549804 552094 554488 562384 666436 582576 109176 448588 448609 452899 467064 469101 469661 475641 476434 481340 416022 419584 427338 435962 439268 452262 459203 460291 462231 462536 465754 471331 424165 439264 439365 455570 455940 458772 466645 436080 445212 448013 448582 454808 461860 461957 470410 471693 477146 478519 438973 439300 448571 454133 461956 475597 513938 524031 509019 508995 509304 522270 490397 490619 491104 494486 510561 444536 453394 814355 825514 824668 460056 535332 477140 554215 556590 564742 566907 541122 553004 667033 674220 677907 679051 703574 703969 704063 661062 662842 673838 ] |
||||||||||||||||||||||||||||||
|
4.86 ms (2.52%) |
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 109176 387047 389596 392021 392025 415354 416022 417396 419584 424165 427338 431090 435962 436080 438973 439264 439268 439300 439365 444536 445212 447734 448013 448571 448582 448588 448609 452262 452899 453394 454133 454808 455570 455940 458772 459203 460056 460291 461860 461956 461957 462231 462536 465754 466645 466868 467064 469101 469661 469845 470410 471331 471693 475597 475641 476434 476837 477140 477146 478519 479665 481340 489376 489848 490397 490619 491104 494486 494547 499513 506119 508995 509019 509304 510561 513472 513938 517315 522270 524031 528143 535332 541122 542926 547890 549804 552094 553004 554215 554488 556590 558179 560409 562384 564486 564742 566907 582576 661062 662842 666436 667033 673838 674220 677907 679051 700671 703574 703969 704063 716551 778731 780547 783043 784704 800736 803880 814355 824668 825514 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"rus solo toys"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск соло toys"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск соло toys"
]
|
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.