Query Metrics
7
Database Queries
7
Different statements
376.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.18 ms (54.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny mature ass"
]
|
||||||||||||||||||||||||||||||
|
147.08 ms (39.05%) |
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 405145 412081 413819 418124 418139 424001 434309 434338 434367 434624 442629 446624 449562 449886 467908 481939 486199 487729 495126 497537 497866 498290 498830 499889 502866 505504 511825 515499 515724 515931 516047 517008 520793 522604 523423 530010 531920 532172 532645 532666 534215 536542 536584 536649 536695 541216 541728 542189 545819 547474 547488 547958 549223 549977 554462 554472 556014 557124 559161 559201 561040 561415 562190 562830 564563 565160 565526 566686 567421 568546 569099 569129 569168 569258 569533 572031 573105 580950 581618 581997 583996 586433 586805 587578 590872 591067 592492 592675 595835 598169 598309 600017 600275 600280 600302 600344 600365 602747 603686 606587 606608 607293 620243 622382 624226 645920 660416 664960 668176 669007 669074 695870 700284 717550 729829 736920 780690 788926 788953 814072 ] |
||||||||||||||||||||||||||||||
|
15.95 ms (4.23%) |
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 499889 497866 534215 532645 531920 536695 542189 814072 486199 581997 556014 607293 602747 412081 520793 418139 442629 467908 495126 515499 536542 498290 515931 547488 562190 562830 569129 561415 565160 566686 569099 569168 541216 547474 559201 567421 568546 573105 581618 583996 645920 669074 695870 660416 669007 717550 547958 549223 549977 561040 591067 592492 606587 587578 592675 598169 600280 606608 622382 600302 600344 603686 586433 600017 788953 788926 729829 736920 700284 780690 434309 424001 434367 413819 434338 481939 502866 516047 511825 434624 418124 446624 449562 449886 530010 515724 523423 498830 532172 536649 554462 559161 565526 554472 569533 580950 545819 557124 664960 668176 569258 572031 586805 598309 600275 600365 405145 497537 487729 522604 541728 505504 564563 595835 624226 532666 536584 590872 620243 517008 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.74%) |
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 405145 412081 413819 418124 418139 424001 434309 434338 434367 434624 442629 446624 449562 449886 467908 481939 486199 487729 495126 497537 497866 498290 498830 499889 502866 505504 511825 515499 515724 515931 516047 517008 520793 522604 523423 530010 531920 532172 532645 532666 534215 536542 536584 536649 536695 541216 541728 542189 545819 547474 547488 547958 549223 549977 554462 554472 556014 557124 559161 559201 561040 561415 562190 562830 564563 565160 565526 566686 567421 568546 569099 569129 569168 569258 569533 572031 573105 580950 581618 581997 583996 586433 586805 587578 590872 591067 592492 592675 595835 598169 598309 600017 600275 600280 600302 600344 600365 602747 603686 606587 606608 607293 620243 622382 624226 645920 660416 664960 668176 669007 669074 695870 700284 717550 729829 736920 780690 788926 788953 814072 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые mature жоп"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.45%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.