Query Metrics
7
Database Queries
7
Different statements
225.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
198.61 ms (88.08%) |
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 203645 323041 326017 357595 358466 365893 382434 386378 387010 388543 389223 389895 390807 390830 391576 391588 392563 397899 400816 400844 401003 403321 411409 411794 411945 422349 439522 439591 440898 440999 443124 443658 443732 443766 449692 451470 451504 451877 454175 454274 460743 462324 462605 465075 465333 465429 465828 465957 466102 466217 466231 466271 467488 467523 468393 468916 469164 470196 470198 472905 473960 474652 476786 478385 478387 479134 480814 484665 484705 485817 487342 488964 490126 490404 493304 494516 504057 506705 512416 513537 515915 518160 518822 520660 520872 539951 542215 545899 546928 550233 555118 555134 559796 563058 563180 563227 563413 567056 573801 604018 610048 614479 619528 623462 623936 705466 705630 720511 751640 754227 761022 781741 782230 782250 788450 792136 794830 797151 805005 ] |
||||||||||||||||||||||||||||||
|
17.45 ms (7.74%) |
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 468916 389895 473960 520660 610048 326017 443732 449692 488964 400816 542215 705466 623936 792136 797151 805005 740583 751640 705630 788450 490126 462605 476786 465429 422349 468393 513537 518822 323041 546928 563180 203645 390830 451470 520872 504057 411794 451877 439522 382434 469164 720511 782230 782250 391588 563227 391576 403321 466102 479134 411409 392563 467488 539951 573801 604018 451504 454274 474652 470196 465075 466217 484705 490404 494516 563413 466231 472905 358466 389223 555134 465957 462324 555118 623462 460743 467523 487342 563058 794830 754227 781741 761022 478387 480814 390807 439591 443658 465333 512416 614479 388543 485817 545899 397899 440898 443766 365893 387010 478385 515915 550233 440999 401003 619528 559796 357595 470198 466271 484665 454175 411945 518160 567056 493304 506705 443124 386378 400844 465828 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.58%) |
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 203645 323041 326017 357595 358466 365893 382434 386378 387010 388543 389223 389895 390807 390830 391576 391588 392563 397899 400816 400844 401003 403321 411409 411794 411945 422349 439522 439591 440898 440999 443124 443658 443732 443766 449692 451470 451504 451877 454175 454274 460743 462324 462605 465075 465333 465429 465828 465957 466102 466217 466231 466271 467488 467523 468393 468916 469164 470196 470198 472905 473960 474652 476786 478385 478387 479134 480814 484665 484705 485817 487342 488964 490126 490404 493304 494516 504057 506705 512416 513537 515915 518160 518822 520660 520872 539951 542215 545899 546928 550233 555118 555134 559796 563058 563180 563227 563413 567056 573801 604018 610048 614479 619528 623462 623936 705466 705630 720511 751640 754227 761022 781741 782230 782250 788450 792136 794830 797151 805005 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian stockings mature"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск чулк нижн бел mature"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск чулк нижн бел mature"
]
|
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.