Query Metrics
7
Database Queries
7
Different statements
157.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.12 ms (83.07%) |
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 382408 397045 420268 421020 425876 427207 430581 432909 435177 435669 436796 437323 441402 443464 444608 445642 445941 446942 448108 448375 448677 452635 453018 453165 453815 454149 459061 459508 460323 461220 466417 466474 469213 470067 471172 472338 473778 478110 479352 484819 487154 490854 490866 492273 492565 497579 497636 500766 503032 503688 504080 508224 508938 510190 514383 517868 521887 525402 529092 531143 532550 536388 537976 543749 546665 551183 552099 554485 555834 560416 561851 567334 575104 576387 580623 597167 598577 598854 602627 607315 609130 612363 615226 617959 630830 630982 633015 639040 643404 647315 662134 670534 671085 679355 687964 690859 690919 694028 695262 695929 696353 699682 706359 717314 723914 733106 747398 750213 752450 763398 763536 768961 770387 770390 770397 770410 783069 803796 810303 822061 ] |
||||||||||||||||||||||||||||||
|
16.42 ms (10.40%) |
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 695929 662134 630830 597167 639040 723914 750213 783069 770390 633015 427207 435177 454149 459508 598854 747398 763536 471172 461220 543749 671085 598577 382408 532550 425876 452635 453018 576387 561851 643404 615226 521887 537976 469213 679355 552099 473778 421020 437323 822061 453815 525402 670534 602627 752450 492565 420268 444608 445642 448677 459061 460323 487154 497636 508224 503032 554485 555834 560416 696353 695262 706359 690919 551183 617959 810303 768961 733106 770387 770410 630982 717314 466417 510190 504080 436796 514383 529092 575104 647315 546665 612363 803796 432909 445941 397045 479352 497579 517868 484819 490866 492273 567334 694028 470067 500766 430581 443464 435669 478110 446942 508938 531143 490854 580623 687964 690859 609130 607315 770397 763398 699682 448375 453165 466474 441402 448108 472338 503688 536388 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (2.13%) |
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 382408 397045 420268 421020 425876 427207 430581 432909 435177 435669 436796 437323 441402 443464 444608 445642 445941 446942 448108 448375 448677 452635 453018 453165 453815 454149 459061 459508 460323 461220 466417 466474 469213 470067 471172 472338 473778 478110 479352 484819 487154 490854 490866 492273 492565 497579 497636 500766 503032 503688 504080 508224 508938 510190 514383 517868 521887 525402 529092 531143 532550 536388 537976 543749 546665 551183 552099 554485 555834 560416 561851 567334 575104 576387 580623 597167 598577 598854 602627 607315 609130 612363 615226 617959 630830 630982 633015 639040 643404 647315 662134 670534 671085 679355 687964 690859 690919 694028 695262 695929 696353 699682 706359 717314 723914 733106 747398 750213 752450 763398 763536 768961 770387 770390 770397 770410 783069 803796 810303 822061 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 teen video"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 teen video"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 teen video"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.