Query Metrics
7
Database Queries
7
Different statements
179.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.20 ms (82.42%) |
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 67006 76645 148582 182340 188561 203927 249873 269287 287436 309480 366011 382176 382290 382347 382485 384126 385285 386765 387334 390012 391684 391701 391956 393585 393756 394198 397019 398263 407151 407173 413707 415753 416795 418697 421637 421776 422186 424182 425775 426672 426809 439749 441561 441563 445571 450776 455633 458346 461697 466336 466808 467956 471460 471571 473388 476049 477407 478324 479567 481432 484549 485281 486409 491493 496039 496293 497216 499018 500776 502031 503032 507427 509794 517764 517807 519274 520305 520428 524103 526645 528026 528505 533968 537281 538672 540132 542331 551419 552009 564621 569321 573426 573475 574642 575212 578815 579821 582334 584453 584564 585618 589611 592371 596622 597135 605918 609897 617214 622876 624501 645596 645605 649056 655320 671518 675396 685613 688403 761749 811435 ] |
||||||||||||||||||||||||||||||
|
22.10 ms (12.29%) |
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 67006 188561 384126 528505 649056 578815 416795 471460 455633 509794 520305 507427 551419 585618 589611 441563 502031 517764 573475 575212 391684 287436 390012 421637 426672 382290 466336 421776 481432 685613 573426 624501 450776 478324 445571 499018 524103 538672 622876 461697 519274 617214 439749 391701 484549 500776 569321 385285 382485 497216 203927 471571 496039 542331 675396 645596 148582 655320 473388 393585 609897 671518 426809 394198 596622 466808 486409 584564 386765 413707 415753 441561 503032 574642 579821 761749 467956 476049 526645 485281 533968 425775 391956 76645 645605 269287 582334 407173 520428 491493 605918 422186 517807 393756 418697 552009 584453 309480 382176 387334 397019 537281 540132 564621 811435 182340 424182 479567 249873 688403 592371 597135 366011 458346 528026 496293 382347 398263 407151 477407 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.62%) |
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 67006 76645 148582 182340 188561 203927 249873 269287 287436 309480 366011 382176 382290 382347 382485 384126 385285 386765 387334 390012 391684 391701 391956 393585 393756 394198 397019 398263 407151 407173 413707 415753 416795 418697 421637 421776 422186 424182 425775 426672 426809 439749 441561 441563 445571 450776 455633 458346 461697 466336 466808 467956 471460 471571 473388 476049 477407 478324 479567 481432 484549 485281 486409 491493 496039 496293 497216 499018 500776 502031 503032 507427 509794 517764 517807 519274 520305 520428 524103 526645 528026 528505 533968 537281 538672 540132 542331 551419 552009 564621 569321 573426 573475 574642 575212 578815 579821 582334 584453 584564 585618 589611 592371 596622 597135 605918 609897 617214 622876 624501 645596 645605 649056 655320 671518 675396 685613 688403 761749 811435 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð▒ÐÇÐÄð¢ðÁÐéð║Ðâ ÐÇð░ð║ð¥ð╝ ð▓ ð║ð©Ðüð║ÐÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.90%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая рак в вагин"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.