Query Metrics
7
Database Queries
7
Different statements
153.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.07 ms (79.35%) |
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 72730 122488 122817 236472 351650 366284 382085 383697 402254 402518 411047 411697 415540 417391 418877 423375 426675 430407 451578 453514 453595 454279 458595 460726 462155 462539 464738 467628 468006 470003 470563 470590 474247 474494 476259 476261 478461 480387 481358 484547 485487 485960 491361 493342 499022 504446 508041 513303 522104 522838 523109 523982 533851 539139 548092 550804 552034 552159 552212 552887 556879 556884 562247 566503 566575 566637 573776 576393 584022 585089 585596 585671 590579 590839 591918 599332 600887 614611 625164 633079 633085 633097 651644 659347 662556 664087 671761 686401 692973 695661 699661 702147 704702 706480 713794 719452 722086 731285 738583 740035 744933 749799 758501 763724 776403 779144 779146 779162 781601 794500 795585 797598 799813 804158 809125 810692 814765 822412 822768 823648 ] |
||||||||||||||||||||||||||||||
|
21.94 ms (14.26%) |
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 522104 556879 411047 476259 591918 556884 415540 462539 566575 662556 671761 633097 633079 522838 474247 470003 418877 430407 533851 573776 590839 460726 467628 468006 633085 548092 411697 552887 451578 426675 523982 484547 462155 417391 481358 763724 499022 590579 625164 562247 566637 576393 480387 72730 523109 566503 474494 470590 476261 584022 823648 122817 423375 692973 614611 699661 504446 122488 794500 749799 659347 513303 366284 585671 740035 458595 795585 382085 695661 550804 804158 402518 799813 822412 719452 822768 706480 704702 454279 779162 781601 731285 797598 236472 351650 402254 585089 722086 539139 464738 552159 585596 779144 738583 508041 383697 758501 485487 470563 809125 744933 810692 493342 552212 776403 552034 702147 664087 814765 686401 713794 485960 600887 478461 599332 453514 453595 651644 779146 491361 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (2.22%) |
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 72730 122488 122817 236472 351650 366284 382085 383697 402254 402518 411047 411697 415540 417391 418877 423375 426675 430407 451578 453514 453595 454279 458595 460726 462155 462539 464738 467628 468006 470003 470563 470590 474247 474494 476259 476261 478461 480387 481358 484547 485487 485960 491361 493342 499022 504446 508041 513303 522104 522838 523109 523982 533851 539139 548092 550804 552034 552159 552212 552887 556879 556884 562247 566503 566575 566637 573776 576393 584022 585089 585596 585671 590579 590839 591918 599332 600887 614611 625164 633079 633085 633097 651644 659347 662556 664087 671761 686401 692973 695661 699661 702147 704702 706480 713794 719452 722086 731285 738583 740035 744933 749799 758501 763724 776403 779144 779146 779162 781601 794500 795585 797598 799813 804158 809125 810692 814765 822412 822768 823648 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex sauna"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс бан"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.88%) |
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.