Query Metrics
7
Database Queries
7
Different statements
203.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.74 ms (87.42%) |
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 386684 388919 392498 395723 399143 402848 403654 416894 417530 420106 421073 421310 422048 424701 425337 428963 430320 434850 435916 438533 439897 440686 440701 440992 441538 441622 442754 443611 444403 446833 449230 451015 453422 453666 455377 456174 456581 460562 461174 461495 462589 463008 465404 465461 465713 468188 470663 470891 471484 471559 471596 472028 472042 472342 474088 474903 474910 474945 475622 476414 479700 479781 480070 480638 481320 481321 481635 482583 482774 482906 482915 482952 483875 485499 486817 486883 489178 489226 490088 493997 495240 495433 495844 497800 498763 501518 504228 504252 508078 509096 509840 510088 510232 510560 510652 510990 512162 512921 514118 516283 519383 520490 521443 521917 521926 522560 523972 524681 525196 525565 525781 525995 527111 527113 528727 531523 533665 537290 748349 815076 ] |
||||||||||||||||||||||||||||||
|
15.97 ms (7.86%) |
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 430320 471559 480070 476414 481321 465713 474903 510652 485499 508078 489178 521926 402848 440701 444403 438533 441622 420106 416894 527113 482774 523972 527111 495844 501518 510560 461174 417530 474910 428963 439897 462589 455377 465404 442754 468188 475622 482915 483875 510088 482906 498763 512921 519383 441538 440992 456581 482583 446833 472042 495433 422048 434850 453422 461495 443611 489226 509840 521917 482952 479700 388919 451015 504252 392498 533665 510990 463008 524681 520490 424701 395723 472342 504228 521443 399143 403654 421310 815076 456174 481635 748349 421073 510232 435916 465461 531523 516283 525995 537290 525196 471484 386684 425337 495240 453666 490088 486883 471596 449230 474088 509096 486817 512162 514118 525565 525781 493997 522560 440686 479781 497800 528727 470663 474945 480638 460562 470891 472028 481320 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.48%) |
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 386684 388919 392498 395723 399143 402848 403654 416894 417530 420106 421073 421310 422048 424701 425337 428963 430320 434850 435916 438533 439897 440686 440701 440992 441538 441622 442754 443611 444403 446833 449230 451015 453422 453666 455377 456174 456581 460562 461174 461495 462589 463008 465404 465461 465713 468188 470663 470891 471484 471559 471596 472028 472042 472342 474088 474903 474910 474945 475622 476414 479700 479781 480070 480638 481320 481321 481635 482583 482774 482906 482915 482952 483875 485499 486817 486883 489178 489226 490088 493997 495240 495433 495844 497800 498763 501518 504228 504252 508078 509096 509840 510088 510232 510560 510652 510990 512162 512921 514118 516283 519383 520490 521443 521917 521926 522560 523972 524681 525196 525565 525781 525995 527111 527113 528727 531523 533665 537290 748349 815076 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex white couple"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс white couple"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс white couple"
]
|
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.