Query Metrics
7
Database Queries
7
Different statements
174.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.46 ms (86.42%) |
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 28386 365348 384945 387441 400469 401589 402928 412518 412537 412866 413254 413289 414220 418493 421138 426177 429161 432327 434838 443197 444098 445764 446656 447390 447496 447609 448077 449291 457653 460853 467324 468209 470784 470839 473019 475509 479281 485017 486889 488060 491581 494645 494815 494822 498875 499177 500943 501567 501784 503293 512297 512647 515556 518152 521869 528018 528182 550716 560630 562236 564461 571585 576039 576102 576276 576290 586928 593237 595419 604064 617096 620775 628055 631299 648754 652262 668397 674240 679347 679355 679385 685676 696465 709306 710246 712882 717887 722854 726449 736056 737386 742456 744540 747257 747487 754529 756047 767560 773349 774299 775995 779124 779360 779532 780369 780445 784069 786859 790240 791789 800976 801901 803079 803677 820150 825803 825942 826103 827960 ] |
||||||||||||||||||||||||||||||
|
14.61 ms (8.39%) |
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 426177 562236 800976 803677 413254 449291 470784 468209 825942 744540 28386 825803 503293 652262 668397 747487 726449 402928 518152 576290 564461 571585 576276 710246 679385 560630 586928 595419 421138 447609 434838 445764 457653 475509 443197 479281 512647 501567 512297 498875 500943 696465 780445 412866 401589 413289 447390 470839 827960 742456 773349 737386 767560 780369 791789 779360 648754 628055 784069 786859 754529 679347 384945 604064 779124 790240 774299 617096 709306 779532 387441 593237 801901 736056 775995 494815 712882 827931 826103 722854 685676 747257 756047 803079 631299 365348 460853 446656 550716 576039 674240 679355 717887 576102 620775 447496 429161 467324 412518 432327 400469 414220 418493 444098 448077 473019 528182 486889 494645 501784 491581 515556 485017 488060 494822 499177 521869 528018 412537 820150 ] |
||||||||||||||||||||||||||||||
|
2.33 ms (1.34%) |
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 28386 365348 384945 387441 400469 401589 402928 412518 412537 412866 413254 413289 414220 418493 421138 426177 429161 432327 434838 443197 444098 445764 446656 447390 447496 447609 448077 449291 457653 460853 467324 468209 470784 470839 473019 475509 479281 485017 486889 488060 491581 494645 494815 494822 498875 499177 500943 501567 501784 503293 512297 512647 515556 518152 521869 528018 528182 550716 560630 562236 564461 571585 576039 576102 576276 576290 586928 593237 595419 604064 617096 620775 628055 631299 648754 652262 668397 674240 679347 679355 679385 685676 696465 709306 710246 712882 717887 722854 726449 736056 737386 742456 744540 747257 747487 754529 756047 767560 773349 774299 775995 779124 779360 779532 780369 780445 784069 786859 790240 791789 800976 801901 803079 803677 820150 825803 825942 826103 827960 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful pussy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая pussy"
]
|
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.