Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

23 Database Queries

2 Different statements

5.14 ms Query time

14 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
4.42 ms (0.00%)	22	SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = 29;
0.73 ms (0.00%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = ? AND t0.status = ? ORDER BY t0.id ASC Parameters: [`"gribu.lv" "active"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = ? AND t0.status = ? ORDER BY t0.id ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = 'gribu.lv' AND t0.status = 'active' ORDER BY t0.id ASC;

Time▼

Count

Info

4.42 ms
(0.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = ?

Parameters:

[
  29
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri AS uri_3,
  t0.title AS title_4,
  t0.meta_description AS meta_description_5,
  t0.h1 AS h1_6,
  t0.h1text AS h1text_7,
  t0.lang AS lang_8,
  t0.domain AS domain_9,
  t0.h2 AS h2_10,
  t0.h2text AS h2text_11,
  t0.category_id AS category_id_12
FROM
  story_category_sub t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri AS uri_3, t0.title AS title_4, t0.meta_description AS meta_description_5, t0.h1 AS h1_6, t0.h1text AS h1text_7, t0.lang AS lang_8, t0.domain AS domain_9, t0.h2 AS h2_10, t0.h2text AS h2text_11, t0.category_id AS category_id_12 FROM story_category_sub t0 WHERE t0.category_id = 29;

0.73 ms
(0.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = ? AND t0.status = ? ORDER BY t0.id ASC

Parameters:

[
  "gribu.lv"
  "active"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.h1 AS h1_4,
  t0.h1text AS h1text_5,
  t0.domain AS domain_6
FROM
  story_category t0
WHERE
  t0.domain = ?
  AND t0.status = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.h1 AS h1_4, t0.h1text AS h1text_5, t0.domain AS domain_6 FROM story_category t0 WHERE t0.domain = 'gribu.lv' AND t0.status = 'active' ORDER BY t0.id ASC;

sphinx connection

No database queries were performed.

sexycommunity connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
sphinx	doctrine.dbal.sphinx_connection
sexycommunity	doctrine.dbal.sexycommunity_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
sphinx	doctrine.orm.sphinx_entity_manager
sexycommunity	doctrine.orm.sexycommunity_entity_manager
auto_generate_proxy_classes	doctrine.orm.auto_generate_proxy_classes_entity_manager
auto_mapping	doctrine.orm.auto_mapping_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\StoryCategory	No errors.
App\Entity\Story	No errors.
App\Entity\AdsInfo	No errors.
App\EntitySphinx\Ads	No errors.
App\Entity\SubscribeLog	No errors.
App\Entity\User	The field App\Entity\User#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Video#user does not contain the required 'inversedBy="videos"' attribute. The field App\Entity\User#presents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserPresent#receivingUser does not contain the required 'inversedBy="presents"' attribute.
App\Entity\ChatGroup	The field App\Entity\ChatGroup#conversations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Conversation#chatGroup does not contain the required 'inversedBy="conversations"' attribute.
App\Entity\Activity	No errors.
App\Entity\Comment	No errors.
App\Entity\VideoComment	No errors.
App\Entity\BlogComment	The association App\Entity\BlogComment#parent refers to the inverse side field App\Entity\BlogComment#children which does not exist.
App\Entity\GroupPublication	The association App\Entity\GroupPublication#parent refers to the inverse side field App\Entity\GroupPublication#children which does not exist.
App\Entity\Message	The association App\Entity\Message#parent refers to the inverse side field App\Entity\Message#children which does not exist.
App\Entity\StoryComment	No errors.
App\Entity\GuestbookPublication	The association App\Entity\GuestbookPublication#parent refers to the inverse side field App\Entity\GuestbookPublication#children which does not exist.
App\Entity\Blog	No errors.
App\Entity\LiveMessage	No errors.
App\Entity\Conversation	The field App\Entity\Conversation#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#conversation does not contain the required 'inversedBy="messages"' attribute.
App\Entity\ChatGroupLock	No errors.
App\Entity\Setting	No errors.
App\Entity\Category	The association App\Entity\Category#city refers to the inverse side field App\Entity\City#categories which does not exist.
App\Entity\Image	The association App\Entity\Image#groupPublications refers to the owning side field App\Entity\GroupPublication#avatar which does not exist.
App\Entity\PhotoAlbum	No errors.
App\Entity\ImageOld	The association App\Entity\ImageOld#groupPublications refers to the owning side field App\Entity\GroupPublication#avatar which does not exist.
App\Entity\UserStatusLog	No errors.
App\Entity\MaxOnlineStatInfo	No errors.
App\Entity\ChatVerification	No errors.
App\Entity\Payment	No errors.
App\Entity\Transaction	No errors.
App\Entity\Subscription	No errors.
App\Entity\Contest	The field App\Entity\Contest#info is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContestInfo#contest does not contain the required 'inversedBy="info"' attribute.
App\Entity\Video	The field App\Entity\Video#likes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VideoLike#video does not contain the required 'inversedBy="likes"' attribute.
App\Entity\VideoAlbum	No errors.
App\Entity\AdsReport	No errors.
App\Entity\Voting	The field App\Entity\Voting#questions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VotingQuestion#voting does not contain the required 'inversedBy="questions"' attribute.
App\Entity\VotingQuestion	The field App\Entity\VotingQuestion#answers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\VotingAnswer#question does not contain the required 'inversedBy="answers"' attribute.
App\Entity\VotingAnswer	No errors.
App\Entity\UserAgreement	No errors.
App\Entity\StoryCategorySub	No errors.

sphinx entity manager

No loaded entities.

sexycommunity entity manager

No loaded entities.

auto_generate_proxy_classes entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

Symfony Profiler

https://sokol.datads.pro/frontapi/get_stories_categories

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

sphinx connection

sexycommunity connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

sphinx entity manager

sexycommunity entity manager

auto_generate_proxy_classes entity manager

auto_mapping entity manager