Query Metrics
7
Database Queries
7
Different statements
143.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.87 ms (82.59%) |
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 447903 459002 466557 467839 468893 475931 480079 486162 488154 495361 497834 498405 500633 502887 503353 504825 509005 513837 514661 518223 518577 518875 518877 519845 521103 521828 522918 522987 523564 523734 524037 526733 528960 529565 530473 534594 534630 535979 538478 538913 542294 542520 543494 549170 551131 556922 558956 558990 559566 560168 563042 563534 565739 567758 569025 569085 569087 569131 569526 572970 573740 573911 574414 575708 577535 577778 580254 581698 583644 583979 584528 584716 585003 586426 588154 588276 588300 589074 589087 589425 590501 590813 594151 594406 597430 598919 599040 605486 605703 605826 606564 607369 609540 609723 609926 612933 613007 614495 616760 617139 617857 618534 619782 620072 620162 620266 620943 621140 621305 621566 624320 626127 628681 629688 643668 670329 672804 673667 676209 688991 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (10.97%) |
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 629688 643668 586426 609723 588300 624320 628681 607369 612933 447903 459002 468893 498405 522918 528960 534630 500633 519845 523564 535979 509005 522987 560168 575708 551131 569025 563534 565739 569085 584528 673667 676209 688991 556922 574414 583644 583979 589087 605486 619782 626127 589425 599040 606564 620072 620162 588154 597430 620943 605826 614495 488154 538913 572970 617857 594151 577778 518577 534594 558956 573911 590501 588276 466557 616760 521103 495361 523734 617139 480079 529565 521828 503353 486162 542294 577535 569131 558990 569526 670329 584716 605703 609540 589074 621140 621566 621305 609926 620266 585003 467839 497834 518223 518877 513837 514661 518875 504825 524037 526733 502887 530473 538478 475931 542520 559566 563042 567758 543494 581698 672804 549170 569087 573740 580254 594406 598919 613007 618534 590813 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (2.16%) |
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 447903 459002 466557 467839 468893 475931 480079 486162 488154 495361 497834 498405 500633 502887 503353 504825 509005 513837 514661 518223 518577 518875 518877 519845 521103 521828 522918 522987 523564 523734 524037 526733 528960 529565 530473 534594 534630 535979 538478 538913 542294 542520 543494 549170 551131 556922 558956 558990 559566 560168 563042 563534 565739 567758 569025 569085 569087 569131 569526 572970 573740 573911 574414 575708 577535 577778 580254 581698 583644 583979 584528 584716 585003 586426 588154 588276 588300 589074 589087 589425 590501 590813 594151 594406 597430 598919 599040 605486 605703 605826 606564 607369 609540 609723 609926 612933 613007 614495 616760 617139 617857 618534 619782 620072 620162 620266 620943 621140 621305 621566 624320 626127 628681 629688 643668 670329 672804 673667 676209 688991 ] |
||||||||||||||||||||||||||||||
|
1.62 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"заглотила сперму"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"заглот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"заглот сперм"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.01%) |
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.