Query Metrics
7
Database Queries
7
Different statements
163.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.65 ms (80.12%) |
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 29367 96200 191509 311163 385710 386918 388739 389391 392266 393582 395142 395583 402312 411347 411533 419140 421617 424438 427050 431487 449744 451092 451150 457120 457897 458036 460764 464239 466029 467376 467659 468344 471914 473115 474584 476429 481286 483968 487556 488329 494732 496347 497670 499832 500043 502269 505851 517613 520917 521369 521902 526124 534155 536012 543080 551812 552045 556703 557263 558372 558832 559726 563523 563648 565630 566704 566889 576375 579103 589512 594442 597530 598751 600064 601763 602438 603955 610139 612030 621811 622064 622665 625819 628345 634905 646061 649024 650277 656400 656472 663000 667906 670411 673118 675795 678260 681142 686648 709916 717918 720631 724312 732986 739120 752754 753031 756838 760609 765381 768933 773158 773817 775828 782710 792899 800275 800406 800562 803839 814371 ] |
||||||||||||||||||||||||||||||
|
21.01 ms (12.89%) |
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 481286 395583 473115 466029 488329 521902 96200 494732 775828 29367 520917 385710 392266 388739 389391 419140 431487 497670 534155 517613 579103 650277 678260 686648 656472 552045 566889 601763 612030 800275 521369 393582 421617 464239 457897 451092 536012 499832 557263 551812 565630 649024 667906 681142 646061 663000 709916 720631 634905 621811 610139 792899 800406 753031 782710 803839 752754 756838 768933 732986 765381 773158 739120 760609 773817 625819 386918 468344 191509 411533 467659 476429 427050 458036 460764 451150 487556 483968 395142 311163 814371 589512 457120 502269 496347 500043 526124 563648 543080 556703 558372 559726 563523 576375 558832 566704 673118 675795 656400 670411 717918 594442 600064 598751 602438 603955 622064 597530 622665 628345 800562 724312 402312 424438 474584 411347 471914 449744 467376 505851 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.92%) |
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 29367 96200 191509 311163 385710 386918 388739 389391 392266 393582 395142 395583 402312 411347 411533 419140 421617 424438 427050 431487 449744 451092 451150 457120 457897 458036 460764 464239 466029 467376 467659 468344 471914 473115 474584 476429 481286 483968 487556 488329 494732 496347 497670 499832 500043 502269 505851 517613 520917 521369 521902 526124 534155 536012 543080 551812 552045 556703 557263 558372 558832 559726 563523 563648 565630 566704 566889 576375 579103 589512 594442 597530 598751 600064 601763 602438 603955 610139 612030 621811 622064 622665 625819 628345 634905 646061 649024 650277 656400 656472 663000 667906 670411 673118 675795 678260 681142 686648 709916 717918 720631 724312 732986 739120 752754 753031 756838 760609 765381 768933 773158 773817 775828 782710 792899 800275 800406 800562 803839 814371 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс трах пальцем"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.35%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс секс пальц"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
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.