Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

6 Database Queries

6 Different statements

625.55 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

561.81 ms
(89.81%)

SELECT s0_.id AS id_0, s0_.consignment_no AS consignment_no_1, s0_.shipper_account AS shipper_account_2, s0_.ref_no AS ref_no_3, s0_.courier_awb_no AS courier_awb_no_4, s0_.type AS type_5, s0_.pieces AS pieces_6, s0_.weight AS weight_7, s0_.ship_content AS ship_content_8, s0_.booking_date AS booking_date_9, s0_.shiper_company AS shiper_company_10, s0_.shiper_address AS shiper_address_11, s0_.shiper_city AS shiper_city_12, s0_.shiper_state AS shiper_state_13, s0_.shiper_zip_code AS shiper_zip_code_14, s0_.sender_name AS sender_name_15, s0_.shiper_tel_no AS shiper_tel_no_16, s0_.shiper_mp AS shiper_mp_17, s0_.consigne_company AS consigne_company_18, s0_.consigne_adress AS consigne_adress_19, s0_.consigne_city AS consigne_city_20, s0_.consigne_state AS consigne_state_21, s0_.consigne_zip_code AS consigne_zip_code_22, s0_.recipent_name AS recipent_name_23, s0_.consigne_tel_no AS consigne_tel_no_24, s0_.consigne_mp AS consigne_mp_25, s0_.remarks AS remarks_26, s0_.height AS height_27, s0_.width AS width_28, s0_.length AS length_29, s0_.pickupby AS pickupby_30, s0_.pickup_date AS pickup_date_31, s0_.total_amount AS total_amount_32, s0_.collect_amount AS collect_amount_33, s0_.third_party_amount AS third_party_amount_34, s0_.cheque_no AS cheque_no_35, s0_.account_no AS account_no_36, s0_.note AS note_37, s0_.deliverystatus AS deliverystatus_38, s0_.trackingstatus AS trackingstatus_39, s0_.nid AS nid_40, s0_.payment_mode AS payment_mode_41, s0_.consigne_nid AS consigne_nid_42, s0_.nid_path AS nid_path_43, s0_.awb_path AS awb_path_44, s0_.invoice_path AS invoice_path_45, s0_.other_path AS other_path_46, s0_.courier_id AS courier_id_47, s0_.origin_country_id AS origin_country_id_48, s0_.destination_country_id AS destination_country_id_49, s0_.shipper_id AS shipper_id_50, s0_.consignee_id AS consignee_id_51 FROM shipment s0_ WHERE s0_.consignment_no = ?

Parameters:

[
  "5066033871"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.consignment_no AS consignment_no_1,
  s0_.shipper_account AS shipper_account_2,
  s0_.ref_no AS ref_no_3,
  s0_.courier_awb_no AS courier_awb_no_4,
  s0_.type AS type_5,
  s0_.pieces AS pieces_6,
  s0_.weight AS weight_7,
  s0_.ship_content AS ship_content_8,
  s0_.booking_date AS booking_date_9,
  s0_.shiper_company AS shiper_company_10,
  s0_.shiper_address AS shiper_address_11,
  s0_.shiper_city AS shiper_city_12,
  s0_.shiper_state AS shiper_state_13,
  s0_.shiper_zip_code AS shiper_zip_code_14,
  s0_.sender_name AS sender_name_15,
  s0_.shiper_tel_no AS shiper_tel_no_16,
  s0_.shiper_mp AS shiper_mp_17,
  s0_.consigne_company AS consigne_company_18,
  s0_.consigne_adress AS consigne_adress_19,
  s0_.consigne_city AS consigne_city_20,
  s0_.consigne_state AS consigne_state_21,
  s0_.consigne_zip_code AS consigne_zip_code_22,
  s0_.recipent_name AS recipent_name_23,
  s0_.consigne_tel_no AS consigne_tel_no_24,
  s0_.consigne_mp AS consigne_mp_25,
  s0_.remarks AS remarks_26,
  s0_.height AS height_27,
  s0_.width AS width_28,
  s0_.length AS length_29,
  s0_.pickupby AS pickupby_30,
  s0_.pickup_date AS pickup_date_31,
  s0_.total_amount AS total_amount_32,
  s0_.collect_amount AS collect_amount_33,
  s0_.third_party_amount AS third_party_amount_34,
  s0_.cheque_no AS cheque_no_35,
  s0_.account_no AS account_no_36,
  s0_.note AS note_37,
  s0_.deliverystatus AS deliverystatus_38,
  s0_.trackingstatus AS trackingstatus_39,
  s0_.nid AS nid_40,
  s0_.payment_mode AS payment_mode_41,
  s0_.consigne_nid AS consigne_nid_42,
  s0_.nid_path AS nid_path_43,
  s0_.awb_path AS awb_path_44,
  s0_.invoice_path AS invoice_path_45,
  s0_.other_path AS other_path_46,
  s0_.courier_id AS courier_id_47,
  s0_.origin_country_id AS origin_country_id_48,
  s0_.destination_country_id AS destination_country_id_49,
  s0_.shipper_id AS shipper_id_50,
  s0_.consignee_id AS consignee_id_51
FROM
  shipment s0_
WHERE
  s0_.consignment_no = ?

SELECT s0_.id AS id_0, s0_.consignment_no AS consignment_no_1, s0_.shipper_account AS shipper_account_2, s0_.ref_no AS ref_no_3, s0_.courier_awb_no AS courier_awb_no_4, s0_.type AS type_5, s0_.pieces AS pieces_6, s0_.weight AS weight_7, s0_.ship_content AS ship_content_8, s0_.booking_date AS booking_date_9, s0_.shiper_company AS shiper_company_10, s0_.shiper_address AS shiper_address_11, s0_.shiper_city AS shiper_city_12, s0_.shiper_state AS shiper_state_13, s0_.shiper_zip_code AS shiper_zip_code_14, s0_.sender_name AS sender_name_15, s0_.shiper_tel_no AS shiper_tel_no_16, s0_.shiper_mp AS shiper_mp_17, s0_.consigne_company AS consigne_company_18, s0_.consigne_adress AS consigne_adress_19, s0_.consigne_city AS consigne_city_20, s0_.consigne_state AS consigne_state_21, s0_.consigne_zip_code AS consigne_zip_code_22, s0_.recipent_name AS recipent_name_23, s0_.consigne_tel_no AS consigne_tel_no_24, s0_.consigne_mp AS consigne_mp_25, s0_.remarks AS remarks_26, s0_.height AS height_27, s0_.width AS width_28, s0_.length AS length_29, s0_.pickupby AS pickupby_30, s0_.pickup_date AS pickup_date_31, s0_.total_amount AS total_amount_32, s0_.collect_amount AS collect_amount_33, s0_.third_party_amount AS third_party_amount_34, s0_.cheque_no AS cheque_no_35, s0_.account_no AS account_no_36, s0_.note AS note_37, s0_.deliverystatus AS deliverystatus_38, s0_.trackingstatus AS trackingstatus_39, s0_.nid AS nid_40, s0_.payment_mode AS payment_mode_41, s0_.consigne_nid AS consigne_nid_42, s0_.nid_path AS nid_path_43, s0_.awb_path AS awb_path_44, s0_.invoice_path AS invoice_path_45, s0_.other_path AS other_path_46, s0_.courier_id AS courier_id_47, s0_.origin_country_id AS origin_country_id_48, s0_.destination_country_id AS destination_country_id_49, s0_.shipper_id AS shipper_id_50, s0_.consignee_id AS consignee_id_51 FROM shipment s0_ WHERE s0_.consignment_no = '5066033871';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 50)
7	App\Repository\ShipmentRepository->getShipmentTracking (line 58)
8	App\Controller\HomeController->trackingResultLink (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

38.73 ms
(6.19%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "theprofessionalcourier@outlook.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.email = 'theprofessionalcourier@outlook.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 54)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 63)
6	Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler->consumeRememberMeCookie (line 63)
7	Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler->consumeRememberMeCookie (line 95)
8	Symfony\Component\Security\Http\Authenticator\RememberMeAuthenticator->Symfony\Component\Security\Http\Authenticator\{closure} (line 87)
9	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
10	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
11	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
18	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
19	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
20	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
21	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
22	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
23	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 75)
24	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 169)
25	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
26	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
31	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

20.54 ms
(3.28%)

SELECT t0.id AS id_1, t0.consignment_no AS consignment_no_2, t0.shipper_account AS shipper_account_3, t0.ref_no AS ref_no_4, t0.courier_awb_no AS courier_awb_no_5, t0.type AS type_6, t0.pieces AS pieces_7, t0.weight AS weight_8, t0.ship_content AS ship_content_9, t0.booking_date AS booking_date_10, t0.shiper_company AS shiper_company_11, t0.shiper_address AS shiper_address_12, t0.shiper_city AS shiper_city_13, t0.shiper_state AS shiper_state_14, t0.shiper_zip_code AS shiper_zip_code_15, t0.sender_name AS sender_name_16, t0.shiper_tel_no AS shiper_tel_no_17, t0.shiper_mp AS shiper_mp_18, t0.consigne_company AS consigne_company_19, t0.consigne_adress AS consigne_adress_20, t0.consigne_city AS consigne_city_21, t0.consigne_state AS consigne_state_22, t0.consigne_zip_code AS consigne_zip_code_23, t0.recipent_name AS recipent_name_24, t0.consigne_tel_no AS consigne_tel_no_25, t0.consigne_mp AS consigne_mp_26, t0.remarks AS remarks_27, t0.height AS height_28, t0.width AS width_29, t0.length AS length_30, t0.pickupby AS pickupby_31, t0.pickup_date AS pickup_date_32, t0.total_amount AS total_amount_33, t0.collect_amount AS collect_amount_34, t0.third_party_amount AS third_party_amount_35, t0.cheque_no AS cheque_no_36, t0.account_no AS account_no_37, t0.note AS note_38, t0.deliverystatus AS deliverystatus_39, t0.trackingstatus AS trackingstatus_40, t0.nid AS nid_41, t0.payment_mode AS payment_mode_42, t0.consigne_nid AS consigne_nid_43, t0.nid_path AS nid_path_44, t0.awb_path AS awb_path_45, t0.invoice_path AS invoice_path_46, t0.other_path AS other_path_47, t0.courier_id AS courier_id_48, t0.origin_country_id AS origin_country_id_49, t0.destination_country_id AS destination_country_id_50, t0.shipper_id AS shipper_id_51, t0.consignee_id AS consignee_id_52 FROM shipment t0 WHERE t0.id = ?

Parameters:

[
  "6066"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.consignment_no AS consignment_no_2,
  t0.shipper_account AS shipper_account_3,
  t0.ref_no AS ref_no_4,
  t0.courier_awb_no AS courier_awb_no_5,
  t0.type AS type_6,
  t0.pieces AS pieces_7,
  t0.weight AS weight_8,
  t0.ship_content AS ship_content_9,
  t0.booking_date AS booking_date_10,
  t0.shiper_company AS shiper_company_11,
  t0.shiper_address AS shiper_address_12,
  t0.shiper_city AS shiper_city_13,
  t0.shiper_state AS shiper_state_14,
  t0.shiper_zip_code AS shiper_zip_code_15,
  t0.sender_name AS sender_name_16,
  t0.shiper_tel_no AS shiper_tel_no_17,
  t0.shiper_mp AS shiper_mp_18,
  t0.consigne_company AS consigne_company_19,
  t0.consigne_adress AS consigne_adress_20,
  t0.consigne_city AS consigne_city_21,
  t0.consigne_state AS consigne_state_22,
  t0.consigne_zip_code AS consigne_zip_code_23,
  t0.recipent_name AS recipent_name_24,
  t0.consigne_tel_no AS consigne_tel_no_25,
  t0.consigne_mp AS consigne_mp_26,
  t0.remarks AS remarks_27,
  t0.height AS height_28,
  t0.width AS width_29,
  t0.length AS length_30,
  t0.pickupby AS pickupby_31,
  t0.pickup_date AS pickup_date_32,
  t0.total_amount AS total_amount_33,
  t0.collect_amount AS collect_amount_34,
  t0.third_party_amount AS third_party_amount_35,
  t0.cheque_no AS cheque_no_36,
  t0.account_no AS account_no_37,
  t0.note AS note_38,
  t0.deliverystatus AS deliverystatus_39,
  t0.trackingstatus AS trackingstatus_40,
  t0.nid AS nid_41,
  t0.payment_mode AS payment_mode_42,
  t0.consigne_nid AS consigne_nid_43,
  t0.nid_path AS nid_path_44,
  t0.awb_path AS awb_path_45,
  t0.invoice_path AS invoice_path_46,
  t0.other_path AS other_path_47,
  t0.courier_id AS courier_id_48,
  t0.origin_country_id AS origin_country_id_49,
  t0.destination_country_id AS destination_country_id_50,
  t0.shipper_id AS shipper_id_51,
  t0.consignee_id AS consignee_id_52
FROM
  shipment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.consignment_no AS consignment_no_2, t0.shipper_account AS shipper_account_3, t0.ref_no AS ref_no_4, t0.courier_awb_no AS courier_awb_no_5, t0.type AS type_6, t0.pieces AS pieces_7, t0.weight AS weight_8, t0.ship_content AS ship_content_9, t0.booking_date AS booking_date_10, t0.shiper_company AS shiper_company_11, t0.shiper_address AS shiper_address_12, t0.shiper_city AS shiper_city_13, t0.shiper_state AS shiper_state_14, t0.shiper_zip_code AS shiper_zip_code_15, t0.sender_name AS sender_name_16, t0.shiper_tel_no AS shiper_tel_no_17, t0.shiper_mp AS shiper_mp_18, t0.consigne_company AS consigne_company_19, t0.consigne_adress AS consigne_adress_20, t0.consigne_city AS consigne_city_21, t0.consigne_state AS consigne_state_22, t0.consigne_zip_code AS consigne_zip_code_23, t0.recipent_name AS recipent_name_24, t0.consigne_tel_no AS consigne_tel_no_25, t0.consigne_mp AS consigne_mp_26, t0.remarks AS remarks_27, t0.height AS height_28, t0.width AS width_29, t0.length AS length_30, t0.pickupby AS pickupby_31, t0.pickup_date AS pickup_date_32, t0.total_amount AS total_amount_33, t0.collect_amount AS collect_amount_34, t0.third_party_amount AS third_party_amount_35, t0.cheque_no AS cheque_no_36, t0.account_no AS account_no_37, t0.note AS note_38, t0.deliverystatus AS deliverystatus_39, t0.trackingstatus AS trackingstatus_40, t0.nid AS nid_41, t0.payment_mode AS payment_mode_42, t0.consigne_nid AS consigne_nid_43, t0.nid_path AS nid_path_44, t0.awb_path AS awb_path_45, t0.invoice_path AS invoice_path_46, t0.other_path AS other_path_47, t0.courier_id AS courier_id_48, t0.origin_country_id AS origin_country_id_49, t0.destination_country_id AS destination_country_id_50, t0.shipper_id AS shipper_id_51, t0.consignee_id AS consignee_id_52 FROM shipment t0 WHERE t0.id = '6066';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 44)
7	App\Controller\HomeController->trackingResultLink (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.47 ms
(0.40%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.mobileno AS mobileno_4, t0.email AS email_5, t0.full_url AS full_url_6, t0.remarks AS remarks_7, t0.first_url AS first_url_8, t0.last_url AS last_url_9 FROM courier t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.mobileno AS mobileno_4,
  t0.email AS email_5,
  t0.full_url AS full_url_6,
  t0.remarks AS remarks_7,
  t0.first_url AS first_url_8,
  t0.last_url AS last_url_9
FROM
  courier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.mobileno AS mobileno_4, t0.email AS email_5, t0.full_url AS full_url_6, t0.remarks AS remarks_7, t0.first_url AS first_url_8, t0.last_url AS last_url_9 FROM courier t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Courier::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Courier->__get (line 60)
8	App\Entity\Courier->getName (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 159)
10	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->block_body (line 431)
11	Twig\Template->yieldBlock (line 191)
12	__TwigTemplate_04b23d8ad2320a5cae383654bc1bf5a7->doDisplay (line 387)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 63)
23	App\Controller\HomeController->trackingResultLink (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.31 ms
(0.21%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM origin_country t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.remarks AS remarks_4
FROM
  origin_country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM origin_country t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\OriginCountry::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\OriginCountry->__get (line 52)
8	App\Entity\OriginCountry->getName (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 213)
10	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->block_body (line 431)
11	Twig\Template->yieldBlock (line 191)
12	__TwigTemplate_04b23d8ad2320a5cae383654bc1bf5a7->doDisplay (line 387)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 63)
23	App\Controller\HomeController->trackingResultLink (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.68 ms
(0.11%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM destination_country t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.remarks AS remarks_4
FROM
  destination_country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM destination_country t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\DestinationCountry::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\DestinationCountry->__get (line 52)
8	App\Entity\DestinationCountry->getName (line 1861)
9	Twig\Extension\CoreExtension::getAttribute (line 225)
10	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->block_body (line 431)
11	Twig\Template->yieldBlock (line 191)
12	__TwigTemplate_04b23d8ad2320a5cae383654bc1bf5a7->doDisplay (line 387)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_e60b2da88ed7ba6212e559c53cb31127->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 63)
23	App\Controller\HomeController->trackingResultLink (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

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

Class	Mapping errors
App\Entity\Shipment	No errors.
App\Entity\Courier	No errors.
App\Entity\OriginCountry	No errors.
App\Entity\DestinationCountry	No errors.
App\Entity\Shipper	No errors.
App\Entity\Consignee	No errors.
App\Entity\ShipmentDocuments	No errors.
App\Entity\Booking	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.tpc-bd.org/track/link/5066033871/6066

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping