Query Metrics
7
Database Queries
7
Different statements
163.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.15 ms (84.32%) |
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 6696 89199 225519 233355 287436 383880 384027 385831 387394 388290 388566 388891 389389 390776 390904 392554 392623 395373 395664 396103 396201 396212 396215 396235 397288 397353 397536 398025 400026 401124 401764 401858 403166 404113 418053 421544 427544 428586 429385 441407 441613 442632 443868 458920 463912 475250 497467 497870 499134 504672 509892 522160 529025 529045 536256 536271 543127 549089 550180 556335 561895 566586 570469 573676 574848 575160 575495 575583 581229 584287 648648 651876 652616 659423 660444 660713 663166 666528 669339 670997 671648 671832 674966 680204 682924 683143 683382 683564 683584 684887 687204 688660 688997 693484 695096 696227 699667 705514 705791 712713 714433 718690 720045 720749 721394 721428 722222 722585 722592 722594 722607 722890 723536 723539 723662 797389 810210 813549 823359 823493 ] |
||||||||||||||||||||||||||||||
|
16.65 ms (10.16%) |
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 797389 810210 388290 392554 396215 396235 397353 400026 401124 401858 404113 392623 396201 397288 458920 388566 389389 233355 390904 395373 418053 529025 666528 674966 497870 385831 384027 383880 225519 395664 287436 89199 6696 388891 387394 390776 396212 396103 397536 398025 401764 403166 441613 421544 429385 441407 442632 443868 427544 428586 723536 723539 813549 723662 823359 823493 475250 463912 497467 499134 536256 529045 504672 509892 522160 536271 549089 550180 556335 561895 566586 570469 575495 581229 573676 574848 575160 543127 575583 584287 648648 660713 663166 670997 671832 682924 688660 688997 693484 705514 705791 714433 721394 721428 722585 722594 722890 651876 652616 659423 660444 669339 671648 683143 683382 683564 695096 696227 712713 720045 720749 722222 722592 722607 680204 683584 684887 687204 699667 718690 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.60%) |
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 6696 89199 225519 233355 287436 383880 384027 385831 387394 388290 388566 388891 389389 390776 390904 392554 392623 395373 395664 396103 396201 396212 396215 396235 397288 397353 397536 398025 400026 401124 401764 401858 403166 404113 418053 421544 427544 428586 429385 441407 441613 442632 443868 458920 463912 475250 497467 497870 499134 504672 509892 522160 529025 529045 536256 536271 543127 549089 550180 556335 561895 566586 570469 573676 574848 575160 575495 575583 581229 584287 648648 651876 652616 659423 660444 660713 663166 666528 669339 670997 671648 671832 674966 680204 682924 683143 683382 683564 683584 684887 687204 688660 688997 693484 695096 696227 699667 705514 705791 712713 714433 718690 720045 720749 721394 721428 722222 722585 722592 722594 722607 722890 723536 723539 723662 797389 810210 813549 823359 823493 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen xxx"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen-xxx"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.23 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen xxx"
]
|
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.