Query Metrics
7
Database Queries
7
Different statements
175.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.46 ms (87.78%) |
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 6745 7456 27847 28568 181422 187542 187956 233608 325648 382431 382874 383117 384480 390966 392510 392971 393097 396619 397216 397666 398562 398570 404386 407444 482527 506056 530465 542193 555290 555769 555779 564298 592428 599572 610473 646290 646292 674770 675558 677972 692049 692813 693535 695380 707309 714888 715524 717085 719942 720065 721102 721890 725142 726490 727783 729247 730360 731126 731228 731482 731800 736522 739164 744193 744213 744215 744446 750135 750305 759752 759927 760738 760841 761103 766608 768195 774147 782474 784305 788557 790009 795141 797186 797367 798696 800432 801269 801398 802139 802147 802514 805813 807609 808152 810308 811474 811989 815180 815890 815910 816063 816538 816886 816991 817189 817194 817347 819053 821187 821238 821521 822045 822278 822421 822585 825571 826024 826046 826317 827259 ] |
||||||||||||||||||||||||||||||
|
12.05 ms (6.85%) |
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 797186 729247 482527 506056 727783 564298 714888 720065 801269 725142 731228 739164 759927 750305 750135 761103 766608 404386 390966 407444 798696 826024 677972 731126 744446 744213 810308 187956 325648 382431 397216 826046 826317 827259 675558 721890 805813 801398 802139 807609 808152 731800 774147 760738 717085 719942 721102 782474 788557 397666 398570 393097 382874 396619 815180 815890 822278 822585 816063 816538 816991 817347 816886 821187 821238 822421 815910 821521 822045 825571 530465 555769 555779 695380 707309 715524 646290 646292 674770 692049 693535 555290 592428 610473 599572 797367 795141 731482 744215 811989 726490 760841 768195 730360 736522 744193 759752 784305 802514 811474 233608 28568 383117 542193 398562 692813 790009 800432 802147 384480 181422 187542 392971 392510 27847 6745 7456 817189 817194 819053 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.63%) |
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 6745 7456 27847 28568 181422 187542 187956 233608 325648 382431 382874 383117 384480 390966 392510 392971 393097 396619 397216 397666 398562 398570 404386 407444 482527 506056 530465 542193 555290 555769 555779 564298 592428 599572 610473 646290 646292 674770 675558 677972 692049 692813 693535 695380 707309 714888 715524 717085 719942 720065 721102 721890 725142 726490 727783 729247 730360 731126 731228 731482 731800 736522 739164 744193 744213 744215 744446 750135 750305 759752 759927 760738 760841 761103 766608 768195 774147 782474 784305 788557 790009 795141 797186 797367 798696 800432 801269 801398 802139 802147 802514 805813 807609 808152 810308 811474 811989 815180 815890 815910 816063 816538 816886 816991 817189 817194 817347 819053 821187 821238 821521 822045 822278 822421 822585 825571 826024 826046 826317 827259 ] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"зрелая мам"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"зрелая женщин мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.90%) |
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.