Query Metrics
7
Database Queries
7
Different statements
374.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.42 ms (55.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian cumshot amateur"
]
|
||||||||||||||||||||||||||||||
|
141.24 ms (37.67%) |
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 388962 389612 410884 412579 423887 424092 424128 424539 425341 426843 432479 432496 432497 434936 435541 436203 436833 436948 437120 437152 437449 438020 438091 439608 440537 442558 442995 443007 445756 448471 449171 453937 454275 455558 456646 457339 457574 457590 458474 459747 462180 463446 464526 466381 466551 467798 467914 473673 475129 478268 478330 481279 481465 481727 484250 486374 489122 489812 492054 496374 496499 496871 498363 499395 500151 501538 503338 503482 506190 508811 509332 509747 512236 513885 514118 516489 517572 519237 522216 522990 524684 525377 529495 539243 544062 546879 557657 565021 567587 569296 574097 574408 608357 610731 623238 637444 666427 677861 686583 706567 714335 736151 736979 742414 749909 756251 761517 764017 764675 777223 780215 784776 785299 791610 799239 803444 803589 804817 805259 808896 ] |
||||||||||||||||||||||||||||||
|
17.42 ms (4.65%) |
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 442558 473673 448471 449171 457339 481465 437449 438020 443007 466551 456646 459747 463446 478268 466381 516489 522990 492054 506190 519237 803444 481727 539243 503482 574097 574408 608357 610731 777223 785299 804817 742414 791610 756251 764017 764675 736151 736979 749909 803589 432497 436203 424539 467798 478330 410884 435541 436948 438091 453937 434936 462180 508811 512236 522216 484250 500151 389612 445756 432479 686583 388962 425341 424092 467914 457590 426843 440537 514118 525377 489122 501538 503338 529495 677861 706567 666427 637444 432496 464526 509747 412579 498363 455558 475129 481279 458474 424128 457574 489812 496499 524684 496871 499395 513885 517572 496374 509332 437152 486374 544062 565021 557657 714335 546879 567587 569296 623238 784776 799239 805259 761517 780215 808896 423887 436833 437120 454275 442995 439608 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (0.82%) |
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 388962 389612 410884 412579 423887 424092 424128 424539 425341 426843 432479 432496 432497 434936 435541 436203 436833 436948 437120 437152 437449 438020 438091 439608 440537 442558 442995 443007 445756 448471 449171 453937 454275 455558 456646 457339 457574 457590 458474 459747 462180 463446 464526 466381 466551 467798 467914 473673 475129 478268 478330 481279 481465 481727 484250 486374 489122 489812 492054 496374 496499 496871 498363 499395 500151 501538 503338 503482 506190 508811 509332 509747 512236 513885 514118 516489 517572 519237 522216 522990 524684 525377 529495 539243 544062 546879 557657 565021 567587 569296 574097 574408 608357 610731 623238 637444 666427 677861 686583 706567 714335 736151 736979 742414 749909 756251 761517 764017 764675 777223 780215 784776 785299 791610 799239 803444 803589 804817 805259 808896 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск cumshot любительск"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск cumshot любительск"
]
|
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.