Query Metrics
7
Database Queries
7
Different statements
173.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.85 ms (86.15%) |
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 14365 382049 382314 383290 384803 386304 389813 394751 394760 396410 396695 396701 398029 398053 399090 401724 402869 404364 405507 411684 414101 415155 416437 421435 423790 424895 426249 430290 435703 441901 443510 443578 444473 445266 445322 448705 451161 453373 456405 461756 461830 463838 465477 466324 466499 466588 466642 472052 472553 472803 476441 477387 481806 485354 487020 493937 495917 498993 505667 508282 516686 518587 519862 520726 521046 521109 521550 521826 523114 523367 529269 532312 535427 536570 536853 538283 539105 544857 545475 547074 548568 554797 565335 575172 577312 581231 596479 597242 601668 601738 602061 603398 604601 604905 607215 620857 621675 630204 636574 648925 649137 654600 667826 674128 675120 675725 695929 706658 714556 718947 720305 730715 733307 735942 737673 746827 784976 788923 792817 811696 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (8.05%) |
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 396410 398053 398029 441901 416437 444473 414101 453373 466642 466499 451161 481806 520726 521826 532312 536570 519862 521046 529269 535427 472553 477387 493937 547074 565335 548568 554797 714556 648925 695929 718947 720305 675120 545475 575172 577312 601738 604905 636574 602061 620857 784976 811696 788923 730715 733307 746827 735942 737673 607215 792817 399090 423790 448705 384803 461830 456405 466324 14365 382314 415155 485354 487020 505667 508282 521109 521550 386304 405507 443510 667826 675725 382049 538283 516686 465477 476441 472803 495917 544857 630204 383290 394751 394760 389813 396701 396695 402869 401724 404364 421435 426249 430290 411684 424895 435703 443578 445266 445322 472052 461756 463838 466588 518587 539105 523367 498993 523114 536853 649137 654600 706658 674128 581231 596479 597242 604601 621675 603398 601668 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (1.88%) |
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 14365 382049 382314 383290 384803 386304 389813 394751 394760 396410 396695 396701 398029 398053 399090 401724 402869 404364 405507 411684 414101 415155 416437 421435 423790 424895 426249 430290 435703 441901 443510 443578 444473 445266 445322 448705 451161 453373 456405 461756 461830 463838 465477 466324 466499 466588 466642 472052 472553 472803 476441 477387 481806 485354 487020 493937 495917 498993 505667 508282 516686 518587 519862 520726 521046 521109 521550 521826 523114 523367 529269 532312 535427 536570 536853 538283 539105 544857 545475 547074 548568 554797 565335 575172 577312 581231 596479 597242 601668 601738 602061 603398 604601 604905 607215 620857 621675 630204 636574 648925 649137 654600 667826 674128 675120 675725 695929 706658 714556 718947 720305 730715 733307 735942 737673 746827 784976 788923 792817 811696 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white black порно"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white black порн"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white black порн"
]
|
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.