Query Metrics
7
Database Queries
7
Different statements
197.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.95 ms (85.43%) |
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 383406 386771 387085 394006 397329 416185 420900 425610 431224 433963 439257 443516 448609 449572 452890 452914 453759 461739 465720 469080 473004 476054 478029 483559 493834 502384 512879 517038 517578 522082 522617 523197 523751 525405 525466 525979 527109 527516 527541 531559 531767 533922 535277 535552 539669 541797 549574 554083 560738 561276 566739 568569 568995 569646 572752 576386 577100 578137 578478 578501 580623 585842 589886 590807 590963 592167 592875 592937 594601 598493 598668 601367 601519 603528 605966 607248 612905 614095 618368 618808 619242 619612 624174 624755 625762 628053 633300 635823 636278 640975 645525 660821 662134 663715 670839 678950 682642 684492 687375 687399 695564 704698 716992 718327 723838 728771 729634 737786 739320 742307 756830 757514 790394 793292 803378 803387 812500 817382 826804 ] |
||||||||||||||||||||||||||||||
|
17.20 ms (8.70%) |
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 572752 723838 704698 628053 535552 793292 663715 645525 718327 589886 541797 695564 662134 569646 812500 803387 742307 790394 433963 416185 607248 728771 502384 525405 580623 624755 592167 598668 577100 687375 635823 386771 633300 566739 739320 756830 716992 387085 817382 687399 533922 539669 603528 826804 619242 598493 624174 619612 394006 803378 531767 729634 670839 592937 578501 476054 682642 594601 590807 449572 512879 612905 517578 660821 525466 523197 443516 469080 522617 527516 527541 493834 618808 585842 757514 535277 578137 625762 766889 453759 465720 561276 640975 420900 461739 527109 549574 554083 678950 636278 448609 452890 601519 568995 473004 431224 618368 425610 439257 452914 522082 525979 560738 605966 592875 601367 590963 737786 397329 523751 576386 614095 568569 383406 578478 684492 483559 478029 531559 517038 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.48%) |
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 383406 386771 387085 394006 397329 416185 420900 425610 431224 433963 439257 443516 448609 449572 452890 452914 453759 461739 465720 469080 473004 476054 478029 483559 493834 502384 512879 517038 517578 522082 522617 523197 523751 525405 525466 525979 527109 527516 527541 531559 531767 533922 535277 535552 539669 541797 549574 554083 560738 561276 566739 568569 568995 569646 572752 576386 577100 578137 578478 578501 580623 585842 589886 590807 590963 592167 592875 592937 594601 598493 598668 601367 601519 603528 605966 607248 612905 614095 618368 618808 619242 619612 624174 624755 625762 628053 633300 635823 636278 640975 645525 660821 662134 663715 670839 678950 682642 684492 687375 687399 695564 704698 716992 718327 723838 728771 729634 737786 739320 742307 756830 757514 790394 793292 803378 803387 812500 817382 826804 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen палец жоп"
]
|
||||||||||||||||||||||||||||||
|
2.21 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen finger ass"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen палец жоп"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.