Query Metrics
7
Database Queries
7
Different statements
158.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.20 ms (79.04%) |
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 20190 23104 23524 163006 188655 324568 327421 379377 382812 383734 383735 384038 384092 384433 384492 385448 385590 386023 386050 386323 386605 387143 388027 388771 390305 390754 390804 392739 396922 405727 406330 407566 408988 420135 428450 444218 456862 457097 457980 458327 458844 465076 465235 475450 478454 481941 497235 498620 499485 511038 512683 512955 516430 530348 535434 537932 540788 547871 549319 550617 550618 550776 551028 551949 551969 552017 552028 552053 552897 552913 552933 554343 556398 556409 556662 557815 559873 559897 560216 565990 565998 571813 574642 581972 583298 583667 583934 590966 591849 596422 600631 601081 605848 605919 618483 619487 622266 622650 623515 623608 623610 627728 639310 662069 712154 717298 727334 737105 747958 758601 770665 776554 785005 802533 808775 809163 813507 817757 828085 828866 ] |
||||||||||||||||||||||||||||||
|
22.36 ms (14.12%) |
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 383735 384038 465235 481941 549319 571813 727334 622650 828866 407566 828085 23524 386023 383734 188655 163006 390305 406330 511038 557815 623515 627728 776554 785005 388027 386050 747958 23104 458844 516430 499485 574642 583298 551028 551969 556409 556398 550776 551949 552028 552897 559873 618483 428450 498620 537932 560216 386605 384092 390804 444218 540788 478454 497235 512683 552933 552017 554343 662069 605919 596422 809163 758601 802533 717298 408988 387143 390754 817757 565990 550617 600631 590966 550618 396922 405727 456862 465076 475450 530348 583667 712154 552913 622266 623608 601081 605848 619487 639310 813507 737105 808775 770665 20190 457097 384433 382812 327421 457980 512955 552053 559897 591849 623610 547871 583934 379377 388771 392739 420135 324568 565998 458327 535434 581972 556662 386323 385448 385590 384492 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.08%) |
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 20190 23104 23524 163006 188655 324568 327421 379377 382812 383734 383735 384038 384092 384433 384492 385448 385590 386023 386050 386323 386605 387143 388027 388771 390305 390754 390804 392739 396922 405727 406330 407566 408988 420135 428450 444218 456862 457097 457980 458327 458844 465076 465235 475450 478454 481941 497235 498620 499485 511038 512683 512955 516430 530348 535434 537932 540788 547871 549319 550617 550618 550776 551028 551949 551969 552017 552028 552053 552897 552913 552933 554343 556398 556409 556662 557815 559873 559897 560216 565990 565998 571813 574642 581972 583298 583667 583934 590966 591849 596422 600631 601081 605848 605919 618483 619487 622266 622650 623515 623608 623610 627728 639310 662069 712154 717298 727334 737105 747958 758601 770665 776554 785005 802533 808775 809163 813507 817757 828085 828866 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf asian"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf азиатк"
]
|
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.