Query Metrics
8
Database Queries
8
Different statements
184.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.83 ms (84.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 88591 118436 151179 154133 154171 188560 248347 340567 357499 387293 387480 388183 388545 391944 391994 392848 401768 403973 408880 409060 410694 412852 413673 414050 414253 414595 415292 415300 416707 416731 428171 431439 452815 453223 464951 465454 466476 471132 473213 473450 475336 477055 477760 479723 480450 493763 497693 505140 511862 513968 517509 519722 529797 530402 531217 531844 531862 532736 532749 532803 534545 534563 535438 536224 536226 536604 537138 540868 541322 541394 541451 544829 545439 545459 547475 547489 548854 553646 559359 561019 574377 595145 609920 660369 660380 660382 660385 660415 666736 668660 669017 669046 669071 670366 671038 671043 672315 672952 718772 725400 735703 749090 750426 751609 752632 752648 752660 752677 752679 770814 782854 788908 795404 795420 796333 796703 796939 808331 814459 ] |
||||||||||||||||||||||||||||||
|
17.07 ms (9.23%) |
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 188560 392848 511862 530402 547475 574377 545459 561019 660369 672315 672952 660415 671038 795420 796939 403973 428171 401768 413673 431439 414050 248347 415300 473450 513968 535438 464951 357499 415292 151179 808331 154171 388545 416731 505140 536226 519722 536224 537138 408880 414595 414253 540868 534545 534563 660380 718772 609920 795404 796703 782854 796333 749090 770814 750426 752679 725400 735703 751609 752648 788908 118436 670366 391944 416707 412852 477760 493763 465454 473213 531844 497693 475336 477055 544829 553646 595145 452815 666736 671043 669017 154133 88591 387293 410694 340567 387480 409060 471132 564310 547489 668660 669071 660385 660382 545439 752632 752660 480450 453223 479723 541451 669046 752677 391994 388183 466476 814459 532803 517509 531217 532749 536604 531862 529797 532736 541394 559359 541322 548854 ] |
||||||||||||||||||||||||||||||
|
3.87 ms (2.09%) |
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 88591 118436 151179 154133 154171 188560 248347 340567 357499 387293 387480 388183 388545 391944 391994 392848 401768 403973 408880 409060 410694 412852 413673 414050 414253 414595 415292 415300 416707 416731 428171 431439 452815 453223 464951 465454 466476 471132 473213 473450 475336 477055 477760 479723 480450 493763 497693 505140 511862 513968 517509 519722 529797 530402 531217 531844 531862 532736 532749 532803 534545 534563 535438 536224 536226 536604 537138 540868 541322 541394 541451 544829 545439 545459 547475 547489 548854 553646 559359 561019 574377 595145 609920 660369 660380 660382 660385 660415 666736 668660 669017 669046 669071 670366 671038 671043 672315 672952 718772 725400 735703 749090 750426 751609 752632 752648 752660 752677 752679 770814 782854 788908 795404 795420 796333 796703 796939 808331 814459 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge dildo anal"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.92%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01ùz\x04│Øsr┐óúQ\x0F╠3E"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные дилд анал"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.79%) |
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.