Query Metrics
7
Database Queries
7
Different statements
160.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.00 ms (78.67%) |
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 96530 152276 152508 359441 395354 395398 395401 415497 416146 417878 418575 424839 437302 437338 439899 444163 447725 448262 450711 453391 461115 461851 463632 464211 465215 466299 471591 472963 482007 485095 485636 491603 491643 495026 495311 500044 506127 514776 514858 515586 521092 522493 526697 543384 546128 547834 552865 553553 557539 561285 561447 562699 564189 569241 569394 572276 578785 579304 579974 580533 585473 586019 586050 587711 589677 590214 590223 593985 599490 602405 606438 608428 609214 610672 615673 615707 621267 623983 625233 629831 632734 641482 643319 647302 650687 672765 677143 689169 691832 692750 693468 708433 708517 713329 718790 722227 724604 736905 736965 750724 751600 758793 760698 768186 771251 772151 775379 783267 783392 784303 793368 798535 798681 805497 807486 809696 810521 813071 819353 821838 ] |
||||||||||||||||||||||||||||||
|
23.40 ms (14.61%) |
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 557539 650687 677143 689169 672765 589677 590223 602405 623983 643319 625233 783267 810521 807486 750724 629831 798535 809696 152508 461851 152276 395398 359441 415497 444163 416146 819353 821838 465215 453391 482007 491603 495311 500044 526697 485095 569394 543384 692750 722227 708433 580533 586019 599490 593985 641482 586050 615673 590214 775379 793368 798681 736965 751600 724604 736905 768186 771251 760698 608428 610672 713329 718790 813071 417878 466299 418575 439899 471591 447725 437302 514776 485636 491643 521092 515586 96530 395354 395401 424839 437338 448262 464211 450711 461115 495026 506127 514858 522493 463632 472963 561447 569241 572276 552865 561285 564189 562699 578785 579974 647302 708517 691832 693468 546128 547834 553553 579304 615707 621267 632734 606438 609214 585473 587711 783392 784303 805497 758793 772151 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.95%) |
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 96530 152276 152508 359441 395354 395398 395401 415497 416146 417878 418575 424839 437302 437338 439899 444163 447725 448262 450711 453391 461115 461851 463632 464211 465215 466299 471591 472963 482007 485095 485636 491603 491643 495026 495311 500044 506127 514776 514858 515586 521092 522493 526697 543384 546128 547834 552865 553553 557539 561285 561447 562699 564189 569241 569394 572276 578785 579304 579974 580533 585473 586019 586050 587711 589677 590214 590223 593985 599490 602405 606438 608428 609214 610672 615673 615707 621267 623983 625233 629831 632734 641482 643319 647302 650687 672765 677143 689169 691832 692750 693468 708433 708517 713329 718790 722227 724604 736905 736965 750724 751600 758793 760698 768186 771251 772151 775379 783267 783392 784303 793368 798535 798681 805497 807486 809696 810521 813071 819353 821838 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"room hotel"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"room hotel"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"room hotel"
]
|
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.