Query Metrics
7
Database Queries
7
Different statements
393.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.86 ms (53.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"touch in public"
]
|
||||||||||||||||||||||||||||||
|
154.62 ms (39.29%) |
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 387709 406695 414009 417722 429266 439652 453638 456955 459346 476441 486601 486659 487946 488240 489431 489787 492208 493160 495275 496354 505963 509548 510609 516742 517480 517580 523592 523813 525892 525971 526360 527822 528141 528447 529185 529454 530312 532152 533628 537224 539106 539942 541150 541284 542533 544305 545028 546149 546419 548547 549521 551038 551831 551921 551960 552051 552280 553079 554260 555313 555434 555502 555698 555942 557467 558234 559200 559242 560083 561252 562037 562118 562836 564935 565126 568177 570843 572290 572291 576137 576725 577620 578060 578118 578161 578961 579516 579764 580958 581188 584736 585666 589568 589775 590499 596014 596599 598186 598515 601159 603704 604941 605396 606890 609221 612065 614325 615587 617770 618952 619734 623973 626145 635697 649362 651269 657817 663374 677106 678481 ] |
||||||||||||||||||||||||||||||
|
19.12 ms (4.86%) |
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 617770 456955 486601 489431 525892 529185 579764 577620 551921 603704 598186 489787 596014 387709 429266 476441 486659 505963 533628 539106 523592 541284 545028 548547 559200 560083 565126 578060 578118 541150 549521 555313 555698 584736 649362 651269 677106 551831 555942 557467 564935 590499 589568 589775 619734 453638 417722 493160 562037 572290 609221 529454 585666 559242 579516 581188 552280 578961 523813 487946 406695 496354 517480 562118 561252 618952 623973 612065 528447 542533 525971 527822 539942 509548 517580 528141 544305 578161 555434 555502 572291 576137 663374 546149 554260 626145 614325 598515 604941 606890 635697 562836 552051 530312 532152 678481 596599 414009 526360 537224 510609 516742 546419 551960 558234 553079 657817 551038 576725 615587 601159 605396 439652 492208 568177 580958 495275 570843 459346 488240 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (0.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 387709 406695 414009 417722 429266 439652 453638 456955 459346 476441 486601 486659 487946 488240 489431 489787 492208 493160 495275 496354 505963 509548 510609 516742 517480 517580 523592 523813 525892 525971 526360 527822 528141 528447 529185 529454 530312 532152 533628 537224 539106 539942 541150 541284 542533 544305 545028 546149 546419 548547 549521 551038 551831 551921 551960 552051 552280 553079 554260 555313 555434 555502 555698 555942 557467 558234 559200 559242 560083 561252 562037 562118 562836 564935 565126 568177 570843 572290 572291 576137 576725 577620 578060 578118 578161 578961 579516 579764 580958 581188 584736 585666 589568 589775 590499 596014 596599 598186 598515 601159 603704 604941 605396 606890 609221 612065 614325 615587 617770 618952 619734 623973 626145 635697 649362 651269 657817 663374 677106 678481 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.41%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трога на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.38%) |
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.