Query Metrics
7
Database Queries
7
Different statements
192.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.09 ms (86.79%) |
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 390175 397849 398769 421780 427946 427981 429089 440862 442336 448719 454778 455941 457023 459972 463966 465480 465483 466491 474148 474324 478674 479955 482379 484370 487472 489288 489425 489429 491704 492325 493134 494705 495730 496317 500976 501205 501262 506133 506822 507249 513125 514935 517180 517814 519446 521725 528061 528959 529174 529976 535049 535745 536701 537685 539224 540282 540512 541890 542525 544150 545219 546776 548848 549787 551476 552121 553273 556789 558336 559079 559122 561509 562785 564488 566371 570728 574198 576628 576645 576711 576713 577711 578255 579405 579451 582437 586650 587471 598513 603290 604868 605345 607342 619822 622827 629268 634212 643041 643334 660137 666180 669504 690866 714089 721895 742535 750062 755924 756139 760122 771821 773864 779591 780737 791201 800198 809068 809211 810744 820743 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (8.45%) |
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 535049 553273 576628 544150 548848 598513 605345 604868 455941 487472 429089 440862 421780 820743 454778 459972 495730 517180 521725 513125 529174 540282 559079 570728 556789 578255 541890 564488 566371 660137 546776 549787 561509 629268 607342 619822 643041 586650 779591 800198 773864 771821 780737 398769 479955 463966 491704 494705 489425 465483 474324 489429 496317 551476 552121 574198 562785 666180 714089 669504 690866 603290 587471 643334 791201 809068 810744 809211 756139 760122 755924 742535 750062 622827 390175 448719 519446 397849 482379 514935 542525 721895 466491 442336 501205 528061 427946 506133 537685 484370 576713 576645 576711 634212 427981 577711 474148 478674 500976 492325 465480 493134 457023 489288 506822 528959 529976 501262 517814 536701 539224 507249 535745 540512 558336 579405 579451 582437 559122 545219 ] |
||||||||||||||||||||||||||||||
|
2.85 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 390175 397849 398769 421780 427946 427981 429089 440862 442336 448719 454778 455941 457023 459972 463966 465480 465483 466491 474148 474324 478674 479955 482379 484370 487472 489288 489425 489429 491704 492325 493134 494705 495730 496317 500976 501205 501262 506133 506822 507249 513125 514935 517180 517814 519446 521725 528061 528959 529174 529976 535049 535745 536701 537685 539224 540282 540512 541890 542525 544150 545219 546776 548848 549787 551476 552121 553273 556789 558336 559079 559122 561509 562785 564488 566371 570728 574198 576628 576645 576711 576713 577711 578255 579405 579451 582437 586650 587471 598513 603290 604868 605345 607342 619822 622827 629268 634212 643041 643334 660137 666180 669504 690866 714089 721895 742535 750062 755924 756139 760122 771821 773864 779591 780737 791201 800198 809068 809211 810744 820743 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother porn"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин porn"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин porn"
]
|
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.