Query Metrics
7
Database Queries
7
Different statements
261.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
233.74 ms (89.53%) |
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 130060 383439 385348 387973 388785 390717 395375 396577 396744 396747 405177 406030 407454 408443 413567 413584 414103 415128 415224 416523 416668 419130 420615 421077 423592 424366 424397 441417 443232 445323 445530 449679 451261 452068 452463 452800 454081 454585 456208 459561 463001 463853 463938 464171 464210 466878 467968 468610 469536 470470 474752 475724 479860 480510 481253 482761 484553 485175 487191 495228 500623 501048 501474 510478 511721 514254 515588 518548 519481 521431 524526 530497 530636 530765 531107 531403 532854 533477 536542 540575 541859 544439 555124 555817 564716 583593 590079 598675 599894 599916 600269 614968 615933 622391 625685 633767 639782 642060 647935 651136 666968 677142 690323 699682 699718 721106 721992 730461 759344 782653 788800 795396 805439 809782 813540 814270 815559 818387 821043 821409 ] |
||||||||||||||||||||||||||||||
|
17.73 ms (6.79%) |
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 759344 615933 388785 420615 463938 479860 396744 456208 524526 495228 511721 500623 519481 424397 642060 459561 466878 464171 485175 533477 555817 647935 598675 805439 730461 625685 518548 501048 487191 395375 443232 555124 451261 463001 590079 622391 454585 413584 452463 677142 415128 424366 484553 445530 521431 530765 532854 540575 475724 541859 651136 666968 614968 445323 464210 454081 469536 531107 564716 501474 390717 414103 814270 818387 821409 815559 821043 449679 468610 474752 514254 531403 544439 721106 721992 699718 600269 639782 782653 809782 788800 795396 413567 385348 467968 421077 387973 408443 416523 416668 813540 130060 383439 405177 406030 407454 423592 441417 452800 463853 452068 482761 470470 530497 536542 530636 510478 515588 690323 583593 599894 633767 599916 699682 415224 419130 480510 481253 396577 396747 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.11%) |
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 130060 383439 385348 387973 388785 390717 395375 396577 396744 396747 405177 406030 407454 408443 413567 413584 414103 415128 415224 416523 416668 419130 420615 421077 423592 424366 424397 441417 443232 445323 445530 449679 451261 452068 452463 452800 454081 454585 456208 459561 463001 463853 463938 464171 464210 466878 467968 468610 469536 470470 474752 475724 479860 480510 481253 482761 484553 485175 487191 495228 500623 501048 501474 510478 511721 514254 515588 518548 519481 521431 524526 530497 530636 530765 531107 531403 532854 533477 536542 540575 541859 544439 555124 555817 564716 583593 590079 598675 599894 599916 600269 614968 615933 622391 625685 633767 639782 642060 647935 651136 666968 677142 690323 699682 699718 721106 721992 730461 759344 782653 788800 795396 805439 809782 813540 814270 815559 818387 821043 821409 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal huge cock"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.64%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.64%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал огромные cock"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал огромные cock"
]
|
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.