Query Metrics
7
Database Queries
7
Different statements
216.01 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.89 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.25 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в кровате"
]
|
||||||||||||||||||||||||||||||
| 3 | 15.47 ms |
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 398742 437178 62253 403478 452662 538233 508719 581209 571922 443129 475973 480851 504262 230243 398927 404112 415039 409696 450835 453526 527517 538146 570245 681437 652924 570015 629942 393469 425590 461188 461590 398757 400906 409730 486487 511395 527634 506691 507835 424675 517187 439490 617146 430264 68529 160525 395672 275727 266633 39497 387259 537683 549414 574285 650913 685277 688230 591299 634519 85250 48159 323899 403292 66264 191059 377287 420334 516803 526482 503535 497120 393333 391543 343350 61563 388344 387539 387886 432390 433299 469732 480013 458776 505971 522093 506791 531940 528885 543227 551703 549263 571808 582959 656068 656372 659682 667921 598353 621026 58408 400653 436953 463247 387868 469886 475829 28386 397005 406045 415344 383360 426875 504028 498178 505786 506235 482853 509246 416959 396797 ] |
||||||||||||||||||||||||||||||
| 4 | 2.81 ms |
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 28386 39497 48159 58408 61563 62253 66264 68529 85250 160525 191059 230243 266633 275727 323899 343350 377287 383360 387259 387539 387868 387886 388344 391543 393333 393469 395672 396797 397005 398742 398757 398927 400653 400906 403292 403478 404112 406045 409696 409730 415039 415344 416959 420334 424675 425590 426875 430264 432390 433299 436953 437178 439490 443129 450835 452662 453526 458776 461188 461590 463247 469732 469886 475829 475973 480013 480851 482853 486487 497120 498178 503535 504028 504262 505786 505971 506235 506691 506791 507835 508719 509246 511395 516803 517187 522093 526482 527517 527634 528885 531940 537683 538146 538233 543227 549263 549414 551703 570015 570245 571808 571922 574285 581209 582959 591299 598353 617146 621026 629942 634519 650913 652924 656068 656372 659682 667921 681437 685277 688230 ] |
||||||||||||||||||||||||||||||
| 5 | 190.14 ms |
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 28386 39497 48159 58408 61563 62253 66264 68529 85250 160525 191059 230243 266633 275727 323899 343350 377287 383360 387259 387539 387868 387886 388344 391543 393333 393469 395672 396797 397005 398742 398757 398927 400653 400906 403292 403478 404112 406045 409696 409730 415039 415344 416959 420334 424675 425590 426875 430264 432390 433299 436953 437178 439490 443129 450835 452662 453526 458776 461188 461590 463247 469732 469886 475829 475973 480013 480851 482853 486487 497120 498178 503535 504028 504262 505786 505971 506235 506691 506791 507835 508719 509246 511395 516803 517187 522093 526482 527517 527634 528885 531940 537683 538146 538233 543227 549263 549414 551703 570015 570245 571808 571922 574285 581209 582959 591299 598353 617146 621026 629942 634519 650913 652924 656068 656372 659682 667921 681437 685277 688230 ] |
||||||||||||||||||||||||||||||
| 6 | 1.76 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в кроват"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.70 ms |
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.