Query Metrics
7
Database Queries
7
Different statements
153.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.99 ms (81.88%) |
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 7727 8028 20886 34391 73143 88760 311092 373998 382834 383173 384416 384445 386598 398053 398576 398924 400850 401660 403308 404020 404087 404619 404787 406867 408770 410435 413140 413171 413235 413262 413496 415430 416696 418720 418991 420225 421235 422307 424095 425441 429723 430920 430979 431735 446093 448351 455729 465989 469611 471377 475045 477190 483681 487010 495384 495980 496564 507010 508096 516718 517059 517998 518208 519027 528353 534107 536398 536702 537243 543642 545832 553362 556933 559837 564772 565227 570212 571012 571768 573486 593287 603473 603751 605814 608681 615938 621407 638326 650067 658281 692412 692774 693209 693355 697135 697322 727396 736938 737397 750004 751341 753251 753529 755416 760483 761340 768741 774299 775677 776191 777169 778681 779846 785964 786181 797867 799508 805316 822932 825522 ] |
||||||||||||||||||||||||||||||
|
17.29 ms (11.24%) |
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 373998 448351 822932 400850 564772 469611 519027 413496 422307 418720 545832 571012 559837 508096 825522 573486 416696 638326 404619 517059 621407 608681 475045 404787 455729 570212 430979 516718 658281 429723 496564 528353 615938 805316 383173 431735 483681 424095 8028 692774 311092 413140 413262 543642 768741 518208 401660 73143 693355 382834 495384 593287 786181 785964 536702 404087 410435 88760 797867 34391 418991 425441 779846 727396 753529 736938 693209 761340 776191 398924 384416 650067 692412 774299 430920 471377 413235 517998 507010 697322 777169 384445 386598 420225 536398 398576 20886 446093 565227 753251 755416 603473 775677 799508 413171 404020 534107 571768 603751 751341 553362 778681 415430 477190 487010 408770 697135 406867 495980 556933 7727 750004 760483 398053 465989 737397 403308 421235 537243 605814 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.82%) |
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 7727 8028 20886 34391 73143 88760 311092 373998 382834 383173 384416 384445 386598 398053 398576 398924 400850 401660 403308 404020 404087 404619 404787 406867 408770 410435 413140 413171 413235 413262 413496 415430 416696 418720 418991 420225 421235 422307 424095 425441 429723 430920 430979 431735 446093 448351 455729 465989 469611 471377 475045 477190 483681 487010 495384 495980 496564 507010 508096 516718 517059 517998 518208 519027 528353 534107 536398 536702 537243 543642 545832 553362 556933 559837 564772 565227 570212 571012 571768 573486 593287 603473 603751 605814 608681 615938 621407 638326 650067 658281 692412 692774 693209 693355 697135 697322 727396 736938 737397 750004 751341 753251 753529 755416 760483 761340 768741 774299 775677 776191 777169 778681 779846 785964 786181 797867 799508 805316 822932 825522 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big beautiful"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие красивая"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.17%) |
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.