Query Metrics
7
Database Queries
7
Different statements
197.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.33 ms (82.32%) |
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 384582 392750 396322 401766 416277 426841 428547 432556 432871 437013 440486 440534 446086 446820 448096 453295 453300 457776 465450 467378 470652 480833 481318 482274 482518 483283 493162 493299 497197 501618 506552 510824 510988 511074 514757 515592 516997 519766 521418 524955 528088 528826 530168 531268 531945 531955 543544 544511 547409 547773 552334 552367 553359 557152 559851 562540 564113 565343 567076 576594 580022 580653 583730 588410 609210 628459 650011 673366 697354 699549 707605 716267 718779 718909 720911 726967 730547 734005 734386 737178 739060 744791 746600 747202 748213 753511 755141 756920 760240 760775 760928 761842 762670 767639 774141 774376 775605 775818 784857 787479 788783 800432 801393 801413 803740 805589 805594 806356 810061 815117 816345 817537 817579 819151 821899 825274 826302 826587 828410 828740 ] |
||||||||||||||||||||||||||||||
|
22.72 ms (11.52%) |
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 730547 801413 559851 511074 562540 734005 746600 753511 514757 760775 428547 761842 440534 510988 401766 457776 699549 565343 748213 557152 510824 544511 547773 707605 552334 803740 739060 755141 481318 467378 528826 432871 501618 531955 756920 810061 609210 543544 819151 817537 816345 583730 697354 673366 805589 805594 760240 726967 760928 720911 806356 828410 828740 437013 446086 516997 483283 446820 519766 482274 384582 826302 817579 530168 521418 482518 800432 821899 788783 734386 787479 588410 801393 774141 826587 775605 774376 396322 744791 465450 493162 440486 825274 576594 747202 718779 426841 767639 784857 531268 531945 762670 528088 552367 453295 392750 815117 453300 524955 580653 547409 564113 718909 650011 567076 737178 775818 480833 470652 416277 553359 580022 628459 432556 515592 716267 506552 497197 493299 448096 ] |
||||||||||||||||||||||||||||||
|
4.37 ms (2.22%) |
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 384582 392750 396322 401766 416277 426841 428547 432556 432871 437013 440486 440534 446086 446820 448096 453295 453300 457776 465450 467378 470652 480833 481318 482274 482518 483283 493162 493299 497197 501618 506552 510824 510988 511074 514757 515592 516997 519766 521418 524955 528088 528826 530168 531268 531945 531955 543544 544511 547409 547773 552334 552367 553359 557152 559851 562540 564113 565343 567076 576594 580022 580653 583730 588410 609210 628459 650011 673366 697354 699549 707605 716267 718779 718909 720911 726967 730547 734005 734386 737178 739060 744791 746600 747202 748213 753511 755141 756920 760240 760775 760928 761842 762670 767639 774141 774376 775605 775818 784857 787479 788783 800432 801393 801413 803740 805589 805594 806356 810061 815117 816345 817537 817579 819151 821899 825274 826302 826587 828410 828740 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"handjob mother"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк член мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.92%) |
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.