Query Metrics
7
Database Queries
7
Different statements
370.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
222.92 ms (60.18%) |
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 434488 445041 408768 418553 444118 411834 440292 446136 450280 450795 458804 460842 468316 469240 469976 473786 486008 488564 445576 447162 450136 453197 493808 447342 454682 465706 477266 489335 491601 495322 496981 497235 504079 512605 532498 507127 509372 495211 509959 469571 474657 486365 493834 548659 551397 570559 575129 578138 570528 552208 552222 574358 579456 674125 722557 548713 551334 554143 563135 566301 570533 573051 575630 590334 596625 730751 753155 219740 220774 400235 417608 438540 441376 449216 449316 454361 463812 472798 479567 392785 402234 446215 454106 456125 464270 386915 426003 427004 430858 455450 465200 468793 471938 476439 476534 478520 382734 420329 428848 433827 437727 452925 474260 479283 447083 449712 455284 501435 502727 503196 508304 513628 516077 518259 526668 485976 487300 489164 495620 497498 ] |
||||||||||||||||||||||||||||||
|
137.84 ms (37.21%) |
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 219740 220774 382734 386915 392785 400235 402234 408768 411834 417608 418553 420329 426003 427004 428848 430858 433827 434488 437727 438540 440292 441376 444118 445041 445576 446136 446215 447083 447162 447342 449216 449316 449712 450136 450280 450795 452925 453197 454106 454361 454682 455284 455450 456125 458804 460842 463812 464270 465200 465706 468316 468793 469240 469571 469976 471938 472798 473786 474260 474657 476439 476534 477266 478520 479283 479567 485976 486008 486365 487300 488564 489164 489335 491601 493808 493834 495211 495322 495620 496981 497235 497498 501435 502727 503196 504079 507127 508304 509372 509959 512605 513628 516077 518259 526668 532498 548659 548713 551334 551397 552208 552222 554143 563135 566301 570528 570533 570559 573051 574358 575129 575630 578138 579456 590334 596625 674125 722557 730751 753155 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (0.84%) |
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 219740 220774 382734 386915 392785 400235 402234 408768 411834 417608 418553 420329 426003 427004 428848 430858 433827 434488 437727 438540 440292 441376 444118 445041 445576 446136 446215 447083 447162 447342 449216 449316 449712 450136 450280 450795 452925 453197 454106 454361 454682 455284 455450 456125 458804 460842 463812 464270 465200 465706 468316 468793 469240 469571 469976 471938 472798 473786 474260 474657 476439 476534 477266 478520 479283 479567 485976 486008 486365 487300 488564 489164 489335 491601 493808 493834 495211 495322 495620 496981 497235 497498 501435 502727 503196 504079 507127 508304 509372 509959 512605 513628 516077 518259 526668 532498 548659 548713 551334 551397 552208 552222 554143 563135 566301 570528 570533 570559 573051 574358 575129 575630 578138 579456 590334 596625 674125 722557 730751 753155 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"коже"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кож"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.36 ms (0.37%) |
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.