Query Metrics
7
Database Queries
7
Different statements
179.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.92 ms (86.85%) |
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 76074 304300 364655 383382 383571 384580 386856 387213 392797 394366 398628 402243 407250 413309 413734 415583 418036 419143 420621 421990 422069 423692 426514 426869 428218 428786 431224 433911 434992 435874 435975 442360 443676 443955 444372 444550 444893 445006 447133 448625 449237 449287 452393 453479 454031 455242 456435 456569 456906 459153 460891 461812 464541 465675 465868 466568 466934 467099 469359 469897 472139 472957 475569 476218 476814 476825 477904 481231 483876 483901 484011 489862 491342 495498 496384 499088 499398 503749 505430 505578 507138 509252 509302 511043 512563 513171 513579 514041 514116 515662 528325 528391 528730 531934 534488 534827 548326 550218 550487 552501 554648 560292 580967 586144 589580 589860 601138 612968 617796 630569 647212 659381 693423 709612 714466 721939 747325 750996 763336 770348 ] |
||||||||||||||||||||||||||||||
|
14.39 ms (8.01%) |
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 763336 770348 617796 721939 386856 387213 421990 433911 461812 423692 472139 434992 443955 444550 449287 460891 443676 453479 455242 456569 469897 505578 513579 304300 76074 413734 419143 431224 422069 449237 465675 466568 469359 476825 447133 511043 514116 531934 534488 499088 528730 534827 548326 550487 580967 552501 554648 560292 659381 693423 709612 647212 550218 630569 589860 601138 612968 586144 589580 747325 750996 714466 394366 398628 402243 413309 392797 407250 442360 467099 472957 477904 481231 456435 464541 454031 435874 476814 509302 484011 495498 503749 528391 489862 509252 514041 528325 496384 499398 512563 515662 384580 383382 383571 364655 415583 435975 445006 444893 426514 428218 444372 420621 428786 418036 426869 465868 475569 476218 483901 448625 459153 483876 491342 452393 456906 466934 505430 507138 513171 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.56%) |
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 76074 304300 364655 383382 383571 384580 386856 387213 392797 394366 398628 402243 407250 413309 413734 415583 418036 419143 420621 421990 422069 423692 426514 426869 428218 428786 431224 433911 434992 435874 435975 442360 443676 443955 444372 444550 444893 445006 447133 448625 449237 449287 452393 453479 454031 455242 456435 456569 456906 459153 460891 461812 464541 465675 465868 466568 466934 467099 469359 469897 472139 472957 475569 476218 476814 476825 477904 481231 483876 483901 484011 489862 491342 495498 496384 499088 499398 503749 505430 505578 507138 509252 509302 511043 512563 513171 513579 514041 514116 515662 528325 528391 528730 531934 534488 534827 548326 550218 550487 552501 554648 560292 580967 586144 589580 589860 601138 612968 617796 630569 647212 659381 693423 709612 714466 721939 747325 750996 763336 770348 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"окна"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"окн"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.84%) |
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.