Query Metrics
7
Database Queries
7
Different statements
387.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.37 ms (53.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"black вагин"
]
|
||||||||||||||||||||||||||||||
|
154.98 ms (39.96%) |
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 13011 382460 382466 382928 383022 383933 385341 386697 386758 387221 388653 389640 395499 396720 397973 399358 400753 402664 415097 416236 417095 417441 419483 423539 423981 423987 428535 437123 443340 445050 445684 457145 458013 459032 459085 460328 460561 462610 467588 468008 471859 475262 475568 475698 478491 481673 482610 494349 494365 499177 504379 505690 509221 511777 511844 514289 517819 519105 519712 524440 524867 525063 526669 547237 555807 558156 558581 565103 575020 578204 586407 588697 589756 591582 592046 592384 595244 601755 604551 604597 604849 605196 614715 617420 619401 622583 625752 626138 626482 627740 630204 630292 630857 644059 645322 646846 649136 649137 660405 672140 676073 680242 681257 681301 704715 716969 720112 720253 725408 733271 741733 741752 743159 744597 750466 762191 765459 775414 785877 788789 ] |
||||||||||||||||||||||||||||||
|
14.14 ms (3.65%) |
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 565103 575020 645322 649136 660405 676073 716969 720253 649137 680242 681257 704715 720112 646846 592384 604849 605196 626482 630857 644059 622583 626138 630292 586407 589756 595244 627740 775414 733271 741752 765459 785877 725408 741733 744597 762191 743159 750466 601755 630204 387221 445684 478491 481673 423539 459032 395499 396720 423987 382928 399358 402664 475568 416236 428535 460561 519712 494349 504379 514289 499177 509221 519105 525063 386758 415097 417095 417441 460328 468008 458013 517819 494365 524867 526669 505690 558156 555807 547237 578204 672140 588697 591582 614715 625752 604597 788789 423981 443340 459085 467588 471859 445050 475698 400753 437123 462610 475262 482610 457145 524440 511777 558581 681301 592046 619401 604551 419483 511844 617420 386697 383933 385341 383022 382460 382466 13011 388653 389640 397973 ] |
||||||||||||||||||||||||||||||
|
4.38 ms (1.13%) |
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 13011 382460 382466 382928 383022 383933 385341 386697 386758 387221 388653 389640 395499 396720 397973 399358 400753 402664 415097 416236 417095 417441 419483 423539 423981 423987 428535 437123 443340 445050 445684 457145 458013 459032 459085 460328 460561 462610 467588 468008 471859 475262 475568 475698 478491 481673 482610 494349 494365 499177 504379 505690 509221 511777 511844 514289 517819 519105 519712 524440 524867 525063 526669 547237 555807 558156 558581 565103 575020 578204 586407 588697 589756 591582 592046 592384 595244 601755 604551 604597 604849 605196 614715 617420 619401 622583 625752 626138 626482 627740 630204 630292 630857 644059 645322 646846 649136 649137 660405 672140 676073 680242 681257 681301 704715 716969 720112 720253 725408 733271 741733 741752 743159 744597 750466 762191 765459 775414 785877 788789 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"black vagina"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"black вагин"
]
|
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.