Query Metrics
7
Database Queries
7
Different statements
198.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.57 ms (85.00%) |
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 411515 434834 438878 440696 452551 456388 456486 459208 460459 463698 465747 466548 469626 474299 475011 478728 478744 483586 485008 486493 489813 492081 495499 496959 498512 499361 500377 502337 513162 513563 513950 514729 515665 518962 519119 520940 522683 525284 525454 526144 526463 526802 529488 534446 546335 547639 552571 553428 553608 554947 556391 557433 558691 560961 566344 571072 572674 574280 580024 581246 586245 586285 589811 591724 592218 594570 595601 595899 599360 610680 613625 613630 617614 625456 625578 626972 627774 630955 641334 641539 644139 650725 655466 661896 666496 671650 677189 678205 678704 682417 695501 696916 697416 699583 701910 716572 718556 719461 721867 722341 727970 737882 738653 740157 753050 757909 760456 761699 766469 779344 786346 796363 797496 799575 802005 804213 809864 811052 814230 820306 ] |
||||||||||||||||||||||||||||||
|
18.39 ms (9.27%) |
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 580024 581246 557433 571072 666496 661896 678704 718556 722341 671650 697416 719461 721867 560961 586245 586285 589811 595601 595899 641539 599360 644139 591724 613630 625578 779344 760456 766469 740157 761699 626972 630955 716572 811052 459208 474299 465747 478744 411515 456486 502337 485008 489813 514729 519119 522683 486493 500377 529488 820306 814230 513162 499361 534446 526144 483586 547639 546335 553428 678205 695501 701910 650725 677189 655466 682417 696916 558691 574280 592218 617614 625456 594570 610680 613625 627774 641334 797496 799575 804213 753050 786346 796363 802005 809864 737882 757909 727970 738653 456388 434834 469626 518962 492081 495499 460459 513950 525454 515665 556391 553608 452551 496959 498512 438878 520940 572674 552571 554947 699583 566344 475011 513563 525284 526802 526463 440696 463698 478728 466548 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.73%) |
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 411515 434834 438878 440696 452551 456388 456486 459208 460459 463698 465747 466548 469626 474299 475011 478728 478744 483586 485008 486493 489813 492081 495499 496959 498512 499361 500377 502337 513162 513563 513950 514729 515665 518962 519119 520940 522683 525284 525454 526144 526463 526802 529488 534446 546335 547639 552571 553428 553608 554947 556391 557433 558691 560961 566344 571072 572674 574280 580024 581246 586245 586285 589811 591724 592218 594570 595601 595899 599360 610680 613625 613630 617614 625456 625578 626972 627774 630955 641334 641539 644139 650725 655466 661896 666496 671650 677189 678205 678704 682417 695501 696916 697416 699583 701910 716572 718556 719461 721867 722341 727970 737882 738653 740157 753050 757909 760456 761699 766469 779344 786346 796363 797496 799575 802005 804213 809864 811052 814230 820306 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"neighbor girl"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"neighbor девушк"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"neighbor девушк"
]
|
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.