Query Metrics
7
Database Queries
7
Different statements
162.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.19 ms (85.41%) |
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 4282 246261 263331 382021 382781 385119 389260 390625 391890 398690 400534 402576 433622 444641 445367 456426 460407 469696 486217 489868 506238 512059 518599 521693 522343 523169 526223 530570 531299 532485 532632 533692 533979 536466 537256 537408 541565 541917 543703 543844 546197 546218 549304 550659 552273 560980 563853 565239 565704 566465 567319 577963 578104 578984 585341 585619 590275 590455 592589 598859 604207 605617 607556 615492 617782 624504 632794 633591 647173 650491 650509 661645 679515 686916 698256 709794 710538 716736 718107 718131 720130 723086 727458 729917 730743 734370 739632 743783 746567 749322 750860 755076 759178 769021 769483 784894 787573 788296 790185 794969 795885 796743 796748 796786 796921 803149 807883 809797 811747 817105 817153 825280 825916 826219 826409 826809 826862 827064 827191 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (9.10%) |
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 541565 585341 650491 445367 486217 523169 489868 632794 605617 385119 246261 826409 565239 578984 563853 566465 769483 750860 456426 796748 512059 624504 263331 4282 825280 826219 827064 827191 817153 826809 531299 543703 567319 549304 710538 679515 592589 590455 811747 787573 730743 739632 755076 759178 795885 803149 807883 809797 533692 577963 788296 796786 650509 526223 552273 522343 530570 729917 727458 391890 543844 444641 825916 826023 826862 817105 532485 537256 506238 532632 533979 521693 537408 560980 541917 550659 546197 578104 686916 716736 709794 720130 723086 647173 718107 718131 546218 590275 615492 585619 617782 604207 794969 796921 784894 749322 746567 743783 769021 607556 790185 796743 382781 382021 698256 734370 633591 469696 661645 460407 565704 536466 598859 518599 389260 390625 398690 400534 402576 433622 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.33%) |
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 4282 246261 263331 382021 382781 385119 389260 390625 391890 398690 400534 402576 433622 444641 445367 456426 460407 469696 486217 489868 506238 512059 518599 521693 522343 523169 526223 530570 531299 532485 532632 533692 533979 536466 537256 537408 541565 541917 543703 543844 546197 546218 549304 550659 552273 560980 563853 565239 565704 566465 567319 577963 578104 578984 585341 585619 590275 590455 592589 598859 604207 605617 607556 615492 617782 624504 632794 633591 647173 650491 650509 661645 679515 686916 698256 709794 710538 716736 718107 718131 720130 723086 727458 729917 730743 734370 739632 743783 746567 749322 750860 755076 759178 769021 769483 784894 787573 788296 790185 794969 795885 796743 796748 796786 796921 803149 807883 809797 811747 817105 817153 825280 825916 826219 826409 826809 826862 827064 827191 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"доминирован жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"доминирован жен"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"humiliation wife"
]
|
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.