Query Metrics
7
Database Queries
7
Different statements
154.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.07 ms (81.83%) |
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 365885 365912 388777 391925 404395 408586 411342 422235 422453 424414 424426 427014 435398 435413 439638 439682 443184 443761 443766 443770 443787 443789 443894 449178 451521 454264 454272 454282 454542 454558 454567 454735 454861 456062 456291 457106 457108 457953 460599 460732 460751 465843 466085 466330 466884 469887 470031 470536 470835 470918 471768 472001 474674 477974 477983 479079 479114 479121 479506 482837 486355 490402 496008 498875 499510 502212 504056 504629 506051 508777 510624 513931 515258 515836 518869 519925 520916 521972 524423 526010 544971 545672 549771 556848 560130 560403 564475 570521 571348 581126 598132 598538 598552 607231 609896 615705 622829 623831 648021 670617 671701 675589 679048 719461 729821 769448 777203 788443 790809 795948 800753 800754 800906 802652 804235 805368 810409 818057 818464 819894 ] |
||||||||||||||||||||||||||||||
|
17.37 ms (11.28%) |
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 477974 818057 819894 790809 615705 408586 422453 443766 365912 456062 482837 443787 460732 460599 460751 439682 470031 443789 466085 506051 424426 449178 788443 490402 502212 466330 513931 466884 571348 570521 671701 648021 769448 454861 524423 598538 805368 510624 456291 515258 560403 581126 675589 435398 454567 477983 439638 486355 518869 679048 365885 471768 451521 411342 443761 474674 549771 472001 556848 598552 623831 729821 800906 465843 443894 479506 521972 404395 470536 470918 454735 388777 479121 545672 560130 719461 607231 622829 598132 810409 609896 443770 454272 424414 469887 504056 508777 519925 504629 498875 454542 454264 479114 454558 526010 670617 457106 457108 479079 443184 457953 470835 422235 499510 515836 520916 454282 818464 435413 427014 496008 564475 544971 777203 795948 800753 800754 802652 804235 391925 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (2.06%) |
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 365885 365912 388777 391925 404395 408586 411342 422235 422453 424414 424426 427014 435398 435413 439638 439682 443184 443761 443766 443770 443787 443789 443894 449178 451521 454264 454272 454282 454542 454558 454567 454735 454861 456062 456291 457106 457108 457953 460599 460732 460751 465843 466085 466330 466884 469887 470031 470536 470835 470918 471768 472001 474674 477974 477983 479079 479114 479121 479506 482837 486355 490402 496008 498875 499510 502212 504056 504629 506051 508777 510624 513931 515258 515836 518869 519925 520916 521972 524423 526010 544971 545672 549771 556848 560130 560403 564475 570521 571348 581126 598132 598538 598552 607231 609896 615705 622829 623831 648021 670617 671701 675589 679048 719461 729821 769448 777203 788443 790809 795948 800753 800754 800906 802652 804235 805368 810409 818057 818464 819894 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian hairy fuck"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск волосатая секс"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.08%) |
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.