Query Metrics
7
Database Queries
7
Different statements
147.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.42 ms (83.23%) |
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 61051 386156 396326 398132 399036 402067 403896 412753 414048 416138 418053 418844 419910 423464 423703 424839 427449 428728 429608 436074 443523 443554 443582 445842 446480 446882 454741 456640 459316 460474 460488 465548 469114 478030 478955 483737 497382 497420 497448 497454 497459 497467 498988 499931 500271 511256 511270 511271 514248 518011 518929 522188 522190 522198 523373 529810 530277 535072 535151 542029 545508 564223 568613 576858 582303 585390 585967 592323 594441 594497 600539 600553 600627 601200 604134 616578 618753 621073 622367 628909 630736 635061 643671 645677 650495 651548 651561 652121 652125 652129 658216 658223 658226 658989 687000 694197 697608 712177 719179 740534 740831 741812 748748 749268 750449 758724 758725 758731 759503 760481 767327 768164 770747 785571 791525 796397 800303 807190 810040 828324 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (10.03%) |
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 635061 497448 412753 694197 418053 741812 719179 758731 497420 398132 650495 740831 530277 424839 564223 545508 460474 497467 568613 628909 750449 758725 396326 658989 428728 427449 443582 446480 443523 522190 592323 807190 748748 800303 423703 594441 768164 456640 469114 542029 658216 403896 478030 419910 454741 658223 658226 630736 600539 446882 497382 61051 518929 522188 535151 645677 604134 759503 522198 500271 511256 576858 712177 652121 600627 418844 497459 687000 760481 499931 414048 511271 585967 601200 386156 416138 460488 497454 616578 810040 791525 796397 770747 429608 828324 459316 483737 478955 651561 585390 529810 622367 594497 785571 758724 445842 523373 511270 600553 402067 498988 643671 621073 740534 767327 749268 518011 652125 443554 465548 423464 514248 582303 651548 697608 652129 618753 399036 436074 535072 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (1.94%) |
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 61051 386156 396326 398132 399036 402067 403896 412753 414048 416138 418053 418844 419910 423464 423703 424839 427449 428728 429608 436074 443523 443554 443582 445842 446480 446882 454741 456640 459316 460474 460488 465548 469114 478030 478955 483737 497382 497420 497448 497454 497459 497467 498988 499931 500271 511256 511270 511271 514248 518011 518929 522188 522190 522198 523373 529810 530277 535072 535151 542029 545508 564223 568613 576858 582303 585390 585967 592323 594441 594497 600539 600553 600627 601200 604134 616578 618753 621073 622367 628909 630736 635061 643671 645677 650495 651548 651561 652121 652125 652129 658216 658223 658226 658989 687000 694197 697608 712177 719179 740534 740831 741812 748748 749268 750449 758724 758725 758731 759503 760481 767327 768164 770747 785571 791525 796397 800303 807190 810040 828324 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam asian teen"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер азиатк teen"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"вебкамер азиатк teen"
]
|
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.