Query Metrics
7
Database Queries
7
Different statements
370.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.61 ms (56.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая парен teen"
]
|
||||||||||||||||||||||||||||||
|
124.45 ms (33.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 386271 395871 396188 404383 406172 415735 417136 417428 418774 419383 422909 423033 426152 426361 427909 428385 429185 429629 438597 443465 444938 445252 447313 447348 447501 447563 447751 454835 459366 459490 459506 461423 461437 461716 462287 462854 463077 463144 463903 463943 463955 463988 464147 465808 468849 470045 475313 477385 478482 478606 481105 482084 482538 485196 485305 486213 489486 489561 489577 490086 490833 491614 492565 495670 497554 501723 501755 501831 509648 512645 513276 516737 519012 519498 524719 527927 538229 539126 548782 548872 550434 550611 551199 551202 552665 554356 554366 558020 558129 559018 560038 560585 561639 561694 561821 561831 565324 565947 569070 569988 572954 574615 574884 575087 575117 575733 576299 576342 577333 578392 590081 590413 595412 595436 596578 598519 598530 601915 602506 603482 ] |
||||||||||||||||||||||||||||||
|
25.63 ms (6.92%) |
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 429185 463144 463988 417428 445252 447501 478482 513276 516737 489561 490833 524719 485196 512645 485305 486213 489577 538229 539126 602506 419383 482538 501723 527927 561694 578392 554356 565947 569988 574615 575117 595412 595436 598530 590413 596578 598519 603482 447751 468849 447348 462854 463943 463955 465808 395871 396188 461423 461437 470045 482084 417136 426361 427909 454835 463903 429629 438597 519498 489486 490086 501831 509648 519012 495670 497554 501755 426152 492565 550434 550611 561821 575087 551199 569070 572954 558129 574884 575733 565324 386271 404383 406172 444938 415735 422909 447563 459366 463077 475313 447313 478606 464147 491614 561831 576299 577333 548782 551202 558020 559018 548872 552665 560038 576342 554366 560585 561639 590081 601915 423033 428385 462287 477385 443465 459490 459506 461716 418774 481105 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (1.00%) |
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 386271 395871 396188 404383 406172 415735 417136 417428 418774 419383 422909 423033 426152 426361 427909 428385 429185 429629 438597 443465 444938 445252 447313 447348 447501 447563 447751 454835 459366 459490 459506 461423 461437 461716 462287 462854 463077 463144 463903 463943 463955 463988 464147 465808 468849 470045 475313 477385 478482 478606 481105 482084 482538 485196 485305 486213 489486 489561 489577 490086 490833 491614 492565 495670 497554 501723 501755 501831 509648 512645 513276 516737 519012 519498 524719 527927 538229 539126 548782 548872 550434 550611 551199 551202 552665 554356 554366 558020 558129 559018 560038 560585 561639 561694 561821 561831 565324 565947 569070 569988 572954 574615 574884 575087 575117 575733 576299 576342 577333 578392 590081 590413 595412 595436 596578 598519 598530 601915 602506 603482 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.60%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small boy teen"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"маленькая парен teen"
]
|
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.