Query Metrics
7
Database Queries
7
Different statements
356.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.53 ms (59.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм home"
]
|
||||||||||||||||||||||||||||||
|
121.43 ms (34.03%) |
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 403716 415822 415900 420860 421547 426465 432650 440889 442474 442989 453655 454149 456033 456034 456522 457340 457804 458472 461915 462936 464837 465122 469638 470123 471493 475831 476806 476915 479403 479959 480955 481075 481523 481926 483841 484111 486112 486232 487272 491439 492222 493286 498474 498530 502707 505083 505922 506209 507865 508247 508987 511924 516909 517989 518536 519123 520067 520099 521991 523231 523702 524174 524180 524359 524638 525126 525898 526147 528661 528858 529423 530192 532352 536176 537963 541479 543143 545188 545510 546665 551228 554419 557015 558473 559045 560438 562006 565756 565937 568802 581354 582390 582450 584200 584244 589653 592933 599738 602633 605688 612467 625460 631801 644129 652968 697909 715615 727692 753205 753765 756803 763845 764652 766706 769490 783927 784475 784524 793252 810405 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (4.41%) |
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 462936 465122 470123 471493 476806 479959 403716 442989 454149 457804 458472 469638 476915 480955 415822 453655 456033 456522 481926 508247 520067 521991 524180 524638 486112 487272 492222 493286 498530 502707 505083 519123 505922 506209 484111 486232 491439 516909 518536 523702 524174 524359 528858 529423 530192 536176 525126 498474 532352 464837 554419 557015 560438 565756 582390 584244 543143 559045 562006 545188 551228 715615 652968 697909 581354 584200 589653 625460 602633 784475 753205 764652 766706 753765 756803 769490 727692 763845 612467 475831 457340 481075 461915 537963 483841 508987 511924 520099 526147 479403 541479 605688 592933 631801 644129 784524 793252 783927 810405 426465 456034 481523 523231 507865 525898 517989 558473 568802 582450 545510 546665 565937 599738 528661 420860 421547 440889 442474 415900 432650 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (0.89%) |
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 403716 415822 415900 420860 421547 426465 432650 440889 442474 442989 453655 454149 456033 456034 456522 457340 457804 458472 461915 462936 464837 465122 469638 470123 471493 475831 476806 476915 479403 479959 480955 481075 481523 481926 483841 484111 486112 486232 487272 491439 492222 493286 498474 498530 502707 505083 505922 506209 507865 508247 508987 511924 516909 517989 518536 519123 520067 520099 521991 523231 523702 524174 524180 524359 524638 525126 525898 526147 528661 528858 529423 530192 532352 536176 537963 541479 543143 545188 545510 546665 551228 554419 557015 558473 559045 560438 562006 565756 565937 568802 581354 582390 582450 584200 584244 589653 592933 599738 602633 605688 612467 625460 631801 644129 652968 697909 715615 727692 753205 753765 756803 763845 764652 766706 769490 783927 784475 784524 793252 810405 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм home"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm home"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.43%) |
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.