Query Metrics
7
Database Queries
7
Different statements
175.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.94 ms (83.70%) |
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 446217 446614 447755 448064 448800 448868 451729 456029 456380 456689 458119 459235 460324 461893 462359 462360 462363 462367 463600 469191 470087 470138 471934 474895 475720 475945 476712 477568 477875 480414 480992 483159 485319 486659 486695 487122 487718 487864 488909 489092 489973 491611 491792 491893 493264 494703 494933 496772 497395 497962 497974 498773 499027 499207 499794 499900 500173 500530 501968 502508 503690 503812 503861 503996 504668 504740 506448 506783 507176 509498 510024 510545 510827 511269 511532 512459 513125 514818 515058 515344 515511 516022 516026 516976 519595 519685 520669 521339 522239 523105 523140 524598 525221 525273 526053 526371 526892 526961 527116 527247 527280 527591 529173 529364 529542 530610 530713 531093 532595 533901 533932 534261 535546 535717 536264 536667 537240 538624 540245 540690 ] |
||||||||||||||||||||||||||||||
|
17.83 ms (10.15%) |
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 469191 470138 471934 474895 480414 483159 485319 486695 491893 446217 447755 462363 463600 475720 476712 480992 488909 491792 446614 448064 448800 448868 451729 456029 456380 456689 458119 459235 460324 461893 462359 462360 462367 470087 475945 477568 477875 486659 487122 487718 487864 489092 489973 491611 493264 494933 497395 497962 497974 500530 501968 506448 509498 515344 516022 516026 516976 521339 525221 526371 534261 535546 536264 536667 494703 499794 500173 502508 503861 510827 514818 515511 519595 519685 520669 522239 523105 523140 526053 526892 526961 527247 529542 531093 533901 535717 540245 540690 496772 498773 499207 503690 503812 503996 504668 506783 507176 510545 512459 513125 515058 524598 525273 527116 527280 527591 529173 529364 530610 530713 532595 533932 537240 538624 499027 499900 504740 510024 511269 511532 ] |
||||||||||||||||||||||||||||||
|
4.03 ms (2.30%) |
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 446217 446614 447755 448064 448800 448868 451729 456029 456380 456689 458119 459235 460324 461893 462359 462360 462363 462367 463600 469191 470087 470138 471934 474895 475720 475945 476712 477568 477875 480414 480992 483159 485319 486659 486695 487122 487718 487864 488909 489092 489973 491611 491792 491893 493264 494703 494933 496772 497395 497962 497974 498773 499027 499207 499794 499900 500173 500530 501968 502508 503690 503812 503861 503996 504668 504740 506448 506783 507176 509498 510024 510545 510827 511269 511532 512459 513125 514818 515058 515344 515511 516022 516026 516976 519595 519685 520669 521339 522239 523105 523140 524598 525221 525273 526053 526371 526892 526961 527116 527247 527280 527591 529173 529364 529542 530610 530713 531093 532595 533901 533932 534261 535546 535717 536264 536667 537240 538624 540245 540690 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white submissive"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white доминирован"
]
|
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.