Query Metrics
7
Database Queries
7
Different statements
149.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.63 ms (83.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 5565 29272 147638 197389 382382 382474 382488 384562 387213 389864 393393 395628 400619 403129 405125 411132 413244 413769 414139 414621 416333 416441 418465 419400 420062 420577 420700 421122 421355 427869 428109 430064 430508 430916 431205 432403 433671 437676 440694 443463 444653 449398 450247 451678 457254 459704 459724 462782 463205 464310 466446 469055 469548 472312 474376 474708 476156 478849 479995 484248 485800 487417 488080 489144 491514 491581 492840 499433 500715 500862 502321 506301 509188 512974 517795 517912 520417 521964 523155 523272 524755 527063 528268 537311 538905 543125 547184 558061 559838 561978 567572 570045 574700 575688 590734 593144 599317 601970 626863 633527 635203 643964 649507 673868 693209 695158 704261 716170 722913 733501 733686 736408 741770 741989 761340 775774 795674 797867 803501 806109 ] |
||||||||||||||||||||||||||||||
|
14.49 ms (9.72%) |
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 387213 521964 489144 509188 479995 382474 444653 382488 197389 405125 733501 599317 722913 419400 469548 517912 527063 491581 512974 500862 523155 414139 695158 716170 643964 593144 736408 741770 29272 420062 803501 574700 575688 741989 420577 414621 528268 472312 440694 430064 601970 5565 413244 382382 797867 492840 538905 567572 570045 649507 633527 626863 704261 403129 459724 432403 499433 517795 523272 413769 590734 795674 384562 478849 469055 524755 450247 488080 559838 806109 451678 474376 484248 462782 506301 547184 561978 673868 635203 775774 733686 421355 420700 433671 466446 487417 543125 537311 416333 411132 147638 476156 474708 558061 463205 464310 428109 459704 430508 457254 485800 400619 418465 430916 449398 500715 431205 389864 393393 395628 421122 443463 416441 427869 437676 502321 491514 520417 693209 761340 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (1.83%) |
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 5565 29272 147638 197389 382382 382474 382488 384562 387213 389864 393393 395628 400619 403129 405125 411132 413244 413769 414139 414621 416333 416441 418465 419400 420062 420577 420700 421122 421355 427869 428109 430064 430508 430916 431205 432403 433671 437676 440694 443463 444653 449398 450247 451678 457254 459704 459724 462782 463205 464310 466446 469055 469548 472312 474376 474708 476156 478849 479995 484248 485800 487417 488080 489144 491514 491581 492840 499433 500715 500862 502321 506301 509188 512974 517795 517912 520417 521964 523155 523272 524755 527063 528268 537311 538905 543125 547184 558061 559838 561978 567572 570045 574700 575688 590734 593144 599317 601970 626863 633527 635203 643964 649507 673868 693209 695158 704261 716170 722913 733501 733686 736408 741770 741989 761340 775774 795674 797867 803501 806109 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"красивая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beautiful big tits"
]
|
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.