Query Metrics
7
Database Queries
7
Different statements
159.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.24 ms (83.31%) |
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 416039 420191 421043 424238 424917 425079 426919 427064 427327 427332 428166 430324 432510 435346 436447 437309 437613 437876 437996 438906 441215 441447 442402 442425 444184 445524 445551 445967 449122 450330 450418 450442 453568 453732 453802 453845 453908 457622 458394 458713 459517 460570 461337 461348 461596 462481 462994 463623 464043 464082 464111 466865 473673 473898 476329 476333 477235 481802 483172 484300 489630 489712 492657 495088 498238 499757 503075 504735 504739 504751 504772 507890 507906 508309 509513 510203 511514 511544 511804 516427 516455 518054 519661 519664 519668 523036 523473 523479 523494 524789 525145 527066 527186 528234 529134 532826 551816 552865 554253 555971 561948 567185 567194 573391 575272 577899 581715 587171 588200 590076 590174 591676 601940 602742 608620 610828 619849 621599 716980 726410 ] |
||||||||||||||||||||||||||||||
|
16.30 ms (10.19%) |
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 519664 528234 441215 450330 504751 466865 552865 577899 587171 726410 427064 437613 473673 450442 453802 453908 476329 477235 442402 459517 460570 523479 492657 499757 508309 504735 436447 621599 608620 424238 601940 435346 444184 527186 507906 489630 437309 427332 464082 462994 481802 523036 532826 507890 523473 529134 555971 567194 567185 573391 716980 437876 445967 437996 458713 495088 503075 519668 428166 457622 445524 453568 462481 510203 516455 523494 461337 461348 561948 424917 438906 425079 442425 473898 461596 463623 516427 483172 511804 519661 524789 484300 498238 525145 610828 591676 619849 602742 445551 453845 416039 464043 476333 518054 554253 575272 588200 590076 449122 511544 527066 441447 430324 464111 450418 453732 551816 590174 420191 427327 504739 504772 511514 426919 421043 432510 458394 509513 489712 581715 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.12%) |
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 416039 420191 421043 424238 424917 425079 426919 427064 427327 427332 428166 430324 432510 435346 436447 437309 437613 437876 437996 438906 441215 441447 442402 442425 444184 445524 445551 445967 449122 450330 450418 450442 453568 453732 453802 453845 453908 457622 458394 458713 459517 460570 461337 461348 461596 462481 462994 463623 464043 464082 464111 466865 473673 473898 476329 476333 477235 481802 483172 484300 489630 489712 492657 495088 498238 499757 503075 504735 504739 504751 504772 507890 507906 508309 509513 510203 511514 511544 511804 516427 516455 518054 519661 519664 519668 523036 523473 523479 523494 524789 525145 527066 527186 528234 529134 532826 551816 552865 554253 555971 561948 567185 567194 573391 575272 577899 581715 587171 588200 590076 590174 591676 601940 602742 608620 610828 619849 621599 716980 726410 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur brother sister"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск brother sister"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск brother sister"
]
|
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.