Query Metrics
7
Database Queries
7
Different statements
378.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.37 ms (56.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"couple лиза"
]
|
||||||||||||||||||||||||||||||
|
133.27 ms (35.26%) |
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 386682 396957 397366 404483 408708 414646 415834 416817 418359 425337 425767 426487 431365 431371 433920 438684 439906 443580 450508 454254 454768 455730 455876 459667 462545 464619 469137 470211 471055 471605 472342 472956 475082 477362 479050 481320 481612 481772 482088 483370 483607 486817 489112 490968 491130 492564 492602 494672 498012 498656 499323 499740 501144 502249 502600 502865 502868 504046 504232 505041 510232 512160 512162 514118 515578 516443 518064 519240 519288 519786 519795 520433 520730 520748 520986 521990 524014 524131 525118 525377 525565 525781 527706 527808 528270 534284 556665 557992 563337 564453 566459 567749 571680 571682 571839 572537 574410 588650 589207 595682 595808 596351 599921 602572 603121 609197 619038 621396 621657 622218 624480 636110 638532 654449 665107 665108 665116 669738 688573 721057 ] |
||||||||||||||||||||||||||||||
|
22.45 ms (5.94%) |
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 455876 470211 481320 414646 415834 433920 479050 425337 438684 472342 504232 521990 524014 483370 486817 502865 512160 512162 514118 519288 525377 525565 525781 490968 501144 502868 492564 510232 520748 483607 619038 464619 425767 459667 469137 481772 502600 534284 494672 520730 557992 571839 665107 688573 566459 567749 572537 638532 602572 622218 636110 595808 603121 609197 721057 408708 416817 397366 418359 454254 454768 462545 396957 439906 471055 471605 481612 431365 499740 516443 524131 528270 498012 519786 498656 505041 519795 520433 527706 527808 491130 499323 518064 654449 564453 571680 482088 504046 589207 489112 588650 472956 492602 525118 386682 426487 443580 431371 455730 475082 477362 450508 502249 520986 515578 519240 563337 574410 665116 665108 669738 556665 571682 595682 599921 621396 624480 596351 621657 404483 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (0.90%) |
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 386682 396957 397366 404483 408708 414646 415834 416817 418359 425337 425767 426487 431365 431371 433920 438684 439906 443580 450508 454254 454768 455730 455876 459667 462545 464619 469137 470211 471055 471605 472342 472956 475082 477362 479050 481320 481612 481772 482088 483370 483607 486817 489112 490968 491130 492564 492602 494672 498012 498656 499323 499740 501144 502249 502600 502865 502868 504046 504232 505041 510232 512160 512162 514118 515578 516443 518064 519240 519288 519786 519795 520433 520730 520748 520986 521990 524014 524131 525118 525377 525565 525781 527706 527808 528270 534284 556665 557992 563337 564453 566459 567749 571680 571682 571839 572537 574410 588650 589207 595682 595808 596351 599921 602572 603121 609197 619038 621396 621657 622218 624480 636110 638532 654449 665107 665108 665116 669738 688573 721057 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"couple licking"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"couple лиза"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (0.53%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.