Logo Sas Asia
  • Company
    • Management
  • Quality
  • Applications
  • News
  • Reference projects
  • Downloads
    • Technical Documents
    • Catalogs and Brochures
    • Approvals
    • Certificates
  • Contact
    • SAH worldwide
  • Career
  1. Home
  2. Terms and Conditions

General Terms and Conditions of Business

§ 1 Scope of the con­di­ti­ons
1.1)

The­se Ge­ne­ral Terms and Con­di­ti­ons of Busi­ness (the "Terms and Con­di­ti­ons") shall ap­p­ly ex­clu­si­ve­ly to the de­li­very of goods and the pro­vi­si­on of ser­vices by SAS Asia Bar Sys­tems Pte. Ltd. ("SAS") to the purcha­ser (the "Purcha­ser"). The­se Terms and Con­di­ti­ons al­so ap­p­ly to all fu­ture busi­ness re­la­ti­ons­hips bet­ween SAS and the Purcha­ser, even if the par­ties ha­ve not ex­press­ly agreed to the­se Terms and Con­di­ti­ons. The term "par­ties" shall hence­forth re­fer collec­tive­ly to both SAS and the Purcha­ser and the term "par­ty" shall re­fer to each of the par­ties. The term "goods" in the­se Terms and Con­di­ti­ons shall re­fer to the goods to be de­li­ver­ed by SAS to the Purcha­ser.
1.2)

The­se Terms and Con­di­ti­ons shall not ap­p­ly to con­su­mers who are in­di­vi­du­als, who purcha­se goods (not as de­fi­ned her­ein) and ser­vices (not as de­fi­ned her­ein) in ge­ne­ral, other­wi­se than ex­clu­si­ve­ly in the cour­se of busi­ness.
1.3)

The Purcha­ser shall be re­s­pon­si­ble for en­su­ring com­p­li­an­ce with ap­p­lica­ble laws and re­gu­la­ti­ons (in­clu­ding work safe­ty and en­vi­ron­men­tal re­gu­la­ti­ons) in con­nec­tion with the use of goods sup­p­lied by SAS to the Purcha­ser.

§ 2 Quo­ta­ti­ons and En­te­ring in­to Contracts
2.1)

SAS' quo­ta­ti­ons are sub­ject to writ­ten con­fir­ma­ti­on by SAS in all in­stan­ces. Any de­cla­ra­ti­ons or con­fir­ma­ti­on of ac­cep­tan­ce and any or­der pla­ced by the Purcha­ser must be ul­ti­mate­ly con­fir­med by SAS in wri­ting (by let­ter, fax or elec­tro­nic mail) in or­der for them to be le­gal­ly va­lid and bin­ding on the par­ties. Each or­der so ac­cep­ted or con­fir­med by SAS shall be upon the­se Terms and Con­di­ti­ons and shall con­sti­tu­te an in­di­vi­du­al le­gal­ly bin­ding contract bet­ween SAS and the Purcha­ser and such contract is her­einaf­ter re­fer­red to as a "Contract".
2.2)

The­se Terms and Con­di­ti­ons shall over­ri­de any con­tra­ry, dif­fe­rent or ad­di­tio­nal terms (if any) con­tai­ned on or re­fer­red to in an or­der form or other do­cu­ments or cor­re­spon­dence from the Purcha­ser, and no ad­di­ti­on, al­te­ra­ti­on or sub­sti­tu­ti­on of the­se terms will bind SAS or form part of the Contract un­less they are ex­press­ly ac­cep­ted in wri­ting by an aut­ho­ri­sed per­son­nel of SAS.
2.3)

All goods sup­p­lied by SAS shall be in ac­cor­dance with the cur­rent edi­ti­on of the re­le­vant pro­duct de­scrip­ti­on in SAS' bro­chu­res or pu­bli­ca­ti­on (whe­ther the­se are in print, elec­tro­nic form, on­line or in any other form of me­dia or plat­form) as pu­blis­hed from ti­me to ti­me by SAS on its web­site (if so ap­p­lica­ble to the goods). Any other goods which are not de­scri­bed on the said web­site shall be in ac­cor­dance with the spe­ci­fi­ca­ti­ons, drawings and/or de­scrip­ti­ons set out in the or­der form as agreed by SAS. SAS shall not be de­emed to be ma­king any re­pre­sen­ta­ti­ons as to the goods in any ex­ch­an­ge of in­for­ma­ti­on, cor­re­spon­dence and/or do­cu­men­ta­ti­on bet­ween the par­ties. No other spe­ci­fi­ca­ti­on, de­scrip­ti­ve ma­te­ri­al, writ­ten or oral re­pre­sen­ta­ti­on, cor­re­spon­dence or state­ment, pro­mo­tio­nal or sa­les li­te­ra­tu­re shall form part of or be in­cor­po­ra­ted in­to the Contract.
2.4)

SAS re­ser­ves all rights of ow­nership and in­tel­lec­tu­al pro­per­ty rights (in­clu­ding co­py­right, de­sign rights, trade­mark rights and pa­tent rights) in and to the cost esti­ma­tes, drawings and other in­for­ma­ti­on, in any form or me­dia, which are pro­vi­ded to the Purcha­ser.

§ 3 Pri­ces
3.1)

Un­less other­wi­se agreed in wri­ting by the par­ties, pri­ces sta­ted in SAS' quo­ta­ti­on shall be va­lid for a pe­ri­od of 30 days from the date of such quo­ta­ti­on. The ap­p­lica­ble pri­ces shall be the pri­ces sta­ted in the or­der con­fir­ma­ti­on. Whe­re ap­p­lica­ble, tur­no­ver tax, va­lue ad­ded tax or goods and ser­vices tax at the cur­rent sta­tu­to­ry ra­te (as the ca­se may be) shall be ad­ded to the­se pri­ces. Pri­ces shall in­clu­de de­li­very and ser­vices (if so ap­p­lica­ble) and shall be con­fir­med by SAS in wri­ting.
3.2)

Un­less other­wi­se agreed in wri­ting by the par­ties, pri­ces shall be on an ex-works ba­sis (as de­fi­ned in the In­coterms ® 2010).
3.3)

SAS re­ser­ves the right to in­crea­se or lo­wer pri­ces to the extent that the "scrap and al­loy­ing sup­ple­ment" chan­ges. The ap­p­lica­ble pri­ce shall be the pri­ce sta­ted on SAS' web­site, i.e., www.sas-asia.sg on the date of de­li­very of the goods.

§ 4 De­li­very and Per­for­mance
4.1)

De­li­very of the goods by SAS shall be ba­sed on the re­le­vant In­coterm (in ac­cor­dance with In­coterms®2010) sta­ted in our quo­ta­ti­on and as con­fir­med by us.
4.2)

On­ly tho­se de­li­very dead­lines spe­ci­fied in the writ­ten or­der con­fir­ma­ti­on by SAS shall be ap­p­lica­ble. All other de­li­very dead­lines in­di­ca­ted by SAS shall be non-bin­ding un­less ex­press­ly spe­ci­fied in wri­ting by SAS. A de­li­very pe­ri­od be­gins, at the ear­liest, upon con­fir­ma­ti­on of the or­der by SAS.
4.3)

The de­li­very pe­ri­od is on­ly de­emed to ha­ve com­men­ced when the Purcha­ser has sub­mit­ted the re­qui­red do­cu­men­ta­ti­on to SAS ac­cor­ding to the agreed ti­me­li­nes.
4.4)

SAS shall not be un­der any lia­bi­li­ty for any failu­re to per­form any of its ob­li­ga­ti­ons un­der the Contract due to Force Ma­jeu­re. Fol­lo­wing no­ti­fi­ca­ti­on from SAS to the Purcha­ser of such cau­se, SAS shall be al­lo­wed a re­a­sonable ex­ten­si­on of ti­me plus an ap­pro­pria­te start-up pe­ri­od for the per­for­mance of its ob­li­ga­ti­ons. If the pe­ri­od of Force Ma­jeu­re ex­ceeds 90 ca­len­dar days, SAS shall be en­t­it­led to ter­mi­na­te the Contract by gi­ving the Purcha­ser 7 days' (being such 7 ca­len­dar days af­ter the ex­pi­ry of the afo­re­said 90 days) writ­ten no­ti­ce, whe­reu­pon SAS shall be di­sch­ar­ged from its ob­li­ga­ti­ons un­der the Contract. In the event of a ter­mi­na­ti­on of the Contract as de­scri­bed in this Clau­se, the Purcha­ser shall not be en­t­it­led to any claims for com­pen­sa­ti­on in da­mages if the ti­me for de­li­very was ex­ten­ded or if SAS is no lon­ger ob­li­ged to de­li­ver the goods to the Purcha­ser.
For the pur­po­ses of this clau­se 4.4), "Force Ma­jeu­re" me­ans fi­re, ex­plo­si­on, flood, light­ning, Act of God, act of ter­ro­rism, war, re­bel­li­on, ri­ot, sa­bo­ta­ge, strikes, lock-outs, la­bour dis­pu­tes, a shor­ta­ge of sup­p­ly of goods to SAS from its upstream sup­p­liers, a de­lay in the sup­p­ly of goods to SAS from its upstream sup­p­liers, of­fi­ci­al di­rec­tives or events or cir­cum­stan­ces outs­ide the re­a­sonable con­trol of SAS.
4.5)

If SAS is un­able to com­ply with the de­li­very dead­lines or de­li­very pe­ri­ods, the Purcha­ser is en­t­it­led to claim com­pen­sa­ti­on of 0.5% of the in­voice va­lue for every full week of de­lay, up to a ma­xi­mum of 5% of the in­voice va­lue of the de­li­very. SAS' lia­bi­li­ty towards the Purcha­ser with re­spect to non-com­p­li­an­ce with de­li­very dead­lines or de­li­very pe­ri­od shall be li­mi­ted to the com­pen­sa­ti­on sum set out in this Clau­se.
4.6)

SAS has the right to ma­ke par­ti­al de­li­ve­ries of the goods and to ren­der par­ti­al per­for­man­ces un­less other­wi­se agreed in wri­ting with the Purcha­ser.

§ 5 Trans­fer of Risk
5.1)

Risk of da­ma­ge to or loss to the goods shall pass (and even in the ca­se of dis­patch which is de­lay­ed) ac­cor­ding to the re­le­vant In­coterm (in ac­cor­dance with In­coterms®2010) na­med in the writ­ten or­der con­fir­ma­ti­on which has be­en agreed upon by SAS.
5.2)

If the Purcha­ser de­lays in ta­king de­li­very of the goods, SAS shall then ha­ve the right to de­mand reim­bur­se­ment for any loss of the goods ari­sing from such de­lay. The risk of ac­ci­den­tal de­te­rio­ra­ti­on and ac­ci­den­tal de­struc­tion of the goods pas­ses to the Purcha­ser if the Purcha­ser de­lays in ta­king de­li­very of such goods. In the event that (i) the Purcha­ser de­lays in ta­king de­li­very of the goods de­s­pi­te being gi­ven a two-week gra­ce pe­ri­od by SAS or (ii) the Purcha­ser sus­pends its pay­ments due to SAS hereun­der or (iii) the Purcha­ser be­co­mes in­sol­vent or be­co­mes bur­de­ned by ex­ces­si­ve debt, SAS shall be en­t­it­led to im­me­dia­te­ly de­mand pay­ment
for the purcha­se pri­ce of the goods or to ter­mi­na­te the Contract and the Purcha­ser shall be lia­ble for any da­mages in con­nec­tion with such ter­mi­na­ti­on.

§ 6 Re­ten­ti­on of Tit­le
6.1)

SAS shall re­tain tit­le in the goods un­til all pay­ments and each and every claim un­der every Contract has be­en re­cei­ved by SAS.
6.2)

The Purcha­ser is en­t­it­led to pro­cess and dis­po­se of the goods sold in the nor­mal cour­se of its busi­ness sub­ject al­ways to the re­ten­ti­on of tit­le by SAS and pro­vi­ded the Purcha­ser is not in ar­re­ars of any pay­ments due and owing to SAS un­der any Contract. The Purcha­ser shall not sell, pledge, mort­ga­ge or other­wi­se deal with the goods as se­cu­ri­ty. The Purcha­ser her­e­by as­signs to SAS in ad­van­ce all claims on the Purcha­ser's cust­o­m­ers or third par­ties in con­nec­tion with the resa­le of the goods, re­gard­less of whe­ther the goods are sold in a pro­ces­sed or un­pro­ces­sed con­di­ti­on. SAS her­e­by aut­ho­ri­ses the Purcha­ser the right to collect such claims for and on be­half of SAS ex­cept that such aut­ho­ri­sa­ti­on shall be re­vo­ked by SAS if the Purcha­ser does not com­ply with its pay­ment ob­li­ga­ti­ons her­ein. The Purcha­ser shall ad­vi­se SAS of the as­si­gned claims and the re­le­vant debtors, pro­vi­de no­ti­ce to the re­le­vant debtors of such as­si­gn­ment and pro­vi­de all ne­cessa­ry in­for­ma­ti­on to SAS to enable SAS to ef­fect collec­tion of such claims. If the goods are re­sold to­ge­ther with other goods not sup­p­lied by SAS, the Purcha­ser's claim on his end cust­o­m­er shall be de­emed to ha­ve be­en as­si­gned to SAS to the amount of the contract pri­ce agreed upon bet­ween SAS and the Purcha­ser for such goods of SAS.
6.3)

The Purcha­ser shall en­su­re that the pro­ces­sing or con­ver­si­on of the goods shall be sub­ject to SAS' re­ten­ti­on of tit­le ("SAS' pro­prieta­ry goods"). If SAS' pro­prieta­ry goods are pro­ces­sed or ins­e­pa­ra­b­ly com­bi­ned with other items not in SAS' pos­ses­si­on, then SAS be­co­mes the co-ow­ner of the­se pro­ces­sed or com­bi­ned goods from the ti­me of such pro­ces­sing or com­bi­na­ti­on. If SAS' pro­prieta­ry goods are in­te­gra­ted or ins­e­pa­ra­b­ly com­bi­ned with other mova­ble ob­jects and if the other ob­ject is re­gar­ded as con­sti­tu­ting the prin­ci­pal ob­ject, the Purcha­ser is de­emed to ha­ve trans­fer­red his right of co-ow­nership to SAS pro­vi­ded the prin­ci­pal ob­ject be­longs to the Purcha­ser. In such a ca­se, the Purcha­ser holds the right of ow­nership or co-ow­nership on SAS' be­half. In all other re­spects, the ob­ject pro­du­ced by pro­ces­sing, con­ver­si­on, com­bi­na­ti­on or in­te­gra­ti­on is sub­ject to the sa­me con­di­ti­on as SAS' pro­prieta­ry goods.
6.4)

In the event of a de­fault by the Purcha­ser, the com­men­ce­ment of in­sol­vency pro­cee­dings or sei­zu­re with re­spect to the Purcha­ser, SAS shall be en­t­it­led to re­co­ver the goods sub­ject to the re­ten­ti­on of tit­le wi­thout the Purcha­ser being able to ma­ke any claims against SAS, e.g. tre­spas­sing of pro­per­ty. In the ca­se of third par­ties ob­tai­ning ac­cess to the goods sold sub­ject to the re­ten­ti­on of tit­le and in par­ti­cu­lar, in the ca­se of le­vies of exe­cu­ti­on, sei­zu­res or other court or­ders, the Purcha­ser shall im­me­dia­te­ly draw at­ten­ti­on to SAS' ow­nership and in­form SAS so as to enable SAS to en­force its right of ow­nership over the goods. The Purcha­ser shall be lia­ble for all costs that may ari­se in con­nec­tion with SAS en­for­cing its rights her­ein.
6.5)

In the event of a breach of the Contract, and in par­ti­cu­lar, in the event of a de­lay in pay­ment by the Purcha­ser un­der the Contract, SAS shall ha­ve a right to ter­mi­na­te the Contract and to im­me­dia­te­ly de­mand from the Purcha­ser a lis­ting of the goods which are still in the Purcha­ser's pos­ses­si­on and sub­ject to a re­ten­ti­on of tit­le by SAS, and al­so the extent to which such goods are being pro­ces­sed. The Contract is not ter­mi­na­ted me­rely by SAS ta­king back the goods from the Purcha­ser or the sei­zu­re of goods by an or­der of court.
6.6)

Upon the Purcha­ser's re­quest, SAS shall ha­ve the op­ti­on to re­lease the re­le­vant se­cu­ri­ties to which it is en­t­it­led if their rea­li­sa­ble va­lue per­sis­tent­ly ex­ceeds the va­lue of the claims to be se­cu­red by mo­re than 20%.

§ 7 Pay­ment
7.1)

Un­less other­wi­se agreed in wri­ting bet­ween the par­ties, the Purcha­ser shall ma­ke pay­ment for in­voices ren­de­red by SAS wi­t­hin 21 ca­len­dar days of the date of the in­voice, net (wi­thout any de­duc­tions or wi­th­hol­ding or bank char­ges).
7.2)

SAS re­ser­ves the right to set-off pay­ments ma­de by the Purcha­ser against ear­lier debts in­cur­red by the Purcha­ser in con­nec­tion with any goods or ser­vices purcha­sed by the Purcha­ser. SAS will in­form the Purcha­ser of any set-offs ma­de. If any costs and in­te­rests ha­ve ari­sen, SAS has the right to set the pay­ment off first against such costs, then against such in­te­rests and fi­nal­ly against the prin­ci­pal sum owing by the Purcha­ser to SAS.
7.3)

A pay­ment shall be de­emed to ha­ve be­en ma­de on­ly if the pay­ment (whe­ther by che­que or other­wi­se) has be­en credi­ted in­to SAS's de­si­gna­ted bank ac­count.
7.4)

All sums paya­ble by the Purcha­ser un­der each Contract shall be paid free and cle­ar of any de­duc­tions or wi­th­hol­ding, ex­cept as re­qui­red by law. If any such de­duc­tions or wi­th­hol­ding are re­qui­red by law, the Purcha­ser shall pay SAS an amount such that SAS shall re­cei­ve the sums paya­ble un­der SAS's in­voices as if the­re was no such re­qui­re­ment to ma­ke a de­duc­tion or wi­th­hol­ding.
7.5)

If the Purcha­ser de­faults in the pay­ment of any in­voice is­sued by SAS to the Purcha­ser, SAS shall be en­t­it­led to char­ge in­te­rest on such pay­ments in de­fault at the ra­te of 8% per an­num. Such in­te­rest shall be ap­p­lied to the pay­ments in de­fault from the date when such pay­ment is due un­til the date of ac­tu­al pay­ment. Such in­te­rest shall ac­crue from day to day. If the­re are any wi­th­hol­ding ta­xes or de­duc­tions re­qui­red by ap­p­lica­ble law, the Purcha­ser shall pay SAS an amount such that SAS shall re­cei­ve the full in­te­rest pay­ments as if the­re was no such re­qui­re­ment to ma­ke a de­duc­tion or wi­th­hol­ding.
7.6)

(i) If SAS is sa­tis­fied that the­re are cir­cum­stan­ces that call in­to ques­ti­on the Purcha­ser's credit-wort­hi­ness and in par­ti­cu­lar, if the Purcha­ser dis­ho­no­urs a che­que or is in breach of any ob­li­ga­ti­ons to ma­ke pay­ments to SAS un­der the­se Terms and Con­di­ti­ons or (ii) if SAS' credit in­suran­ce de­cli­nes the co­ver­age of the pay­ment re­quest against the Purcha­ser due to the Purcha­ser's lack of credit wort­hi­ness or due to the pay­ment amount ex­cee­ding the in­su­red amount , SAS shall ha­ve the right to de­mand im­me­dia­te pay­ment for any sums which are out­stan­ding un­der the­se Terms and Con­di­ti­ons. In such a ca­se, SAS shall al­so ha­ve the right to de­mand pay­ments in ad­van­ce or pro­vi­si­ons for se­cu­ri­ty. SAS shall then al­so be en­t­it­led to claim a ti­me ex­ten­si­on for the de­li­very of the goods and de­li­ver the goods on­ly if ad­van­ce pay­ment has be­en ma­de or if ade­qua­te se­cu­ri­ty has be­en ma­de be­fo­re the de­li­very of the goods.


§ 8 Chan­ges in De­sign 
SAS re­ser­ves the right to un­der­ta­ke chan­ges in de­sign at any ti­me for com­p­li­an­ce with safe­ty re­gu­la­ti­ons or laws or for re­a­sons of im­pro­ve­ments to the de­sign.

§ 9 De­fects 
9.1)

Goods are de­li­ver­ed free of de­fects in the ma­te­ri­als and fa­bri­ca­ting pro­ces­ses con­cer­ned.
9.2)

The Purcha­ser shall im­me­dia­te­ly no­ti­fy SAS in wri­ting of any de­fects in the goods, at the la­test wi­t­hin one (1) week af­ter the Purcha­ser ta­kes de­li­very of the goods. For de­fects that are not pos­si­ble to de­tect wi­t­hin the said one (1) week even af­ter ca­re­ful in­spec­tion, such de­fects shall be re­por­ted im­me­dia­te­ly in wri­ting to SAS on­ce they are dis­co­ver­ed.
9.3)

Claims by the Purcha­ser on ac­count of any de­fect in the goods shall on­ly be per­mit­ted pro­vi­ded the Purcha­ser no­ti­fies SAS in wri­ting of such claims wi­t­hin 12 months of the date of de­li­very of the goods.
9.4)

Upon such no­ti­fi­ca­ti­on, SAS shall be en­t­it­led, at its ab­so­lu­te dis­cre­ti­on, to eit­her re­pair or re­place the de­fec­tive goods pro­vi­ded that such de­fects shall ha­ve be­en found to SAS' re­a­sonable sa­tis­fac­tion to ha­ve ari­sen from SAS' faul­ty de­sign, work­manship or ma­te­ri­als. Upon the re­quest of SAS, the de­fec­tive goods shall be re­tur­ned to SAS' pre­mi­ses at the Purcha­ser's ex­pen­se. Any re­pai­red or re­pla­ced good shall be re­de­li­ver­ed by SAS free of char­ge to the ori­gi­nal point of de­li­very but other­wi­se in ac­cor­dance with and sub­ject to the­se Terms and Con­di­ti­ons sa­ve that the pe­ri­od of 12 months re­fer­red to in Clau­se 9.3) shall be re­pla­ced by the un­ex­pi­red por­ti­on of that pe­ri­od on­ly.
9.5)

Ex­cept for the ex­press re­pre­sen­ta­ti­ons and war­ran­ties set out her­ein, SAS does not ma­ke any other ex­press or im­plied re­pre­sen­ta­ti­ons or war­ran­ties, in fact or in law, in­clu­ding wi­thout li­mi­ta­ti­on, any ex­press or im­plied war­ran­ties of qua­li­ty or fit­ness for a par­ti­cu­lar pur­po­se. Ex­cept as ex­press­ly pro­vi­ded her­ein, all re­pre­sen­ta­ti­ons, war­ran­ties, terms, con­di­ti­ons, un­der­ta­kings or in­du­ce­ments whe­ther ex­press, im­plied, sta­tu­to­ry, un­der com­mon law or other­wi­se re­la­ting in any way to the goods, are her­e­by ex­clu­ded to the fullest extent per­mit­ted by law.

§ 10 Lia­bi­li­ty
10.1)

SAS shall not be lia­ble to the Purcha­ser by re­a­son of any re­pre­sen­ta­ti­on (un­less frau­du­lent), or any other con­di­ti­ons, war­ran­ties, sti­pu­la­ti­ons or other state­ments whatsoever con­cerning the goods, whe­ther ex­press or im­plied, by sta­tu­te, at com­mon law or other­wi­se how­soever, for loss of pro­fit or for any in­di­rect, spe­cial or con­se­quen­ti­al loss or da­ma­ge, costs, ex­pen­ses or other claims for com­pen­sa­ti­on whatsoever (whe­ther cau­sed by the ne­gli­gence of SAS, its em­ployees or agents or other­wi­se) which ari­se out of or in con­nec­tion with the sup­p­ly of the goods (in­clu­ding any de­lay in sup­p­ly­ing or any failu­re to sup­p­ly the goods in ac­cor­dance with the­se Terms and Con­di­ti­ons or at all) or their use or resa­le by the Purcha­ser, and the ent­i­re lia­bi­li­ty of SAS un­der or in con­nec­tion with the­se Terms and Con­di­ti­ons shall not ex­ceed the contract pri­ce of the goods, un­less ex­press­ly pro­vi­ded other­wi­se in the­se Terms and Con­di­ti­ons.
10.2)

Claims for com­pen­sa­ti­on in da­mages are, ir­re­spec­tive of the ty­pe of breach of du­ty, in­clu­ding un­aut­ho­ri­sed acts, ex­clu­ded, un­less in­ten­tio­nal or gross­ly ne­gli­gent acts are in­vol­ved. With re­spect to the ex­clu­si­on or li­mi­ta­ti­on of lia­bi­li­ty un­der the­se Terms and Con­di­ti­ons, de­ath or per­so­nal in­ju­ry cau­sed by SAS' ne­gli­gence shall not be ex­clu­ded.
10.3)

To the extent that SAS' lia­bi­li­ty is li­mi­ted or ex­clu­ded, the sa­me ap­p­lies to SAS' em­ployees, workers, re­pre­sen­ta­ti­ve and its agents. 

§ 11 Con­fi­den­tia­li­ty
Un­less other­wi­se ex­pres­sed or de­si­gna­ted as con­fi­den­ti­al by the Purcha­ser and/ or SAS, in­for­ma­ti­on dis­clo­sed by the Purcha­ser to SAS in con­nec­tion with an or­der for goods is not con­side­red con­fi­den­ti­al in­for­ma­ti­on.

§ 12 Ge­ne­ral Pro­vi­si­ons
12.1)

The­se Terms and Con­di­ti­ons shall be go­ver­ned by and con­strued in ac­cor­dance with the laws of Sin­g­a­po­re. The United Na­ti­ons Con­ven­ti­on on Contracts for the In­ter­na­tio­nal Sa­le of Goods (CISG) shall not ap­p­ly to the­se Terms and Con­di­ti­ons.
12.2)

The par­ties her­e­by sub­mit to the non-ex­clu­si­ve ju­ris­dic­tion of the Sin­g­a­po­re courts.
12.3)

The in­va­li­di­ty, il­le­ga­li­ty or un­en­force­a­bi­li­ty for any re­a­son of any part of the­se terms and con­di­ti­ons shall not pre­ju­di­ce or af­fect the va­li­di­ty, le­ga­li­ty or en­force­a­bi­li­ty of the re­mai­ning terms.
12.4)

No failu­re on the part of eit­her par­ty to ex­er­cise any rights, nor any de­lay in ex­er­cising any rights, un­der the­se Terms and Con­di­ti­ons at any ti­me shall con­sti­tu­te a wai­ver of the­se Terms and Con­di­ti­ons nor shall any sin­gle or par­ti­al ex­er­cise of any right un­der the­se Terms and Con­di­ti­ons pre­clu­de any other or fur­ther ex­er­cise of any other right.
12.5)

Un­less other­wi­se ex­press­ly sta­ted, the elec­tion by eit­her par­ty of a par­ti­cu­lar reme­dy in the event of de­fault by the other par­ty shall not be ex­clu­si­ve of any other reme­dy and all rights and re­me­di­es of the par­ties here­to shall be cu­mu­la­ti­ve and not ex­haus­ti­ve of any other rights or re­me­di­es pro­vi­ded by the law.
12.6)

The Purcha­ser shall not wi­thout the pri­or writ­ten con­sent of SAS as­sign trans­fer or sub-contract the rights or ob­li­ga­ti­ons un­der the­se Terms and Con­di­ti­ons or any part of the­se Terms and Con­di­ti­ons.
12.7)

SAS may as­sign trans­fer or sub-contract the­se Terms and Con­di­ti­ons or any part the­re­of to any other per­son or com­pa­ny.
12.8)

A per­son who is not a par­ty to the­se Terms and Con­di­ti­ons has no right un­der the Contracts (Rights of Third Par­ties) Act , Chap­ter 53B to en­force any term of the­se Terms and Con­di­ti­ons but this does not af­fect any right or reme­dy of a third par­ty which exists or is avail­able apart from that Act.

© SAS Asia Bar Systems Pte. Ltd.
  • Terms and Conditions
  • Data Privacy
Partnerlogo UkasPartnerlogo Biz Safe
  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    • Restore to current request
    • biz-safe
    • home/contact
    • home
    • home
    ====
  • Session
    +

    Session

    • Config(array)
      • userAgentca40b5f22cf3d88f707fb259b2686ed4
      • time1657142321
      • countdown10
      • languageen
    ====
  • Request
    +

    Request

    Cake Params

    • pluginFrontendMenus
    • controllerFrontendMenus
    • actioncontent
    • named(empty)
    • pass(array)
      • 081
    • ids(array)
      • Menu81
      • Content(null)
      • Language2
    • route(array)
      • id217
      • hashede7454fd0d0bc91d0d5ac3c3f11caac
      • created2018-01-23 08:16:34
      • updated2018-01-23 08:16:34
      • modelMenu
      • foreign_key81
      • base/home/
      • aliasterms-and-conditions
      • controllerFrontendMenus.FrontendMenus
      • actioncontent
      • parent_id169
      • lft252
      • rght255
      • route/home/terms-and-conditions
    • isAjax(false)

    Post data

    No post data.

    Query string

    No querystring data.

    Cookie

    To view Cookies, add CookieComponent to Controller

    Current Route

    • keys(empty)
    • options(empty)
    • defaults(array)
      • plugin(null)
      • actionindex
    • template/*
    ====
  • Sql Log
    +

    Sql Logs

    default

    Total Time: 14 ms
    Total Queries: 106 queries
    Query Affected Num. rows Took (ms) Actions
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/home/terms-and-conditions' LIMIT 1 1 1 1
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`lft` <= 252 AND `Route`.`rght` >= 255 ORDER BY `Route`.`lft` asc 4 4 0
    SELECT `Language`.`langid` FROM `sas_asia`.`languages` AS `Language` WHERE `Language`.`id` = 2 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 81 LIMIT 1 1 1 1
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 207 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 1 maybe slow
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published` FROM `sas_asia`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (81) ORDER BY `Content`.`position` asc 1 1 1
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 149 AND `Route`.`model` = 'Content' 1 1 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 52 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 151 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 151 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 52 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 3 3 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (1, 76, 77) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 24 24 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 52 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (54) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 7 7 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 52 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 3 3 0
    SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 14 AND `Menu`.`rght` < 77 ORDER BY `Menu`.`lft` asc 31 31 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 81 LIMIT 1 1 1 1
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 207 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 1 maybe slow
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 81 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 81 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 1 maybe slow
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 81 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`contents` AS `Content` LEFT JOIN `sas_asia`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Teaser`.`show_home` = 1 AND `Language`.`id` = 2 ORDER BY `Teaser`.`updated` desc LIMIT 3 3 3 3
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 234 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 231 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 212 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 234 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (26) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 231 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (25) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 9 9 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 212 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ArticleContentMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (146, 145, 126) AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC 17 17 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (355, 354, 347, 343, 342, 341, 339, 337, 336, 333, 331, 316, 315, 294, 71, 64, 61) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 120 120 0
    SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `GalleryMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (146, 145, 126) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Teaser`.`show_home` = 1 AND `Language`.`id` = 2 ORDER BY `Teaser`.`updated` desc LIMIT 3 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 209 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (62) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 83 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 1 1 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (66) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 8 8 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 83 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 83 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 78 AND `Menu`.`rght` < 83 ORDER BY `Menu`.`lft` asc 2 2 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'firma' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 68 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 167 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 167 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 68 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 91 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 240 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 240 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 91 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 91 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 91 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 91 2 2 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 241 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 242 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 241 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 242 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (92, 93) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (92, 93) AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 2 2 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (59, 58) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 2 2 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` IN (92, 93) AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`languages` AS `Language` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1 1 1 0
    SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `sas_asia`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC 2 2 0
    SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 81 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank` FROM `sas_asia`.`menus` AS `Menu` WHERE `Menu`.`id` = 81 LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 79 AND `Menu`.`rght` >= 80 ORDER BY `Menu`.`lft` asc 3 3 1 maybe slow
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-logos' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 88 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 237 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 237 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 88 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 88 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 88 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 88 2 2 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 238 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 239 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 238 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 239 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (89, 90) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (89, 90) AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 2 2 0
    SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `sas_asia`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (55, 56) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC 14 14 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` IN (89, 90) AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/home/terms-and-conditions/terms-and-conditions' LIMIT 1 1 1 1
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `sas_asia`.`routes` AS `Route` WHERE `Route`.`lft` <= 253 AND `Route`.`rght` >= 254 ORDER BY `Route`.`lft` asc 5 5 1 maybe slow
    SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `sas_asia`.`contents` AS `Content` LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE `Content`.`status` = 'active' AND `Content`.`id` = 149 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1 1 1 1
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 243 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `sas_asia`.`languages` AS `Language` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`id` = 2 LIMIT 1 1 1 0
    SELECT *, Language.id FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `sas_asia`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'en' LIMIT 1 1 1 0
    SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`show_home` FROM `sas_asia`.`menus` AS `Menu` LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `sas_asia`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `sas_asia`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 65 LIMIT 1 1 1 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 164 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `ImageMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 164 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `HeaderImagesMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 65 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `sas_asia`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `sas_asia`.`media` AS `LogoMedia` JOIN `sas_asia`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 65 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo' ORDER BY `MediaEntity`.`pos` ASC 0 0 0
    SELECT `Item`.`id`, `Item`.`hash`, `Item`.`created`, `Item`.`updated`, `Item`.`menu_id`, `Item`.`position`, `Item`.`type`, `Item`.`status`, `Item`.`title`, `Item`.`intern_title`, `Item`.`language_id`, `Item`.`content`, `Item`.`release`, `Item`.`hide`, `Item`.`link`, `Item`.`link_title`, `ItemsMenu`.`id`, `ItemsMenu`.`menu_id`, `ItemsMenu`.`item_id`, `ItemsMenu`.`position` FROM `sas_asia`.`items` AS `Item` JOIN `sas_asia`.`items_menus` AS `ItemsMenu` ON (`ItemsMenu`.`menu_id` = 65 AND `ItemsMenu`.`item_id` = `Item`.`id`) ORDER BY `ItemsMenu`.`position` ASC 0 0 0
    SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1 1 1 0
    SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `sas_asia`.`settings` AS `Setting` LEFT JOIN `sas_asia`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id` 27 27 0
    SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `sas_asia`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC 1 1 0
    SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `sas_asia`.`mount_points` AS `MountPoint` LEFT JOIN `sas_asia`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `sas_asia`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'search-result' LIMIT 1 1 1 0

    Query Explain:

    Click an "Explain" link above, to see the query explanation.

    ====
  • Timer
    +

    Memory

    Peak Memory Use 20.51 MB

    Message Memory use
    Component initialization 7.19 MB
    Controller action start 7.41 MB
    Controller render start 9.99 MB
    Component initialization #2 14.54 MB
    Controller action start #2 14.72 MB
    Controller render start #2 14.87 MB
    View render complete 15.93 MB

    Timers

    Total Request Time: 567 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 168.25
    Event: Controller.initialize 4.61
    Event: Controller.startup 1.15
    Controller action 60.37
    Event: Controller.beforeRender 131.85
    » Processing toolbar data 27.62
    Rendering View 73.07
    » Event: View.beforeRender 0.06
    » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php 38.61
    » » Event: Controller.initialize #2 0.95
    » » Event: Controller.startup #2 0.45
    » » Controller action #2 4.20
    » » Event: Controller.beforeRender #2 13.47
    » » » Processing toolbar data #2 13.28
    Rendering View #2 0.00
    » » » Event: View.beforeRender #2 0.06
    » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php 5.70
    » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php 0.51
    » » » Event: View.afterRender 0.05
    » » » Event: Controller.shutdown 0.03
    » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2 0.40
    » » Event: View.afterRender #2 10.08
    » » Event: View.beforeLayout 0.05
    » » Rendering APP/View/Layouts/index.php 20.87
    » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php 11.70
    Event: View.afterLayout 0.00
    ====
  • Log
    +

    Logs

    There were no log entries made this request

    ====
  • Variables
    +

    View Variables

    • row(array)
      • Menu(array)
        • id81
        • hash88b81d072766229e90ee88b7c0177a62
        • created2018-01-23 08:16:34
        • updated2018-01-23 08:16:34
        • parent_id61
        • lft79
        • rght80
        • language_id2
        • typecontent
        • titleTerms and Conditions
        • previous_url(null)
        • url(null)
        • target_blank(false)
      • Seo(array)
        • id207
        • hash00895fb2e6e381a38e09a7b536e6c730
        • created2018-01-23 08:16:34
        • updated2018-01-23 08:16:34
        • modelMenu
        • foreign_key81
        • titleTerms and Conditions
        • description
        • author
        • tw_creator
        • fb_author
        • robots3
        • ImageMedia(empty)
      • Content(array)
        • 0(array)
          • id149
          • hashcc4b1cf1ac9c0360ba99d291d0729118
          • created2018-10-01 11:03:33
          • updated2018-10-01 11:03:45
          • menu_id81
          • position1
          • typearticle
          • statusactive
          • titleTerms and Conditions
          • layoutcol12
          • language_id2
          • article_content<h1>General Terms and Conditions of Business</h1> <p>§ 1 Scope of the con­di­ti­ons<br /> 1.1)</p> <p>The­se Ge­ne­ral Terms and Con­di­ti­ons of Busi­ness (the "Terms and Con­di­ti­ons") shall ap­p­ly ex­clu­si­ve­ly to the de­li­very of goods and the pro­vi­si­on of ser­vices by SAS Asia Bar Sys­tems Pte. Ltd. ("SAS") to the purcha­ser (the "Purcha­ser"). The­se Terms and Con­di­ti­ons al­so ap­p­ly to all fu­ture busi­ness re­la­ti­ons­hips bet­ween SAS and the Purcha­ser, even if the par­ties ha­ve not ex­press­ly agreed to the­se Terms and Con­di­ti­ons. The term "par­ties" shall hence­forth re­fer collec­tive­ly to both SAS and the Purcha­ser and the term "par­ty" shall re­fer to each of the par­ties. The term "goods" in the­se Terms and Con­di­ti­ons shall re­fer to the goods to be de­li­ver­ed by SAS to the Purcha­ser.<br /> 1.2)</p> <p>The­se Terms and Con­di­ti­ons shall not ap­p­ly to con­su­mers who are in­di­vi­du­als, who purcha­se goods (not as de­fi­ned her­ein) and ser­vices (not as de­fi­ned her­ein) in ge­ne­ral, other­wi­se than ex­clu­si­ve­ly in the cour­se of busi­ness.<br /> 1.3)</p> <p>The Purcha­ser shall be re­s­pon­si­ble for en­su­ring com­p­li­an­ce with ap­p­lica­ble laws and re­gu­la­ti­ons (in­clu­ding work safe­ty and en­vi­ron­men­tal re­gu­la­ti­ons) in con­nec­tion with the use of goods sup­p­lied by SAS to the Purcha­ser.<br /> <br /> § 2 Quo­ta­ti­ons and En­te­ring in­to Contracts<br /> 2.1)</p> <p>SAS' quo­ta­ti­ons are sub­ject to writ­ten con­fir­ma­ti­on by SAS in all in­stan­ces. Any de­cla­ra­ti­ons or con­fir­ma­ti­on of ac­cep­tan­ce and any or­der pla­ced by the Purcha­ser must be ul­ti­mate­ly con­fir­med by SAS in wri­ting (by let­ter, fax or elec­tro­nic mail) in or­der for them to be le­gal­ly va­lid and bin­ding on the par­ties. Each or­der so ac­cep­ted or con­fir­med by SAS shall be upon the­se Terms and Con­di­ti­ons and shall con­sti­tu­te an in­di­vi­du­al le­gal­ly bin­ding contract bet­ween SAS and the Purcha­ser and such contract is her­einaf­ter re­fer­red to as a "Contract".<br /> 2.2)</p> <p>The­se Terms and Con­di­ti­ons shall over­ri­de any con­tra­ry, dif­fe­rent or ad­di­tio­nal terms (if any) con­tai­ned on or re­fer­red to in an or­der form or other do­cu­ments or cor­re­spon­dence from the Purcha­ser, and no ad­di­ti­on, al­te­ra­ti­on or sub­sti­tu­ti­on of the­se terms will bind SAS or form part of the Contract un­less they are ex­press­ly ac­cep­ted in wri­ting by an aut­ho­ri­sed per­son­nel of SAS.<br /> 2.3)</p> <p>All goods sup­p­lied by SAS shall be in ac­cor­dance with the cur­rent edi­ti­on of the re­le­vant pro­duct de­scrip­ti­on in SAS' bro­chu­res or pu­bli­ca­ti­on (whe­ther the­se are in print, elec­tro­nic form, on­line or in any other form of me­dia or plat­form) as pu­blis­hed from ti­me to ti­me by SAS on its web­site (if so ap­p­lica­ble to the goods). Any other goods which are not de­scri­bed on the said web­site shall be in ac­cor­dance with the spe­ci­fi­ca­ti­ons, drawings and/or de­scrip­ti­ons set out in the or­der form as agreed by SAS. SAS shall not be de­emed to be ma­king any re­pre­sen­ta­ti­ons as to the goods in any ex­ch­an­ge of in­for­ma­ti­on, cor­re­spon­dence and/or do­cu­men­ta­ti­on bet­ween the par­ties. No other spe­ci­fi­ca­ti­on, de­scrip­ti­ve ma­te­ri­al, writ­ten or oral re­pre­sen­ta­ti­on, cor­re­spon­dence or state­ment, pro­mo­tio­nal or sa­les li­te­ra­tu­re shall form part of or be in­cor­po­ra­ted in­to the Contract.<br /> 2.4)</p> <p>SAS re­ser­ves all rights of ow­nership and in­tel­lec­tu­al pro­per­ty rights (in­clu­ding co­py­right, de­sign rights, trade­mark rights and pa­tent rights) in and to the cost esti­ma­tes, drawings and other in­for­ma­ti­on, in any form or me­dia, which are pro­vi­ded to the Purcha­ser.<br /> <br /> § 3 Pri­ces<br /> 3.1)</p> <p>Un­less other­wi­se agreed in wri­ting by the par­ties, pri­ces sta­ted in SAS' quo­ta­ti­on shall be va­lid for a pe­ri­od of 30 days from the date of such quo­ta­ti­on. The ap­p­lica­ble pri­ces shall be the pri­ces sta­ted in the or­der con­fir­ma­ti­on. Whe­re ap­p­lica­ble, tur­no­ver tax, va­lue ad­ded tax or goods and ser­vices tax at the cur­rent sta­tu­to­ry ra­te (as the ca­se may be) shall be ad­ded to the­se pri­ces. Pri­ces shall in­clu­de de­li­very and ser­vices (if so ap­p­lica­ble) and shall be con­fir­med by SAS in wri­ting.<br /> 3.2)</p> <p>Un­less other­wi­se agreed in wri­ting by the par­ties, pri­ces shall be on an ex-works ba­sis (as de­fi­ned in the In­coterms ® 2010).<br /> 3.3)</p> <p>SAS re­ser­ves the right to in­crea­se or lo­wer pri­ces to the extent that the "scrap and al­loy­ing sup­ple­ment" chan­ges. The ap­p­lica­ble pri­ce shall be the pri­ce sta­ted on SAS' web­site, i.e., www.sas-asia.sg on the date of de­li­very of the goods.<br /> <br /> § 4 De­li­very and Per­for­mance<br /> 4.1)</p> <p>De­li­very of the goods by SAS shall be ba­sed on the re­le­vant In­coterm (in ac­cor­dance with In­coterms®2010) sta­ted in our quo­ta­ti­on and as con­fir­med by us.<br /> 4.2)</p> <p>On­ly tho­se de­li­very dead­lines spe­ci­fied in the writ­ten or­der con­fir­ma­ti­on by SAS shall be ap­p­lica­ble. All other de­li­very dead­lines in­di­ca­ted by SAS shall be non-bin­ding un­less ex­press­ly spe­ci­fied in wri­ting by SAS. A de­li­very pe­ri­od be­gins, at the ear­liest, upon con­fir­ma­ti­on of the or­der by SAS.<br /> 4.3)</p> <p>The de­li­very pe­ri­od is on­ly de­emed to ha­ve com­men­ced when the Purcha­ser has sub­mit­ted the re­qui­red do­cu­men­ta­ti­on to SAS ac­cor­ding to the agreed ti­me­li­nes.<br /> 4.4)</p> <p>SAS shall not be un­der any lia­bi­li­ty for any failu­re to per­form any of its ob­li­ga­ti­ons un­der the Contract due to Force Ma­jeu­re. Fol­lo­wing no­ti­fi­ca­ti­on from SAS to the Purcha­ser of such cau­se, SAS shall be al­lo­wed a re­a­sonable ex­ten­si­on of ti­me plus an ap­pro­pria­te start-up pe­ri­od for the per­for­mance of its ob­li­ga­ti­ons. If the pe­ri­od of Force Ma­jeu­re ex­ceeds 90 ca­len­dar days, SAS shall be en­t­it­led to ter­mi­na­te the Contract by gi­ving the Purcha­ser 7 days' (being such 7 ca­len­dar days af­ter the ex­pi­ry of the afo­re­said 90 days) writ­ten no­ti­ce, whe­reu­pon SAS shall be di­sch­ar­ged from its ob­li­ga­ti­ons un­der the Contract. In the event of a ter­mi­na­ti­on of the Contract as de­scri­bed in this Clau­se, the Purcha­ser shall not be en­t­it­led to any claims for com­pen­sa­ti­on in da­mages if the ti­me for de­li­very was ex­ten­ded or if SAS is no lon­ger ob­li­ged to de­li­ver the goods to the Purcha­ser.<br /> For the pur­po­ses of this clau­se 4.4), "Force Ma­jeu­re" me­ans fi­re, ex­plo­si­on, flood, light­ning, Act of God, act of ter­ro­rism, war, re­bel­li­on, ri­ot, sa­bo­ta­ge, strikes, lock-outs, la­bour dis­pu­tes, a shor­ta­ge of sup­p­ly of goods to SAS from its upstream sup­p­liers, a de­lay in the sup­p­ly of goods to SAS from its upstream sup­p­liers, of­fi­ci­al di­rec­tives or events or cir­cum­stan­ces outs­ide the re­a­sonable con­trol of SAS.<br /> 4.5)</p> <p>If SAS is un­able to com­ply with the de­li­very dead­lines or de­li­very pe­ri­ods, the Purcha­ser is en­t­it­led to claim com­pen­sa­ti­on of 0.5% of the in­voice va­lue for every full week of de­lay, up to a ma­xi­mum of 5% of the in­voice va­lue of the de­li­very. SAS' lia­bi­li­ty towards the Purcha­ser with re­spect to non-com­p­li­an­ce with de­li­very dead­lines or de­li­very pe­ri­od shall be li­mi­ted to the com­pen­sa­ti­on sum set out in this Clau­se.<br /> 4.6)</p> <p>SAS has the right to ma­ke par­ti­al de­li­ve­ries of the goods and to ren­der par­ti­al per­for­man­ces un­less other­wi­se agreed in wri­ting with the Purcha­ser.<br /> <br /> § 5 Trans­fer of Risk<br /> 5.1)</p> <p>Risk of da­ma­ge to or loss to the goods shall pass (and even in the ca­se of dis­patch which is de­lay­ed) ac­cor­ding to the re­le­vant In­coterm (in ac­cor­dance with In­coterms®2010) na­med in the writ­ten or­der con­fir­ma­ti­on which has be­en agreed upon by SAS.<br /> 5.2)</p> <p>If the Purcha­ser de­lays in ta­king de­li­very of the goods, SAS shall then ha­ve the right to de­mand reim­bur­se­ment for any loss of the goods ari­sing from such de­lay. The risk of ac­ci­den­tal de­te­rio­ra­ti­on and ac­ci­den­tal de­struc­tion of the goods pas­ses to the Purcha­ser if the Purcha­ser de­lays in ta­king de­li­very of such goods. In the event that (i) the Purcha­ser de­lays in ta­king de­li­very of the goods de­s­pi­te being gi­ven a two-week gra­ce pe­ri­od by SAS or (ii) the Purcha­ser sus­pends its pay­ments due to SAS hereun­der or (iii) the Purcha­ser be­co­mes in­sol­vent or be­co­mes bur­de­ned by ex­ces­si­ve debt, SAS shall be en­t­it­led to im­me­dia­te­ly de­mand pay­ment<br /> for the purcha­se pri­ce of the goods or to ter­mi­na­te the Contract and the Purcha­ser shall be lia­ble for any da­mages in con­nec­tion with such ter­mi­na­ti­on.<br /> <br /> § 6 Re­ten­ti­on of Tit­le<br /> 6.1)</p> <p>SAS shall re­tain tit­le in the goods un­til all pay­ments and each and every claim un­der every Contract has be­en re­cei­ved by SAS.<br /> 6.2)</p> <p>The Purcha­ser is en­t­it­led to pro­cess and dis­po­se of the goods sold in the nor­mal cour­se of its busi­ness sub­ject al­ways to the re­ten­ti­on of tit­le by SAS and pro­vi­ded the Purcha­ser is not in ar­re­ars of any pay­ments due and owing to SAS un­der any Contract. The Purcha­ser shall not sell, pledge, mort­ga­ge or other­wi­se deal with the goods as se­cu­ri­ty. The Purcha­ser her­e­by as­signs to SAS in ad­van­ce all claims on the Purcha­ser's cust­o­m­ers or third par­ties in con­nec­tion with the resa­le of the goods, re­gard­less of whe­ther the goods are sold in a pro­ces­sed or un­pro­ces­sed con­di­ti­on. SAS her­e­by aut­ho­ri­ses the Purcha­ser the right to collect such claims for and on be­half of SAS ex­cept that such aut­ho­ri­sa­ti­on shall be re­vo­ked by SAS if the Purcha­ser does not com­ply with its pay­ment ob­li­ga­ti­ons her­ein. The Purcha­ser shall ad­vi­se SAS of the as­si­gned claims and the re­le­vant debtors, pro­vi­de no­ti­ce to the re­le­vant debtors of such as­si­gn­ment and pro­vi­de all ne­cessa­ry in­for­ma­ti­on to SAS to enable SAS to ef­fect collec­tion of such claims. If the goods are re­sold to­ge­ther with other goods not sup­p­lied by SAS, the Purcha­ser's claim on his end cust­o­m­er shall be de­emed to ha­ve be­en as­si­gned to SAS to the amount of the contract pri­ce agreed upon bet­ween SAS and the Purcha­ser for such goods of SAS.<br /> 6.3)</p> <p>The Purcha­ser shall en­su­re that the pro­ces­sing or con­ver­si­on of the goods shall be sub­ject to SAS' re­ten­ti­on of tit­le ("SAS' pro­prieta­ry goods"). If SAS' pro­prieta­ry goods are pro­ces­sed or ins­e­pa­ra­b­ly com­bi­ned with other items not in SAS' pos­ses­si­on, then SAS be­co­mes the co-ow­ner of the­se pro­ces­sed or com­bi­ned goods from the ti­me of such pro­ces­sing or com­bi­na­ti­on. If SAS' pro­prieta­ry goods are in­te­gra­ted or ins­e­pa­ra­b­ly com­bi­ned with other mova­ble ob­jects and if the other ob­ject is re­gar­ded as con­sti­tu­ting the prin­ci­pal ob­ject, the Purcha­ser is de­emed to ha­ve trans­fer­red his right of co-ow­nership to SAS pro­vi­ded the prin­ci­pal ob­ject be­longs to the Purcha­ser. In such a ca­se, the Purcha­ser holds the right of ow­nership or co-ow­nership on SAS' be­half. In all other re­spects, the ob­ject pro­du­ced by pro­ces­sing, con­ver­si­on, com­bi­na­ti­on or in­te­gra­ti­on is sub­ject to the sa­me con­di­ti­on as SAS' pro­prieta­ry goods.<br /> 6.4)</p> <p>In the event of a de­fault by the Purcha­ser, the com­men­ce­ment of in­sol­vency pro­cee­dings or sei­zu­re with re­spect to the Purcha­ser, SAS shall be en­t­it­led to re­co­ver the goods sub­ject to the re­ten­ti­on of tit­le wi­thout the Purcha­ser being able to ma­ke any claims against SAS, e.g. tre­spas­sing of pro­per­ty. In the ca­se of third par­ties ob­tai­ning ac­cess to the goods sold sub­ject to the re­ten­ti­on of tit­le and in par­ti­cu­lar, in the ca­se of le­vies of exe­cu­ti­on, sei­zu­res or other court or­ders, the Purcha­ser shall im­me­dia­te­ly draw at­ten­ti­on to SAS' ow­nership and in­form SAS so as to enable SAS to en­force its right of ow­nership over the goods. The Purcha­ser shall be lia­ble for all costs that may ari­se in con­nec­tion with SAS en­for­cing its rights her­ein.<br /> 6.5)</p> <p>In the event of a breach of the Contract, and in par­ti­cu­lar, in the event of a de­lay in pay­ment by the Purcha­ser un­der the Contract, SAS shall ha­ve a right to ter­mi­na­te the Contract and to im­me­dia­te­ly de­mand from the Purcha­ser a lis­ting of the goods which are still in the Purcha­ser's pos­ses­si­on and sub­ject to a re­ten­ti­on of tit­le by SAS, and al­so the extent to which such goods are being pro­ces­sed. The Contract is not ter­mi­na­ted me­rely by SAS ta­king back the goods from the Purcha­ser or the sei­zu­re of goods by an or­der of court.<br /> 6.6)</p> <p>Upon the Purcha­ser's re­quest, SAS shall ha­ve the op­ti­on to re­lease the re­le­vant se­cu­ri­ties to which it is en­t­it­led if their rea­li­sa­ble va­lue per­sis­tent­ly ex­ceeds the va­lue of the claims to be se­cu­red by mo­re than 20%.<br /> <br /> § 7 Pay­ment<br /> 7.1)</p> <p>Un­less other­wi­se agreed in wri­ting bet­ween the par­ties, the Purcha­ser shall ma­ke pay­ment for in­voices ren­de­red by SAS wi­t­hin 21 ca­len­dar days of the date of the in­voice, net (wi­thout any de­duc­tions or wi­th­hol­ding or bank char­ges).<br /> 7.2)</p> <p>SAS re­ser­ves the right to set-off pay­ments ma­de by the Purcha­ser against ear­lier debts in­cur­red by the Purcha­ser in con­nec­tion with any goods or ser­vices purcha­sed by the Purcha­ser. SAS will in­form the Purcha­ser of any set-offs ma­de. If any costs and in­te­rests ha­ve ari­sen, SAS has the right to set the pay­ment off first against such costs, then against such in­te­rests and fi­nal­ly against the prin­ci­pal sum owing by the Purcha­ser to SAS.<br /> 7.3)</p> <p>A pay­ment shall be de­emed to ha­ve be­en ma­de on­ly if the pay­ment (whe­ther by che­que or other­wi­se) has be­en credi­ted in­to SAS's de­si­gna­ted bank ac­count.<br /> 7.4)</p> <p>All sums paya­ble by the Purcha­ser un­der each Contract shall be paid free and cle­ar of any de­duc­tions or wi­th­hol­ding, ex­cept as re­qui­red by law. If any such de­duc­tions or wi­th­hol­ding are re­qui­red by law, the Purcha­ser shall pay SAS an amount such that SAS shall re­cei­ve the sums paya­ble un­der SAS's in­voices as if the­re was no such re­qui­re­ment to ma­ke a de­duc­tion or wi­th­hol­ding.<br /> 7.5)</p> <p>If the Purcha­ser de­faults in the pay­ment of any in­voice is­sued by SAS to the Purcha­ser, SAS shall be en­t­it­led to char­ge in­te­rest on such pay­ments in de­fault at the ra­te of 8% per an­num. Such in­te­rest shall be ap­p­lied to the pay­ments in de­fault from the date when such pay­ment is due un­til the date of ac­tu­al pay­ment. Such in­te­rest shall ac­crue from day to day. If the­re are any wi­th­hol­ding ta­xes or de­duc­tions re­qui­red by ap­p­lica­ble law, the Purcha­ser shall pay SAS an amount such that SAS shall re­cei­ve the full in­te­rest pay­ments as if the­re was no such re­qui­re­ment to ma­ke a de­duc­tion or wi­th­hol­ding.<br /> 7.6)</p> <p>(i) If SAS is sa­tis­fied that the­re are cir­cum­stan­ces that call in­to ques­ti­on the Purcha­ser's credit-wort­hi­ness and in par­ti­cu­lar, if the Purcha­ser dis­ho­no­urs a che­que or is in breach of any ob­li­ga­ti­ons to ma­ke pay­ments to SAS un­der the­se Terms and Con­di­ti­ons or (ii) if SAS' credit in­suran­ce de­cli­nes the co­ver­age of the pay­ment re­quest against the Purcha­ser due to the Purcha­ser's lack of credit wort­hi­ness or due to the pay­ment amount ex­cee­ding the in­su­red amount , SAS shall ha­ve the right to de­mand im­me­dia­te pay­ment for any sums which are out­stan­ding un­der the­se Terms and Con­di­ti­ons. In such a ca­se, SAS shall al­so ha­ve the right to de­mand pay­ments in ad­van­ce or pro­vi­si­ons for se­cu­ri­ty. SAS shall then al­so be en­t­it­led to claim a ti­me ex­ten­si­on for the de­li­very of the goods and de­li­ver the goods on­ly if ad­van­ce pay­ment has be­en ma­de or if ade­qua­te se­cu­ri­ty has be­en ma­de be­fo­re the de­li­very of the goods.</p> <p><br /> § 8 Chan­ges in De­sign <br /> SAS re­ser­ves the right to un­der­ta­ke chan­ges in de­sign at any ti­me for com­p­li­an­ce with safe­ty re­gu­la­ti­ons or laws or for re­a­sons of im­pro­ve­ments to the de­sign.<br /> <br /> § 9 De­fects <br /> 9.1)</p> <p>Goods are de­li­ver­ed free of de­fects in the ma­te­ri­als and fa­bri­ca­ting pro­ces­ses con­cer­ned.<br /> 9.2)</p> <p>The Purcha­ser shall im­me­dia­te­ly no­ti­fy SAS in wri­ting of any de­fects in the goods, at the la­test wi­t­hin one (1) week af­ter the Purcha­ser ta­kes de­li­very of the goods. For de­fects that are not pos­si­ble to de­tect wi­t­hin the said one (1) week even af­ter ca­re­ful in­spec­tion, such de­fects shall be re­por­ted im­me­dia­te­ly in wri­ting to SAS on­ce they are dis­co­ver­ed.<br /> 9.3)</p> <p>Claims by the Purcha­ser on ac­count of any de­fect in the goods shall on­ly be per­mit­ted pro­vi­ded the Purcha­ser no­ti­fies SAS in wri­ting of such claims wi­t­hin 12 months of the date of de­li­very of the goods.<br /> 9.4)</p> <p>Upon such no­ti­fi­ca­ti­on, SAS shall be en­t­it­led, at its ab­so­lu­te dis­cre­ti­on, to eit­her re­pair or re­place the de­fec­tive goods pro­vi­ded that such de­fects shall ha­ve be­en found to SAS' re­a­sonable sa­tis­fac­tion to ha­ve ari­sen from SAS' faul­ty de­sign, work­manship or ma­te­ri­als. Upon the re­quest of SAS, the de­fec­tive goods shall be re­tur­ned to SAS' pre­mi­ses at the Purcha­ser's ex­pen­se. Any re­pai­red or re­pla­ced good shall be re­de­li­ver­ed by SAS free of char­ge to the ori­gi­nal point of de­li­very but other­wi­se in ac­cor­dance with and sub­ject to the­se Terms and Con­di­ti­ons sa­ve that the pe­ri­od of 12 months re­fer­red to in Clau­se 9.3) shall be re­pla­ced by the un­ex­pi­red por­ti­on of that pe­ri­od on­ly.<br /> 9.5)</p> <p>Ex­cept for the ex­press re­pre­sen­ta­ti­ons and war­ran­ties set out her­ein, SAS does not ma­ke any other ex­press or im­plied re­pre­sen­ta­ti­ons or war­ran­ties, in fact or in law, in­clu­ding wi­thout li­mi­ta­ti­on, any ex­press or im­plied war­ran­ties of qua­li­ty or fit­ness for a par­ti­cu­lar pur­po­se. Ex­cept as ex­press­ly pro­vi­ded her­ein, all re­pre­sen­ta­ti­ons, war­ran­ties, terms, con­di­ti­ons, un­der­ta­kings or in­du­ce­ments whe­ther ex­press, im­plied, sta­tu­to­ry, un­der com­mon law or other­wi­se re­la­ting in any way to the goods, are her­e­by ex­clu­ded to the fullest extent per­mit­ted by law.<br /> <br /> § 10 Lia­bi­li­ty<br /> 10.1)</p> <p>SAS shall not be lia­ble to the Purcha­ser by re­a­son of any re­pre­sen­ta­ti­on (un­less frau­du­lent), or any other con­di­ti­ons, war­ran­ties, sti­pu­la­ti­ons or other state­ments whatsoever con­cerning the goods, whe­ther ex­press or im­plied, by sta­tu­te, at com­mon law or other­wi­se how­soever, for loss of pro­fit or for any in­di­rect, spe­cial or con­se­quen­ti­al loss or da­ma­ge, costs, ex­pen­ses or other claims for com­pen­sa­ti­on whatsoever (whe­ther cau­sed by the ne­gli­gence of SAS, its em­ployees or agents or other­wi­se) which ari­se out of or in con­nec­tion with the sup­p­ly of the goods (in­clu­ding any de­lay in sup­p­ly­ing or any failu­re to sup­p­ly the goods in ac­cor­dance with the­se Terms and Con­di­ti­ons or at all) or their use or resa­le by the Purcha­ser, and the ent­i­re lia­bi­li­ty of SAS un­der or in con­nec­tion with the­se Terms and Con­di­ti­ons shall not ex­ceed the contract pri­ce of the goods, un­less ex­press­ly pro­vi­ded other­wi­se in the­se Terms and Con­di­ti­ons.<br /> 10.2)</p> <p>Claims for com­pen­sa­ti­on in da­mages are, ir­re­spec­tive of the ty­pe of breach of du­ty, in­clu­ding un­aut­ho­ri­sed acts, ex­clu­ded, un­less in­ten­tio­nal or gross­ly ne­gli­gent acts are in­vol­ved. With re­spect to the ex­clu­si­on or li­mi­ta­ti­on of lia­bi­li­ty un­der the­se Terms and Con­di­ti­ons, de­ath or per­so­nal in­ju­ry cau­sed by SAS' ne­gli­gence shall not be ex­clu­ded.<br /> 10.3)</p> <p>To the extent that SAS' lia­bi­li­ty is li­mi­ted or ex­clu­ded, the sa­me ap­p­lies to SAS' em­ployees, workers, re­pre­sen­ta­ti­ve and its agents. <br /> <br /> § 11 Con­fi­den­tia­li­ty<br /> Un­less other­wi­se ex­pres­sed or de­si­gna­ted as con­fi­den­ti­al by the Purcha­ser and/ or SAS, in­for­ma­ti­on dis­clo­sed by the Purcha­ser to SAS in con­nec­tion with an or­der for goods is not con­side­red con­fi­den­ti­al in­for­ma­ti­on.<br /> <br /> § 12 Ge­ne­ral Pro­vi­si­ons<br /> 12.1)</p> <p>The­se Terms and Con­di­ti­ons shall be go­ver­ned by and con­strued in ac­cor­dance with the laws of Sin­g­a­po­re. The United Na­ti­ons Con­ven­ti­on on Contracts for the In­ter­na­tio­nal Sa­le of Goods (CISG) shall not ap­p­ly to the­se Terms and Con­di­ti­ons.<br /> 12.2)</p> <p>The par­ties her­e­by sub­mit to the non-ex­clu­si­ve ju­ris­dic­tion of the Sin­g­a­po­re courts.<br /> 12.3)</p> <p>The in­va­li­di­ty, il­le­ga­li­ty or un­en­force­a­bi­li­ty for any re­a­son of any part of the­se terms and con­di­ti­ons shall not pre­ju­di­ce or af­fect the va­li­di­ty, le­ga­li­ty or en­force­a­bi­li­ty of the re­mai­ning terms.<br /> 12.4)</p> <p>No failu­re on the part of eit­her par­ty to ex­er­cise any rights, nor any de­lay in ex­er­cising any rights, un­der the­se Terms and Con­di­ti­ons at any ti­me shall con­sti­tu­te a wai­ver of the­se Terms and Con­di­ti­ons nor shall any sin­gle or par­ti­al ex­er­cise of any right un­der the­se Terms and Con­di­ti­ons pre­clu­de any other or fur­ther ex­er­cise of any other right.<br /> 12.5)</p> <p>Un­less other­wi­se ex­press­ly sta­ted, the elec­tion by eit­her par­ty of a par­ti­cu­lar reme­dy in the event of de­fault by the other par­ty shall not be ex­clu­si­ve of any other reme­dy and all rights and re­me­di­es of the par­ties here­to shall be cu­mu­la­ti­ve and not ex­haus­ti­ve of any other rights or re­me­di­es pro­vi­ded by the law.<br /> 12.6)</p> <p>The Purcha­ser shall not wi­thout the pri­or writ­ten con­sent of SAS as­sign trans­fer or sub-contract the rights or ob­li­ga­ti­ons un­der the­se Terms and Con­di­ti­ons or any part of the­se Terms and Con­di­ti­ons.<br /> 12.7)</p> <p>SAS may as­sign trans­fer or sub-contract the­se Terms and Con­di­ti­ons or any part the­re­of to any other per­son or com­pa­ny.<br /> 12.8)</p> <p>A per­son who is not a par­ty to the­se Terms and Con­di­ti­ons has no right un­der the Contracts (Rights of Third Par­ties) Act , Chap­ter 53B to en­force any term of the­se Terms and Con­di­ti­ons but this does not af­fect any right or reme­dy of a third par­ty which exists or is avail­able apart from that Act.</p>
          • contact_content(null)
          • contact_email(null)
          • contact_success(null)
          • contact_error(null)
          • iframe_url(null)
          • iframe_width(null)
          • iframe_height(null)
          • release(null)
          • hide(null)
          • gmap_lat(null)
          • gmap_long(null)
          • gmap_zoom(null)
          • gmap_type(null)
          • gmap_marker(null)
          • video_type(null)
          • video_url(null)
          • developer_template_code(null)
          • teaser_menu_id(null)
          • teaser_external_url(null)
          • teaser_external_target(null)
          • developer_template_css(null)
          • developer_template_js(null)
          • gmap
          • published1
          • Route(array)
            • id253
            • hashef7dc65ad4a41e5da676e2237d24254f
            • created2018-10-01 11:03:33
            • updated2018-10-01 11:03:45
            • modelContent
            • foreign_key149
            • base/home/terms-and-conditions/
            • aliasterms-and-conditions
            • controllerFrontendContents.FrontendContents
            • actionarticle
            • parent_id217
            • lft253
            • rght254
            • route/home/terms-and-conditions/terms-and-conditions
    • $request->data(empty)
    • $this->validationErrors(array)
      • Route(empty)
      • MountPoint(empty)
      • Redirect(empty)
      • Language(empty)
      • Menu(empty)
      • Parent(empty)
      • HeaderImagesMedia(empty)
      • MediaEntity(empty)
      • LogoMedia(empty)
      • Seo(empty)
      • ImageMedia(empty)
      • Teaser(empty)
      • Item(empty)
      • Content(empty)
      • ArticleContentMedia(empty)
      • GalleryMedia(empty)
      • FileUpload(empty)
      • ItemsMenu(empty)
      • FlagUpload(empty)
    • Loaded Helpers(array)
      • 0Html
      • 1Tree
      • 2Upload
      • 3Media
      • 4Route
      • 5Bs3Html
      • 6Form
      • 7SocialMedia
      • 8GMap
      • 9Embed
      • 10Layout
      • 11CookieBar
      • 12Number
      • 13SimpleGraph
      • 14DebugTimer
      • 15Toolbar
      • 16Session
      • 17Js
      • 18HtmlToolbar
    ====
  • Environment
    +

    App Constants

    Constant Value
    MH
    MH_IP
    BACKEND_APP_DIR contrance
    UPLOADS_APP /var/www/vhosts/sas-asia.sg/httpdocs/contrance/
    UPLOAD_TMP_DIR tmp/uploads/

    CakePHP Constants

    Constant Value
    APP /var/www/vhosts/sas-asia.sg/httpdocs/
    APP_DIR httpdocs
    APPLIBS /var/www/vhosts/sas-asia.sg/httpdocs/Lib/
    CACHE /var/www/vhosts/sas-asia.sg/httpdocs/tmp/cache/
    CAKE /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/Cake/
    CAKE_CORE_INCLUDE_PATH /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib
    CORE_PATH /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/
    CAKE_VERSION 2.9.0
    CSS /var/www/vhosts/sas-asia.sg/httpdocs/webroot/css/
    CSS_URL css/
    DS /
    FULL_BASE_URL https://www.sas-asia.sg
    IMAGES /var/www/vhosts/sas-asia.sg/httpdocs/webroot/img/
    IMAGES_URL img/
    JS /var/www/vhosts/sas-asia.sg/httpdocs/webroot/js/
    JS_URL js/
    LOGS /var/www/vhosts/sas-asia.sg/httpdocs/tmp/logs/
    ROOT /var/www/vhosts/sas-asia.sg
    TESTS /var/www/vhosts/sas-asia.sg/httpdocs/Test/
    TMP /var/www/vhosts/sas-asia.sg/httpdocs/tmp/
    VENDORS /var/www/vhosts/sas-asia.sg/vendors/
    WEBROOT_DIR webroot
    WWW_ROOT /var/www/vhosts/sas-asia.sg/httpdocs/webroot/

    PHP Environment

    Environment Variable Value
    Php Version 5.5.38
    User u020939593499
    Home /var/www/vhosts/sas-asia.sg
    Fcgi Role RESPONDER
    Redirect Redirect Unique Id YsXD8QqAb9VLe59fDTXRqAAAAMc
    Redirect Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Redirect Redirect Https on
    Redirect Redirect Status 200
    Redirect Unique Id YsXD8QqAb9VLe59fDTXRqAAAAMc
    Redirect Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Redirect Https on
    Redirect Status 200
    Unique Id YsXD8QqAb9VLe59fDTXRqAAAAMc
    Perl5lib /usr/share/awstats/lib:/usr/share/awstats/plugins
    Https on
    Proxy-nokeepalive 1
    Http Host www.sas-asia.sg
    Http X Real Ip 3.236.221.156
    Http X Accel Internal /internal-nginx-static-location
    Http Connection close
    Http User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
    Http Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Http Accept Language en-US,en;q=0.5
    Http If Modified Since Thu, 20 Jan 2022 18:04:32 GMT
    Http Accept Encoding br,gzip
    Path /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
    Server Signature
    Server Software Apache
    Server Name www.sas-asia.sg
    Server Addr 85.236.63.133
    Server Port 443
    Remote Addr 3.236.221.156
    Document Root /var/www/vhosts/sas-asia.sg/httpdocs
    Request Scheme https
    Context Prefix
    Context Document Root /var/www/vhosts/sas-asia.sg/httpdocs
    Server Admin root@localhost
    Script Filename /var/www/vhosts/sas-asia.sg/httpdocs/webroot/index.php
    Remote Port 39646
    Redirect Url /webroot/home/terms-and-conditions
    Gateway Interface CGI/1.1
    Server Protocol HTTP/1.0
    Request Method GET
    Query String
    Request Uri /home/terms-and-conditions
    Script Name /webroot/index.php
    Php Self /webroot/index.php
    Request Time Float 1657127921.7273
    Request Time 1657127921
    ====
  • Include
    +

    Included Files

    Include Paths

    • 1/opt/plesk/php/5.5/share/pear
    • 2-> /var/www/vhosts/sas-asia.sg/httpdocs/contrance/Vendor/Cake/lib/Cake/

    Included Files

    • core(empty)
    • app(array)
      • Behavior(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
      • Cache(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
      • Component(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
      • Config(array)
        • 0APP/Config/core.php
        • 1APP/Config/bootstrap.php
        • 2APP/Config/routes.php
        • 3APP/Config/database.php
        • 4APP/contrance/Config/database.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
      • Controller(array)
        • 0APP/Controller/AppController.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
      • Datasource(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
      • Error(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
      • I18n(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
      • Log(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
      • Model(array)
        • 0APP/Model/AppModel.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
      • Network(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
      • Other(array)
        • 0APP/webroot/index.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/basics.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
        • 6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
        • 7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
        • 8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
        • 9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
      • Routing(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
        • 5APP/Lib/Routing/Route/AliasRoute.php
        • 6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
      • Utility(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
        • 1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
        • 2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
        • 3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
        • 4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
        • 5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
      • View(array)
        • 0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
    • plugins(array)
      • Audit(array)
        • Behavior(array)
          • 0Audit/Model/Behavior/AuditableBehavior.php
      • BaseData(array)
        • Model(array)
          • 0BaseData/Model/BaseDataAppModel.php
        • Behavior(array)
          • 0BaseData/Model/Behavior/AdvancedContainableBehavior.php
          • 1BaseData/Model/Behavior/EssentialBehavior.php
          • 2BaseData/Model/Behavior/SearchBehavior.php
          • 3BaseData/Model/Behavior/HashBehavior.php
          • 4BaseData/Model/Behavior/DateTimeBehavior.php
          • 5BaseData/Model/Behavior/NullableBehavior.php
          • 6BaseData/Model/Behavior/EnumBehavior.php
          • 7BaseData/Model/Behavior/SwitchableBehavior.php
          • 8BaseData/Model/Behavior/BitMaskBehavior.php
          • 9BaseData/Model/Behavior/LayoutBehavior.php
          • 10BaseData/Model/Behavior/HabtmBehavior.php
          • 11BaseData/Model/Behavior/ListBehavior.php
      • BaseTree(array)
        • Model(array)
          • 0BaseTree/Model/BaseTreeAppModel.php
      • Contents(array)
        • Model(array)
          • 0Contents/Model/Content.php
          • 1Contents/Model/ContentsAppModel.php
      • DebugKit(array)
        • Component(array)
          • 0DebugKit/Controller/Component/ToolbarComponent.php
        • Plugin(array)
          • 0DebugKit/Lib/DebugMemory.php
          • 1DebugKit/Lib/Panel/HistoryPanel.php
          • 2DebugKit/Lib/DebugPanel.php
          • 3DebugKit/Lib/Panel/SessionPanel.php
          • 4DebugKit/Lib/Panel/RequestPanel.php
          • 5DebugKit/Lib/Panel/SqlLogPanel.php
          • 6DebugKit/Lib/Panel/TimerPanel.php
          • 7DebugKit/Lib/Panel/LogPanel.php
          • 8DebugKit/Lib/Log/Engine/DebugKitLog.php
          • 9DebugKit/Lib/Panel/VariablesPanel.php
          • 10DebugKit/Lib/Panel/EnvironmentPanel.php
          • 11DebugKit/Lib/Panel/IncludePanel.php
          • 12DebugKit/Lib/DebugTimer.php
      • FrontendMenus(array)
        • Controller(array)
          • 0FrontendMenus/Controller/FrontendMenusController.php
          • 1FrontendMenus/Controller/FrontendMenusAppController.php
      • FrontendUploads(array)
        • Config(array)
          • 0FrontendUploads/Config/routes.php
      • FrontendUtils(array)
        • Config(array)
          • 0FrontendUtils/Config/bootstrap.php
          • 1FrontendUtils/Config/routes.php
        • Plugin(array)
          • 0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
      • Items(array)
        • Model(array)
          • 0Items/Model/Item.php
          • 1Items/Model/ItemsAppModel.php
      • Languages(array)
        • Behavior(array)
          • 0Languages/Model/Behavior/LanguageBehavior.php
        • Model(array)
          • 0Languages/Model/Language.php
          • 1Languages/Model/LanguagesAppModel.php
      • Media(array)
        • Behavior(array)
          • 0Media/Model/Behavior/MediaBehavior.php
        • Model(array)
          • 0Media/Model/Media.php
          • 1Media/Model/MediaAppModel.php
          • 2Media/Model/MediaEntity.php
      • Menus(array)
        • Model(array)
          • 0Menus/Model/Menu.php
          • 1Menus/Model/MenusAppModel.php
      • MountPoints(array)
        • Model(array)
          • 0MountPoints/Model/MountPoint.php
          • 1MountPoints/Model/MountPointsAppModel.php
      • Outdooractive(array)
        • Behavior(array)
          • 0Outdooractive/Model/Behavior/OAGeoBehavior.php
      • Pdf(array)
        • Config(array)
          • 0Pdf/Config/bootstrap.php
          • 1Pdf/Config/routes.php
        • Plugin(array)
          • 0Pdf/Vendor/autoload.php
          • 1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
          • 2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
          • 3Pdf/Vendor/autoloader/Autoloader.php
      • Routes(array)
        • Model(array)
          • 0Routes/Model/Route.php
          • 1Routes/Model/RoutesAppModel.php
          • 2Routes/Model/Redirect.php
        • Behavior(array)
          • 0Routes/Model/Behavior/RedirectBehavior.php
          • 1Routes/Model/Behavior/RoutableBehavior.php
      • Seo(array)
        • Behavior(array)
          • 0Seo/Model/Behavior/SeoBehavior.php
        • Model(array)
          • 0Seo/Model/Seo.php
          • 1Seo/Model/SeoAppModel.php
      • Tags(array)
        • Behavior(array)
          • 0Tags/Model/Behavior/TaggableBehavior.php
      • Teasers(array)
        • Behavior(array)
          • 0Teasers/Model/Behavior/TeaserBehavior.php
        • Model(array)
          • 0Teasers/Model/Teaser.php
          • 1Teasers/Model/TeasersAppModel.php
      • Uploads(array)
        • Config(array)
          • 0Uploads/Config/bootstrap.php
        • Behavior(array)
          • 0Uploads/Model/Behavior/UploadBehavior.php
          • 1Uploads/Model/Behavior/TransformationBehavior.php
        • Model(array)
          • 0Uploads/Model/Upload.php
          • 1Uploads/Model/UploadsAppModel.php
    ====