Query Metrics
7
Database Queries
7
Different statements
402.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.03 ms (50.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
170.28 ms (42.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 386709 390610 410640 418928 419043 419840 419847 420275 422074 423491 425495 425977 428250 429568 434189 442280 447995 448064 448069 448800 448874 454113 454168 456029 456367 456383 457475 461059 461893 462359 462360 466721 468650 468828 468884 469191 470138 470424 474845 474895 475945 477069 477875 480414 484019 484495 485051 485319 486695 487005 487115 487122 487718 489973 490783 490903 491444 491928 491983 493220 494703 494933 495876 497005 497386 501348 503535 503632 506014 506448 507931 509498 511162 511259 511277 511348 511478 511823 512786 513114 513295 514710 514818 515002 515511 516495 516768 516976 517283 517368 518005 518972 519595 520151 521203 521219 521226 521254 522180 523105 523257 523440 523635 524357 525392 525418 526077 526371 526728 527618 527668 529146 532384 532508 534261 534359 535546 543845 603269 818160 ] |
||||||||||||||||||||||||||||||
|
19.91 ms (4.94%) |
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 503535 514710 515002 516495 523440 527618 532508 490903 491444 491928 506014 511277 513114 521254 525392 484495 487005 487115 491983 501348 511823 512786 524357 526728 495876 497386 511478 513295 518005 523635 527668 418928 425495 490783 468650 511162 517283 517368 520151 470424 543845 603269 461059 425977 468884 386709 390610 410640 419840 420275 429568 419847 434189 422074 423491 442280 428250 419043 818160 447995 454113 456367 457475 466721 469191 470138 474845 474895 477069 480414 484019 485319 486695 448069 454168 456383 448064 448800 448874 456029 461893 462359 462360 468828 475945 477875 485051 487122 487718 489973 493220 494933 506448 507931 509498 511348 516976 518972 521203 521219 521226 522180 525418 526077 526371 529146 532384 534261 534359 535546 494703 497005 503632 511259 514818 515511 516768 519595 523105 523257 ] |
||||||||||||||||||||||||||||||
|
3.10 ms (0.77%) |
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 386709 390610 410640 418928 419043 419840 419847 420275 422074 423491 425495 425977 428250 429568 434189 442280 447995 448064 448069 448800 448874 454113 454168 456029 456367 456383 457475 461059 461893 462359 462360 466721 468650 468828 468884 469191 470138 470424 474845 474895 475945 477069 477875 480414 484019 484495 485051 485319 486695 487005 487115 487122 487718 489973 490783 490903 491444 491928 491983 493220 494703 494933 495876 497005 497386 501348 503535 503632 506014 506448 507931 509498 511162 511259 511277 511348 511478 511823 512786 513114 513295 514710 514818 515002 515511 516495 516768 516976 517283 517368 518005 518972 519595 520151 521203 521219 521226 521254 522180 523105 523257 523440 523635 524357 525392 525418 526077 526371 526728 527618 527668 529146 532384 532508 534261 534359 535546 543845 603269 818160 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.51%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"domination milf"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.42%) |
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.