Query Metrics
7
Database Queries
7
Different statements
165.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.70 ms (84.80%) |
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 391372 393342 396100 416928 417799 418974 421571 421621 425744 426076 427388 429665 433436 434609 436848 437232 441269 441476 450910 450966 451907 459364 463026 463183 463197 468462 469191 474933 476780 477393 477401 477414 478431 479295 480976 481792 482623 483124 483593 484023 487864 489931 494379 495930 496237 496686 498773 499034 499149 499617 499693 500129 500824 501968 502019 503812 506014 509322 511337 511348 511596 514055 514136 514364 516438 519691 522239 523321 524207 524327 525273 525418 525994 526233 527110 527668 533192 533261 538077 538544 541767 542182 542387 542412 545675 545725 548117 548897 551457 552544 553946 554782 555882 562211 569568 587951 597169 604329 610228 615177 615415 618673 620244 621387 633215 633689 640592 641778 649622 650636 662900 736265 746722 756493 761746 767508 771213 772964 773524 781164 ] |
||||||||||||||||||||||||||||||
|
15.04 ms (9.06%) |
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 542412 553946 562211 542182 542387 554782 649622 650636 551457 597169 641778 604329 633215 736265 746722 761746 773524 771213 767508 615177 463197 417799 421571 421621 426076 434609 477393 477401 478431 480976 418974 441476 499617 502019 506014 511337 524207 489931 527668 548897 662900 772964 499034 620244 391372 459364 481792 524327 527110 545725 509322 499149 483593 640592 756493 396100 433436 416928 441269 451907 469191 476780 487864 501968 511348 525418 522239 498773 503812 525273 496686 516438 538077 477414 545675 569568 548117 552544 555882 621387 615415 610228 587951 618673 781164 633689 427388 436848 474933 479295 463026 425744 463183 468462 429665 437232 499693 500129 500824 519691 483124 495930 514055 526233 541767 484023 511596 538544 496237 514364 523321 525994 482623 533192 533261 494379 393342 450910 450966 514136 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.76%) |
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 391372 393342 396100 416928 417799 418974 421571 421621 425744 426076 427388 429665 433436 434609 436848 437232 441269 441476 450910 450966 451907 459364 463026 463183 463197 468462 469191 474933 476780 477393 477401 477414 478431 479295 480976 481792 482623 483124 483593 484023 487864 489931 494379 495930 496237 496686 498773 499034 499149 499617 499693 500129 500824 501968 502019 503812 506014 509322 511337 511348 511596 514055 514136 514364 516438 519691 522239 523321 524207 524327 525273 525418 525994 526233 527110 527668 533192 533261 538077 538544 541767 542182 542387 542412 545675 545725 548117 548897 551457 552544 553946 554782 555882 562211 569568 587951 597169 604329 610228 615177 615415 618673 620244 621387 633215 633689 640592 641778 649622 650636 662900 736265 746722 756493 761746 767508 771213 772964 773524 781164 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов доминирован"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov domina"
]
|
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.