Query Metrics
7
Database Queries
7
Different statements
172.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.82 ms (82.57%) |
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 156688 195329 383638 389982 390845 391306 415858 418452 419808 431488 435642 437172 442897 443185 443661 444893 445946 450219 451799 456746 458786 460026 460194 461526 462053 462805 467252 467303 469555 472603 474959 476213 477365 477467 477470 478526 479814 479889 480852 480973 480991 481664 482121 485996 486920 489621 491909 492167 493299 500463 500531 501938 511720 511743 513408 514668 514693 515379 516270 517604 517654 519104 519851 520185 523127 524724 525248 526496 538835 540521 540530 542858 544972 556915 558657 559037 575792 584245 587759 591855 599213 602986 605553 611702 615083 617373 618579 632513 632922 636585 636904 650018 650523 655108 657920 658045 658363 658586 661300 673468 678967 686341 694632 710839 719427 720287 733108 742152 759453 764650 773287 788212 788752 789207 789382 791904 797157 802462 808656 825136 ] |
||||||||||||||||||||||||||||||
|
18.52 ms (10.71%) |
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 591855 469555 500463 519104 513408 525248 485996 584245 661300 678967 719427 481664 450219 480991 478526 435642 456746 479814 516270 443661 500531 519851 477470 514693 658363 389982 390845 391306 418452 431488 444893 443185 451799 477467 445946 472603 517604 511720 491909 650018 694632 556915 559037 632922 599213 636904 617373 618579 802462 773287 632513 467303 476213 156688 460194 461526 462053 462805 467252 477365 442897 415858 511743 520185 514668 526496 515379 523127 524724 544972 575792 602986 195329 558657 636585 474959 437172 501938 419808 482121 479889 720287 788212 383638 460026 480852 458786 486920 489621 492167 493299 517654 605553 658045 789382 764650 825136 480973 540530 538835 540521 542858 657920 658586 710839 650523 655108 673468 686341 587759 615083 611702 797157 788752 789207 791904 808656 759453 733108 742152 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.25%) |
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 156688 195329 383638 389982 390845 391306 415858 418452 419808 431488 435642 437172 442897 443185 443661 444893 445946 450219 451799 456746 458786 460026 460194 461526 462053 462805 467252 467303 469555 472603 474959 476213 477365 477467 477470 478526 479814 479889 480852 480973 480991 481664 482121 485996 486920 489621 491909 492167 493299 500463 500531 501938 511720 511743 513408 514668 514693 515379 516270 517604 517654 519104 519851 520185 523127 524724 525248 526496 538835 540521 540530 542858 544972 556915 558657 559037 575792 584245 587759 591855 599213 602986 605553 611702 615083 617373 618579 632513 632922 636585 636904 650018 650523 655108 657920 658045 658363 658586 661300 673468 678967 686341 694632 710839 719427 720287 733108 742152 759453 764650 773287 788212 788752 789207 789382 791904 797157 802462 808656 825136 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold big ass"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"куколд большая большие жоп"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.93%) |
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.