Query Metrics
7
Database Queries
7
Different statements
156.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.44 ms (80.99%) |
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 391676 424254 432472 433039 437848 440815 443179 443375 446684 446937 447949 450587 453505 454499 455621 455631 456629 458311 458470 458806 460784 462289 462316 464031 466135 466405 469171 469888 475568 477619 478310 479975 480743 481245 482061 483187 484100 486293 487605 490399 494614 495182 499423 500197 500207 500342 500441 501007 502172 503389 505236 506693 508820 508941 509630 512734 513523 513732 514657 515280 515714 516156 516178 517079 517579 518297 521192 522234 522249 522526 523023 523520 524376 525169 526300 543592 546762 546994 555604 555963 555967 555983 555990 555993 555995 556001 556004 557563 559071 560791 562168 563075 563175 564204 567063 567361 570954 571526 573388 589129 590597 599152 599510 602834 609841 620217 625246 657774 658797 661409 688146 696430 735091 742046 744912 771395 778941 781683 795612 796831 ] |
||||||||||||||||||||||||||||||
|
19.19 ms (12.29%) |
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 453505 464031 432472 455621 469171 477619 479975 466405 475568 500197 490399 514657 515714 522234 494614 502172 483187 486293 515280 458806 546994 562168 661409 437848 688146 625246 735091 469888 462316 454499 556004 462289 480743 513523 506693 522249 505236 555967 555983 543592 443179 458470 424254 446684 447949 455631 466135 503389 499423 500342 512734 513732 487605 657774 523023 563175 573388 571526 440815 501007 795612 781683 742046 391676 481245 500207 526300 478310 555990 567361 546762 555993 559071 564204 555604 555995 563075 567063 570954 658797 696430 555963 557563 560791 609841 620217 599152 589129 590597 599510 602834 796831 778941 744912 771395 443375 458311 446937 456629 460784 433039 482061 450587 516178 518297 523520 508820 516156 524376 484100 508941 509630 500441 517079 517579 522526 525169 556001 495182 521192 ] |
||||||||||||||||||||||||||||||
|
3.20 ms (2.05%) |
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 391676 424254 432472 433039 437848 440815 443179 443375 446684 446937 447949 450587 453505 454499 455621 455631 456629 458311 458470 458806 460784 462289 462316 464031 466135 466405 469171 469888 475568 477619 478310 479975 480743 481245 482061 483187 484100 486293 487605 490399 494614 495182 499423 500197 500207 500342 500441 501007 502172 503389 505236 506693 508820 508941 509630 512734 513523 513732 514657 515280 515714 516156 516178 517079 517579 518297 521192 522234 522249 522526 523023 523520 524376 525169 526300 543592 546762 546994 555604 555963 555967 555983 555990 555993 555995 556001 556004 557563 559071 560791 562168 563075 563175 564204 567063 567361 570954 571526 573388 589129 590597 599152 599510 602834 609841 620217 625246 657774 658797 661409 688146 696430 735091 742046 744912 771395 778941 781683 795612 796831 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian sexy wife"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск sexy жен"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск sexy жен"
]
|
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.