Query Metrics
7
Database Queries
7
Different statements
195.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.07 ms (84.96%) |
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 398582 402848 412136 419432 431487 434850 444230 446081 446946 449744 452366 453424 456870 457133 458269 458477 459530 460917 463012 463051 463360 463706 465315 466431 466533 469935 471985 474228 475161 477783 479252 479482 485420 486232 486908 488679 488706 490365 491071 491383 494794 495844 495897 496049 498927 499157 500766 502677 505239 507354 507366 508188 508612 509363 509545 510495 510560 511441 511999 517084 520608 522549 522564 527111 527113 533665 537274 537449 551203 552211 552235 552854 557202 565069 566473 578266 579974 583773 584781 589110 593664 594500 595114 598062 598931 603587 609838 614954 618009 619630 627507 632308 635227 644397 652805 652968 652969 654078 664459 666495 670376 679657 680422 681369 691724 707688 716675 721948 733295 738030 738050 753077 758465 761789 762329 768013 781621 797078 802540 824289 ] |
||||||||||||||||||||||||||||||
|
17.56 ms (8.98%) |
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 486232 486908 491383 499157 522549 507354 552211 654078 444230 431487 446946 457133 465315 475161 479252 466533 488679 494794 498927 520608 509363 496049 466431 477783 491071 551203 565069 557202 584781 652805 552854 566473 603587 618009 761789 762329 758465 721948 781621 802540 453424 458269 474228 479482 456870 460917 463012 469935 398582 419432 471985 446081 449744 458477 505239 508188 511999 507366 508612 488706 652968 552235 412136 527113 533665 510560 679657 680422 707688 635227 595114 627507 463051 495897 537449 666495 594500 614954 434850 402848 459530 485420 502677 527111 495844 500766 509545 517084 537274 511441 490365 583773 578266 579974 691724 652969 664459 681369 716675 598062 593664 598931 619630 632308 589110 797078 753077 733295 738050 738030 609838 644397 463360 522564 824289 463706 452366 510495 670376 768013 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (2.10%) |
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 398582 402848 412136 419432 431487 434850 444230 446081 446946 449744 452366 453424 456870 457133 458269 458477 459530 460917 463012 463051 463360 463706 465315 466431 466533 469935 471985 474228 475161 477783 479252 479482 485420 486232 486908 488679 488706 490365 491071 491383 494794 495844 495897 496049 498927 499157 500766 502677 505239 507354 507366 508188 508612 509363 509545 510495 510560 511441 511999 517084 520608 522549 522564 527111 527113 533665 537274 537449 551203 552211 552235 552854 557202 565069 566473 578266 579974 583773 584781 589110 593664 594500 595114 598062 598931 603587 609838 614954 618009 619630 627507 632308 635227 644397 652805 652968 652969 654078 664459 666495 670376 679657 680422 681369 691724 707688 716675 721948 733295 738030 738050 753077 758465 761789 762329 768013 781621 797078 802540 824289 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teens couple"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teens couple"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teens couple"
]
|
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.