Query Metrics
7
Database Queries
7
Different statements
154.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.64 ms (81.55%) |
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 4199 246488 310758 382610 383287 386099 389616 390418 392002 395587 401071 404576 412733 413100 413254 420056 425008 429949 431323 434071 443719 443804 448072 449175 451086 460020 460195 467915 472163 474408 476502 479465 480701 482599 491064 493061 494044 497816 502998 504023 510280 512189 514031 516561 520034 522271 526084 528520 528816 532885 535261 541484 544980 546648 548556 550354 552899 554178 554631 567604 568851 571469 572689 576525 577780 577926 579873 580976 584305 585050 585225 587567 590518 592690 600684 601052 601813 601859 602189 602737 605561 610154 612051 612232 614856 619714 619857 620172 620820 621298 628059 639208 660807 678766 680937 685940 731158 732165 754731 756816 758261 758919 760686 780887 792528 793095 794632 798725 801471 807902 808319 808979 809998 812072 814120 814812 817247 821111 824833 826498 ] |
||||||||||||||||||||||||||||||
|
17.89 ms (11.61%) |
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 600684 401071 434071 4199 420056 514031 474408 392002 389616 826498 817247 814120 814812 568851 678766 619857 620172 798725 793095 808979 809998 754731 756816 758261 792528 812072 443804 395587 480701 541484 590518 413100 404576 482599 448072 614856 808319 528816 532885 535261 660807 552899 592690 587567 612232 794632 732165 758919 386099 425008 801471 585050 512189 476502 494044 577926 554631 567604 621298 601859 731158 612051 639208 584305 472163 502998 429949 824833 413254 246488 550354 451086 510280 383287 382610 807902 760686 443719 821111 491064 780887 390418 310758 431323 412733 546648 467915 449175 460020 493061 522271 516561 504023 497816 520034 526084 528520 460195 479465 544980 548556 554178 571469 580976 680937 685940 572689 576525 577780 579873 602189 619714 602737 585225 605561 620820 601052 601813 610154 628059 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.93%) |
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 4199 246488 310758 382610 383287 386099 389616 390418 392002 395587 401071 404576 412733 413100 413254 420056 425008 429949 431323 434071 443719 443804 448072 449175 451086 460020 460195 467915 472163 474408 476502 479465 480701 482599 491064 493061 494044 497816 502998 504023 510280 512189 514031 516561 520034 522271 526084 528520 528816 532885 535261 541484 544980 546648 548556 550354 552899 554178 554631 567604 568851 571469 572689 576525 577780 577926 579873 580976 584305 585050 585225 587567 590518 592690 600684 601052 601813 601859 602189 602737 605561 610154 612051 612232 614856 619714 619857 620172 620820 621298 628059 639208 660807 678766 680937 685940 731158 732165 754731 756816 758261 758919 760686 780887 792528 793095 794632 798725 801471 807902 808319 808979 809998 812072 814120 814812 817247 821111 824833 826498 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая трусик нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy panties"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.