Query Metrics
7
Database Queries
7
Different statements
635.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
418.72 ms (65.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск вперв"
]
|
||||||||||||||||||||||||||||||
|
179.59 ms (28.24%) |
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 427044 427166 430374 439927 441168 446543 447412 447523 447615 451497 454238 455096 455912 456179 456362 456452 461454 461456 463305 463927 467508 468910 471402 473781 475388 479190 484372 484581 485246 487325 489097 490657 495259 495937 497240 498192 498656 500870 500978 503385 505614 508870 510392 512583 513061 517945 518133 518521 522221 523322 523333 523871 524712 526524 528262 530249 533760 542218 542765 545730 545755 546465 547620 552978 553631 554577 558566 560396 560845 560858 561821 563446 576096 577966 588801 591216 593372 595498 595891 596645 597013 598067 598464 598494 598510 598524 599404 599512 601314 601906 601917 601924 601959 601976 602017 604289 605416 606011 606014 607363 608200 610695 617006 617039 619965 622423 622778 626617 634230 637002 637243 651938 652907 653238 653267 654552 655087 655615 657438 676989 ] |
||||||||||||||||||||||||||||||
|
29.82 ms (4.69%) |
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 560396 560858 479190 447412 498192 487325 576096 490657 495937 552978 558566 561821 542765 560845 554577 546465 553631 427044 471402 456179 463927 468910 430374 455096 463305 441168 447523 461454 475388 523333 517945 497240 498656 500978 510392 518133 523322 495259 524712 528262 530249 588801 637243 595498 595891 598494 655087 653267 598464 598510 622423 451497 593372 533760 503385 545730 598067 456452 454238 447615 473781 427166 508870 513061 526524 489097 505614 484581 652907 446543 500870 523871 439927 542218 676989 601959 461456 512583 485246 655615 604289 597013 455912 651938 608200 591216 637002 598524 599404 619965 617039 601976 518521 484372 547620 577966 626617 467508 522221 456362 634230 545755 654552 602017 617006 601906 653238 606014 599512 622778 563446 605416 601917 606011 601924 596645 610695 657438 601314 607363 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.46%) |
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 427044 427166 430374 439927 441168 446543 447412 447523 447615 451497 454238 455096 455912 456179 456362 456452 461454 461456 463305 463927 467508 468910 471402 473781 475388 479190 484372 484581 485246 487325 489097 490657 495259 495937 497240 498192 498656 500870 500978 503385 505614 508870 510392 512583 513061 517945 518133 518521 522221 523322 523333 523871 524712 526524 528262 530249 533760 542218 542765 545730 545755 546465 547620 552978 553631 554577 558566 560396 560845 560858 561821 563446 576096 577966 588801 591216 593372 595498 595891 596645 597013 598067 598464 598494 598510 598524 599404 599512 601314 601906 601917 601924 601959 601976 602017 604289 605416 606011 606014 607363 608200 610695 617006 617039 619965 622423 622778 626617 634230 637002 637243 651938 652907 653238 653267 654552 655087 655615 657438 676989 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русское первый раз"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.