Query Metrics
7
Database Queries
7
Different statements
203.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.46 ms (85.64%) |
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 397901 416039 420512 424238 424917 425079 426105 427064 427332 428166 428265 430394 432526 432538 435346 436447 437309 437876 437996 438349 438906 442402 442425 443300 445524 445551 445967 447574 448578 450442 453436 453568 453802 453845 453908 455574 457622 458713 458723 459225 459517 461337 461348 461596 462481 462994 463121 464082 466865 469452 472122 473229 473673 474782 481802 483172 484300 489630 489653 490079 490623 491573 492657 495088 499021 499757 500010 503075 504735 504751 504752 507890 507906 508309 510203 511078 516427 516438 516444 516455 518081 519661 519668 521979 523458 523473 523476 523494 523766 524789 525145 525180 526518 527079 527186 527687 528234 529134 532027 532826 536913 555971 561948 565094 567185 567194 571392 573391 577899 587171 591940 600395 601940 608620 609432 621599 662567 716980 726410 799063 ] |
||||||||||||||||||||||||||||||
|
18.71 ms (9.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 799063 427064 436447 463121 469452 490623 521979 492657 489630 518081 532027 571392 587171 609432 438349 459225 397901 450442 432526 472122 500010 527687 523476 499021 443300 447574 448578 565094 453802 473229 527079 508309 455574 504751 526518 516438 536913 466865 577899 591940 600395 726410 453436 453908 459517 504735 528234 430394 504752 474782 662567 473673 432538 426105 442402 499757 491573 453845 461337 416039 445524 462994 523766 420512 458713 507906 511078 428265 453568 516455 525180 555971 567185 716980 425079 445967 458723 523458 490079 519668 489653 510203 507890 608620 621599 438906 442425 519661 527186 484300 424238 445551 464082 462481 516444 532826 523494 523473 529134 461348 561948 573391 601940 424917 437876 435346 483172 495088 524789 503075 481802 567194 461596 437996 516427 525145 428166 437309 427332 457622 ] |
||||||||||||||||||||||||||||||
|
4.24 ms (2.08%) |
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 397901 416039 420512 424238 424917 425079 426105 427064 427332 428166 428265 430394 432526 432538 435346 436447 437309 437876 437996 438349 438906 442402 442425 443300 445524 445551 445967 447574 448578 450442 453436 453568 453802 453845 453908 455574 457622 458713 458723 459225 459517 461337 461348 461596 462481 462994 463121 464082 466865 469452 472122 473229 473673 474782 481802 483172 484300 489630 489653 490079 490623 491573 492657 495088 499021 499757 500010 503075 504735 504751 504752 507890 507906 508309 510203 511078 516427 516438 516444 516455 518081 519661 519668 521979 523458 523473 523476 523494 523766 524789 525145 525180 526518 527079 527186 527687 528234 529134 532027 532826 536913 555971 561948 565094 567185 567194 571392 573391 577899 587171 591940 600395 601940 608620 609432 621599 662567 716980 726410 799063 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brother sex sister"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"brother секс sister"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.70%) |
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.